01Relates to the patient
LAB_ORDER_NUMBER + LAB_ID matches EMR_ORDERS.LAB_ORDER_NUMBER + EMR_ORDERS.LAB_ID on a row of EMR_ORDERS that relates to the patient
Single-patient export: the patient's rows.
02References
LAB_ORDER_NUMBER,LAB_ID→EMR_ORDERS.LAB_ORDER_NUMBER,LAB_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | LAB_ORDER_NUMBER PK | string | varchar(20) | no | |
| 2 | LAB_ID PK | string | varchar(40) | no | |
| 3 | LAST_NAME | string | varchar(35) | yes | |
| 4 | FIRST_NAME | string | varchar(25) | yes | |
| 5 | MI | string | varchar(1) | yes | |
| 6 | ADDR1 | string | varchar(55) | yes | |
| 7 | ADDR2 | string | varchar(55) | yes | |
| 8 | CITY | string | varchar(30) | yes | |
| 9 | STATE | string | varchar(2) | yes | |
| 10 | ZIP | string | varchar(10) | yes | |
| 11 | PHONE | string | varchar(20) | yes | |
| 12 | EMP_NAME | string | varchar(30) | yes | |
| 13 | RELATION_TO_PAT | string | varchar(15) | yes | |
| 14 | DATE_OF_BIRTH | datetime | datetime | yes | |
| 15 | SEX | string | char(1) | yes |