Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view contains the Term or Teaching calendar instances with corresponding academic alternate codes |
Implementation/DBA Data: | Not implemented in this database |
SELECT CI.ROW_ID
, CI.CAL_TYPE
, CT.DESCRIPTION
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.CAL_STATUS
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(CI.CAL_TYPE
, CI.SEQUENCE_NUMBER)
, 1
, 10) || '/' ||CI.ALTERNATE_CODE
, CT.S_CAL_CAT
, CT.CLOSED_IND
, CI.SUP_CAL_STATUS_DIFFER_IND
, CI.PRIOR_CI_SEQUENCE_NUMBER
, CI.CREATED_BY
, CI.CREATION_DATE
, CI.LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN
, CI.SS_DISPLAYED
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, CI.IVR_DISPLAY_IND
, CI.TERM_INSTRUCTION_TIME
, CI.PLANNING_FLAG
, CI.SCHEDULE_FLAG
, CI.ADMIN_FLAG
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
WHERE CT.CAL_TYPE = CI.CAL_TYPE
AND CT.S_CAL_CAT IN ('LOAD'
, 'TEACHING')