01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
ACTOR_ID→ACTORS.ACTOR_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | LAB_ID PK | string | varchar(40) | no | |
| 2 | LAB_NAME | string | varchar(50) | no | |
| 3 | LAB_ADDRESS1 | string | varchar(50) | yes | |
| 4 | LAB_ADDRESS2 | string | varchar(50) | yes | |
| 5 | CITY | string | varchar(50) | yes | |
| 6 | STATE | string | varchar(50) | yes | |
| 7 | ZIP | string | varchar(50) | yes | |
| 8 | LAB_PHONE | string | varchar(50) | yes | |
| 9 | LAB_FAX | string | varchar(50) | yes | |
| 10 | ACTOR_ID | string | varchar(100) | yes | |
| 11 | CODING_SYSTEM | string | varchar(40) | yes | |
| 12 | LAB_TYPE | integer | int | yes | |
| 13 | NAMESPACE_ID | string | varchar(40) | yes | |
| 14 | UNIVERSAL_ID | string | varchar(30) | yes | |
| 15 | UNIVERSAL_ID_TYPE | string | varchar(10) | yes | |
| 16 | IDENTIFIER_TYPE_CODE | string | varchar(10) | yes | |
| 17 | COUNTRY | string | varchar(10) | yes | |
| 18 | COUNTY_CODE | string | varchar(10) | yes | |
| 19 | ALIAS | string | varchar(40) | yes |