| Data element |
Definition |
ACTIVE_FLAG
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
A Y/N flag indicating whether the Supervisory Organization is active. |
DEFAULT_COST_CENTER
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The default cost center of the Supervisory Organization. The value can be overridden at the position level. |
INHERITED_AU
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The inherited Academic Unit associated by the Supervisory Organization's hierarchy. |
LAST_EXTRACT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the record was extracted from Workday and loaded to the Data Warehouse. |
MANAGER_PENN_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
Then Penn ID of the manager of the Supervisory Organization. |
MANAGER_WORKDAY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The Workday ID of the manager of the Supervisory Organization. |
PRIMARY_BUSINESS_SITE_REF
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The primary business location of the Supervisory Organization. |
RELATED_AU
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The Academic Unit directly related to the Supervisory Organization. |
SUPERIOR_SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The next level hierarchical parent of the Supervisory Organization. |
SUPERVISORY_ORG_CODE
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The abbreviated prefix representing the school or center of the Supervisory Organization. |
SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The system name representing a Supervisory Organization. |
SUPERVISORY_ORG_LONG_DESC
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The long description of the Supervisory Organization, including the Supervisory ORG Code, the Supervisory ORG Name, the manager name and Penn ID. |
SUPERVISORY_ORG_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive name representing the Supervisory Organization for the position. |
SUPERVISORY_ORG_SUBTYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The type of Supervisory Organization (e.g., Department). |
