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

HCM_PAP_COSTING Table

Explanation
Contains information about period activity pay established for positions managed in Workday as of July 1, 2019 or thereafter. There may be multiple rows per worker if an individual occupies multiple positions, or there are multiple activity pay rows (e.g., for multiple accounts) per position and timeframe. Not all positions have period activity payments.

Common Uses
To determine the period activity payments, dates, and types of activity for which payments were made, for a position.

PENN_ID
PERIOD_ACT_END_DATE
PERIOD_ACT_END_FISCAL_YEAR
PERIOD_ACT_END_YEAR
PERIOD_ACT_START_DATE
PERIOD_ACT_START_FISCAL_YEAR
PERIOD_ACT_START_YEAR
POSITION_ID
POSITION_PENN_COST_CENTER
POSITION_SCHOOL_CTR 
POSITION_SUPERVISORY_ORG_ID
PRI_PENN_COST_CENTER
PRI_PENN_SCH_CTR
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)
HCM_WORKER_PAYMENT (DWHCM)
LKUP_HCM_ACAD_RANK_MAP (DWHCM)
ORG_CODES (DWADMIN)
PROGRAM_CODES (DWADMIN)

• The HCM_PAP_COSTING table contains records about payments associated with particular period activity for positions managed in Workday, which came into use on July 1, 2019.
• Not all positions have period activity pay; if a position did have period activity pay in the past, it may not have it on an ongoing basis. Individuals with period activity pay may also have pay for the same time frame resulting from their positions' compensation plan(s).
• Refer to the HCM_WORKER_PAYMENT table to see the actual details of all payments for a position for a particular time period.
• Period activity pay records include COA ORG, Fund, Program and CREF segments; the Object code will be assigned at the time payments are generated and is not available in the activity pay detail.
• Penn_ID should be used to uniquely identify records in HCM_PAP_COSTING, and to join HCM_PAP_COSTING 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_PAP_COSTING table does not keep longitudinal history. Historical snapshots of this information are available in the HCM_PAP_COST_SNAP table, beginning with the JUL-19 period.
• You can access an HCM_PAP_COSTING row only if you are authorized to access data for the individual's Pri_Penn_Cost_Center, the Penn_Cost_Center or Position_Default_Penn_Cost_Ctr for a particular position, or the Costing_COA_ORG or the Costing_COA_Resp_ORG.
• The HCM_PAP_COSTING table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

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