SQL AutoGen

Automation SQL Field Mappings H

Automation SQL Field Mappings V

To access this page:

  1. Click the Automation tab on the Quick Panel.
  2. Click the Mappings icon for an Object.

Field

Description

Create and Complete

Click to build a view and a stored procedure for the selected field mapping in the object database. The rule is automatically registered in Transform.

NOTE: Rules can be created for one mapping at a time.

NOTE: After the user clicks this icon, the Rule Status is set to Complete.

NOTE: If the target is in a Design Status of Inactive or Complete, this icon is disabled.

Reset

Click to clear the Mapping Status and Rule Status for the selected field mapping on the Field Mappings page in Map. This process allows the mapper to remap the field.

NOTE: When a user clicks Reset, the Created By field on the Vertical View of the Field Mappings page is updated to display the user name of the user who clicked Reset. The Created On field, on the Vertical View of the Field Mappings page, is updated to reflect the date of the reset.

NOTE: Rules can be reset for one mapping at a time.

NOTE: The Reset Field Mapping parameter set in Console on the Parameters page controls how a mapping is updated when it is reset. Options are:

  • Reset all Field Mapping Fields – All fields are cleared of values

    NOTE: If the mapping is associated with a field group other than the default field group (* or “All”), the Target Relationship ID field is not updated on a reset.

  • Reset Status Fields only – All fields retain values except for the Mapping Status and Rule Status, which are set to Pending Review.

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.

Review Mappings

Click to open the Field Mappings page in Map for the selected mapping.

METRIC GROUP

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.

FIELD GROUP

Displays the name of the field group to which the field belongs. All fields are assigned to the default field group (*). Field groups are used to organize data to be able to apply different rules, criticality levels, requirements settings against each group depending on the values of data in a related field.

PRIORITY

Displays the order that fields should be mapped, and the order that fields display on the Field Mappings page in Map. Field priority is set on the Target Fields page in Target Design in the Field Order field.

TARGET FIELD

Displays the name of the target and field selected on the Field Mappingspage. The second line will display the description of the field enter in Target Design.

SOURCE DETAILS

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.

ACTION

Displays action used to map the field, such as Copy, Default, or Rule.

Values are:

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

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.

SOURCE TABLE

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.

RULES COMMENT

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

SOURCE FIELD

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

DEFAULT VALUE

Displays data used in the default rule creation process (for example, when ACTION is set to Default). For actions other than Default, this field is <Blank>. Enter <Blank> to indicate the field does not have a default value. The value will be automatically set to a space (' ').

RULE SQL

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.

CREATED ON

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

CREATED BY

Displays the user ID of the user who clicked the Create and Complete icon on this page or the Create and Approve icon on the Automation page.

MAPPING STATUS

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 is Complete.

RULE STATUS

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 is Complete.

Rule status can be updated. Refer to Update a Rule Status for more information.  

Log

Click to open the AutoGen SQL Log page and view successful or failed AutoGen tasks.

NOTE: If the icon is disabled, no source tables, target tables or rules have been generated for the selected 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.