Data dictionary › Messaging, alerts, tasks & portal

EMR_ALERT_RULES

Population

File
data/EMR_ALERT_RULES.csv
Category
reference
Primary key
ALERT_RULE_ID
Columns
11

01Relates to the patient

reference data (no patient link)

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

02Columns

#ColumnTypeSource typeNullNotes
1ALERT_RULE_ID PKintegerintno
2ALERT_RULE_NAMEstringvarchar(50)no
3RULE_CONDITIONstringvarchar(300)yes
4RULE_XMLstringxmlyes
5ERROR_MESSAGEstringvarchar(1000)yes
6IS_SYS_DEFINEDbooleanbitno
7CREATED_USER_IDstringvarchar(20)yes
8CREATED_DATEdatetimedatetimeyes
9MODIFIED_USER_IDstringvarchar(20)yes
10MODIFIED_DATEdatetimedatetimeyes
11IS_DELETEDbooleanbitno