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

HCM_POSITION_HISTORY Table

Explanation
Contains historical information about positions from Workday. The table includes positions managed in Workday as of July 1, 2019 or thereafter. Multiple versions of position records are included and are organized by active indicators and date columns.

Common Uses
To determine what positions a Worker holds (or has held) at a point in time, the supervisory organization for each role, when the role appointment begins, the associated job profile code and title, the pay cycle, and the percentage of full-time hours spent in the role, the associated pay rate and base pay amount.

HISTORY_SEQUENCE
      

COMPANY_ID
COMPANY_NAME
MANAGER_PENN_ID
MANAGER_WORKDAY_ID
PAY_GROUP
POSITION_ID
POSITION_PENN_COST_CENTER
POSITION_SCHOOL_CTR 
POSITION_STATUS
PRI_PENN_COST_CENTER
PRI_PENN_SCH_CTR
SUPERVISORY_ORG_ID
SUPERVISORY_ORG_NAME
WORKDAY_ID
WORKER_PENN_ID

      

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)
HCM_WORKER_PAYMENT (DWHCM)
LKUP_HCM_ACAD_RANK_MAP (DWHCM)
      

• The HCM_POSITION_ HISTORY table contains a history of changes to HCM_POSITION records. To view the current record for a position, use the HCM_POSITION table.
  • In HCM_POSITION_HISTORY, the SCD_ACTIVE field indicates the “active” record for a position. The "active" position history record is the record that contains the current data for the position as stored in the HCM_POSITION table.  The SCD_START and SCD_END dates indicate the timeframe that a position history record was the “active” record.
  • Note: the SCD_START and SCD_END dates are not the dates when a change to a position was effective in Workday but rather the dates when a change to a position was first reflected in the warehouse (SCD_START) and subsequently superseded (SCD_END).
• The HCM_POSITION_HISTORY table contains historical records about positions managed in Workday, which came into use on July 1, 2019. In addition to currently filled positions, HCM_POSITION_ HISTORY may contain records about open or vacated positions.
• For information about roles and jobs in the legacy PennWorks and mainframe Personnel/Payroll systems, refer to the COMP_PERSON_ROLE and EMPLOYEE_JOB tables.
• For faculty workers, position records may be related to one or more academic appointments (available in HCM_ACAD_APPOINTMENT).
• You can access an HCM_POSITION_HISTORY 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_PERSON table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

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