Data dictionary › Messaging, alerts, tasks & portal

PAT_EMR_MESSAGE_ATTACHMENTS

Single Population

File
data/PAT_EMR_MESSAGE_ATTACHMENTS.csv
Category
patient
Primary key
none
Columns
4

01Relates to the patient

MESSAGE_ID matches EMR_MESSAGES_MASTER.MESSAGE_ID on a row of EMR_MESSAGES_MASTER that relates to the patient

Single-patient export: the patient's rows.

02Columns

#ColumnTypeSource typeNullNotes
1ATTACHMENT_IDintegerintno
2MESSAGE_IDintegerintno
3ATTACHMENT_NAMEstringvarchar(280)no
4ATTACHMENT_ALIASstringvarchar(280)no