[Home] [Help]
View: IGS_PR_PERIOD_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PRG_CI.CAL_TYPE
, PRG_CI.SEQUENCE_NUMBER
, PRG_CI.START_DT
, PRG_CI.END_DT
, ACAD_CI.ALTERNATE_CODE || '/' || PRG_CI.ALTERNATE_CODE
, PRG_CI.CAL_STATUS
, PRG_CS.S_CAL_STATUS
, PRG_CI.CREATED_BY
, PRG_CI.CREATION_DATE
, PRG_CI.LAST_UPDATED_BY
, PRG_CI.LAST_UPDATE_DATE
, PRG_CI.LAST_UPDATE_LOGIN
FROM IGS_CA_TYPE PRG_CAT
, IGS_CA_INST PRG_CI
, IGS_CA_STAT PRG_CS
, IGS_CA_INST_REL CIR
, IGS_CA_INST ACAD_CI
, IGS_CA_TYPE ACAD_CAT
WHERE PRG_CAT.S_CAL_CAT = 'PROGRESS' AND PRG_CAT.CAL_TYPE = PRG_CI.CAL_TYPE AND CIR.SUB_CAL_TYPE = PRG_CI.CAL_TYPE AND CIR.SUB_CI_SEQUENCE_NUMBER = PRG_CI.SEQUENCE_NUMBER AND ACAD_CAT.S_CAL_CAT = 'ACADEMIC' AND ACAD_CAT.CAL_TYPE = ACAD_CI.CAL_TYPE AND CIR.SUP_CAL_TYPE = ACAD_CI.CAL_TYPE AND CIR.SUP_CI_SEQUENCE_NUMBER = ACAD_CI.SEQUENCE_NUMBER AND PRG_CI.CAL_STATUS = PRG_CS.CAL_STATUS
Columns
Name |
CAL_TYPE |
CI_SEQUENCE_NUMBER |
START_DT |
END_DT |
PRG_PERIOD |
CAL_STATUS |
S_CAL_STATUS |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |