Test Data Manager

 View Only
  • 1.  HL7 File Masking

    Posted Jan 27, 2020 05:12 PM

    Hi,

    We have a requirement to mask HL7 - ADT and ORU files.
    HL7 is a '|' delimited file but has other delimiters as well (like ^, &, `) to separate the subcomponents in a field. We have to extract each subcomponent and mask only the PHI ones using appropriate masking algorithm.
    I am attaching a sample file below

    MSH|^~\&|FLHIE|FLHIESJH^ST JOSEPHS HOSPITAL |WELLCARE^Wellcare of Florida||20191113065416||ADT^A08|20191113065416986|P|2.5||||| EVN|A08|20191113065000 PID|1||19601244^^^WELLCARE^MRN~2107707580^^^FLHIESJH^MRN||SARA^HULLINS^O||20150928|F|||1921 E 26TH AVE^^Tampa^FL^33601||(813) 575-8502~(813) 844-8990|||||1110121158||||||N|0|||||N| PV1|1|E||Emergency|||1285990515^Telt^Nadya||||||N||||||5114254288|||||||||||||||||AHR||||||||20191112085200|20191112133600| PV2|||^COUGH FEVER BLOODY NOSE DG1|||R05|Cough|Adm| PD1||||6^^^YAKUBU, ELIZABETH; MD IN1|||1430|MCD Staywell|||||||||||||||||||||||||||||||||||||||||||||8568066236| ZDS|176688|YAKUBU, ELIZABETH; MD|||

    Thanks,
    Roshni Mathew



  • 2.  RE: HL7 File Masking
    Best Answer

    Broadcom Employee
    Posted Jan 28, 2020 09:49 AM
    Hi Rosni,

    As you've mentioned, in order to mask using the TDM tools (Fast Data Masker), you'll need to parse this data out into a formatted file structure like XML, JSON, CSV or EXCEL so that FDM can identify & mask the specific PII fields.

    TDM can also be used to Synthetically generate new HL7 records based off your template above.   We've just recently updated a couple of data generation formulas to assist with this:     @caret()@ used to generate one "^", now you can pass a numeric value to get multiples, e.g.  @caret(3)@ generates "^^^"   Same for @tilde()@     This update is available as a patch to TDM 4.8.1 and can be requested from support.

    Scott​​​


  • 3.  RE: HL7 File Masking

    Posted Jan 30, 2020 04:33 PM
    Hi Scott,

    Thanks for the reply.

    I will try to convert HL7 to XML and mask using FDM.

    Thanks,
    Roshni Mathew