Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

LA Results LRIv5 Transformation #1355

Closed
24 tasks done
JohnNKing opened this issue Sep 24, 2024 · 26 comments
Closed
24 tasks done

LA Results LRIv5 Transformation #1355

JohnNKing opened this issue Sep 24, 2024 · 26 comments

Comments

@JohnNKing
Copy link
Contributor

JohnNKing commented Sep 24, 2024

Story

As Ochsner, so that our EHR can ingest results messages from ReportStream, I need all but one of the OBR segments removed.

Pre-conditions

n/a

Acceptance Criteria

  • The OBR for "54089-8" remains unchanged
  • All other OBR are removed from the outgoing HL7 ORU message
  • All OBXs appear under the sole remaining OBR
  • Numeric OBX IDs are sequential and unique
  • Write a RS E2E test that covers this transformation similar to Implementation: Automated TI <> RS tests #1255.

See #639 for the same effort that was done for CA.

Tasks

Engineering

  • Add draft transformations for this story (done before we had sample files)
  • Add unit tests for new transformation (done before we had sample files)
  • Use real sample files for unit tests
  • Make any necessary updates based on outcomes of sample files
  • Do manual E2E test with RS using sample files
  • Add RS E2E test that covers this transformation

Definition of Done

  • Code quality tasks completed
    • Code refactored for clarity and no design/technical debt
    • Adhere to separation of concerns; code is not tightly coupled, especially to 3rd party dependencies
    • Code is reviewed or developed by pair; 1 approval is needed but consider requiring an outside-the-pair reviewer
    • Code quality checks passed
  • Security & Privacy tasks completed
    • Security & privacy gates passed
  • Testing tasks completed
    • Unit test coverage of our code >= 90%
  • Build & Deploy tasks completed
    • Build process updated
    • API(s) are versioned
    • Source code is merged to the main branch

Research Questions

  • Optional: Any initial questions for research

Decisions

  • Optional: Any decisions we've made while working on this story

Notes

  • Optional: Any reference material or thoughts we may need for later reference
@JohnNKing JohnNKing changed the title LA Results Flattening LA Results LRIv5 Transformation Sep 24, 2024
@saquino0827
Copy link
Contributor

Current outgoing questions:

  1. We have specific UCSD identifiers R797 and R508. Are there identifiers we can leverage for LA?
  2. Do we have up-to-date LA sample files?

@pluckyswan
Copy link
Contributor

Branch for this

@saquino0827
Copy link
Contributor

Waiting for an answer for filtering for LA specific facilities.

@pluckyswan
Copy link
Contributor

pluckyswan commented Oct 8, 2024

We're currently filtering off: "Bundle.entry.resource.ofType(MessageHeader).destination.extension.where(url = 'https://reportstream.cdc.gov/fhir/StructureDefinition/universal-id').value = '1.2.840.114350.1.13.286.2.7.2.695071'"
We still need confirmation on final details for LA specific facilities and a LA sample ORU file, see thread for details: https://flexion.slack.com/archives/C044P2CBEKS/p1728057396567869.

@scleary1cs
Copy link
Contributor

LA NBS MSH Values.docx

@scleary1cs
Copy link
Contributor

@saquino0827 @pluckyswan @jherrflexion above doc shared by Jason.

@saquino0827
Copy link
Contributor

saquino0827 commented Oct 9, 2024

Jason ([email protected]) is working on getting an LA sample file for us.

Jason also confirmed that the MSH 5.2 OID is correct for filtering LA ORU specific messages.

@pluckyswan
Copy link
Contributor

See here for sample files.

@saquino0827
Copy link
Contributor

We're waiting on a response from Jason to make sure the sample files don't contain PHI. We're set up with RS locally and will manually update the sample file for now to include test data

@saquino0827
Copy link
Contributor

saquino0827 commented Nov 1, 2024

