eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_CA_INST_ADM_PERD_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER
, CAT1.DESCRIPTION
, CI1.START_DT
, CI1.END_DT
, CI1.CAL_STATUS
, CI1.ALTERNATE_CODE
, CI1.PRIOR_CI_SEQUENCE_NUMBER
, CIR.SUP_CAL_TYPE
, CIR.SUP_CI_SEQUENCE_NUMBER
, CI2.START_DT
, CI2.END_DT
, CI2.ALTERNATE_CODE
, CI2.ALTERNATE_CODE || '/' || CI1.ALTERNATE_CODE
, CI1.CREATED_BY
, CI1.CREATION_DATE
, CI1.LAST_UPDATED_BY
, CI1.LAST_UPDATE_DATE
, CI1.LAST_UPDATE_LOGIN
FROM IGS_CA_INST CI1
, IGS_CA_INST_REL CIR
, IGS_CA_INST CI2
, IGS_CA_TYPE CAT1
, IGS_CA_TYPE CAT2
WHERE CIR.SUB_CAL_TYPE (+) = CI1.CAL_TYPE
AND CIR.SUB_CI_SEQUENCE_NUMBER (+) = CI1.SEQUENCE_NUMBER
AND CI2.CAL_TYPE (+) = CIR.SUP_CAL_TYPE
AND CI2.SEQUENCE_NUMBER (+) = CIR.SUP_CI_SEQUENCE_NUMBER
AND CAT1.CAL_TYPE = CI1.CAL_TYPE
AND CAT1.S_CAL_CAT = 'ADMISSION'
AND CAT2.CAL_TYPE (+) = CI2.CAL_TYPE
AND CAT2.S_CAL_CAT = 'ACADEMIC'

Columns

Name
ADM_CAL_TYPE
ADM_CI_SEQUENCE_NUMBER
DESCRIPTION
ADM_START_DT
ADM_END_DT
ADM_CAL_STATUS
ADM_ALTERNATE_CODE
ADM_CI_PRIOR_SEQUENCE_NUMBER
ACAD_CAL_TYPE
ACAD_CI_SEQUENCE_NUMBER
ACAD_START_DT
ACAD_END_DT
ACAD_ALTERNATE_CODE
COMMENCEMENT_PERIOD
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN