Is there an easy way to document ANSI 837 structure to database structure?

May 30, 2013 at 7:38 PM
I have a hierarchical database structure which was constructed from your tools. What would be useful is a mapping that describes/translates the 5010 nomenclature such as Loop 1000A - NM103 to the DB table/field name such as CLAIMS.PATIENT_NAME_LASTNAME.

My reason for needing this is that when I need to research a particular field in the database, what it contains, how/why and with what it gets populated, I need to identify what I am looking for using the common terminology.

Is there any way to generate this sort of map/translation?
Coordinator
May 30, 2013 at 8:08 PM
There isn't an "easy" way to do this. But the way to do this would be to reverse engineer the xslt that does this mapping:

https://x12parser.codeplex.com/SourceControl/latest#154136