01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
CHANGE_USER→USERS.USER_IDENTRY_USER→USERS.USER_IDLAB_ID→EMR_LABS_MASTER.LAB_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | QUESTION_CODE PK | string | varchar(15) | no | |
| 2 | QUESTION | string | varchar(100) | no | |
| 3 | DATA_TYPE | string | varchar(20) | no | |
| 4 | CONTROL_TYPE_ID | integer | smallint | no | |
| 5 | DATA_LENGTH | integer | smallint | yes | |
| 6 | LOOKUP_ID | integer | int | yes | |
| 7 | ENTRY_DATE | datetime | datetime | no | |
| 8 | ENTRY_USER | string | varchar(20) | no | |
| 9 | CHANGE_DATE | datetime | datetime | yes | |
| 10 | CHANGE_USER | string | varchar(20) | yes | |
| 11 | ANALYTE_CODE | string | varchar(11) | yes | |
| 12 | INSTRUCTIONS | string | varchar(350) | yes | |
| 13 | LAB_ID PK | string | varchar(40) | no | |
| 14 | QUESTION_TYPE | string | varchar(15) | yes |