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

HCM_PERSON_EDUCATION Table

Explanation
Contains most current available higher education information for Workers and Affiliates from 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 an individual's higher education degree, field of study, or year of graduation.

EDUCATION_DESC
EDUCATION_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_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_PERSON_EDUCATION table contains records for Workers (employees and contingent workers) and Academic Affiliates managed in Workday. Not all individuals will have rows in this table, and the amount of information available will vary based on data maintained by the individual in Workday.
• Penn_ID should be used to uniquely identify records in HCM_PERSON_EDUCATION, and to join HCM_PERSON_EDUCATION 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_EDUCATION table does not keep longitudinal history. Historical snapshots of this information are available in the HCM_PERS_EDUC_SNAP table, beginning with the JUL-19 period.
• You can access an HCM_PERSON_EDUCATION row only if you are authorized to access data for the individual's Pri_Penn_Cost_Center.
• The HCM_PERSON_EDUCATION table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

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