01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
BILL_TYPE→V_ORDER_BILL_CODES.BILL_TYPEDIAG_CODE→DIAGNOSIS_CODES.DIAG_CODEOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONLAB_ID→EMR_LABS_MASTER.LAB_IDORDERING_PHYSICIAN→USERS.USER_IDPROGRAM_CODE→PROGRAM_CODES.PROGRAM_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | OFFICE_LOCATION PK | string | varchar(20) | no | |
| 2 | LAB_ID PK | string | varchar(40) | no | |
| 3 | LOCATION_LAB_ID PK | string | varchar(40) | no | |
| 4 | RECEIVING_FACILITY | string | varchar(10) | yes | |
| 5 | DIAG_CODE | string | varchar(8) | yes | |
| 6 | BILL_TYPE | integer | int | yes | |
| 7 | ORDERING_PHYSICIAN | string | varchar(20) | yes | |
| 8 | DEFAULT_PAT_DIAGS | boolean | bit | yes | |
| 9 | PROGRAM_CODE | string | varchar(15) | yes |