Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This is a base view , which describes the instances of a calendar type in that a particular program is on offer. |
Implementation/DBA Data: | Not implemented in this database |
SELECT OI.COURSE_CD
, OI.VERSION_NUMBER
, OI.CAL_TYPE
, OI.CI_SEQUENCE_NUMBER
, OI.CI_START_DT
, OI.CI_END_DT
, OI.MIN_ENTRY_ASS_SCORE
, OI.GUARANTEED_ENTRY_ASS_SCR
, VE.TITLE
, TY.DESCRIPTION
, INS.DESCRIPTION
, OI.CREATED_BY
, OI.CREATION_DATE
, OI.LAST_UPDATED_BY
, OI.LAST_UPDATE_DATE
FROM IGS_PS_OFR_INST OI
, IGS_CA_INST_ALL INS
, IGS_CA_TYPE TY
, IGS_PS_VER_ALL VE
WHERE OI.CAL_TYPE=TY.CAL_TYPE
AND OI.COURSE_CD=VE.COURSE_CD
AND OI.VERSION_NUMBER=VE.VERSION_NUMBER
AND OI.CAL_TYPE=INS.CAL_TYPE
AND OI.CI_SEQUENCE_NUMBER=INS.SEQUENCE_NUMBER
AND OI.CI_START_DT=INS.START_DT
AND OI.CI_END_DT=INS.END_DT WITH READ ONLY