overlapping lab_no for Imported and Uploaded labs

Preconditions

None

Steps to Reproduce

None

Expected Result

None

Observed Result

None

Additional Comments

We have found an issue with labs imported using the 'Import New Demographic' functionality and labs coming in via the HL7 Lab Upload / Mule upload.

These two areas in oscar store lab data in seperate tables (hl7TextMessage and labPatientPhysicianInfo). However, they use the same tables to store meta-data about labs (i.e. providerLabRouting). They both use their respective primary keys as the 'lab number'. This causes key conflicts in the meta-data tables.

The end result is that we are seeing new labs come in that say they have been acknowledged already by providers, often from providers that the lab is not assigned to, and always on a date before the lab was even uploaded. This is confusing for doctors, and may even be dangerous, as a provider could theoretically have a lab come in that ends up with the same lab number as an imported lab that was already acknowledged by that provider (I don't think it would even show up in the inbox in this case).

To reproduce, simply import demographic data using 'Admin' -> 'Import New Demographic' (make sure it includes lab data). Acknowledge these labs. Then, import a lab using 'Admin' -> 'HL7 Lab Upload'. You will be able to see the new labs seem to be already acknowledged.

Assignee

Unassigned

Reporter

Sourceforge Migration

OSCAR Build Date

None

OSCAR Build Tag

None

Client Browser

None

Client OS

None

Are you or your organization planning on submitting a fix for this bug in the next 30 days?

None

Validated by Reporter

None

SourceForge Reporter

jarrettchisholm

SourceForge Assigned To

None

SourceForge Date Created

None

SourceForge ID

3,366

Affects versions

Priority

7
Configure