Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity gives the intermission information of the student's program attempt. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SCI.PERSON_ID
, HP1.PARTY_NUMBER
, HP1.PARTY_NAME
, SCI.COURSE_CD
, PS.TITLE
, SCI.INTERMISSION_TYPE
, EITY.DESCRIPTION
, SCI. START_DT
, SCI.END_DT
, SCI.VOLUNTARY_IND
, '_LA:VOLUNTARY_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SCI.COMMENTS
, SCI.APPROVED
, '_LA:APPROVED:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SCI.INSTITUTION_NAME
, HP3.PARTY_NUMBER
, SCI.MAX_CREDIT_PTS
, SCI.MAX_TERMS
, SCI.ANTICIPATED_CREDIT_POINTS
, '_DF:IGS:IGS_EN_STDNT_INTM_FLEX:SCI'
, SCI.APPROVER_ID
, HP2.PARTY_NUMBER
, HP2.PARTY_NAME
, SCI.CREATED_BY
, SCI.CREATION_DATE
, SCI.LAST_UPDATED_BY
, SCI.LAST_UPDATE_DATE
, SCI.LOGICAL_DELETE_DATE
, SCI.COND_RETURN_FLAG
FROM IGS_EN_STDNT_PS_INTM SCI
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, HZ_PARTIES HP3
, IGS_EN_INTM_TYPES EITY
, IGS_EN_STDNT_PS_ATT_ALL SPA
, IGS_PS_VER_ALL PS
WHERE SCI.PERSON_ID = HP1.PARTY_ID
AND SCI.PERSON_ID = SPA.PERSON_ID
AND SCI.COURSE_CD = SPA.COURSE_CD
AND SPA.COURSE_CD = PS.COURSE_CD
AND SPA.VERSION_NUMBER = PS.VERSION_NUMBER
AND SCI.APPROVER_ID = HP2.PARTY_ID (+)
AND SCI.INSTITUTION_NAME = HP3.PARTY_NAME (+)
AND SCI.INTERMISSION_TYPE = EITY.INTERMISSION_TYPE (+) WITH READ ONLY