CDCgov / prime-reportstream

ReportStream is a public intermediary tool for delivery of data between different parts of the healthcare ecosystem.
https://reportstream.cdc.gov
Creative Commons Zero v1.0 Universal
71 stars 40 forks source link

Add new column 'Corrected_result_ID' to simplereport schema to fully support corrections. #344

Closed jimduff-usds closed 3 years ago

jimduff-usds commented 3 years ago

SimpleReport will soon be sending us corrections. this ticket is to be ready for that.

Every submitted result row from SimpleReport, even a correction, always has a new/unique Result_ID.

So, we'll create a new Corrected_result_ID column that a Correction can use to point to the previous data being corrected.

If there are multiple corrections, the Corrected_result_id should be the Result_id of the most recent previous connection. That is, the second correction points to the first correction, not back to the original result.

There are two work items for the Hub team:

jimduff-usds commented 3 years ago

So, hl70123 is the "Result Status", and is required for use in an OBR hl7 line. https://phinvads.cdc.gov/vads/ViewValueSet.action?oid=2.16.840.1.114222.4.11.815

And hl70085 is the "Observation Result Status" and is required for use in an OBX hl7 line. See: https://phinvads.cdc.gov/vads/ViewValueSet.action?oid=2.16.840.1.114222.4.11.811

Our hl7 appears to create both OBX and OBR rows, so we probably need both. However, we're only likely to use Final, Corrected, and Delete/Cancel, so it seems silly to ask SimpleReport to send both. I think we can just map from one to the other. So, I'm going to leave it as hl70123 in the schema, and we can translate as needed to generated the OBX line.