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

HCM_ACAD_COMP_BUCKETS Table

Explanation
Contains most current available information about an Academic worker's compensation and current leave percentage managed in Workday as of July 1, 2019 or thereafter. This data warehouse table mirrors the Workday report, Academic Compensation Buckets.

Common Uses

• To determine the elements of an Academic worker's compensation, as well as the worker's current leave percentage, if applicable.

WORKDAY_ID
PENN_ID
PRI_PENN_COST_CENTER
PRI_PENN_AU_COST_CENTER
PRI_PENN_SCH_CTR

HCM_PERSON (DWHCM)

• The HCM_ACAD_COMP_BUCKETS table contains records about academic compensation managed in Workday, which came into use on July 1, 2019.
• Penn_ID should be used to join HCM_ACAD_COMP_BUCKETS to other tables in the Warehouse. Workday ID is an 8 digit field for workers 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_ACAD_COMP_BUCKETS table does not keep longitudinal history. Historical snapshots of this information are available in the HCM_ACAD_COMP_BUCKETS_SNAP table, beginning with the NOV-2020 accounting period.
• Only Academic workers are included on this table; the compensation elements shown are at the worker level, not the position level.
• The HCM_ACAD_COMP_BUCKETS table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

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