HCM_SUPERVISORY_ORG Table
Explanation
Reference table containing Workday Supervisory Organization codes and names, and associated manager and default cost center ORG code. Supervisory Organizations group positions into a management hierarchy and are a required foundation for Workday HCM (Human Capital Management).
They provide the structure for how faculty and staff are organized, how HR business processes are enabled, and how HR data is connected in the system.
Common Uses
Displaying the list of possible Supervisory Organizations, or finding the manager of a Supervisory Organization.
| Primary Key |
Indexed Data Elements |
Related Tables |
|
SUPERVISORY_ORG_ID
SUPERVISORY_ORG_CODE
ACTIVE_FLAG
MANAGER_WORKDAY_ID
MANAGER_PENN_ID
|
HCM_ACAD_APPOINTMENT (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_WORKER_ENCUMBRANCE (DWHCM)
HCM_WORKER_PAYMENT (DWHCM)
|
Cautions
- Supervisory Organizations are not used to manage finances and financial responsibilities.
- Each supervisory organization will be assigned one manager. Managers may be assigned to more than one supervisory organization.
- Supervisory Organizations are related to, but distinct from, Workday Academic Units and BEN Financials ORG codes.
- Keep in mind that this is the latest information about supervisory organizations - the HCM_SUPERVISORY_ORG table does not keep longitudinal history. Historical snapshots of this information are available in the HCM_SUPE_ORG_SNAP table, beginning with the JUL-19 period.
- The HCM_SUPERVISORY_ORG 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
|
