Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Student Intermission Return Conditions |
Implementation/DBA Data: | Not implemented in this database |
SELECT SRC.PERSON_ID
, SRC.COURSE_CD
, SRC.START_DT
, SRC.LOGICAL_DELETE_DATE
, SRC.RETURN_CONDITION
, SRC.STATUS_CODE
, SRC.APPROVED_DT
, SRC.APPROVED_BY
, SRC.CREATED_BY
, SRC.CREATION_DATE
, SRC.LAST_UPDATED_BY
, SRC.LAST_UPDATE_DATE
, SRC.LAST_UPDATE_LOGIN
, HZ.PARTY_NUMBER
, PV.TITLE
, RC.DESCRIPTION
FROM IGS_EN_SPI_RCONDS SRC
, IGS_EN_STDNT_PS_ATT_ALL SPA
, IGS_PS_VER_ALL PV
, HZ_PARTIES HZ
, IGS_EN_INTM_RCONDS RC
WHERE RC.RETURN_CONDITION = SRC.RETURN_CONDITION
AND HZ.PARTY_ID = SRC.PERSON_ID
AND SPA.PERSON_ID = SRC.PERSON_ID
AND SPA.COURSE_CD = SRC.COURSE_CD
AND PV.COURSE_CD = SPA.COURSE_CD
AND PV.VERSION_NUMBER = SPA.VERSION_NUMBER WITH READ ONLY