01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
CONTACT_USER_ID→USERS.USER_IDPROGRAM_CODE→PROGRAM_CODES.PROGRAM_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | MESSAGE_CONTACT_ID PK | integer | int | no | |
| 2 | PROGRAM_CODE | string | varchar(15) | yes | |
| 3 | CONTACT_DESC | string | varchar(255) | no | |
| 4 | CONTACT_USER_ID | string | varchar(20) | yes | |
| 5 | CASE_LOAD_PROV | boolean | bit | no | |
| 6 | CASE_LOAD_PSYCH | boolean | bit | no | |
| 7 | EP_ONLY | boolean | bit | no |