patient_reminders


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 patient_reminders.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 generated from the clinical decision support engine that are sent via a communication medium to the patient

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
active BIT 1 1

1 if active and 0 if not active
date_inactivated DATETIME 19 √ null
reason_inactivated VARCHAR 31
list_options.option_id Defined in XML R

Maps to list_options list rule_reminder_inactive_opt
due_status VARCHAR 31
list_options.option_id Defined in XML R

Maps to list_options list rule_reminder_due_opt
pid BIGINT 19 null
patient_data.pid Defined in XML R

The internal patient identifier
category VARCHAR 31
rule_action_item.category Defined in XML R

Maps to the category item in the rule_action_item table
item VARCHAR 31
rule_action_item.item Defined in XML R

Maps to the item column in the rule_action_item table
date_created DATETIME 19 √ null
date_sent DATETIME 19 √ null
voice_status BIT 1 0

0 if not sent and 1 if sent
sms_status BIT 1 0

0 if not sent and 1 if sent
email_status BIT 1 0

0 if not sent and 1 if sent
mail_status BIT 1 0

0 if not sent and 1 if sent

Indexes

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

Relationships

Close relationships within degrees of separation