Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View containing all session/venue combinations - used to validate exam_venue_suprvsr entries |
Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT EI.EXAM_CAL_TYPE
, EI.EXAM_CI_SEQUENCE_NUMBER
, EI.DT_ALIAS
, EI.DAI_SEQUENCE_NUMBER
, IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(EI.DT_ALIAS
, EI.DAI_SEQUENCE_NUMBER
, EI.EXAM_CAL_TYPE
, EI.EXAM_CI_SEQUENCE_NUMBER)
, EI.START_TIME
, EI.END_TIME
, EI.ESE_ID
, EI.VENUE_CD
, VE.EXAM_LOCATION_CD
, ESE.EXAM_SESSION_NUMBER
, EI.CREATED_BY
, EI.CREATION_DATE
, EI.LAST_UPDATED_BY
, EI.LAST_UPDATE_DATE
, EI.LAST_UPDATE_LOGIN
FROM IGS_AS_EXAM_INSTANCE EI
, IGS_AS_EXAM_SESSION ESE
, IGS_GR_VENUE VE
WHERE EI.ESE_ID = ESE.ESE_ID
AND EI.VENUE_CD = VE.VENUE_CD