FND Design Data [Home] [Help]

Table: IGS_PS_OFR_INST

Product: IGS - Student System (Obsolete)
Description: This entity describes the instances of a calendar type in which a particular program is on offer.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_PS_OFR_INST_PK
  1. ColumnCOURSE_CD
  2. ColumnVERSION_NUMBER
  3. ColumnCAL_TYPE
  4. ColumnCI_SEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_OFR_INST FK Joins to TableIGS_CA_INST_ALL IGS_PS_OFR_INST.CAL_TYPE
IGS_PS_OFR_INST.CI_SEQUENCE_NUMBER
IGS_PS_OFR_INST.CI_START_DT
IGS_PS_OFR_INST.CI_END_DT
IGS_PS_OFR_INST FK Joins to TableIGS_PS_OFR_ALL IGS_PS_OFR_INST.COURSE_CD
IGS_PS_OFR_INST.VERSION_NUMBER
IGS_PS_OFR_INST.CAL_TYPE
TableIGS_PS_OFR_PAT FK Joins to IGS_PS_OFR_INST IGS_PS_OFR_PAT.COURSE_CD
IGS_PS_OFR_PAT.VERSION_NUMBER
IGS_PS_OFR_PAT.CAL_TYPE
IGS_PS_OFR_PAT.CI_SEQUENCE_NUMBER