FND Design Data [Home] [Help]

Table: IGS_OR_UNIT_REL

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
Primary Key: IGS_OR_UNIT_REL_PK
  1. ColumnPARENT_ORG_UNIT_CD
  2. ColumnPARENT_START_DT
  3. ColumnCHILD_ORG_UNIT_CD
  4. ColumnCHILD_START_DT
  5. ColumnCREATE_DT
Foreign Keys
Table
Foreign Table Foreign Key Column
TableIGS_OR_REL_PS_TYPE FK Joins to IGS_OR_UNIT_REL IGS_OR_REL_PS_TYPE.PARENT_ORG_UNIT_CD
IGS_OR_REL_PS_TYPE.PARENT_START_DT
IGS_OR_REL_PS_TYPE.CHILD_ORG_UNIT_CD
IGS_OR_REL_PS_TYPE.CHILD_START_DT
IGS_OR_REL_PS_TYPE.OUR_CREATE_DT