Data from Workday is loaded into specifically created tables in the Human Capital Management collection designed to support Workday concepts and data structures. Upon the retirement of PennWorks and the mainframe Personnel/Payroll system, the legacy Salary Management collection will remain available for historical analysis. Only select columns in the EMPLOYEE table (and the EMPLOYEE_GENERAL view) and the JOB_CLASS table (and JOB_CLASS_GENERAL view) will be updated with Workday data, to support longitudinal and cross-collection reporting.
The Human Capital Management information is conceptually similar in many cases to the legacy PennWorks and mainframe Salary Management data. The following table provides a mapping from the Salary Management collection tables/views to those in the HCM collection.
Type of Information |
Legacy Tables or views (data from PennWorks or Mainframe Payroll) |
HCM Collection Table |
|
Person – bio/demo |
COMP_PERSON |
HCM_PERSON |
|
COMP_PERSON_ADDRESS |
HCM_PERSON_ADDRESS |
|
|
COMP_PERSON_LONG_ADDRESS |
HCM_PERSON_ADDRESS |
|
|
EMPLOYEE |
HCM_PERSON |
|
|
EMPLOYEE_ADDRESS |
HCM_PERSON_ADDRESS |
|
|
EMPLOYEE_GENERAL |
HCM_PERSON |
|
|
EMPLOYEE_ETHNICITY and RACE_ETHNICITY_SURVEY_FLAT |
HCM_PERSON*, HCM_PERSON_RACE_ETHNICITY |
|
|
Positions and Appointments, Distribution and Compensation |
COMP_PERSON_ROLE |
HCM_POSITION (worker positions) |
|
COMP_PERSON_ROLE_JOINT_ORG |
HCM_ACAD_APPOINTMENT (contains rows representing PIK and Joint academic units) |
|
|
EMPLOYEE_JOB |
HCM_POSITION (worker positions) |
|
|
COMP_PERSON_SALARY, COMP_PERSON_SALARY_SUMMARY |
[no direct equivalent; HCM_POSITION_COMPENSATION contains compensation plan data that may serve a similar purpose] |
|
|
COMP_DISTRIBUTION |
[no direct equivalent; HCM_POSITION_COSTING contains costing allocations used to distribute costs, but these do not drive pay] |
|
|
EMPLOYEE_DISTRIBUTION |
||
|
Payment actuals and Encumbrance details |
EMPLOYEE_ENCUMBRANCE (and EMPLOYEE_ENCUMBRANCE_CURRENT view) |
HCM_WORKER_ENCUMBRANCE |
|
EMPLOYEE_PAYMENT Note that the very last weekly pay cycle run in the legacy Salary Management system for the week of 6/24/2019 is posted to the JUL-19 accounting period. In order to report on total pay amounts for JUL-19, amounts from that weekly pay in EMPLOYEE_PAYMENT and the rest of period in HCM_WORKER_PAYMENT must be summed together. |
HCM_WORKER_PAYMENT |
|
|
EMPLOYEE_PAYMENT_SUMMARY |
HCM_WORKER_PAYMENT |
|
|
PAR_EARNINGS |
HCM_WORKER_PAYMENT (includes only dollar amounts, not hours worked) |
|
|
Reference / Lookup |
JOB_CLASS (and JOB_CLASS_GENERAL view) |
HCM_JOB_FAMILY |
|
MAIL_CODE |
[no direct equivalent; Workday provides location information available by individual in HCM_PERSON] |
|
|
Additional Pay |
COMP_PAY_DISTRIBUTION |
[no direct equivalent; results of Workday one-time payments will be included in resulting payroll actuals in HCM_WORKER_PAYMENT] |
|
Change Log |
COMP_CHANGE_LOG |
[no direct equivalent; audit records will be available to authorized users in Workday; Warehouse users can refer to monthly snapshot tables to see changes in data over time] |
|
PAR (Payroll Audit Record); Benefits & Tax |
PAR_DOLLAR_GTN_ADJUSTMENTS |
[no direct equivalent; similar data will be available to authorized users in Workday] |
|
Salary Increase |
COMP_INCREASE_BATCH |
[no direct equivalent; similar data will be available to authorized users in Workday] |
Considerations for using EMPLOYEE/EMPLOYEE_GENERAL July 2019+
- Only select columns in the EMPLOYEE table (and the EMPLOYEE_GENERAL view) will be updated with Workday data, to support longitudinal reporting.
- Since the concept of Home Organization does not exist in Workday, the Home Dept ORG and Home School Center columns will be populated with the Penn Cost Center ORG (or Center) Code associated with the employee’s primary position
- Refer to the EMPLOYEE and EMPLOYEE_GENERAL element documentation for specifics about mappings from Workday data
- Rows will be retained for employees terminated prior to the implementation of Workday
- As of July 2019, Primary Appointment and Primary Academic Appointment elements are sourced from Workday and loaded to the EMPLOYEE table and are no longer calculated during the Warehouse load process
- Once a Worker has been terminated in Workday, his/her Primary and Primary Academic elements will be null