[Home] [Help]
View: IGS_CA_INST_ALT_V
Product: | IGS - Student System (Obsolete) |
Description: | View of cal_instance table with alternate code as the primary key. Incorporates s_cal_cat and s_cal_status. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.CAL_STATUS
, CS.S_CAL_STATUS
, CI.ALTERNATE_CODE
, CAT.DESCRIPTION
, CAT.S_CAL_CAT
, CAT.ABBREVIATION
, CI.CREATED_BY
, CI.CREATION_DATE
, CI.LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN FROM IGS_CA_INST CI
, IGS_CA_TYPE CAT
, IGS_CA_STAT CS
WHERE CAT.CAL_TYPE = CI.CAL_TYPE
AND CS.CAL_STATUS = CI.CAL_STATUS
Columns
Name |
CAL_TYPE |
SEQUENCE_NUMBER |
START_DT |
END_DT |
CAL_STATUS |
S_CAL_STATUS |
ALTERNATE_CODE |
DESCRIPTION |
S_CAL_CAT |
ABBREVIATION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |