Notifications
Clear all
Topic starter
Trying to find a way to export charge data to a file after the charges come over to PM and can be reviewed by our billing team. Any ideas or thoughts how we might work this one out?
Posted : November 7, 2017 8:29 am
Can you set up an outbound charge interface to send to an interface engine like Mirth?
I have something set up that sounds very similar. I take certain data in each HL7 message and write it to a CSV file. The CSV can then be opened as a spreadsheet.
-dp
Posted : November 7, 2017 8:43 am
Topic starter
How do you have it setup to export to a csv file? That would work great!
Posted : November 7, 2017 8:54 am
Are you familiar with HL7 interfaces? You can set up an outbound charge interface (DFT messages) which sends HL7 to a destination. It can be a file or to another host via IP address.
We send to the Mirth interface engine, which organizes the HL7 into easy to manage variables that we can then use to write the data we want to a file.
Alternately, if you'd prefer to avoid the interface engine and you are good at scripting in <insert language of choice>, it probably wouldn't be difficult to write a script to parse the extract you want and write it to a CSV as well.
I'd point out an issue that was noted in another recent thread however. Either CEMR, CPS, or both may send the same charge again if an encounter is modified, or something like that. I didn't test it myself. That caveat may or may not affect you, but it's something to watch for.
-dp
Posted : November 7, 2017 9:50 am
Why couldn't you export csv file from Crystal. Should be straight forward.
Posted : November 7, 2017 10:01 am
