Data dictionary › Providers, organization, locations & config

EMR_PATIENT_CLINICAL_INSTRUCTIONS

Single Population

File
data/EMR_PATIENT_CLINICAL_INSTRUCTIONS.csv
Category
patient
Primary key
INSTRUCTION_ID, ACCOUNT
Columns
5

01Relates to the patient

ACCOUNT is the patient's ACCOUNT; or ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient

Single-patient export: the patient's rows.

02References

03Columns

#ColumnTypeSource typeNullNotes
1INSTRUCTION_ID PKintegerintno
2ACCOUNT PKstringvarchar(12)no
3ENCOUNTER_IDintegerintyes
4INSTRUCTION_TYPEstringvarchar(max)yes
5INSTRUCTIONstringvarchar(max)yes