HCM_WORKER_PAYMENT Table - Data Element Index   Tables and Data Elements   Human Capital Management Home   Data Warehouse Home

HCM_WORKER_PAYMENT Table

Explanation
Contains data on payments made to employees, and any payment reallocations, for positions managed in Workday as of July 1, 2019 or thereafter. There is one record per payment or reallocation (per person, position, check date, account number and earnings type).

Common Uses
To determine actual salary expenses, broken down by employee or accounting segment.

ACCOUNTING_PERIOD
FISCAL_MONTH_SEQ
FISCAL_SORT_SEQ
FISCAL_YEAR
PAY_GROUP
PENN_ID
POSTED_COA_ACCOUNT
POSTED_COA_BC
POSTED_COA_CENTER_REF
POSTED_COA_CNAC
POSTED_COA_FUND
POSTED_COA_OBJECT
POSTED_COA_ORG
POSTED_COA_PROGRAM
POSTED_COA_RESP_ORG
PRI_PENN_COST_CENTER
PRI_PENN_SCH_CTR
PRI_SUPERVISORY_ORG_ID
WORKDAY_ID
      

CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
FUND_CODES (DWADMIN)
HCM_ACADEMIC_UNIT (DWHCM)
HCM_ACAD_APPOINTMENT (DWHCM)
HCM_JOB_FAMILY (DWHCM)
HCM_PARENT_ACADEMIC_UNIT (DWHCM)
HCM_PARENT_SUPERVISORY_ORG (DWHCM)
HCM_PERSON (DWHCM)
HCM_PERSON_ADDRESS (DWHCM)
HCM_PERSON_CITIZENSHIP_COUNTRY (DWHCM)
HCM_PERSON_CITIZENSHIP_STATUS (DWHCM)
HCM_PERSON_EDUCATION (DWHCM)
HCM_PERSON_LEAVE_OF_ABSENCE (DWHCM)
HCM_PERSON_RACE_ETHNICITY (DWHCM)
HCM_PERSON_VISA (DWHCM)
HCM_POSITION (DWHCM)
HCM_POSITION_COMPENSATION (DWHCM)
HCM_POSITION_COSTING (DWHCM)
HCM_SUPERVISORY_ORG (DWHCM)
HCM_WORKER_ENCUMBRANCE (DWHCM)
LKUP_HCM_ACAD_RANK_MAP (DWHCM)
ORG_CODES (DWADMIN)
PROGRAM_CODES (DWADMIN)

• The HCM_WORKER_PAYMENT table contains records about payments associated with workers and positions managed in Workday, which came into use on July 1, 2019.
  • This table includes detailed payment actual dollar amounts. Hours worked are not available.
  • Each pay period's data is appended to the existing table.
  • Records include reallocations performed to Workday payroll results via the BEN Payroll Reallocation system.
  • For information about employee payments generated by the legacy Salary Management system (through July 1, 2019), refer to the EMPLOYEE_PAYMENT table.
    • 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.
• Only salary payment amounts are included. Employee benefits amounts are summarized at the 26-digit account level in the BALANCES table in the General Ledger collection (using the appropriate object codes, such as 5190, EB Full Time).
• Penn_ID should be used to uniquely identify records in HCM_WORKER_PAYMENT, and to join HCM_WORKER_PAYMENT to other tables in the Warehouse. Workday ID is an 8 digit field for workers and affiliates unique to Workday.  It is distinct from the Penn ID, which has the same format, but is maintained by Penn Community and is the unique identifier for individuals across Penn’s systems.
• You can access an HCM_WORKER_PAYMENT row only if you are authorized to access data for the individual's Pri_Penn_Cost_Center, the Position_Penn_Cost_Center, the Posted_COA_ORG or the Posted_COA_Resp_ORG.
• The HCM_WORKER_PAYMENT table can be found in the DWHCM schema.

Source

Workday, via the BEN Payroll Reallocation system, both in use at Penn since July 2019.

HCM_WORKER_PAYMENT Table - Data Element Index   Tables and Data Elements   Human Capital Management Home   Data Warehouse Home