[Home] [Help]
View: IGS_CA_TEACH_RET_CTX_V
Product: | IGS - Student System (Obsolete) |
Description: | View to query teaching calendars. The view structure will be same as view IGS_FI_F_TYP_CA_INST_V. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CI.CAL_TYPE
, CI.DESCRIPTION
, CI.SEQUENCE_NUMBER
, NULL
, NULL
, NULL
, NULL
, CI.CREATED_BY
, CI.CREATION_DATE
, CI.LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN
, NULL
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
WHERE CT.S_CAL_CAT='TEACHING'
AND CT.CAL_TYPE=CI.CAL_TYPE
AND CT.CLOSED_IND='N'
Columns
Name |
FEE_CAL_TYPE |
DSP_DESCRIPTION |
FEE_CI_SEQUENCE_NUMBER |
DSP_START_DT |
DSP_END_DT |
FEE_TYPE |
FEE_CATEGORY |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
CGNBT_FEE_TYPE |