[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This is a full view, which describes the Offering Pattern of a program offering option. This is related to a calendar instance, nominating when each option is available. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT OFR.COURSE_CD
, OFR.VERSION_NUMBER
, OFR.CAL_TYPE
, OFR.CI_SEQUENCE_NUMBER
, OFR.LOCATION_CD
, OFR.ATTENDANCE_MODE
, OFR.ATTENDANCE_TYPE
, OFR.COP_ID
, OFR.OFFERED_IND
, OFR.CONFIRMED_OFFERING_IND
, OFR.ENTRY_POINT_IND
, OFR.PRE_ENROL_UNITS_IND
, OFR.ENROLLABLE_IND
, OFR.IVRS_AVAILABLE_IND
, OFR.MIN_ENTRY_ASS_SCORE
, OFR.GUARANTEED_ENTRY_ASS_SCR
, OFR.MAX_CROSS_FACULTY_CP
, OFR.MAX_CROSS_LOCATION_CP
, OFR.MAX_CROSS_MODE_CP
, OFR.MAX_HIST_CROSS_FACULTY_CP
, OFR.GRADING_SCHEMA_CD
, OFR.GS_VERSION_NUMBER
, VE.TITLE
, TY.DESCRIPTION
, INS.DESCRIPTION
, LO.DESCRIPTION
, ATM.DESCRIPTION
, ATT.DESCRIPTION
, PA1.PARTY_NUMBER
, PA2.PARTY_NUMBER
, PA1.PARTY_NAME
, PA2.PARTY_NAME
, GR.DESCRIPTION
, OFR.ADM_ASS_OFFICER_PERSON_ID
, OFR.ADM_CONTACT_PERSON_ID
, OFR.COO_ID
, OFR.CREATED_BY
, OFR.CREATION_DATE
, OFR.LAST_UPDATED_BY
, OFR.LAST_UPDATE_DATE
FROM IGS_PS_OFR_PAT OFR
, IGS_PS_OFR_INST OI
, IGS_PS_OFR_OPT_ALL OP
, IGS_PS_VER_ALL VE
, IGS_CA_TYPE TY
, IGS_CA_INST_ALL INS
, IGS_AD_LOCATION_ALL LO
, IGS_EN_ATD_MODE_ALL ATM
, IGS_EN_ATD_TYPE_ALL ATT
, HZ_PARTIES PA1
, HZ_PARTIES PA2
, IGS_AS_GRD_SCHEMA GR
WHERE OFR.COURSE_CD=OI.COURSE_CD
AND OFR.VERSION_NUMBER=OI.VERSION_NUMBER
AND OFR.CAL_TYPE=OI.CAL_TYPE
AND OFR.CI_SEQUENCE_NUMBER=OI.CI_SEQUENCE_NUMBER
AND OI.COURSE_CD=VE.COURSE_CD
AND OI.VERSION_NUMBER=VE.VERSION_NUMBER
AND OI.CAL_TYPE=TY.CAL_TYPE
AND OI.CAL_TYPE=INS.CAL_TYPE
AND OI.CI_SEQUENCE_NUMBER=INS.SEQUENCE_NUMBER
AND OFR.COURSE_CD =OP.COURSE_CD
AND OFR.VERSION_NUMBER =OP.VERSION_NUMBER
AND OFR.CAL_TYPE =OP.CAL_TYPE
AND OFR.LOCATION_CD =OP.LOCATION_CD
AND OFR.ATTENDANCE_MODE=OP.ATTENDANCE_MODE
AND OFR.ATTENDANCE_TYPE=OP.ATTENDANCE_TYPE
AND OFR.COO_ID=OP.COO_ID
AND OP.LOCATION_CD=LO.LOCATION_CD
AND OP.ATTENDANCE_MODE=ATM.ATTENDANCE_MODE
AND OP.ATTENDANCE_TYPE=ATT.ATTENDANCE_TYPE
AND OFR.ADM_CONTACT_PERSON_ID=PA1.PARTY_ID(+)
AND OFR.ADM_ASS_OFFICER_PERSON_ID=PA2.PARTY_ID(+)
AND PA1.STATUS(+) ='A'
AND PA2.STATUS(+)='A'
AND OFR.GRADING_SCHEMA_CD=GR.GRADING_SCHEMA_CD(+)
AND OFR.GS_VERSION_NUMBER=GR.VERSION_NUMBER(+) WITH READ ONLY