Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view contains all the information on intermission by a student. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ESPI.ROWID
, ESPI.PERSON_ID
, ESPI.COURSE_CD
, EIT.INTERMISSION_TYPE
, EIT.DESCRIPTION
, ESPI.APPROVED
, ESPI.INSTITUTION_NAME INSTITUTION_CD
, IOIE.NAME INSTITUTION_NAME
, ESPI.MAX_CREDIT_PTS
, ESPI.MAX_TERMS
, ESPI.ANTICIPATED_CREDIT_POINTS
, ESPI.APPROVER_ID
, HP.PARTY_NUMBER APPROVER_NUMBER
, HP.PARTY_NAME APPROVER_NAME
, ESPI.START_DT
, ESPI.LOGICAL_DELETE_DATE
, ESPI.END_DT
, ESPI.VOLUNTARY_IND
, ESPI.COMMENTS
, ESPI.CREATED_BY
, ESPI.CREATION_DATE
, ESPI.LAST_UPDATED_BY
, ESPI.LAST_UPDATE_DATE
, ESPI.LAST_UPDATE_LOGIN
, ESPI.ATTRIBUTE_CATEGORY
, ESPI.ATTRIBUTE1
, ESPI.ATTRIBUTE2
, ESPI.ATTRIBUTE3
, ESPI.ATTRIBUTE4
, ESPI.ATTRIBUTE5
, ESPI.ATTRIBUTE6
, ESPI.ATTRIBUTE7
, ESPI.ATTRIBUTE8
, ESPI.ATTRIBUTE9
, ESPI.ATTRIBUTE10
, ESPI.ATTRIBUTE11
, ESPI.ATTRIBUTE12
, ESPI.ATTRIBUTE13
, ESPI.ATTRIBUTE14
, ESPI.ATTRIBUTE15
, ESPI.ATTRIBUTE16
, ESPI.ATTRIBUTE17
, ESPI.ATTRIBUTE18
, ESPI.ATTRIBUTE19
, ESPI.ATTRIBUTE20
, ESPI.COND_RETURN_FLAG
FROM IGS_EN_STDNT_PS_INTM ESPI
, IGS_EN_INTM_TYPES EIT
, HZ_PARTIES HP
, IGS_OR_INST_EXEMPT_V IOIE
WHERE ESPI.INTERMISSION_TYPE = EIT.INTERMISSION_TYPE(+) AND ESPI.APPROVER_ID = HP.PARTY_ID(+)
AND IOIE. EXEMPTION_INSTITUTION_CD(+) = ESPI.INSTITUTION_NAME