FND Design Data [Home] [Help]

Table: IGS_PS_SUB_UNIT_REL

Product: IGS - Student System (Obsolete)
Description: This entity describes the relationships between units, which make up sub-units and super-units. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_PS_SUB_UNIT_REL_PK
  1. ColumnSUP_UNIT_CD
  2. ColumnSUP_VERSION_NUMBER
  3. ColumnSUB_UNIT_CD
  4. ColumnSUB_VERSION_NUMBER
  5. ColumnCREATE_DT
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_SUB_UNIT_REL FK Joins to TableIGS_PS_UNIT_VER_ALL IGS_PS_SUB_UNIT_REL.SUP_UNIT_CD
IGS_PS_SUB_UNIT_REL.SUP_VERSION_NUMBER
IGS_PS_SUB_UNIT_REL FK Joins to TableIGS_PS_UNIT_VER_ALL IGS_PS_SUB_UNIT_REL.SUB_UNIT_CD
IGS_PS_SUB_UNIT_REL.SUB_VERSION_NUMBER