none
Generating 5010 837P file from flat source RRS feed

  • Question

  • Hi all. I have a sql table that stores 837P claim data in the following format:

    claimid    amount amountpaid amount linenumber servicecode

    1            100.00  100.00         100.00  1                900

    1            100.00  100.00         100.00  2                950

    I created a generated schema from this table and my destination schema is the 5010 837P Multiple schema.

    I want to generate an EDI 837File from this sql table. I created a map and linked the claimid to the 2300 segment claim number as a test. My pipeline is the EDISend pipeline.

    When I start the application, instead of creating one EDI file with all the claims in it, it creates multiple files with nothing in them. No claim numbers or anything else.

    How can I create just one EDI file from all these claims? Is there a minimum number of mappings before something will be placed in the file?

    Paul

     

    Tuesday, April 5, 2011 1:51 AM

Answers

  • Here is my clarifications are.

    C:\Users\Pauli\AppData\Local\Temp\2\_MapData\HIPAA837_5010\Map1_output.xml: error btm1046: Output validation error: The element 'ST' has invalid child element 'ST01_TransactionSetIdentifierCode'. List of possible elements expected: 'ST02_TransactionSetControlNumber'.

    You need to provide a mapping for 'ST02_TransactionSetControlNumber'. Since it is not getting mapped so you are getting this error.

    C:\Users\Pauli\AppData\Local\Temp\2\_MapData\HIPAA837_5010\Map1_output.xml: error btm1046: Output validation error: The element 'X12_00501_837_P' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006' has invalid child element 'TS837_2000A_Loop' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006'. List of possible elements expected: 'BHT_BeginningofHierarchicalTransaction' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006'.

    Same goes here as well. You need to provide the mapping for 'BHT_BeginningofHierarchicalTransaction' before start the mapping for 'TS837_2000A_Loop'.


    Best Regards, Vishnu
    Wednesday, April 6, 2011 4:24 AM

All replies

  • So you must be doing mapping between your sql generate schema and the corresponding EDI 837P scheam. can you please test the map and see the desired results. Also you need to pool the sql select query depending on a flag such as "EDI processed" flag. Depending on this flag SQL query will pool for execution and it will select the data from the table. But first verify that your map is working fine. 
    Best Regards, Vishnu
    Tuesday, April 5, 2011 3:37 AM
  • Thanks. Apparently there is something wrong with my map. I'm using the 5010 837P Multiple schema.

     

    C:\Users\Pauli\AppData\Local\Temp\2\_MapData\HIPAA837_5010\Map1_output.xml: error btm1046: Output validation error: The element 'ST' has invalid child element 'ST01_TransactionSetIdentifierCode'. List of possible elements expected: 'ST02_TransactionSetControlNumber'.

    C:\Users\Pauli\AppData\Local\Temp\2\_MapData\HIPAA837_5010\Map1_output.xml: error btm1046: Output validation error: The element 'X12_00501_837_P' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006' has invalid child element 'TS837_2000A_Loop' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006'. List of possible elements expected: 'BHT_BeginningofHierarchicalTransaction' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006'.

    Tuesday, April 5, 2011 5:38 PM
  • Here is my clarifications are.

    C:\Users\Pauli\AppData\Local\Temp\2\_MapData\HIPAA837_5010\Map1_output.xml: error btm1046: Output validation error: The element 'ST' has invalid child element 'ST01_TransactionSetIdentifierCode'. List of possible elements expected: 'ST02_TransactionSetControlNumber'.

    You need to provide a mapping for 'ST02_TransactionSetControlNumber'. Since it is not getting mapped so you are getting this error.

    C:\Users\Pauli\AppData\Local\Temp\2\_MapData\HIPAA837_5010\Map1_output.xml: error btm1046: Output validation error: The element 'X12_00501_837_P' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006' has invalid child element 'TS837_2000A_Loop' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006'. List of possible elements expected: 'BHT_BeginningofHierarchicalTransaction' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006'.

    Same goes here as well. You need to provide the mapping for 'BHT_BeginningofHierarchicalTransaction' before start the mapping for 'TS837_2000A_Loop'.


    Best Regards, Vishnu
    Wednesday, April 6, 2011 4:24 AM