Field Mappings by Target Field (All Waves)

Description

Click to copy the selected mapping to the selected Target or Source.

NOTE: If more than one mapping is selected, this icon is disabled.

NOTE: If the current user is a member of the Map WebApp Groups Ready Only or ValueMapper and is not a member of other groups with broader authorization for changes, this icon does not display.

NOTE: If the selected field has an action set, the Copy icon is disabled. Fields with an action cannot be copied.

Displays the Wave and Process Area that contains the mapping for the field. All mappings across all Waves, Process Areas, and Objects for this field (based on System Types) display on this page.

Displays the Object that contains the mapping for the field. All mappings across all Waves, Process Areas and Objects for this field (based on System Types) display on this page.

Displays the name of the Metric Group added in Target Design Metric groups are a category of field groups that organize and prioritize fields in field groups for mapping.

Displays the name of the field group filter used to organize fields into subsets so that different rules, criticality levels, requirements settings and documentation can be set for these subsets based on values in related fields.

Displays the name of the field to be mapped. The technical field name (including the table) is in bold. The field description is in italics.

Displays the Source system name and the Add Row Source.

If the Source System says “SELECT SOURCE,” no Source has been selected. If it says “{Target Rules},” the rule is a Target rule.

NOTE: If the Target field is a key field on the Target table, a key icon displays to the right of the field name.

Displays action used to map field.

NOTE: If the selected field has an action (as in, a selection displays in the ACTION column), the Copy icon is disabled. Fields with an action cannot be copied.

 Values are:

• Construction
• Copy
• Default
• Internal
• Manual Rule
• Manual Construction
• Not Used
• Rule
• Rule Xref
• Xref

Refer to Select an Action for more information.

Displays the name of the lookup table created in Target Design. Lookup tables can be viewed for mappings with any action. In AutoGen, lookup tables are used with mappings that have an action of RuleXref and Rule.

Displays Source table used for Copy, RuleXref, Xref or Construction actions.

NOTE: When mapping a Source, this field displays the Add Row and Update Row Sources for the Add Row Source only. When mapping a Target, the field displays any Target in the Wave and Process Area.

Displays technical information entered by the Mapper to help the Developer build the rule when the action for the mapping is Manual Rule.

Displays Source field used for Copy, RuleXref, Xref or Construction actions.

Displays data used in the default rule creation process (as in, when ACTION is set to Default). For ACTIONS other than Default, this field is <Blank>.

While mapping a field with the Default action, a user can create output values for blank, empty, and null values.

The rule created by the mapping uses these output values:

• If the user enters <blank> in the Default field on the Field Mappings page, the output used in the rule is single quotes with one space between them (' '). 
• If the user enters <empty>, the rule uses single quotes with no space between them ('').
• If the user enters <null>, the rules uses NULL, representing no data.

Displays the SQL for the rule entered on the Mapping Approvals page. A developer must enter SQL when rejecting a mapping that has a Manual, Rule or RuleXref action.

Displays an icon that represent  the Mapping Status of the field in the mapping process.

• A red icon indicates a Mapping Status of Pending Review.
• A yellow icon represents Design Required.
• A green icon indicates mapping is Complete.

A user can update the Mapping Status on the Vertical View.

Displays an icon representing the Rule Status of the rule to be built from the mapping once it is complete.

• A red icon indicates a Rule Status of Pending Review.
• A yellow icon represents Revision Requested or that the associated mapping has been submitted and is waiting for Developer review.
• A green icon indicates the Rule is Complete.

Rule status is updated by the system and cannot be changed by the user in Map.

Rule status can be updated in SQL AutoGen on the Automation SQL Field Mappings page. Refer to Update a Rule Status for more information.  

Description

Status

Displays an icon that represents  the Mapping Status of the field in the mapping process.

Displays an icon representing the Rule Status of the rule to be built from the mapping once it is complete.

Rule status is updated by the system and cannot be changed by the user in Map.

Rule status can be updated in SQL AutoGen on theAutomation SQL Field Mappings page. Refer to Update a Rule Status for more information.  

Mapping

Displays name of the Source used in field mapping.

Displays the name of the External Source if one is used in the mapping. If the field is blank, an external Source was not used.

An External Source is an Update Row Source that is external to the system used in the Add Row Source when establishing a relationship.

Sources are designated as External Sources in Target Design.

NOTE: This list box displays Update Row Sources only. An Add Row Source cannot be used as an External Source type. The External Source table must be registered as an Update Row first.

Refer to Add an External Source for more information.

Displays the name of the lookup table created in Target Design. Lookup tables can be viewed for mappings with any action. In AutoGen, lookup tables are used with mappings that have an action of RuleXref and Rule.

Displays the name of the table that is joined to the current table in a relationship. Relationships join Add Row and Update Row Sources together. If the field is blank, then the Target for the selected mapping is not joined to another.

Displays the system-generated summary about the field mapping.

Displays the value to use while building a remediation report for field mappings that do not use the Xref or RuleXref action. This field only displays when {Target Rules} is selected on the Field Mappings page. This field only displays for {Target Rule} Target Sources.

Displays the remediation comment that display on the remediation report for field mappings that do not use the Xref or RuleXref action. This field only displays when {Target Rules} is selected on the Field Mappings page.

Displays user-entered notes about the mapping.

The Where Clause Override is an extra clause that conditions to the download SQL, for example, WHERE SPRSL NOT IN (‘a’,’b’,’c’,’d’) and Where ColumnKey like ‘2007%’.

NOTE: When a where clause override is added to a table that is set up as a Data Services package the initial build will require an additional build. Immediately after the first build runs, the user must rerun the build. The second build will use the clause entered in the Where Clause Override field to refresh the table’s contents when a refresh is run. After the second build, the clause entered in the Where Clause Override field will be up to date for every subsequent build, and the user is not required to build the package more than once.

Rule Details

If checked, the rule for the field is auto-generated.

Displays the name of the rule to be generated. This field only displays when {Target Rules} is selected on the Field Mappings page.

Description

Tracking

Displays user ID of individual who set the mapping to a MAPPING STATUS of Complete. After a mapping status is set to Complete the mapping can be submitted for approval.

Displays date and time when field mapping completed, as in when MAPPING STATUS was set to Complete.

Displays user ID of individual who clicked Submit for the mapping on the Field Mappings page. The mapping can then be approved or rejected on the Mapping Approval page.

Displays date and time when the user clicked Submit for the mapping on the Field Mappings page.

Displays user ID of individual who clicked the Create and Approve Rules icon on the Automation page or the Create and Complete icon on the Automation SQL Field Mappings page  to create the rules for the approved mapping.

Displays date and time when a user clicked the Create and Approve Rules icon on the Automation page or the Create and Complete icon on the Automation SQL Field Mappings page  to create the rules for the approved mapping.

Displays user ID of individual who approved the mapping on the Mapping Approval page. Once approved, the rules for the mapping can be created on the Automation page

Displays date and time when the mapping was approved on the Mapping Approval page.

Displays user ID of individual who rejected the mapping on the Mapping Approval page. If Rejected, the mapping must be updated and submitted again on the Field Mappings page.

Displays date and time when the mapping was rejected on the Mapping Approval page.