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_IDOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATION
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | TEST_GROUP_NAME PK | string | varchar(100) | no | |
| 2 | LAB_ID PK | string | varchar(40) | no | |
| 3 | CREATED_USER_ID | string | varchar(20) | yes | |
| 4 | CREATED_DATE | datetime | datetime | yes | |
| 5 | MODIFIED_USER_ID | string | varchar(20) | yes | |
| 6 | MODIFIED_DATE | datetime | datetime | yes | |
| 7 | IS_DELETED | boolean | bit | yes | |
| 8 | OFFICE_LOCATION | string | varchar(20) | yes | |
| 9 | TEST_TYPE | integer | int | yes |