Data dictionary › Providers, organization, locations & config

EMR_AOE_LINK

Population

File
data/EMR_AOE_LINK.csv
Category
reference
Primary key
QUESTION_CODE, LAB_ID, TEST_ID
Columns
4

01Relates to the patient

reference data (no patient link)

Single-patient export: not included (not referenced by patient records).

02References

  • QUESTION_CODE, LAB_ID → EMR_AOE.QUESTION_CODE, LAB_ID
  • TEST_ID, LAB_ID → EMR_TESTS.TEST_ID, LAB_ID

03Columns

#ColumnTypeSource typeNullNotes
1QUESTION_CODE PKstringvarchar(15)no
2LAB_ID PKstringvarchar(40)no
3TEST_ID PKstringvarchar(20)no
4IS_REQUIREDbooleanbityes