[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Describes the teaching calendars for the give load calendar |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AP1.CAL_TYPE LOAD_CAL_TYPE
, AP1.CI_SEQUENCE_NUMBER LOAD_CI_SEQUENCE_NUMBER
, CI.START_DT LOAD_START_DT
, CI.END_DT LOAD_END_DT
, CI.ALTERNATE_CODE LOAD_ALTERNATE_CODE
, CI.DESCRIPTION
, CI1.CAL_TYPE TEACH_CAL_TYPE
, CI1.SEQUENCE_NUMBER TEACH_CI_SEQUENCE_NUMBER
, CI1.START_DT TEACH_START_DT
, CI1.END_DT TEACH_END_DT
, CI1.ALTERNATE_CODE TEACH_ALTERNATE_CODE
, CI1.DESCRIPTION
FROM IGS_ST_DFT_LOAD_APPO AP1
, IGS_CA_INST CI1
, IGS_CA_INST CI
WHERE CI.CAL_TYPE = AP1.CAL_TYPE
AND CI. SEQUENCE_NUMBER = AP1.CI_SEQUENCE_NUMBER
AND CI1.CAL_TYPE = AP1.TEACH_CAL_TYPE
AND (AP1.CAL_TYPE
, AP1.CI_SEQUENCE_NUMBER) IN (SELECT SUB_CAL_TYPE
, SUB_CI_SEQUENCE_NUMBER
FROM IGS_CA_INST_REL R2
, IGS_CA_TYPE CT1
WHERE CT1.CAL_TYPE = R2.SUB_CAL_TYPE
AND CT1.S_CAL_CAT = 'LOAD'
AND (SUP_CAL_TYPE
, SUP_CI_SEQUENCE_NUMBER) IN (SELECT SUP_CAL_TYPE
, SUP_CI_SEQUENCE_NUMBER
FROM IGS_CA_INST_REL R1
, IGS_CA_TYPE CT
WHERE SUB_CAL_TYPE = AP1.TEACH_CAL_TYPE
AND R1.SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND CT.CAL_TYPE = R1.SUP_CAL_TYPE
AND CT.S_CAL_CAT = 'ACADEMIC'))