| Data element |
Definition |
CHILD_DEFAULT_COST_CENTER
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The default cost center of the Child Supervisory Organization. |
CHILD_SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The system name representing a Child Supervisory Organization. |
CHILD_SUPERVISORY_ORG_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive name representing the Supervisory Organization associated with the Child Supervisory Organization. |
CHILD_SUPERVISORY_ORG_PATH
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The sequence of Supervisory_ORG_ID values representing the hierarchical relationship of the child and parent Supervisory Organizations. |
CHILD_SUPV_ORG_LONG_DESC
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The long description of a Supervisory Organization associated with the Child Supervisory Organization, including the Supervisory ORG Code, the Supervisory ORG Name, the manager name and Penn ID. |
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. |
PARENT_DEFAULT_COST_CENTER
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The default cost center of a Supervisory Organization associated with the Parent Supervisory ORG. The value can be overridden at the position level. |
PARENT_SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The system name representing a Supervisory Organization associated with the Parent Supervisory Organization. |
PARENT_SUPERVISORY_ORG_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive name representing the Parent Supervisory Organization. |
PARENT_SUPV_ORG_LONG_DESC
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The long description of a Parent Supervisory Organization, including the Supervisory ORG Code, the Supervisory ORG Name, the manager name and Penn ID. |
