Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Examination Session View - incorporated examination session date alias value from the 'date alias instance' table. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ESE.ROWID
, ESE.EXAM_CAL_TYPE
, ESE.EXAM_CI_SEQUENCE_NUMBER
, ESE.DT_ALIAS
, ESE.DAI_SEQUENCE_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.CI_START_DT
, ESE.CI_END_DT
, ESE.START_TIME
, ESE.END_TIME
, ESE.ESE_ID
, ESE.EXAM_SESSION_NUMBER
, ESE.COMMENTS
, ESE.CREATED_BY
, ESE.CREATION_DATE
, ESE.LAST_UPDATED_BY
, ESE.LAST_UPDATE_DATE
, ESE.LAST_UPDATE_LOGIN
FROM IGS_AS_EXAM_SESSION ESE