Notifications
Clear all
Topic starter
I have two CPS databases. Our main GEMS Database and another from a different city that we would like to ingest patients, chart history, documents, and so on.
Does anyone know of a process or method to bring all that data into one centralized DB?
Posted : October 12, 2016 1:34 am
There are so many dependencies (foreign keys and such) in the CPS database that if this were my project, I think I'd just build HL7 interfaces for it. Exporting tables from one and importing to another I'd expect to really break things.
Off the top of my head, I think demographics wouldn't be too hard via HL7. SQL query the pertinent data and build the ADT messages from scratch.
Documents, obs terms and such would take more research for me. My first thought would be the same way as ADT--query for the pertinent data and build ORU and MDM HL7 for the receiving system to digest.
Posted : October 12, 2016 2:12 am
Are you going to CHUG? I believe someone is doing a presentation on this topic, might be a good place to start.
Posted : October 12, 2016 2:24 am
