Data dictionary › Programs, episodes, referrals & nursing

REFERRALS

Single Population

File
data/REFERRALS.csv
Category
patient
Primary key
REFERRAL_NUMBER, COMPANY_CODE
Columns
7

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02Columns

#ColumnTypeSource typeNullNotes
1REFERRAL_NUMBER PKstringvarchar(15)no
2COMPANY_CODE PKstringvarchar(20)no
3ACCOUNTstringvarchar(12)yes
4FROM_DATEdatetimedatetimeyes
5THRU_DATEdatetimedatetimeyes
6REF_PROV_CODEstringvarchar(20)yes
7COMMENT_TEXTstringtextyes