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_PR_PRG_RU_CA_TYPE_CI_V

Product:	IGS - Student System (Obsolete)
Description:	This view contains the progression calendar types in which theprogression rulerogression rule as it is applied to oneof the allowable system elements - a course version, course type,org unit or individual student course attempt) is to be te
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PRCTV.PROGRESSION_RULE_CAT
, PRCTV.PRA_SEQUENCE_NUMBER
, PRCTV.PRG_CAL_TYPE
, CI.SEQUENCE_NUMBER
, PRCTV.START_EFFECTIVE_PERIOD
, PRCTV.NUM_OF_APPLICATIONS
FROM IGS_PR_RU_CA_TYPE_V PRCTV
, IGS_PR_RU_APPL PRA
, IGS_CA_INST CI
, IGS_CA_STAT CS
WHERE PRA.PROGRESSION_RULE_CAT = PRCTV.PROGRESSION_RULE_CAT
AND PRA.SEQUENCE_NUMBER = PRCTV.PRA_SEQUENCE_NUMBER
AND PRA.LOGICAL_DELETE_DT IS NULL
AND CI.CAL_TYPE = PRCTV.PRG_CAL_TYPE
AND CS.CAL_STATUS = CI.CAL_STATUS
AND CS.S_CAL_STATUS = 'ACTIVE'
AND (( PRCTV.START_SEQUENCE_NUMBER IS NULL OR EXISTS ( SELECT 'X'
FROM IGS_CA_INST SCI
WHERE SCI.CAL_TYPE = PRCTV.PRG_CAL_TYPE
AND SCI.SEQUENCE_NUMBER = PRCTV.START_SEQUENCE_NUMBER
AND SCI.START_DT <= CI.START_DT ) )
AND ( PRCTV.END_SEQUENCE_NUMBER IS NULL OR EXISTS ( SELECT 'X'
FROM IGS_CA_INST SCI
WHERE SCI.CAL_TYPE = PRCTV.PRG_CAL_TYPE
AND SCI.SEQUENCE_NUMBER = PRCTV.END_SEQUENCE_NUMBER
AND SCI.START_DT >= CI.START_DT ) ) )

Columns

Name
PROGRESSION_RULE_CAT
PRA_SEQUENCE_NUMBER
PRG_CAL_TYPE
PRG_CI_SEQUENCE_NUMBER
START_EFFECTIVE_PERIOD
NUM_OF_APPLICATIONS