Data dictionary › Encounter forms & clinical notes

EMR_ENCOUNTERS_MH_TREATMENT_HISTORY

Single Population

File
data/EMR_ENCOUNTERS_MH_TREATMENT_HISTORY.csv
Category
patient
Primary key
ENCOUNTER_ID, SEQUENCE_NO
Columns
6

01Relates to the patient

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
1ENCOUNTER_ID PKintegerintno
2NAME_OF_FACILITYstringvarchar(100)yes
3TYPE_OF_FACILITYstringvarchar(100)yes
4DATESstringvarchar(100)yes
5DIAGNOSISstringvarchar(100)yes
6SEQUENCE_NO PKintegerintno