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

HCM_POSITION_COMPENSATION Table

Explanation
Contains information about components of pay used to assign monetary amounts to a worker’s pay for positions managed in Workday as of July 1, 2019 or thereafter. There may be more than one row per worker if an individual occupies multiple positions, or there are multiple components of pay per position.

Common Uses
To determine the components of pay (e.g. salary or allowance plans), and the related amounts and effective dates, for a position.

COMPENSATION_GRADE_DESC
COMPENSATION_GRADE_ID
COMPENSATION_PLAN_DESC
COMPENSATION_PLAN_ID
COMPENSATION_PLAN_TYPE
COMP_ACTUAL_END_DATE
COMP_ACTUAL_END_YEAR
COMP_ACT_END_FISCAL_YEAR
COMP_EFFECTIVE_START_DATE
COMP_EFFECTIVE_START_YEAR
COMP_EFF_START_FISCAL_YEAR
PENN_ID
POSITION_ID
POSITION_PENN_COST_CENTER
POSITION_SCHOOL_CTR 
POSITION_SUPERVISORY_ORG_ID
PRI_PENN_COST_CENTER
PRI_PENN_SCH_CTR
WORKDAY_ID

      

HCM_ACADEMIC_UNIT (DWHCM)
HCM_ACAD_APPOINTMENT (DWHCM)
HCM_JOB_FAMILY (DWHCM)
HCM_PAP_COSTING (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_COSTING (DWHCM)
HCM_SUPERVISORY_ORG (DWHCM)
HCM_WORKER_ENCUMBRANCE (DWHCM)
HCM_WORKER_PAYMENT (DWHCM)
LKUP_HCM_ACAD_RANK_MAP (DWHCM)

• The HCM_POSITION_COMPENSATION table contains records about compensation components associated with particular positions managed in Workday, which came into use on July 1, 2019.
• Records may represent salary or allowance plans which relate to earnings for a defined timeframe (rather than pay period amounts).
• Penn_ID should be used to uniquely identify records in HCM_POSITION_COMPENSATION, and to join HCM_POSITION_COMPENSATION 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.
• Keep in mind that this is the latest information about an individual with records managed by Workday - the HCM_POSITION_COMPENSATION table does not keep longitudinal history. Historical snapshots of this information are available in the HCM_POSI_COMP_SNAP table, beginning with the JUL-19 period.
• You can access an HCM_POSITION_COMPENSATION row only if you are authorized to access data for the individual's Pri_Penn_Cost_Center or the Penn_Cost_Center for a particular position.
• The HCM_POSITION_COMPENSATION table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

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