Data dictionary › Encounter forms & clinical notes

EMR_ENCOUNTERS_TX_PLANNING_PRIMARY

Single Population

File
data/EMR_ENCOUNTERS_TX_PLANNING_PRIMARY.csv
Category
patient
Primary key
ENCOUNTER_ID, SEQUENCE_NO
Columns
7

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
2SEQUENCE_NO PKintegerintno
3TREATMENTstringvarchar(max)yes
4FREQUENCY_DURATIONstringvarchar(max)yes
5CPT_CODEstringvarchar(max)yes
6SESSIONS_NEEDEDintegerintyes
7TX_PRIM_REVIEWEDbooleanbityes