FND Design Data [Home] [Help]

Table: IGS_PS_OFR_UNIT_SET

Product: IGS - Student System (Obsolete)
Description: This entity describes the link between unit sets and programs. E.g. it would link the possible majors to a program
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_PS_OFR_UNIT_SET_PK
  1. ColumnCOURSE_CD
  2. ColumnCRV_VERSION_NUMBER
  3. ColumnCAL_TYPE
  4. ColumnUNIT_SET_CD
  5. ColumnUS_VERSION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_OFR_UNIT_SET FK Joins to TableIGS_PS_OFR_ALL IGS_PS_OFR_UNIT_SET.COURSE_CD
IGS_PS_OFR_UNIT_SET.CRV_VERSION_NUMBER
IGS_PS_OFR_UNIT_SET.CAL_TYPE
IGS_PS_OFR_UNIT_SET FK Joins to TableIGS_EN_UNIT_SET_ALL IGS_PS_OFR_UNIT_SET.UNIT_SET_CD
IGS_PS_OFR_UNIT_SET.US_VERSION_NUMBER
TableIGS_PS_OF_OPT_UNT_ST FK Joins to IGS_PS_OFR_UNIT_SET IGS_PS_OF_OPT_UNT_ST.COURSE_CD
IGS_PS_OF_OPT_UNT_ST.CRV_VERSION_NUMBER
IGS_PS_OF_OPT_UNT_ST.CAL_TYPE
IGS_PS_OF_OPT_UNT_ST.UNIT_SET_CD
IGS_PS_OF_OPT_UNT_ST.US_VERSION_NUMBER
TableIGS_PS_OF_UNT_SET_RL FK Joins to IGS_PS_OFR_UNIT_SET IGS_PS_OF_UNT_SET_RL.COURSE_CD
IGS_PS_OF_UNT_SET_RL.CRV_VERSION_NUMBER
IGS_PS_OF_UNT_SET_RL.CAL_TYPE
IGS_PS_OF_UNT_SET_RL.SUB_UNIT_SET_CD
IGS_PS_OF_UNT_SET_RL.SUB_US_VERSION_NUMBER
TableIGS_PS_OF_UNT_SET_RL FK Joins to IGS_PS_OFR_UNIT_SET IGS_PS_OF_UNT_SET_RL.COURSE_CD
IGS_PS_OF_UNT_SET_RL.CRV_VERSION_NUMBER
IGS_PS_OF_UNT_SET_RL.CAL_TYPE
IGS_PS_OF_UNT_SET_RL.SUP_UNIT_SET_CD
IGS_PS_OF_UNT_SET_RL.SUP_US_VERSION_NUMBER