[Home] [Help]
View: IGS_EN_EFFECTIVE_TERMS_V
Product: | IGS - Student System (Obsolete) |
Description: | View fetches the current term, one previous term and one next term for the academic calendar. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, CT.CAL_TYPE ACAD_CAL_TYPE
, CT1.ABBREVIATION
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_CA_TYPE CT1
WHERE CI.CAL_TYPE = CT1.CAL_TYPE
AND CI.CAL_TYPE = SUBSTR(IGS_EN_SPA_TERMS_API.GET_CURR_TERM(CT.CAL_TYPE)
, 7)
AND CI.SEQUENCE_NUMBER = RTRIM(SUBSTR(IGS_EN_SPA_TERMS_API.GET_CURR_TERM(CT.CAL_TYPE)
, 1
, 6)) UNION ALL SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, CT.CAL_TYPE ACAD_CAL_TYPE
, CT1.ABBREVIATION
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_CA_TYPE CT1
WHERE CI.CAL_TYPE = CT1.CAL_TYPE
AND CI.CAL_TYPE = SUBSTR(IGS_EN_SPA_TERMS_API.GET_PREV_TERM(CT.CAL_TYPE)
, 7)
AND CI.SEQUENCE_NUMBER = RTRIM(SUBSTR(IGS_EN_SPA_TERMS_API.GET_PREV_TERM(CT.CAL_TYPE)
, 1
, 6)) UNION ALL SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, CT.CAL_TYPE ACAD_CAL_TYPE
, CT1.ABBREVIATION
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_CA_TYPE CT1
WHERE CI.CAL_TYPE = CT1.CAL_TYPE
AND CI.CAL_TYPE = SUBSTR(IGS_EN_SPA_TERMS_API.GET_NEXT_TERM(CT.CAL_TYPE)
, 7)
AND CI.SEQUENCE_NUMBER = RTRIM(SUBSTR(IGS_EN_SPA_TERMS_API.GET_NEXT_TERM(CT.CAL_TYPE)
, 1
, 6))
Columns
Name |
CAL_TYPE |
SEQUENCE_NUMBER |
START_DT |
END_DT |
ALTERNATE_CODE |
DESCRIPTION |
ACAD_CAL_TYPE |
ABBREVIATION |