FND Design Data [Home] [Help]

Table: IGS_PS_OFR_OPT_NOTE

Product: IGS - Student System
Description: This table describes the notes associated with a program offering option.
Implementation/DBA Data: TableIGS.IGS_PS_OFR_OPT_NOTE
Primary Key: IGS_PS_OFR_OPT_NOTE_PK
  1. ColumnCOURSE_CD
  2. ColumnVERSION_NUMBER
  3. ColumnCAL_TYPE
  4. ColumnLOCATION_CD
  5. ColumnATTENDANCE_MODE
  6. ColumnATTENDANCE_TYPE
  7. ColumnREFERENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_OFR_OPT_NOTE FK Joins to TableIGS_PS_NOTE_TYPE_ALL IGS_PS_OFR_OPT_NOTE.CRS_NOTE_TYPE
IGS_PS_OFR_OPT_NOTE FK Joins to TableIGS_PS_OFR_OPT_ALL IGS_PS_OFR_OPT_NOTE.COURSE_CD
IGS_PS_OFR_OPT_NOTE.VERSION_NUMBER
IGS_PS_OFR_OPT_NOTE.CAL_TYPE
IGS_PS_OFR_OPT_NOTE.LOCATION_CD
IGS_PS_OFR_OPT_NOTE.ATTENDANCE_MODE
IGS_PS_OFR_OPT_NOTE.ATTENDANCE_TYPE
IGS_PS_OFR_OPT_NOTE FK Joins to TableIGS_PS_OFR_OPT_ALL IGS_PS_OFR_OPT_NOTE.COO_ID
IGS_PS_OFR_OPT_NOTE FK Joins to TableIGS_GE_NOTE IGS_PS_OFR_OPT_NOTE.REFERENCE_NUMBER