01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
ACCOUNT→PEOPLE.ACCOUNTMSG_ID→PORTAL_MESSAGES.MSG_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | PCL_PK PK | integer | bigint | no | |
| 2 | MSG_ID | integer | int | yes | |
| 3 | RECIPIENT | string | varchar(254) | yes | |
| 4 | PORTAL_USER_ID | string | varchar(40) | yes | |
| 5 | ACCOUNT | string | varchar(12) | yes | |
| 6 | MSG_TYPE | integer | int | no | |
| 7 | COMM_USER | string | varchar(40) | yes | |
| 8 | ENTRY_DATE | datetime | datetime | no | |
| 9 | COMMUNICATION_DATE | datetime | datetime | yes |