01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
MASTER_TEMPLATE_ID→EMR_MASTER_TEMPLATES.MASTER_TEMPLATE_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | TX_TYPE PK | string | varchar(5) | no | |
| 2 | MASTER_TEMPLATE_ID PK | integer | int | no | |
| 3 | ELEMENT_SECTION | string | varchar(6) | yes | |
| 4 | ELEMENT_ID | string | varchar(55) | yes | |
| 5 | ELEMENT_TYPE | string | varchar(15) | yes | |
| 6 | ELEMENT_VALUE | string | varchar(200) | yes | |
| 7 | ELEMENT_VISIBLE | boolean | bit | yes |