Table: IGS_PS_OFR_OPT_ALL

Product:	IGS - Student System
Description:	This entity describes the available options for each program offering.
Implementation/DBA Data:	IGS.IGS_PS_OFR_OPT_ALL

Primary Key: IGS_PS_OFR_OPT_ALL_UK1

1. COO_ID

Primary Key: IGS_PS_OFR_OPT_PK

1. COURSE_CD
2. VERSION_NUMBER
3. CAL_TYPE
4. LOCATION_CD
5. ATTENDANCE_MODE
6. ATTENDANCE_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_PS_OFR_OPT_ALL		IGS_EN_ATD_MODE_ALL	IGS_PS_OFR_OPT_ALL.ATTENDANCE_MODE
IGS_PS_OFR_OPT_ALL		IGS_EN_ATD_TYPE_ALL	IGS_PS_OFR_OPT_ALL.ATTENDANCE_TYPE
IGS_PS_OFR_OPT_ALL		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
IGS_PS_OFR_OPT_ALL		IGS_AD_LOCATION_ALL	IGS_PS_OFR_OPT_ALL.LOCATION_CD
IGS_PS_OFR_OPT_ALL		HZ_PARTIES	IGS_PS_OFR_OPT_ALL.ENR_OFFICER_PERSON_ID
IGS_PS_ENT_PT_REF_CD		IGS_PS_OFR_OPT_ALL	IGS_PS_ENT_PT_REF_CD.COURSE_CD IGS_PS_ENT_PT_REF_CD.VERSION_NUMBER IGS_PS_ENT_PT_REF_CD.CAL_TYPE IGS_PS_ENT_PT_REF_CD.LOCATION_CD IGS_PS_ENT_PT_REF_CD.ATTENDANCE_MODE IGS_PS_ENT_PT_REF_CD.ATTENDANCE_TYPE
IGS_PS_ENT_PT_REF_CD		IGS_PS_OFR_OPT_ALL	IGS_PS_ENT_PT_REF_CD.COO_ID
IGS_PS_OF_OPT_AD_CAT		IGS_PS_OFR_OPT_ALL	IGS_PS_OF_OPT_AD_CAT.COURSE_CD IGS_PS_OF_OPT_AD_CAT.VERSION_NUMBER IGS_PS_OF_OPT_AD_CAT.CAL_TYPE IGS_PS_OF_OPT_AD_CAT.LOCATION_CD IGS_PS_OF_OPT_AD_CAT.ATTENDANCE_MODE IGS_PS_OF_OPT_AD_CAT.ATTENDANCE_TYPE
IGS_PS_OF_OPT_AD_CAT		IGS_PS_OFR_OPT_ALL	IGS_PS_OF_OPT_AD_CAT.COO_ID
IGS_PS_OFR_OPT_NOTE		IGS_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		IGS_PS_OFR_OPT_ALL	IGS_PS_OFR_OPT_NOTE.COO_ID
IGS_PS_OF_OPT_UNT_ST		IGS_PS_OFR_OPT_ALL	IGS_PS_OF_OPT_UNT_ST.COURSE_CD IGS_PS_OF_OPT_UNT_ST.CRV_VERSION_NUMBER IGS_PS_OF_OPT_UNT_ST.CAL_TYPE IGS_PS_OF_OPT_UNT_ST.LOCATION_CD IGS_PS_OF_OPT_UNT_ST.ATTENDANCE_MODE IGS_PS_OF_OPT_UNT_ST.ATTENDANCE_TYPE
IGS_PS_OF_OPT_UNT_ST		IGS_PS_OFR_OPT_ALL	IGS_PS_OF_OPT_UNT_ST.COO_ID
IGS_PS_OFR_PAT		IGS_PS_OFR_OPT_ALL	IGS_PS_OFR_PAT.COURSE_CD IGS_PS_OFR_PAT.VERSION_NUMBER IGS_PS_OFR_PAT.CAL_TYPE IGS_PS_OFR_PAT.LOCATION_CD IGS_PS_OFR_PAT.ATTENDANCE_MODE IGS_PS_OFR_PAT.ATTENDANCE_TYPE
IGS_PS_OFR_PAT		IGS_PS_OFR_OPT_ALL	IGS_PS_OFR_PAT.COO_ID
IGS_HE_POOUS_OU_ALL		IGS_PS_OFR_OPT_ALL	IGS_HE_POOUS_OU_ALL.COURSE_CD IGS_HE_POOUS_OU_ALL.CRV_VERSION_NUMBER IGS_HE_POOUS_OU_ALL.CAL_TYPE IGS_HE_POOUS_OU_ALL.LOCATION_CD IGS_HE_POOUS_OU_ALL.ATTENDANCE_MODE IGS_HE_POOUS_OU_ALL.ATTENDANCE_TYPE
IGS_HE_POOUS_CC_ALL		IGS_PS_OFR_OPT_ALL	IGS_HE_POOUS_CC_ALL.COURSE_CD IGS_HE_POOUS_CC_ALL.CRV_VERSION_NUMBER IGS_HE_POOUS_CC_ALL.CAL_TYPE IGS_HE_POOUS_CC_ALL.LOCATION_CD IGS_HE_POOUS_CC_ALL.ATTENDANCE_MODE IGS_HE_POOUS_CC_ALL.ATTENDANCE_TYPE
IGS_HE_POOUS_ALL		IGS_PS_OFR_OPT_ALL	IGS_HE_POOUS_ALL.COURSE_CD IGS_HE_POOUS_ALL.CRV_VERSION_NUMBER IGS_HE_POOUS_ALL.CAL_TYPE IGS_HE_POOUS_ALL.LOCATION_CD IGS_HE_POOUS_ALL.ATTENDANCE_MODE IGS_HE_POOUS_ALL.ATTENDANCE_TYPE
IGS_EN_SPA_TERMS		IGS_PS_OFR_OPT_ALL	IGS_EN_SPA_TERMS.COO_ID
IGS_AS_SC_ATTEMPT_H_ALL		IGS_PS_OFR_OPT_ALL	IGS_AS_SC_ATTEMPT_H_ALL.COO_ID
IGS_EN_STDNT_PS_ATT_ALL		IGS_PS_OFR_OPT_ALL	IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD IGS_EN_STDNT_PS_ATT_ALL.VERSION_NUMBER IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE IGS_EN_STDNT_PS_ATT_ALL.LOCATION_CD IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE
IGS_EN_STDNT_PS_ATT_ALL		IGS_PS_OFR_OPT_ALL	IGS_EN_STDNT_PS_ATT_ALL.COO_ID