FND Design Data [Home] [Help]

Table: IGS_PS_UNT_OFR_OPT_N

Product: IGS - Student System
Description: This table describes the notes associated with a unit offering option.
Implementation/DBA Data: TableIGS.IGS_PS_UNT_OFR_OPT_N
Primary Key: IGS_PS_UNT_OFR_OPT_N_PK
  1. ColumnUNIT_CD
  2. ColumnVERSION_NUMBER
  3. ColumnCAL_TYPE
  4. ColumnCI_SEQUENCE_NUMBER
  5. ColumnLOCATION_CD
  6. ColumnUNIT_CLASS
  7. ColumnREFERENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_UNT_OFR_OPT_N FK Joins to TableIGS_PS_NOTE_TYPE_ALL IGS_PS_UNT_OFR_OPT_N.CRS_NOTE_TYPE
IGS_PS_UNT_OFR_OPT_N FK Joins to TableIGS_GE_NOTE IGS_PS_UNT_OFR_OPT_N.REFERENCE_NUMBER
IGS_PS_UNT_OFR_OPT_N FK Joins to TableIGS_PS_UNIT_OFR_OPT_ALL IGS_PS_UNT_OFR_OPT_N.UNIT_CD
IGS_PS_UNT_OFR_OPT_N.VERSION_NUMBER
IGS_PS_UNT_OFR_OPT_N.CAL_TYPE
IGS_PS_UNT_OFR_OPT_N.CI_SEQUENCE_NUMBER
IGS_PS_UNT_OFR_OPT_N.LOCATION_CD
IGS_PS_UNT_OFR_OPT_N.UNIT_CLASS
IGS_PS_UNT_OFR_OPT_N FK Joins to TableIGS_PS_UNIT_OFR_OPT_ALL IGS_PS_UNT_OFR_OPT_N.UOO_ID
IGS_PS_UNT_OFR_OPT_N FK Joins to TableIGS_PS_UNIT_OFR_OPT_ALL IGS_PS_UNT_OFR_OPT_N.UOO_ID