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

HCM_PARENT_SUPERVISORY_ORG Table

Explanation
Reference table relating individual Supervisory Organizations to parent or ancestor organizations within Penn’s Workday Supervisory structure.

Common Uses
Retrieving all positions, or individuals assigned to them, associated with a particular organizational unit or place in the Supervisory Organizational hierarchy.

PARENT_SUPERVISORY_ORG_ID
CHILD_SUPERVISORY_ORG_ID

      

PARENT_SUPERVISORY_ORG_ID
CHILD_SUPERVISORY_ORG_ID
PARENT_SUPERVISORY_ORG_ID
CHILD_SUPERVISORY_ORG_ID

      

HCM_ACAD_APPOINTMENT (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)
      

• Supervisory Organizations are related to, but distinct from, Workday Academic Units and BEN Financials ORG codes.
• Data is kept only for the latest mapping of the organizations and their parents.
• Keep in mind that this is the latest information about academic units rollups - the HCM_PARENT_SUPERVISORY_ORG table does not keep longitudinal history. Historical snapshots of this information are available in the HCM_PARE_SUPE_ORG_SNAP table, beginning with the JUL-19 period.
• The HCM_PARENT_SUPERVISORY_ORG table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

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