[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Describes Student Progression Rule Check |
| Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, CRV.TITLE
, SPO.COURSE_CD
, SPO.PRG_CAL_TYPE
, SPO.PRG_CI_SEQUENCE_NUMBER
, SPO.RULE_CHECK_DT
, SPO.PROGRESSION_RULE_CAT
, SPO.PROGRESSION_OUTCOME_TYPE
, SPO.DURATION
, SPO.DURATION_TYPE
, SPO.DECISION_STATUS
, SPO.DECISION_DT
, SPO.DECISION_ORG_UNIT_CD
, SPO.DECISION_OU_START_DT
, SPO.APPLIED_DT
, SPO.EXPIRY_DT
, SPO.SHOW_CAUSE_EXPIRY_DT
, SPO.SHOW_CAUSE_DT
, SPO.SHOW_CAUSE_OUTCOME_DT
, SPO.SHOW_CAUSE_OUTCOME_TYPE
, SPO.SHOW_CAUSE_COMMENTS
, SPO.APPEAL_EXPIRY_DT
, SPO.APPEAL_DT
, SPO.APPEAL_OUTCOME_DT
, SPO.APPEAL_OUTCOME_TYPE
, SPO.APPEAL_COMMENTS
, SPO.ENCMB_COURSE_GROUP_CD
, SPO.RESTRICTED_ENROLMENT_CP
, SPO.RESTRICTED_ATTENDANCE_TYPE
, SPO.COMMENTS
, SPO.SEQUENCE_NUMBER
, SPO.PERSON_ID
, SPO.PRA_SEQUENCE_NUMBER
, SPO.PRO_PRA_SEQUENCE_NUMBER
, SPO.PRO_SEQUENCE_NUMBER
, SPO.CREATED_BY
, SPO.CREATION_DATE
, SPO.LAST_UPDATED_BY
, SPO.LAST_UPDATE_DATE
FROM IGS_PR_STDNT_PR_OU_ALL SPO
, IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP
, IGS_PS_VER_ALL CRV
WHERE SPO.PERSON_ID = HP.PARTY_ID
AND SPO.PERSON_ID = SCA.PERSON_ID
AND SPO.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER WITH READ ONLY