Field Mappings H

Field Mappings V

Use this page to:

NOTE: Bulk Execution has been enabled on this page. Refer to Use Bulk Execution for more information.

To view all field mappings for the selected Target in Map:

  1. Select dspMigrate in the Navigation pane.
  2. Select Map in the Context bar.
  3. Click the Targets icon on the Process Area Launch page.
  4. Click the Mappings icon for a Target.

To view all field mappings for the selected Target Source in Map:

  1. Click Map in the Context bar.
  2. Click the Targets icon on the Process Area Launch page.
  3. Click the Sources icon for a Target.
  4. Click the Mappings icon for a Source.

To view all mappings for fields in a field group in Map:

  1. Click Map in the Context bar.
  2. Click the Targets icon on the Process Area Launch page.
  3. Click the Field Groups icon for a Target.
  4. Click the Mappings icon for a field group.

Field Mappings V

Field Mappings H

Use this page to:

This page has the following tabs:

General tab

Field

Description

Status

Mapping Status

Displays  the Mapping Status of the field in the mapping process.

Rule Status

Displays 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 the Automation SQL Field Mappings page. Refer to Update a Rule Statusfor more information.  

Mapping

Source

Displays name of the Source used in field mapping.

External Source ID

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.

Lookup

Displays the name of the lookup table created in Target Design. The name is a link that directs the user to further details about the lookup table. 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.

Target Relationship ID

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.

NOTE: The relationship between an Add Row Source and an Update Row Source that is external is auto derived.

Refer to Add Relationship Joins to Sources for more information.

Instruction

Displays the system-generated summary about the field mapping. If this field is blank, the rule has not yet been autogenerated.

Additional Notes

Displays user-entered notes about the mapping.

Rule Where Clause

Displays the Where Clause used to filter the records to which a rule is applied. The clause must consist of a column name, an operator and a value. For example, Active = ‘1’. Refer to Register Rules to Tables for more information.

Remediation Value

Displays the value to use while building a remediation report for field mappings that do not use the Xref or RuleXref action.

NOTE: This field only displays when the Source is {Target Rules} .

Remediation Comment

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.

Rule Details

Generate Rule

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

Rule Name

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

 

Audit Information tab

Field

Description

Tracking

Mapped By

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.

Mapped On

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

Submitted By

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.

Submitted On

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

Created By

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

Created On

Displays date and time when a user clicked the Create and Approve

Rules icon on the Automation page to create the rules for the approved mapping.

Approved By

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

Approved On

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

Rejected By

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.

Rejected On

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