Create an EDI Layout from an EDI Standard

When you create a new map, you can either manually create an EDI layout or you can use a wizard that creates a layout for you based on an EDI standard. The wizard saves you time and effort and minimizes the risk of having an invalid standard format.

Note: To create a map using EDI standards, you must have downloaded the EDI standards bundle (from the Deployment > Standards menu) to the same machine where the Sterling B2B Integrator Map Editor is installed. For a complete list of the EDI standards consult Customer Support.

To create an EDI layout from an EDI standard:

  1. From the File menu, select New.
  2. In the New Map Wizard, complete the questions in the first window and click Next.
    Note: Be sure that Sterling B2B Integrator is selected in the What kind of map are you creating list.
  3. If you are translating from EDI, in the Input Format window select Delimited EDI and click Customize. If you are translating from another format, select that format and continue to the next screen.
  4. Select the Import code list checkbox if you want to import code lists from the database, and click Next.
  5. Select the ODBC data source that contains the standards database and click Next.
    Note: The default data source names used by Sterling B2B Integrator Map Editor are HIPAA Standards and Sterling B2B Integrator Standards.
  6. Select the standards agency, version, and transaction set and click Next.
  7. Click Finish to load the transaction set you selected.
  8. If you are translating to EDI, in the Output Format window, select Delimited EDI and click Customize.
  9. Select the Import code list checkbox if you want to import code lists from the database, and click Next.
  10. Select the ODBC data source that contains the standards database and click Next.
    Note: The default data source names used by Sterling B2B Integrator Map Editor are HIPAA Standards and Sterling B2B Integrator Standards.
  11. Select the standards agency, version, and transaction set and click Next.
  12. Click Finish. The Sterling B2B Integrator Map Editor displays the new map in the Sterling B2B Integrator Map Editor window.

Please note the following when you create EDI maps from the standards database:

  • The EDI standards database does not currently have the capability to store more than one version of a record for a given standards version (except for HIPAA). Therefore, it must store the least restrictive version of that record and because of this, some fields are not created as mandatory even when they are noted as “required” in an implementation guide (for example, RAIL, VICS, and so forth).
  • Additionally, maps created from the standards database do not currently indicate which elements are identified as “not used” according to an implementation guide (for example, RAIL, VICS, and so forth). The Sterling B2B Integrator Map Editor is able to display fields as “not used,” and you can set these manually (see Validation Tab for more information). However, the standards database does not store this information yet, except for the HIPAA standard.