Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT RUO.ROWID ROW_ID
, RUO.PROGRESSION_RULE_CAT PROGRESSION_RULE_CAT
, RUO.PRA_SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, RUO.SEQUENCE_NUMBER SEQUENCE_NUMBER
, RUO.NUMBER_OF_FAILURES NUMBER_OF_FAILURES
, RUO.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE
, ROT.POSITIVE_OUTCOME_IND POSITIVE_OUTCOME_IND
, RUO.APPLY_AUTOMATICALLY_IND APPLY_AUTOMATICALLY_IND
, RUO.PRG_RULE_REPEAT_FAIL_TYPE PRG_RULE_REPEAT_FAIL_TYPE
, RUO.OVERRIDE_SHOW_CAUSE_IND OVERRIDE_SHOW_CAUSE_IND
, RUO.OVERRIDE_APPEAL_IND OVERRIDE_APPEAL_IND
, RUO.DURATION DURATION
, RUO.DURATION_TYPE DURATION_TYPE
, RUO.RANK RANK
, RUO.ENCMB_COURSE_GROUP_CD ENCMB_COURSE_GROUP_CD
, RUO.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_CP
, RUO.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE
, RUO.COMMENTS COMMENTS
, RUO.CREATED_BY CREATED_BY
, RUO.CREATION_DATE CREATION_DATE
, RUO.LAST_UPDATED_BY LAST_UPDATED_BY
, RUO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RUO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RUO.LOGICAL_DELETE_DT LOGICAL_DELETE_DT
FROM IGS_PR_RU_OU RUO
, IGS_PR_OU_TYPE ROT
WHERE RUO.PROGRESSION_OUTCOME_TYPE = ROT.PROGRESSION_OUTCOME_TYPE