Stream: implementers
Topic: Convert legacy data to FHIR
Greger George (Dec 07 2021 at 12:33):
Hello,
I have 40+ tables with medical records like Patients, LabTests, Procedure, Conditions(FACT_TABLES), etc. and there are DIM_TABLES for each of these FACT_TABLE which include data like Procedure code details for FACT_PROCEDURE table, etc. All of these tables are available to me as CSV files.
I have to convert all of these to FHIR format. Where should I start? I was planning to write code after creating a mapping file that maps FHIR property to a field name in my table and transform table data to FHIR. Am I in the correct direction? I saw a mapping language in HL7 FHIR specs. Is that of any use for me?
Thanks
Lloyd McKenzie (Dec 07 2021 at 14:20):
It probably won't all be a simple "x column maps to y FHIR element". You should expect some degree of transformation - code mapping, date syntax, local codes to FHIR Codings, etc. You certainly could use StructureMap, though you'd need something that parsed the CSVs to allow their use. However StructureMap is really about sharing transforms and you don't have that use-case, so you may find it easier to just write your own code.
Greger George (Dec 07 2021 at 15:10):
Lloyd McKenzie said:
It probably won't all be a simple "x column maps to y FHIR element". You should expect some degree of transformation - code mapping, date syntax, local codes to FHIR Codings, etc. You certainly could use StructureMap, though you'd need something that parsed the CSVs to allow their use. However StructureMap is really about sharing transforms and you don't have that use-case, so you may find it easier to just write your own code.
Thanks @Lloyd McKenzie
Is there a place where I can find examples of transformations with StrutureMap? If there is some project available in Github which I can refer or some examples, that would be really helpful.
Also, to use StructureMap, I should use FHIR mapping language, right?
Lloyd McKenzie (Dec 07 2021 at 15:57):
There's a couple of examples here: https://build.fhir.org/structuremap-examples.html. StructureMap is implemented by the FHIR validator and instructions are using it are here: https://wiki.hl7.org/Using_the_FHIR_Validator_to_transform_content
StructureMap uses the FHIR mapping language.
Last updated: Apr 12 2022 at 19:14 UTC
