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_RU_CA_TYPE_V

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

View Text

SELECT PRCT.PROGRESSION_RULE_CAT
, PRA.SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, PRCT.PRG_CAL_TYPE
, PRCT.START_SEQUENCE_NUMBER
, PRCT.END_SEQUENCE_NUMBER
, PRCT.START_EFFECTIVE_PERIOD
, PRCT.NUM_OF_APPLICATIONS
, PRA.S_RELATION_TYPE
, PRCT.PRA_SEQUENCE_NUMBER ORIGINAL_PRA_SEQUENCE_NUMBER
, PRCT.CREATED_BY
, PRCT.CREATION_DATE
, PRCT.LAST_UPDATED_BY
, PRCT.LAST_UPDATE_DATE
, PRCT.LAST_UPDATE_LOGIN
FROM IGS_PR_RU_APPL PRA
, IGS_PR_RU_CA_TYPE PRCT
WHERE PRCT.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT AND PRCT.PRA_SEQUENCE_NUMBER = PRA.SEQUENCE_NUMBER UNION SELECT PRCT.PROGRESSION_RULE_CAT
, PRA.SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, PRCT.PRG_CAL_TYPE
, PRCT.START_SEQUENCE_NUMBER
, PRCT.END_SEQUENCE_NUMBER
, PRCT.START_EFFECTIVE_PERIOD
, PRCT.NUM_OF_APPLICATIONS
, PRA.S_RELATION_TYPE
, PRCT.PRA_SEQUENCE_NUMBER ORIGINAL_PRA_SEQUENCE_NUMBER
, PRCT.CREATED_BY
, PRCT.CREATION_DATE
, PRCT.LAST_UPDATED_BY
, PRCT.LAST_UPDATE_DATE
, PRCT.LAST_UPDATE_LOGIN
FROM IGS_PR_RU_APPL PRA
, IGS_PR_RU_APPL PRA1
, IGS_PR_RU_CA_TYPE PRCT
WHERE PRA.PROGRESSION_RULE_CD IS NOT NULL AND PRA.S_RELATION_TYPE IN ('CRV'
, 'OU'
, 'CTY'
, 'SCA'
, 'PRO'
, 'SPO') AND NOT EXISTS ( SELECT 'X' FROM IGS_PR_RU_CA_TYPE PRCT1 WHERE PRCT1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT AND PRCT1.PRA_SEQUENCE_NUMBER = PRA.SEQUENCE_NUMBER ) AND PRA1.S_RELATION_TYPE = 'PRR' AND PRA1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT AND PRA1.PROGRESSION_RULE_CD = PRA.PROGRESSION_RULE_CD AND PRCT.PROGRESSION_RULE_CAT = PRA1.PROGRESSION_RULE_CAT AND PRCT.PRA_SEQUENCE_NUMBER = PRA1.SEQUENCE_NUMBER UNION SELECT PRCT.PROGRESSION_RULE_CAT
, PRA.SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, PRCT.PRG_CAL_TYPE
, PRCT.START_SEQUENCE_NUMBER
, PRCT.END_SEQUENCE_NUMBER
, PRCT.START_EFFECTIVE_PERIOD
, PRCT.NUM_OF_APPLICATIONS
, PRA.S_RELATION_TYPE
, PRCT.PRA_SEQUENCE_NUMBER ORIGINAL_PRA_SEQUENCE_NUMBER
, PRCT.CREATED_BY
, PRCT.CREATION_DATE
, PRCT.LAST_UPDATED_BY
, PRCT.LAST_UPDATE_DATE
, PRCT.LAST_UPDATE_LOGIN
FROM IGS_PR_RU_APPL PRA
, IGS_PR_RU_APPL PRA1
, IGS_PR_RU_CA_TYPE PRCT
WHERE PRA.S_RELATION_TYPE IN ('PRR'
, 'CRV'
, 'OU'
, 'CTY'
, 'SCA'
, 'PRO'
, 'SPO') AND NOT EXISTS ( SELECT 'X' FROM IGS_PR_RU_CA_TYPE PRCT1 WHERE PRCT1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT AND PRCT1.PRA_SEQUENCE_NUMBER = PRA.SEQUENCE_NUMBER ) AND NOT EXISTS ( SELECT 'X' FROM IGS_PR_RU_APPL PRA2
, IGS_PR_RU_CA_TYPE PRCT2 WHERE PRA2.S_RELATION_TYPE = 'PRR' AND PRA2.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT AND PRA2.PROGRESSION_RULE_CD = PRA.PROGRESSION_RULE_CD AND PRCT2.PROGRESSION_RULE_CAT = PRA2.PROGRESSION_RULE_CAT AND PRCT2.PRA_SEQUENCE_NUMBER = PRA2.SEQUENCE_NUMBER ) AND PRA1.S_RELATION_TYPE = 'PRGC' AND PRA1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT AND PRCT.PROGRESSION_RULE_CAT = PRA1.PROGRESSION_RULE_CAT AND PRCT.PRA_SEQUENCE_NUMBER = PRA1.SEQUENCE_NUMBER

Columns

Name
PROGRESSION_RULE_CAT
PRA_SEQUENCE_NUMBER
PRG_CAL_TYPE
START_SEQUENCE_NUMBER
END_SEQUENCE_NUMBER
START_EFFECTIVE_PERIOD
NUM_OF_APPLICATIONS
S_RELATION_TYPE
ORIGINAL_PRA_SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN