Using Database Aliases with Multiple Jobs

When you use multiple jobs processing, database aliases are assigned according to the primary job record. For example, if you reference an employee's pay rate, the pay rate from the primary job record is returned.

See Understanding the Primary Job Selection.

Multiple Jobs Considerations for Database Table Alias and Field

To access the service function result status of accruing or not accruing:

1. Select People Soft Table.

2. Enter PA_PEN_SVC_STAT in the Record field.

3. Enter Status in the Field Name field.

4. Select the Associated Plan and the Service Function Result in the Multiple Jobs group box.