rule_action_item


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of rule_action_item.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Patient Reminders configuration for Clinical Decision Support individual rule settings

Columns

Column Type Size Nulls Auto Default Children Parents Comments
category VARCHAR 31 ''
patient_reminders.category Defined in XML R
rule_patient_data.category Defined in XML R
list_options.option_id Defined in XML R

Maps to list_options list rule_action_category
item VARCHAR 31 ''
patient_reminders.item Defined in XML R
rule_patient_data.item Defined in XML R
list_options.option_id Defined in XML R

Maps to list_options list rule_action
clin_rem_link VARCHAR 255 ''

Custom html link in clinical reminder widget
reminder_message MEDIUMTEXT 16777215 √ NULL

Custom message in patient reminder
custom_flag BOOLEAN 3 0

1 indexed to rule_patient_data, 0 indexed within main schema

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc category + item

Relationships

Close relationships within degrees of separation