HCM_POSITION_GENERAL_V Table
Explanation
Contains most current non-confidential information about positions from Workday. The table includes positions managed in Workday as of July 1, 2019 or thereafter. There may be more than one row per worker if an individual occupies multiple positions.
Common Uses
To determine what positions a Worker holds (or has held), the supervisory organization for each role, when the role appointment begins, the associated job profile code and title, the pay cycle, and the percentage of full-time hours spent in the role.
| Primary Key |
Indexed Data Elements |
Related Tables |
|
JOB_PROFILE_ID
MANAGER_PENN_ID
MANAGER_WORKDAY_ID
PENN_ID
POSITION_ID
POSITION_PENN_COST_CENTER
POSITION_SCHOOL_CTR
POSITION_STATUS
PRI_PENN_COST_CENTER
PRI_PENN_SCH_CTR
SUPERVISORY_ORG_ID
SUPERVISORY_ORG_NAME
WORKDAY_ID
|
HCM_ACADEMIC_UNIT (DWHCM)
HCM_ACAD_APPOINTMENT (DWHCM)
HCM_JOB_FAMILY (DWHCM)
HCM_PAP_COSTING (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_COMPENSATION (DWHCM)
HCM_POSITION_COSTING (DWHCM)
HCM_POSITION_HISTORY (DWHCM)
HCM_SUPERVISORY_ORG (DWHCM)
HCM_WORKER_ENCUMBRANCE (DWHCM)
HCM_WORKER_PAYMENT (DWHCM)
LKUP_HCM_ACAD_RANK_MAP (DWHCM)
|
Cautions
- The HCM_POSITION_GENERAL_V view contains records about positions managed in Workday, which came into use on July 1, 2019. In addition to currently filled positions, HCM_POSITION_GENERAL_V may contain records about open or vacated positions.
- For information about roles and jobs in the legacy PennWorks and mainframe Personnel/Payroll systems, refer to the COMP_PERSON_ROLE and EMPLOYEE_JOB tables.
- For faculty workers, position records may be related to one or more academic appointments (available in HCM_ACAD_APPOINTMENT).
- Penn_ID and Position_ID should be used to uniquely identify records in HCM_POSITION_GENERAL_V, and Penn_ID used to join HCM_POSITION_GENERAL_V 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_POSITION_GENERAL_V table does not keep longitudinal history.
- You can access all HCM_POSITION_GENERAL_V rows if you are granted access to the view. To access confidential data about a position, use the HCM_POSITION table.
- The HCM_POSITION_GENERAL_V 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
|
