FND Design Data [Home] [Help]

Table: IGS_PS_OFR_ALL

Product: IGS - Student System
Description: This entity describes an offering of a university program within a calendar type.
Implementation/DBA Data: TableIGS.IGS_PS_OFR_ALL
Primary Key: IGS_PS_OFR_PK
  1. ColumnCOURSE_CD
  2. ColumnVERSION_NUMBER
  3. ColumnCAL_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_OFR_ALL FK Joins to TableIGS_CA_TYPE IGS_PS_OFR_ALL.CAL_TYPE
IGS_PS_OFR_ALL FK Joins to TableIGS_PS_VER_ALL IGS_PS_OFR_ALL.COURSE_CD
IGS_PS_OFR_ALL.VERSION_NUMBER
TableIGS_AD_PECRS_OFOP_DT FK Joins to IGS_PS_OFR_ALL IGS_AD_PECRS_OFOP_DT.COURSE_CD
IGS_AD_PECRS_OFOP_DT.VERSION_NUMBER
IGS_AD_PECRS_OFOP_DT.ACAD_CAL_TYPE
TableIGS_AD_PRD_PS_OF_OPT FK Joins to IGS_PS_OFR_ALL IGS_AD_PRD_PS_OF_OPT.COURSE_CD
IGS_AD_PRD_PS_OF_OPT.VERSION_NUMBER
IGS_AD_PRD_PS_OF_OPT.ACAD_CAL_TYPE
TableIGS_PS_OFR_INST FK Joins to IGS_PS_OFR_ALL IGS_PS_OFR_INST.COURSE_CD
IGS_PS_OFR_INST.VERSION_NUMBER
IGS_PS_OFR_INST.CAL_TYPE
TableIGS_PS_OFR_NOTE FK Joins to IGS_PS_OFR_ALL IGS_PS_OFR_NOTE.COURSE_CD
IGS_PS_OFR_NOTE.VERSION_NUMBER
IGS_PS_OFR_NOTE.CAL_TYPE
TableIGS_PS_OFR_OPT_ALL FK Joins to IGS_PS_OFR_ALL IGS_PS_OFR_OPT_ALL.COURSE_CD
IGS_PS_OFR_OPT_ALL.VERSION_NUMBER
IGS_PS_OFR_OPT_ALL.CAL_TYPE
TableIGS_PS_OFR_UNIT_SET FK Joins to IGS_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
TableIGS_PS_PAT_OF_STUDY FK Joins to IGS_PS_OFR_ALL IGS_PS_PAT_OF_STUDY.COURSE_CD
IGS_PS_PAT_OF_STUDY.VERSION_NUMBER
IGS_PS_PAT_OF_STUDY.CAL_TYPE