Automation SQL Field Mappings H

Automation SQL Field Mappings V

Use this page to:

To access this page:

  1. Click the Automation tab on the Quick Panel.
  2. 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.