Capture Values for Data Elements

ADP specifies and manages most of the data elements, which have implementation-specific pre-defined list of values. Record these values to Oracle HCM Cloud before they become available for use during person management transactions. Use user lookup types and value sets to capture these values.

The application captures values as lookup codes within specific lookup types, or as value set values directly to establish a parent child relationship between them. For example, Business Area is captured as a lookup code but Employee Group and Subgroup are captured as value set values.

Note: Discuss about these fields with ADP implementation team early in the implementation cycle. Setup of some of these attributes might be part of ADP Global Payroll implementation scope. ADP Global Payroll may configure these fields, ruling out the need for you setting up these fields in the interface.

For example, according to the implementation scope, work schedules are configured on the ADP Global Payroll system. So don't expect attributes like Work Schedule Rule and Working Hours Per Payroll Period through the interface.

Here are the additional data elements for the payroll interface for ADP Global Payroll:

Data Element Name	Level
Type Of Transfer	Assignment
Company Code	Assignment
Personnel Area	Assignment
Personnel Subarea	Assignment
Employee Group	Assignment
Employee Subgroup	Assignment
Business Area	Assignment
Work Contract	Assignment
Organizational Key	Assignment
HR Administrator	Assignment
Payroll Administrator	Assignment
Time Administrator	Assignment
Work Schedule Rule	Assignment
Employment Percentage	Assignment
Weekly Workdays	Assignment
Pay Scale Type And Area	Assignment
Pay Scale Group And Level	Assignment
Capacity Utilization Level	Assignment
Working Hours Per Payroll Period	Assignment
Number of Dependents	Person
Distance in Kilometers	Person

Additional Data Elements

Here's the detail of data elements that ADP Global Payroll interface captures as lookup codes and value sets:

Data Element Name	Data Type	Code
Type Of Transfer	Lookup	ORA_GPY_TRANSFER_TYPE
Company Code	Lookup	ORA_GPY_COMPANY_CODE
Personnel Area	Value set	ORA_GPY_PER_AREA_VS
Personnel Subarea	Value set	ORA_GPY_PER_SUB_AREA_VS
Employee Group	Value set	ORA_GPY_EMP_GRP_VS
Employee Subgroup	Value set	ORA_GPY_EMP_SUB_GRP_VS
Business Area	Lookup	ORA_GPY_BUSINESS_AREA
Work Contract	Lookup	ORA_GPY_WORK_CONTRACT
Organizational Key	Lookup	ORA_GPY_ORG_UNIT
HR Administrator	Lookup	ORA_GPY_HR_ADMIN
Payroll Administrator	Lookup	ORA_GPY_PY_ADMIN
Time Administrator	Lookup	ORA_GPY_TM_ADMIN
Work Schedule Rule	Lookup	ORA_GPY_WRK_SCHD_RULE
Employment Percentage	Free text	Numeric field
Weekly Workdays	Free text	Numeric field
Pay Scale Type And Area	Value set	ORA_GPY_PAY_SCALE_TYPE_AREA_VS
Pay Scale Group And Level	Value set	ORA_GPY_PAY_SCALE_GRP_LEVEL_VS
Capacity Utilization Level	Free text	Numeric field
Working Hours Per Payroll Period	Free text	Numeric field
Number of Dependents	Free text	Numeric field
Distance in Kilometers	Free text	Numeric field

Capture Values Through Lookups

Here's how you can capture values through lookups:

Note: Follow the same steps for other lookups by replacing the lookup types.

1. In the Setup and Maintenance work area, go to the Manage Common Lookups task.

2. Search for the ORA_GPY_BUSINESS_AREA lookup type.

3. In the lookup codes, enter the business areas as lookup codes. Specify the meaning and a meaningful description.

4. Click Save and Close.

Capture Values Through Value Sets

Here's how you can capture values through value sets:

Note: Follow the same steps for other value sets replacing the value set codes.

1. In the Setup and Maintenance work area, go to the Manage Value Sets task.

2. Search for the value set code ORA_GPY_PER_AREA_VS.

3. Click Manage Values.

4. Click the Create icon and enter each Personnel Area as a new value.

5. After you have entered values for all areas, click Save and Close.

6. On the Manage Value Sets page, search for the value set code ORA_GPY_PER_SUB_AREA_VS.

7. Click Manage Values.

8. Click the Create icon and enter each sub area as a new value. When entering each sub area, choose the area to which this sub area belongs in the Independent Value column.

9. After you have entered values for all sub areas, click Save and Close.