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_RULE_OUT_V

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

View Text

SELECT PRO.PROGRESSION_RULE_CAT
, PRA.SEQUENCE_NUMBER
, PRO.SEQUENCE_NUMBER
, PRO.NUMBER_OF_FAILURES
, PRO.PROGRESSION_OUTCOME_TYPE
, PRO.APPLY_AUTOMATICALLY_IND
, PRO.PRG_RULE_REPEAT_FAIL_TYPE
, PRO.OVERRIDE_SHOW_CAUSE_IND
, PRO.OVERRIDE_APPEAL_IND
, PRO.DURATION
, PRO.DURATION_TYPE
, PRO.RANK
, PRO.ENCMB_COURSE_GROUP_CD
, PRO.RESTRICTED_ENROLMENT_CP
, PRO.RESTRICTED_ATTENDANCE_TYPE
, PRA.S_RELATION_TYPE
, PRO.PRA_SEQUENCE_NUMBER
, PRO.POSITIVE_OUTCOME_IND
, PRO.CREATED_BY
, PRO.CREATION_DATE
, PRO.LAST_UPDATED_BY
, PRO.LAST_UPDATE_DATE
, PRO.LAST_UPDATE_LOGIN
, PRO.LOGICAL_DELETE_DT FROM IGS_PR_RU_APPL PRA
, IGS_PR_RU_OU_V PRO
WHERE ( PRO.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRO.PRA_SEQUENCE_NUMBER = PRA.SEQUENCE_NUMBER ) OR EXISTS ( SELECT 1
FROM IGS_PR_RU_APPL PRA1
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_OU PRO1
WHERE PRO1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRO1.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 PRO.PROGRESSION_RULE_CAT = PRA1.PROGRESSION_RULE_CAT
AND PRO.PRA_SEQUENCE_NUMBER = PRA1.SEQUENCE_NUMBER UNION ALL SELECT 1
FROM IGS_PR_RU_APPL PRA1
WHERE PRA.S_RELATION_TYPE IN ('PRR'
, 'CRV'
, 'OU'
, 'CTY'
, 'SCA'
, 'PRO'
, 'SPO')
AND NOT EXISTS ( SELECT 'X'
FROM IGS_PR_RU_OU PRO1
WHERE PRO1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRO1.PRA_SEQUENCE_NUMBER = PRA.SEQUENCE_NUMBER)
AND NOT EXISTS ( SELECT 'X'
FROM IGS_PR_RU_APPL PRA2
, IGS_PR_RU_OU PRO2
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 PRO2.PROGRESSION_RULE_CAT = PRA2.PROGRESSION_RULE_CAT
AND PRO2.PRA_SEQUENCE_NUMBER = PRA2.SEQUENCE_NUMBER)
AND PRA1.S_RELATION_TYPE = 'PRGC'
AND PRA1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRO.PROGRESSION_RULE_CAT = PRA1.PROGRESSION_RULE_CAT
AND PRO.PRA_SEQUENCE_NUMBER = PRA1.SEQUENCE_NUMBER)

Columns

Name
PROGRESSION_RULE_CAT
PRA_SEQUENCE_NUMBER
SEQUENCE_NUMBER
NUMBER_OF_FAILURES
PROGRESSION_OUTCOME_TYPE
APPLY_AUTOMATICALLY_IND
PRG_RULE_REPEAT_FAIL_TYPE
OVERRIDE_SHOW_CAUSE_IND
OVERRIDE_APPEAL_IND
DURATION
DURATION_TYPE
RANK
ENCMB_COURSE_GROUP_CD
RESTRICTED_ENROLMENT_CP
RESTRICTED_ATTENDANCE_TYPE
S_RELATION_TYPE
ORIGINAL_PRA_SEQUENCE_NUMBER
POSITIVE_OUTCOME_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LOGICAL_DELETE_DT