01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
LAB_ID→EMR_LABS_MASTER.LAB_IDLOINC_NUM→LOINC.LOINC_NUMTRANSPORT_CONDITION→EMR_V_TEST_TRANSPORT_CONDITIONS.TRANSPORT_CONDITION
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | TEST_ID PK | string | varchar(20) | no | |
| 2 | LAB_ID PK | string | varchar(40) | no | |
| 3 | TEST_NAME | string | varchar(200) | no | |
| 4 | LOINC_NUM | string | varchar(7) | yes | |
| 5 | IS_DELETED | boolean | bit | yes | |
| 6 | TEST_TYPE | string | varchar(15) | yes | |
| 7 | PROC_CODE | string | varchar(20) | yes | |
| 8 | SNOMED | string | varchar(20) | yes | |
| 9 | ORDERABLE | boolean | bit | yes | |
| 10 | QUESTION_CODE | string | varchar(10) | yes | |
| 11 | TRANSPORT_CONDITION | string | varchar(2) | yes | |
| 12 | REQUIRE_BODY_SITE | boolean | bit | yes |