Data dictionary › Templates & form metadata

EMR_TEMPLATE_TYPES

Population

File
data/EMR_TEMPLATE_TYPES.csv
Category
reference
Primary key
TEMPLATE_TYPE_ID
Columns
13

01Relates to the patient

reference data (no patient link)

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

02Columns

#ColumnTypeSource typeNullNotes
1TEMPLATE_TYPE_ID PKintegersmallintno
2TEMPLATE_TYPE_NAMEstringvarchar(50)no
3TEMPLATE_TYPE_ALIASstringvarchar(50)no
4CREATED_DATEdatetimedatetimeno
5CREATED_USER_IDstringvarchar(20)no
6MODIFIED_DATEdatetimedatetimeyes
7MODIFIED_USER_IDstringvarchar(20)yes
8IS_DELETEDbooleanbitno
9IS_ENCTYPEbooleanbityes
10IS_GOCbooleanbitno
11ON_CHARTbooleanbityes
12IS_GROUP_TYPEbooleanbityes
13TABLE_NAMEstringvarchar(50)yes