We've scrubbed any potential PHI from the one sample file and ran it through the whole E2E Flow from RS -> TI -> RS locally; The end file seemed to not be flattened correctly. Further investigation is required to find the issue. From a first glance in our current LA file, it lists '54089-8' in the ORC's sections rather than in the OBR's which (I think) causes issues with the flattening.

We also need e2e testing to be added. However, before we commit test files to the repo and write E2E testing, we want to be sure the files do not contain PHI. We will follow up with Jason on Monday (11/04) during standup, if we do not get a response today.

@saquino0827
Copy link
Contributor

Another Follow-up: @somesylvie helped me fined the Newborn Screening Tag in the OBR but under the field below:

OBR-50: Parent Universal Service Identifier:           
  OBR-50-0:                                            54089-8
  OBR-50-1:                                            Newborn screening panel American Health Information Community (AHIC)
  OBR-50-2:                                            LN

Our California Sample Results file has the Newborn Screening Identifier here:

OBR-4:  Universal Service Identifier:                  
  OBR-4-0:                                             54089-8
  OBR-4-1:                                             NB Screen Panel Patient AHIC

We will need to follow up with LADPH to see if this is correct; If so, we will need code changes to accommodate this difference.

@somesylvie
Copy link
Contributor

The LA sample file has 57128-1^Newborn Screening Report summary panel^LN in OBR-4

