Creating Normalization Mapping Tables

A content reuse widget was here but the content was missing. The reused content is Media_Repository/Primo/Primo_VE_Doc_Note

Return to menu

For the Normalization subsystem only, you can create additional mapping tables.

To create a new mapping table for the Normalization subsystem:

  1. On the Mapping Tables page, select Normalization in the Sub System drop-down list.

    The Create a New Code Table section displays at the bottom of the page.

  2. Select the configuration level of the mapping table in the Update for Owner drop-down list. If the information you are mapping pertains to a specific institution, select that institution.

    For institution-level staff users, the system will select your institution automatically.

  3. In the Create a New Code Table section, enter the following fields:

    • Table Name– Type the name of the new code table.

      The table names must be unique for all mapping and code tables.

    • Description– Type a description for the new code table.

  4. Click Create to create the new table.

    The new mapping table appears in the list.

  5. Click Edit next to the new mapping table in the list to add mapping rows.

    The Mapping Tables page opens for the new mapping table.

  6. In the Create a New Mapping Row section, enter the fields described in the following table:

    Normalization Code Table Row Details
    Field name Description

    sourceCode1

    The code being mapped.

    targetCode

    The target code of the mapping.

    Description

    A text description of the new table.

  7. Click Create to add the new mapping table row.

  8. Repeat Steps 7 and 8 to add additional mapping table rows.

    If you are using this mapping table for normalization rule transformations, you cannot define more than one mapping row. If you define two or more rows, the system returns unexpected results.

  9. Click Save to save your changes and return to the Mapping Tables page.