Field Mappings by Target Field (All Waves)
Field Mappings by Target Field (All Waves) V
Use this page to Copy a Mapping.
To access this page:
-
Select dspMigrate in the Navigation pane.
-
Select Map in the Context bar.
-
Click the Targets icon on the Process Area Launch page.
Or
Click the Targets icon and click the Sources icon for a Target.
-
Click the Mappings icon for a Target or Target Source.
-
Select a mapping.
-
Click the View All Waves Mappings icon in the Page toolbar.
Field Mappings by Target Field (All Waves) V
Field Mappings by Target Field (All Waves) H
Use this page to view information about the field mapping.
This page has the following tabs:
General tab
Field
Description
Status
Mapping Status
Displays an icon that represents the Mapping Status of the field in the mapping process.
Rule Status
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
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. 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.
Instruction
Displays the system-generated summary about the field mapping.
Remediation Value
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.
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.
Additional Notes
Displays user-entered notes about the mapping.
Where Clause Override
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
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 or the Create and Complete icon on the Automation SQL Field Mappings 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 or the Create and Complete icon on the Automation SQL Field Mappings 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.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.