@JScott-JMC are you able to take a look at this (and Sam's comment above)? We're not sure if we should expect/use this different OBR-4 value, use OBR-50, or if there's something on there end that should change

@JScott-JMC
Copy link

@somesylvie, we'll take this back to Lisa @ Natus. All signs point to having her change this value to 54089-8 in her outputs.

@saquino0827
Copy link
Contributor

@JScott-JMC A follow-up on this, have we already schedule a talk or got a response back from Lisa? Double checking to make sure this
question isn't forgotten.

@JScott-JMC
Copy link

@saquino0827 we've confirmed with HCO & PHL that they will use the 54089-8 code for orders and results. 👍

@somesylvie
Copy link
Contributor

@JScott-JMC can they get us an updated sample file? I don't feel good about making manual changes to files we're going to use for testing. Also any update on whether or not those files contain PHI? The patient data was very realistic

@JScott-JMC
Copy link

@scleary1cs did the Ochsner team send sample order messages per your request on Friday?
@somesylvie I'll be surprised if Ochsner updates their order code to 54089-8 in the near term. We should be safe with a manual change for our testing in the meantime.
Also, Lisa couldn't confirm the PII question, so we should probably scramble the identifiable fields if we're posting to a public repository.

@sfradkin sfradkin added the transformation for CDC mapping label Nov 12, 2024
@scleary1cs
Copy link
Contributor

@JScott-JMC I have not seen any sample files yet, I'll follow up with an email to Mark and Paul right now.

@scleary1cs
Copy link
Contributor

MSH|^~&|13^1.2.840.114350.1.13.286.2.7.2.695071^ISO|4169|Natus.LA.STAG^2.16.840.1.114222.4.3.26.3.2|Louisiana Office of Public Health Laboratory^2.16.840.1.114222.4.3.22.17.1.1|20241113131917|739|ORM^O01^ORM_O01|29|T|2.5.1|||AL|NE

PID|1|10453873^^^MRN^MRN|10453873^^^MRN^MRN||PKUSS^GIRL BEAKER||20241108103900|F||2054-5^Black or African-American^CDCREC|1202 COOLIDGE ST.^^LAFAYETTE^LA^70503^US^P^^LAFAYETTE|LAFAYETTE|(557)559-5559^P^PH||ENGLISH|Single|||000-00-0000||PKUSS^BEAKER^MOM^|HISPANIC||Y|1|||||N

PD1||||1184608010^DREWITZ^TROY^U.^^^^^NPI^^^^NPI

NK1|1|PKUSS^BEAKER^MOM^|Mother|1202 Coolidge St.^^LAFAYETTE^LA^70503^US|(557)559-5559^^PH

PV1|1||^8288^24826^^^^^^^^||||||||||||||1184608010^DREWITZ^TROY^U.^^^^^NPI^^^^NPI

IN1|1|114420|308114401|BLUE CROSS BLUE SHIELD|P. O. BOX 98029^^BATON ROUGE^LA^70898-9029^||(800)495-2583|||||||||PKUSS^GIRL^BEAKER^|Self|20241108|1202 COOLIDGE ST.^^LAFAYETTE^LA^70503^US^^^LAFAYETTE|||1||||||||||||||||||||None|F

GT1|1|100251815|PKUSS^BEAKER^MOM^||1202 COOLIDGE ST.^^LAFAYETTE^LA^70503^US^^^LAFAYETTE|(557)559-5559^P^PH||19891224|F|P/F|MOT|999-99-9999||||||||Full

ORC|NW|243217771^EPC||71414746|||^^^20241113131800^^Routine^^||20241113131721|739^BEAKER^PHLEBOTOMIST^^||1184608010^DREWITZ^TROY^U.^^^^^NPI^^^^NPI|^^^^^^^^OLGH LABOR AND DELIVERY|(504)391-8896||||OCH155315^OCH155315|||OCHSNER LAFAYETTE GENERAL MEDICAL HOSPITAL^D^^^^OCHSNER HEALTH SYSTEM^XX^^^30100|1214 COOLIDGE BLVD^^LAFAYETTE^LA^70503-2621^US^B^^LAFAYETTE|(337)289-7991^^PH|120 OCHSNER BLVD^SUITE 360^GRETNA^LA^70056^^C|||||I|VERBAL WITH

OBR|1|243217771^EPC|1000319697^Beaker|54089-8^Newborn screening panel American Health Information Community (AHIC)^LN^^^^2.72||20241113131800|20241113131859|||739^BEAKER^PHLEBOTOMIST^^|Lab Collect|||||1184608010^DREWITZ^TROY^U.^^^^^NPI^^^^NPI|(504)391-8896|||193989||||Lab|||^^^20241113131800^^Routine^^|||||||||20241113131800

OBX|1|ST|57714-8^Gestational Age (Weeks + Days)||384||||||F|||20241113131719|||||||||||||||QST

OBX|2|ST|82312-0^Infant Blood Transfusion?||No||||||F|||20241113131719|||||||||||||||QST

OBX|3|ST|67704-7^All Feeding Since Birth||Human Milk \T\ Formula||||||F|||20241113131719|||||||||||||||QST

OBX|4|ST|PLT3280^Name of Formula(s)||Enfomil, Similac, Katrina||||||F|||20241113131719|||||||||||||||QST

SPM|1|^24LADH-318X0008&Beaker||BLOOD^Blood||||BLOOD^Blood|||||||||20241113131859|20241113131900||Y|||||||||||||||S

@scleary1cs
Copy link
Contributor

MSH|^~&|13^1.2.840.114350.1.13.286.2.7.2.695071^ISO|4169|Natus.LA.STAG^2.16.840.1.114222.4.3.26.3.2|Louisiana Office of Public Health Laboratory^2.16.840.1.114222.4.3.22.17.1.1|20241113131917|739|ORM^O01^ORM_O01|30|T|2.5.1|||AL|NE
PID|1|10453874^^^MRN^MRN|10453874^^^MRN^MRN||PKUSS^B BOY BEAKER||20241108110000|M||2054-5^Black or African-American^CDCREC|1202 COOLIDGE ST.^^LAFAYETTE^LA^70503^US^P^^LAFAYETTE|LAFAYETTE|(557)559-5559^P^PH||ENGLISH|Single|||000-00-0000||PKUSS^BEAKER^MOM^|HISPANIC||Y|2|||||N
PD1||||1184608010^DREWITZ^TROY^U.^^^^^NPI^^^^NPI
NK1|1|PKUSS^BEAKER^MOM^|Mother|1202 Coolidge St.^^LAFAYETTE^LA^70503^US|(557)559-5559^^PH
PV1|1||^8288^24827^^^^^^^^||||||||||||||1184608010^DREWITZ^TROY^U.^^^^^NPI^^^^NPI
IN1|1|114415|308114401|BLUE CROSS BLUE SHIELD|P O BOX 98029^^BATON ROUGE^LA^70898-9029^||(800)495-2583|||||||||PKUSS^B^BOY BEAKER^|Self|20241108|1202 COOLIDGE ST.^^LAFAYETTE^LA^70503^US^^^LAFAYETTE|||1||||||||||||||||||||None|M
GT1|1|100251816|PKUSS^BEAKER^MOM^||1202 COOLIDGE ST.^^LAFAYETTE^LA^70503^US^^^LAFAYETTE|(557)559-5559^P^PH||19891224|F|P/F|MOT|999-99-9999||||||||Full
ORC|NW|243217750^EPC||71414751|||^^^20241113125400^^Routine^^||20241113125406|739^BEAKER^PHLEBOTOMIST^^||1184608010^DREWITZ^TROY^U.^^^^^NPI^^^^NPI|^^^^^^^^OLGH LABOR AND DELIVERY|(504)391-8896||||OCH155315^OCH155315|||OCHSNER LAFAYETTE GENERAL MEDICAL HOSPITAL^D^^^^OCHSNER HEALTH SYSTEM^XX^^^30100|1214 COOLIDGE BLVD^^LAFAYETTE^LA^70503-2621^US^B^^LAFAYETTE|(337)289-7991^^PH|120 OCHSNER BLVD^SUITE 360^GRETNA^LA^70056^^C|||||I|VERBAL WITH
OBR|1|243217750^EPC|1000319696^Beaker|54089-8^Newborn screening panel American Health Information Community (AHIC)^LN^^^^2.72||20241113125400|20241113131841|||739^BEAKER^PHLEBOTOMIST^^|Lab Collect|||||1184608010^DREWITZ^TROY^U.^^^^^NPI^^^^NPI|(504)391-8896|||193988||||Lab|||^^^20241113125400^^Routine^^|||||||||20241113125400
OBX|1|ST|57714-8^Gestational Age (Weeks + Days)||382||||||F|||20241113125402|||||||||||||||QST
OBX|2|ST|82312-0^Infant Blood Transfusion?||Yes||||||F|||20241113125402|||||||||||||||QST
OBX|3|DT|62317-3^Date of Transfusion||20241108||||||F|||20241113125402|||||||||||||||QST
OBX|4|ST|67704-7^All Feeding Since Birth||Human Milk \T\ Formula||||||F|||20241113125402|||||||||||||||QST
OBX|5|ST|PLT3280^Name of Formula(s)||Enfomil||||||F|||20241113125402|||||||||||||||QST
SPM|1|^24LADH-318X0007&Beaker||BLOOD^Blood||||BLOOD^Blood|||||||||20241113131841|20241113131842||Y|||||||||||||||S

@scleary1cs
Copy link
Contributor

Sample files, also can be found in email(cdc-ti) copied subject "Sample order messages"

@JScott-JMC
Copy link

They updated their LOINC! NICE!!!

@saquino0827
Copy link
Contributor

I de-identified our LA sample ORU messages and put them in keybase for review the folder it's in is called keybase://team/cdc_ti/de_identified_sample_files. We need someone to review to make sure I properly de-identified them.

@saquino0827
Copy link
Contributor

I was able to manually test the LA de-identified sample files successfully. We worked on adding a new transformation rule as well and once the code is merged the RS e2e test should pass.

This was referenced Dec 6, 2024
@saquino0827
Copy link
Contributor

The first PR was merged. Waiting on the Example LA files PR to merge before moving this card further

@scleary1cs
Copy link
Contributor

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

8 participants