We are in the process of converting our data into Common Data Model. We have All Scripts EHR database.
Test orders and test results are linked in our database. For example,
OrderName: Complete Blood Count
Order LOINC: 58410-2
This order (ID: 1) is linked with multiple blood test results:
- Hemoglobin (LOINC 718-7)
- WBC Count (LOINC 57845-0)
- RBC Count (LOINC 26453-1)
The blood test results have their values, units etc. associated with them.
When we convert the data into CDM, how can we carry over both LOINC codes (Result as well as Order)? We would like to link what test result is part of what order.