| Data element |
Definition |
CHILD_ACADEMIC_UNIT_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The system ID of a child Academic Unit. |
CHILD_ACADEMIC_UNIT_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of a child Academic Unit. |
CHILD_ACADEMIC_UNIT_PATH
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The sequence of Academic_Unit_ID values representing the hierarchical relationship of the child and parent Academic Units. |
CHILD_AU_COST_CENTER
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Penn Cost Center (4-digit ORG code) associated with an Academic Unit. |
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_ACADEMIC_UNIT_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The system ID of the parent Academic Unit Hierarchy associated with the child Academic Unit.
Note: A list of Academic Unit Hierarchies is found in the LKUP_HCM_ACAD_UNIT_HIER table. |
PARENT_ACADEMIC_UNIT_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the parent Academic Unit Hierarchy associated with the child Academic Unit.
Note: A list of Academic Unit Hierarchies is found in the LKUP_HCM_ACAD_UNIT_HIER table. |
