FND Design Data [Home] [Help]

Table: IGS_PS_OFR_PAT_NOTE

Product: IGS - Student System (Obsolete)
Description: This table describes the notes associated with a Program Offering Pattern.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_PS_OFR_PAT_NOTE_PK
  1. ColumnCOURSE_CD
  2. ColumnVERSION_NUMBER
  3. ColumnCAL_TYPE
  4. ColumnCI_SEQUENCE_NUMBER
  5. ColumnLOCATION_CD
  6. ColumnATTENDANCE_MODE
  7. ColumnATTENDANCE_TYPE
  8. ColumnREFERENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_OFR_PAT_NOTE FK Joins to TableIGS_PS_NOTE_TYPE_ALL IGS_PS_OFR_PAT_NOTE.CRS_NOTE_TYPE
IGS_PS_OFR_PAT_NOTE FK Joins to TableIGS_PS_OFR_PAT IGS_PS_OFR_PAT_NOTE.COURSE_CD
IGS_PS_OFR_PAT_NOTE.VERSION_NUMBER
IGS_PS_OFR_PAT_NOTE.CAL_TYPE
IGS_PS_OFR_PAT_NOTE.CI_SEQUENCE_NUMBER
IGS_PS_OFR_PAT_NOTE.LOCATION_CD
IGS_PS_OFR_PAT_NOTE.ATTENDANCE_MODE
IGS_PS_OFR_PAT_NOTE.ATTENDANCE_TYPE
IGS_PS_OFR_PAT_NOTE FK Joins to TableIGS_PS_OFR_PAT IGS_PS_OFR_PAT_NOTE.COP_ID
IGS_PS_OFR_PAT_NOTE FK Joins to TableIGS_GE_NOTE IGS_PS_OFR_PAT_NOTE.REFERENCE_NUMBER