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: IGS_SC_COURSE_DTLS_SV

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

View Text

SELECT APP.PERSON_ID
, PS.RESPONSIBLE_ORG_UNIT_CD
, PS.COURSE_TYPE
, PS.COURSE_CD
, PS.VERSION_NUMBER
FROM IGS_PS_VER_ALL PS
, IGS_AD_PS_APPL_INST_ALL APP
WHERE PS.COURSE_CD = APP.COURSE_CD
AND PS.VERSION_NUMBER = APP.CRV_VERSION_NUMBER UNION ALL SELECT SUA.PERSON_ID
, PS.RESPONSIBLE_ORG_UNIT_CD
, PS.COURSE_TYPE
, PS.COURSE_CD
, PS.VERSION_NUMBER
FROM IGS_PS_VER_ALL PS
, IGS_EN_STDNT_PS_ATT_ALL SUA
WHERE PS.COURSE_CD = SUA.COURSE_CD
AND PS.VERSION_NUMBER = SUA.VERSION_NUMBER

Columns

Name
PERSON_ID
RESPONSIBLE_ORG_UNIT_CD
COURSE_TYPE
COURSE_CD
VERSION_NUMBER