Data dictionary › Programs, episodes, referrals & nursing

PROGRAM_SERVICES

Single Population

File
data/PROGRAM_SERVICES.csv
Category
reference
Primary key
SERVICE_DESC, SERVICE_TYPE
Columns
4

01Relates to the patient

reference data (no patient link)

Single-patient export: included in full (reference data).

02References

  • SERVICE_NAME_FULL → SERVICES.SERVICE_NAME
  • SERVICE_NAME_HALF → SERVICES.SERVICE_NAME

03Columns

#ColumnTypeSource typeNullNotes
1SERVICE_TYPE PKintegerintno
2SERVICE_DESC PKstringvarchar(40)no
3SERVICE_NAME_HALFstringvarchar(40)yes
4SERVICE_NAME_FULLstringvarchar(40)yes