[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PSPO.ROWID ROW_ID
, PSPO.PERSON_ID PERSON_ID
, PSPO.COURSE_CD COURSE_CD
, PSPO.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PSPO.PRG_CAL_TYPE PRG_CAL_TYPE
, PSPO.PRG_CI_SEQUENCE_NUMBER PRG_CI_SEQUENCE_NUMBER
, PSPO.RULE_CHECK_DT RULE_CHECK_DT
, PSPO.PROGRESSION_RULE_CAT PROGRESSION_RULE_CAT
, PSPO.PRA_SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, PSPO.PRO_SEQUENCE_NUMBER PRO_SEQUENCE_NUMBER
, PSPO.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE
, PSPO.DURATION DURATION
, PSPO.DURATION_TYPE DURATION_TYPE
, PSPO.DECISION_STATUS DECISION_STATUS
, PSPO.DECISION_DT DECISION_DT
, PSPO.DECISION_ORG_UNIT_CD DECISION_ORG_UNIT_CD
, PSPO.DECISION_OU_START_DT DECISION_OU_START_DT
, PSPO.APPLIED_DT APPLIED_DT
, PSPO.SHOW_CAUSE_EXPIRY_DT SHOW_CAUSE_EXPIRY_DT
, PSPO.SHOW_CAUSE_DT SHOW_CAUSE_DT
, PSPO.SHOW_CAUSE_OUTCOME_DT SHOW_CAUSE_OUTCOME_DT
, PSPO.SHOW_CAUSE_OUTCOME_TYPE SHOW_CAUSE_OUTCOME_TYPE
, PSPO.APPEAL_EXPIRY_DT APPEAL_EXPIRY_DT
, PSPO.APPEAL_DT APPEAL_DT
, PSPO.APPEAL_OUTCOME_DT APPEAL_OUTCOME_DT
, PSPO.APPEAL_OUTCOME_TYPE APPEAL_OUTCOME_TYPE
, PSPO.ENCMB_COURSE_GROUP_CD ENCMB_COURSE_GROUP_CD
, PSPO.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_CP
, PSPO.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE
, PSPO.COMMENTS COMMENTS
, PSPO.SHOW_CAUSE_COMMENTS SHOW_CAUSE_COMMENTS
, PSPO.APPEAL_COMMENTS APPEAL_COMMENTS
, PSPO.CREATED_BY CREATED_BY
, PSPO.CREATION_DATE CREATION_DATE
, PSPO.EXPIRY_DT EXPIRY_DT
, PSPO.PRO_PRA_SEQUENCE_NUMBER PRO_PRA_SEQUENCE_NUMBER
, PSPO.LAST_UPDATED_BY LAST_UPDATED_BY
, PSPO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PSPO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, POT.POSITIVE_OUTCOME_IND POSITIVE_OUTCOME_IND
FROM IGS_PR_STDNT_PR_OU PSPO
, IGS_PR_OU_TYPE POT
WHERE PSPO.PROGRESSION_OUTCOME_TYPE = POT.PROGRESSION_OUTCOME_TYPE