Data dictionary › Templates & form metadata

EMR_GENERIC_LOOKUP_FIELDS

Population

File
data/EMR_GENERIC_LOOKUP_FIELDS.csv
Category
reference
Primary key
SEARCH_VIEW_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
1SEARCH_VIEW_ID PKintegersmallintno
2USER_IDstringvarchar(20)yes
3SEARCH_TYPE_IDintegersmallintyes
4COLUMN_NAMEstringvarchar(50)yes
5DATA_TYPEstringvarchar(50)yes
6IS_VISIBLEbooleanbityes
7IS_MASKEDbooleanbityes