[Home] [Help]
| 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
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SCI.COURSE_CD
, SCI.INTERMISSION_TYPE
, 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
, SCI.MAX_CREDIT_PTS
, SCI.MAX_TERMS
, SCI.ANTICIPATED_CREDIT_POINTS
, SCI.APPROVER_ID
, 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 HP
WHERE SCI.PERSON_ID = HP.PARTY_ID WITH READ ONLY