Notifications
Clear all
General Discussion
2
Posts
2
Users
0
Reactions
94
Views
Topic starter
We are looking to send claim data to a 3rd party and want to setup an automated process to extract the data and store it in a file(s).
Has anyone done this before or have some insights/suggestions they could share?
Currently we are manually exporting the data by going to EDI Submission Mgmt > Claim files > Export
I am also reviewing the database documentation and where the claim data lives.
Thanks -Matthew
Posted : March 17, 2014 3:45 am
This information would reside in the EDIClaimFile table within the database. Shoot me a PM if you would like to discuss more details as to how a process could be setup for export. I would need some detail about your setup to answer properly, which we can discuss.
In a nutshell you would write a SQL query to retrieve the contents of the field Data within the EDIClaimFile table. An SSIS package could be written to write this info to files or a small application (vb.net, python, etc...) could also be written to handle this. I'd be happy to offer some advice.
Posted : March 18, 2014 4:15 am
