[Home] [Help]
View: IGSBV_ORG_UNIT_HIERARCHIES
Product: | IGS - Student System (Obsolete) |
Description: | This entity describes parent and child relationships between organizational units. An organizational unit may have many parents and many children. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PARENT_ORG_UNIT_CD PARENT_ORG_UNIT_CODE
, PARENT_START_DT PARENT_START_DATE
, CHILD_ORG_UNIT_CD CHILD_ORG_UNIT_CODE
, CHILD_START_DT CHILD_START_DATE
, CREATE_DT CREATE_DATE
, LOGICAL_DELETE_DT LOGICAL_DELETE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS_OR_UNIT_REL WITH READ ONLY
Columns
Name |
PARENT_ORG_UNIT_CODE |
PARENT_START_DATE |
CHILD_ORG_UNIT_CODE |
CHILD_START_DATE |
CREATE_DATE |
LOGICAL_DELETE_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |