Automation SQL Field Mappings H
Automation SQL Field Mappings V
Use this page to:
To access this page:
- Click the Automation tab on the Quick Panel.
- Click the Mappings icon for an Object.
Automation SQL Field Mappings V
Automation SQL Field Mappings H
General
Field
Description
Reject
Click to reject the selected mapping(s).
If the mapping action is Rule or RuleXref, the Rule SQL field must also have beencompleted with the correct SQL for the rule in the RULE COMMENT field.
NOTE: If the target is in a Design Status of Inactive or Complete, this icon is disabled.
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 can be updated in SQL AutoGen on this page. Refer to Update a Rule Status for more information.
Mapping
Source
Displays name of the source used in field mapping.
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. If the field is blank, then the target for the selected mapping is not joined to another target.
Instruction
Displays the system-generated summary about the field mapping.
Additional Notes
Displays user-entered notes about the mapping.
Rule Details
Auto Generate Rule
If checked, the rule for the field mapping is generated when the user clicks the Create and Complete icon on the Horizontal View.
Rule Name
Displays the rule name of the rule to be autogenerated.
NOTE: Rule names must follow naming conventions. Refer to Naming Conventions for more information.
Audit Information
Field
Description
Tracking
Mapped By
Displays user ID of individual who selected Complete in the Mapping Status list box on the Field Mappings page in Map.
Mapped On
Displays date and time when field mapping completed, for example, when the MAPPING STATUS field was set to Complete on the Field Mappings page in Map.
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 this 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 this page to create the rules for the approved mapping.
Approved By
Displays the user ID of the user who approved the rule on the Create and Approve Rules icon on the Automation page
NOTE: If the rule has not been approved this field is blank. Rules do not need to be approved to be autogenerated.
Approved On
Displays date and time when rule was approved on the Mapping Approval page.
NOTE: If the rule has not been approved this field is blank. Rules do not need to be approved to be autogenerated.
Rejected By
Displays the user ID of the user who rejected the rule on the Mapping Approval page or on this page.
NOTE: If the rule has not been rejected this field is blank. Rules do not need to be reviewed to be autogenerated.
Rejected On
Displays date and time when rule was rejected on the Mapping Approval page or on this page.
NOTE: If the rule has not been rejected this field is blank. Rules do not need to be reviewed to be autogenerated.
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.