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

HCM_PERSON_LEAVE_OF_ABSENCE Table

Explanation
Contains most current available information about Workers' leaves of absence maintained in Workday. The table includes individuals who had Workday records as of July 1, 2019 or thereafter. There may be one or more rows per individual.

Common Uses
Determining leave of absence types and dates for a Worker.

LEAVE_FAMILY_DESC
LEAVE_FAMILY_ID
LEAVE_FAMILY_WID
LEAVE_TYPE_DESC
LEAVE_TYPE_ID
LEAVE_TYPE_WID
PENN_ID
PRI_PENN_AU_COST_CENTER
PRI_PENN_COST_CENTER
PRI_PENN_SCH_CTR
WORKDAY_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_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_PERSON_LEAVE_OF_ABSENCE table contains detailed leave of absence records for Workers managed in Workday. Not all individuals will have rows in this table, and there may be more than one row per person if multiple leave types apply at a given point in time.
  • The On_Leave_Flag, On_FMLA_Leave_Flag, First_Day_of_Leave, Last_Day_of_Leave, and Est_Last_Day_of_Leave in the HCM_PERSON table are aggregate single values derived from all the current detailed leave information for the individual.
• Penn_ID should be used to uniquely identify records in HCM_PERSON_LEAVE_OF_ABSENCE, and to join HCM_PERSON_LEAVE_OF_ABSENCE 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_PERSON_LEAVE_OF_ABSENCE table does not keep longitudinal history. Historical snapshots of this information are available in the HCM_PERS_LEAV_OF_ABSE_SNAP table, beginning with the JUL-19 period.
• You can access an HCM_PERSON_LEAVE_OF_ABSENCE row only if you are authorized to access data for the individual's Pri_Penn_Cost_Center.
• The HCM_PERSON_LEAVE_OF_ABSENCE table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

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