[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 |