eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_INTM_RETURN_CONDS

Product:	IGS - Student System (Obsolete)
Description:	Student Intermission Return Conditions
Implementation/DBA Data:	Not implemented in this database

View Text

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
, HZ1.PARTY_NUMBER
, PV.TITLE
, RC.DESCRIPTION
, '_LA:STATUS_CODE:IGS_LOOKUP_VALUES:IGS_EN_INTM_RCOND_STS:MEANING'
, HZ2.PARTY_NUMBER
FROM IGS_EN_SPI_RCONDS SRC
, HZ_PARTIES HZ1
, HZ_PARTIES HZ2
, IGS_EN_INTM_RCONDS RC
, IGS_EN_STDNT_PS_ATT_ALL SPA
, IGS_PS_VER_ALL PV
WHERE RC.RETURN_CONDITION = SRC.RETURN_CONDITION
AND HZ1.PARTY_ID = SRC.PERSON_ID
AND HZ2.PARTY_ID(+) = SRC.APPROVED_BY
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

Columns

Name
PERSON_ID
PROGRAM_CODE
START_DATE
LOGICAL_DELETE_DATE
RETURN_CONDITION
STATUS_CODE
APPROVED_DATE
APPROVED_BY
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PERSON_NUMBER
PROGRAM_DESCRIPTION
RETURN_CONDITION_DESC
"_LA:STATUS_DESC"
APPROVER_NUMBER