01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
RESULT_DATETIME,LAB_TEST_ID,ACCOUNT→PAT_LAB_RESULTS.RESULT_DATETIME,LAB_TEST_ID,ACCOUNT
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ACCOUNT PK | string | varchar(12) | no | |
| 2 | RESULT_DATETIME PK | datetime | datetime | no | |
| 3 | LAB_TEST_ID PK | string | varchar(10) | no | |
| 4 | LINE_NO PK | integer | int | no | |
| 5 | LAB_TEST_SUB_ID | string | varchar(10) | no | |
| 6 | LAB_TEST_SUB_DESC | string | varchar(30) | yes | |
| 7 | OBS_RESULTS | string | varchar(80) | yes | |
| 8 | OBS_UNITS | string | varchar(20) | yes | |
| 9 | OBS_REF_RANGE | string | varchar(20) | yes | |
| 10 | OBS_NOTE | string | text | yes |