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.
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:
-
In the Setup and Maintenance work area, go to the Manage Common Lookups task.
-
Search for the ORA_GPY_BUSINESS_AREA lookup type.
-
In the lookup codes, enter the business areas as lookup codes. Specify the meaning and a meaningful description.
-
Click Save and Close.
Capture Values Through Value Sets
Here's how you can capture values through value sets:
-
In the Setup and Maintenance work area, go to the Manage Value Sets task.
-
Search for the value set code ORA_GPY_PER_AREA_VS.
-
Click Manage Values.
-
Click the Create icon and enter each Personnel Area as a new value.
-
After you have entered values for all areas, click Save and Close.
-
On the Manage Value Sets page, search for the value set code ORA_GPY_PER_SUB_AREA_VS.
-
Click Manage Values.
-
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.
-
After you have entered values for all sub areas, click Save and Close.