01Relates to the patient
LAB_ORDER_NUMBER + COMPONENT_SEQUENCE + LAB_ID matches EMR_ORDER_DETAILS.LAB_ORDER_NUMBER + EMR_ORDER_DETAILS.COMPONENT_SEQUENCE + EMR_ORDER_DETAILS.LAB_ID on a row of EMR_ORDER_DETAILS that relates to the patient
Single-patient export: the patient's rows.
02References
ABNORMAL_FLAG→V_ABNORMAL_FLAG_CODES.ABNORMAL_FLAGPERFORMING_LAB_ID→EMR_LABS_MASTER.LAB_IDSTATUS_CODE→V_ORDER_RESULT_STATUS_CODES.STATUS_CODETEST_ID,LAB_ID→EMR_TEST_OBSERVATIONS.TEST_ID,LAB_IDVALUE_TYPE→V_VALUE_TYPE_CODES.VALUE_TYPELAB_ORDER_NUMBER,COMPONENT_SEQUENCE,LAB_ID→EMR_ORDER_DETAILS.LAB_ORDER_NUMBER,COMPONENT_SEQUENCE,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 | COMPONENT_SEQUENCE PK | integer | int | no | |
| 4 | RESULT_SEQUENCE PK | integer | int | no | |
| 5 | OBSERVED_DATETIME | datetime | datetime | yes | |
| 6 | OBSERVED_TIMEZONE_BIAS | integer | int | yes | |
| 7 | TEST_ID | string | varchar(20) | yes | |
| 8 | VALUE_TYPE | string | varchar(15) | yes | |
| 9 | VALUE | string | varchar(250) | yes | |
| 10 | UNITS | string | varchar(250) | yes | |
| 11 | REFERENCE_RANGE | string | varchar(80) | yes | |
| 12 | ABNORMAL_FLAG | string | varchar(10) | yes | |
| 13 | RESULT_STATUS | string | char(1) | yes | |
| 14 | COMMENTS | string | varchar(max) | yes | |
| 15 | ANALYSIS_DATETIME | datetime | datetime | yes | |
| 16 | ANALYSIS_TIMEZONE_BIAS | integer | int | yes | |
| 17 | PERFORMING_LAB_ID | string | varchar(40) | yes | |
| 18 | STATUS_CODE | string | varchar(2) | yes | |
| 19 | PERFORMING_LAB_PHONE | string | varchar(10) | yes | |
| 20 | PERFORMING_LAB_ADDR2 | string | varchar(35) | yes | |
| 21 | PERFORMING_LAB_NAME | string | varchar(50) | yes | |
| 22 | PERFORMING_LAB_MNEMONIC | string | varchar(5) | yes | |
| 23 | PERFORMING_LAB_ADDR1 | string | varchar(35) | yes | |
| 24 | PERFORMING_LAB_CITY | string | varchar(30) | yes | |
| 25 | PERFORMING_LAB_STATE | string | varchar(2) | yes | |
| 26 | PERFORMING_LAB_ZIP | string | varchar(10) | yes | |
| 27 | PERFORMING_LAB_DIR_TITLE | string | varchar(20) | yes | |
| 28 | PERFORMING_LAB_DIR_NAME | string | varchar(45) | yes | |
| 29 | OBSERVATION_METHOD | string | varchar(15) | yes |