Creating Normalization Mapping Tables
For the Normalization subsystem only, you can create additional mapping tables.
To create a new mapping table for the Normalization subsystem:
-
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.
-
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.
-
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.
-
-
Click Create to create the new table.The new mapping table appears in the list.
-
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.
-
In the Create a New Mapping Row section, enter the fields described in the following table:
Normalization Code Table Row Details Field name Description sourceCode1The code being mapped.targetCodeThe target code of the mapping.DescriptionA text description of the new table. -
Click Create to add the new mapping table row.
-
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.
-
Click Save to save your changes and return to the Mapping Tables page.