Adding Records to an Element Map

The procedure for adding records to an element map depends on the record's main (first) key:

  • If the main key is PIN_NUM, the record type is Element Definition (also called Rule Definition).

    Note: Rule definitions are created only by PeopleSoft.

  • If the main key is not PIN_NUM, the record type is Output Result Data, Payee Data, or Set Up Definition, depending on its purpose.

This topic discusses how to add non-rules to an element map.

This topic describes the procedure for adding non-rule definitions to an element map, where the record's main key is not PIN_NUM.

To add a non-rule to an element map:

  1. Use PeopleTools to create a SQL view for the record.

    The view must have the same structure as your new record, as illustrated in the following example.

    In the Select statement, enter + 50 000 000 after each field in the record that references a PIN number.

  2. On the Define/Build page, add a row for the new record.

  3. Complete these fields on the Define/Build page:

    1. For Record Type, select Output Result Data, Payee Data, or Set up Definition.

    2. For Record, select your new record.

    3. For Export Record, select the view that you created in step 1.

    4. For Effective Date Type, select the appropriate value for the record.

    5. For Field Name, select any field in the record that references PIN_NUM.

    6. In the Fields Referencing Other Elements group box, list each field within your record that contains a PIN number.

      This includes the field name defined in step e. You can select only PIN_NUM.

Example

This illustration shows how your SQL statement should match the record structure.

 Record definition for GP_ PYE_OVR_SOVR
SELECT EMPLID
,EMPL_RCD
,PIN_NUM + 50000000
,BGN_DT
,PIN_SOVR_NUM + 50000000
,END_DT
,ENTRY_TYPE_SOVR
,SOVR_VAL_CHAR
,SOVR_VAL_NUM
,SOVR_VAL_DT
  FROM PS_GP_PYE_OVR_SOVR