Hi All,

We have a requirement where we have to send the client data that we received back to client as is but with some modifications to the file.

example:

If we receive a claim from client. while sending back we load the same data that we received and manipulate some fields int the data by doing a SQL lookup based on the claim id and update the values in the file.

We also add some extra segments like NTE or HCP or K3 segments.

Can you please suggest a way to do this in SI. As we want to evaluate this in SI.

Thanks,

Lakshman

Hi Lakshman,

The way I would do this is have a business process that does the following steps

1) Use a Map to extract the claim id and put it into Process Data from the incoming file (assuming incoming file is an X12 document). 

2) Use a Lightweight JDBC Adaptor to retrieve the extra data that you need using a SQL query to the external data source.

3) Use a Map to map input document to output document and insert the extra data as well as extra segments as required

Regards,

Vivek Mittal

Archisage Pty Ltd

Hi Lakshman,

Please check these contents: