During an Import EDI, an SOD Workflow can be hinged to the import process to perform evaluations of the incoming data in the import file against existing data in the IMPACT database.
As shown in the diagram below, the system leverages a user-defined table to temporarily store the inbound data so a Strategy on Demand (“SOD” Workflow of Activity Type “EDIIMP” can perform these evaluations. The results of these evaluations and comparisons can result in updates executed by the EDIIMP SOD.)
In line with the previous example of an export to a vendor, this scenario will show how a return file with the results of the scrub can be imported and, at the same time, the inbound data be evaluated. Based on the results of these evaluations, the underlying EDIIMP SOD Workflow will execute updates on the accounts.
First, the return file needs to be examined to determine its format and layout. Then, an Import Mapping Definition “IMD” is created to mirror the file layout. Then and EDI Import is provisioned that uses the predefined IMD. Finally, the EDIIMP SOD Workflow is configured to perform the desired evaluations and updates.