Table: IGS_PS_OFR_PAT_NOTE

Product:	IGS - Student System
Description:	This table describes the notes associated with a Program Offering Pattern.
Implementation/DBA Data:	IGS.IGS_PS_OFR_PAT_NOTE

Primary Key: IGS_PS_OFR_PAT_NOTE_PK

1. COURSE_CD
2. VERSION_NUMBER
3. CAL_TYPE
4. CI_SEQUENCE_NUMBER
5. LOCATION_CD
6. ATTENDANCE_MODE
7. ATTENDANCE_TYPE
8. REFERENCE_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_PS_OFR_PAT_NOTE		IGS_PS_NOTE_TYPE_ALL	IGS_PS_OFR_PAT_NOTE.CRS_NOTE_TYPE
IGS_PS_OFR_PAT_NOTE		IGS_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		IGS_PS_OFR_PAT	IGS_PS_OFR_PAT_NOTE.COP_ID
IGS_PS_OFR_PAT_NOTE		IGS_GE_NOTE	IGS_PS_OFR_PAT_NOTE.REFERENCE_NUMBER