[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Selects all venues that are unavailable for each examination session. This is the reverse of the data structure that stores the 'availability'. The view will contain a record for each examination session for each open venue, if no availabi |
| Implementation/DBA Data: | Not implemented in this database |
SELECT VE.VENUE_CD
, ESE.EXAM_CAL_TYPE
, ESE.EXAM_CI_SEQUENCE_NUMBER
, ESE.DT_ALIAS
, ESE.DAI_SEQUENCE_NUMBER
, ESE.EXAM_SESSION_NUMBER
, IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(ESE.DT_ALIAS
, ESE.DAI_SEQUENCE_NUMBER
, ESE.EXAM_CAL_TYPE
, ESE.EXAM_CI_SEQUENCE_NUMBER)
, ESE.START_TIME
, ESE.END_TIME
, ESE.ESE_ID
, ESE.CREATED_BY
, ESE.CREATION_DATE
, ESE.LAST_UPDATED_BY
, ESE.LAST_UPDATE_DATE
, ESE.LAST_UPDATE_LOGIN
FROM IGS_GR_VENUE VE
, IGS_AS_EXAM_SESSION ESE
WHERE VE.CLOSED_IND = 'N'
AND EXISTS (SELECT LOCATION_CD FROM IGS_AD_LOCATION LOC
, IGS_AD_LOCATION_TYPE LT WHERE LOC.LOCATION_CD = VE.EXAM_LOCATION_CD
AND LT.LOCATION_TYPE = LOC.LOCATION_TYPE
AND LT.S_LOCATION_TYPE = 'EXAM_CTR' )
AND NOT EXISTS (SELECT ESE_ID FROM IGS_AS_EXMVNU_SESAVL WHERE VENUE_CD = VE.VENUE_CD
AND ESE_ID = ESE.ESE_ID )