HCM_PERSON_PASSPORT Table
Explanation
Contains most current available passport information for Workers and Affiliates from Workday. The table includes individuals who had Workday records as of July 1, 2019 or thereafter.
Common Uses
Determining the passport status and related dates for individuals managed by Workday.
| Primary Key |
Indexed Data Elements |
Related Tables |
|
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_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)
|
Cautions
- The HCM_PERSON_PASSPORT table contains records for Workers (employees and contingent workers) and Academic Affiliates managed in Workday.
- Penn_ID should be used to uniquely identify records in HCM_PERSON_PASSPORT, and to join HCM_PERSON_PASSPORT 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_PASSPORT table does not keep longitudinal history. Historical snapshots of this information are available in the HCM_PERS_PASSPORT_SNAP table, beginning with the JAN-2020 period.
- You can access an HCM_PERSON_PASSPORT row only if you are authorized to access data for the individual's Pri_Penn_Cost_Center.
- The HCM_PERSON_PASSPORT table can be found in the DWHCM schema.
Source
Workday, in use at Penn since July 2019.
Questions about this page? Email us at da-staff@isc.upenn.edu
|
