Data dictionary › Lab orders & results

PAT_LAB_RESULTS

Single Population

File
data/PAT_LAB_RESULTS.csv
Category
patient
Primary key
RESULT_DATETIME, LAB_TEST_ID, ACCOUNT
Columns
6

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

03Columns

#ColumnTypeSource typeNullNotes
1ACCOUNT PKstringvarchar(12)no
2RESULT_DATETIME PKdatetimedatetimeno
3LAB_TEST_ID PKstringvarchar(10)no
4LAB_NAMEstringvarchar(30)yes
5RECEIVING_APP_NAMEstringvarchar(30)yes
6LAB_TEST_DESCstringvarchar(30)yes