Tag SQL

OSCAR Lab Schema Tips

Here’s some info on how the hl7TextInfo, hl7_link, hl7_msh, hl7_obx, hl7_obr, hl7_pid, providerLabRouting, patientLabRouting tables and measurements relate in OSCAR. Lab comes in and writes to hl7TextMessage. I’ll call this hmessage The lab is “dissected” and inputted into: hl7TextInfo I’ll call this…