Processing EDI Claim Payment File

• יום שלישי 14 פברואר 2012 16:39

   

   
  

  0

  Hi,

  I am attempting to process a 4010 835 EDI file that contains multiple TRN segments by

  1) having the receive location pick it up

  2) the receive port contains an inbound map between the single X12_00401_835 schema and custom schema (structure below) to extract information from the EDI file 

  <Transactions>
  <Transaction>
  <TransactionRefId /> (Mapped to the TRN segment)
  <Date /> (Mapped to the TRN segment)
  <Payee /> (Mapped to the TRN segment)
  <Claims>
  <Claim>
  <PatientId />
  <PatientName />
  <AccountNumber />
  </Claim>
  </Claims>
  </Transaction>
  </Transactions>

  3) The EdiReceive pipeline then splits the EDI file on the TRN segment, so if there are 4 TRN segments in the file, then the EDI file is split into 4 files.

  4) My send port then picks up each of the mapped XML blocks and calls a stored procedure over the WCF-SQL adapter 4 or however many files the EDI file has been split into.

  My question is how can I process the EDI file so that I am just calling the stored procedure once?  I know that the mapping needs to be in place & run through the EdiReceive pipeline in order to get the data in the format of my custom schema above, so I am wondering if leveraging an orchestration to call the EdiReceive pipeline & split the file, then eseentially put the contents back together before calling the stored procedure?

  Any help would be much appreciated.  Thanks

  • תגובה
  • ציטוט