Data dictionary › Treatment plans, protocols & standing orders

EMR_TX_TEMPLATE_CONFIG

Population

File
data/EMR_TX_TEMPLATE_CONFIG.csv
Category
reference
Primary key
TX_TYPE, PROGRAM_CODE, ELEMENT_SECTION, ELEMENT_ID
Columns
7

01Relates to the patient

reference data (no patient link)

Single-patient export: not included (not referenced by patient records).

02Columns

#ColumnTypeSource typeNullNotes
1TX_TYPE PKstringvarchar(5)no
2PROGRAM_CODE PKstringvarchar(15)no
3ELEMENT_SECTION PKstringvarchar(6)no
4ELEMENT_ID PKstringvarchar(55)no
5ELEMENT_TYPEstringvarchar(15)no
6ELEMENT_VALUEstringvarchar(200)yes
7ELEMENT_VISIBLEbooleanbitno