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_DA_XML_CONTROLGPA_V

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

View Text

SELECT DCS.STAT_TYPE
, DCS.TIMEFRAME
, NVL( (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.BATCH_ID = DR.BATCH_ID
AND DRF.FEATURE_CODE = 'TRM')
, 'NO SESSION VALUE')
, DR.BATCH_ID
FROM IGS_DA_RQST DR
, IGS_DA_CNFG_STAT DCS
WHERE DR.REQUEST_TYPE_ID = DCS.REQUEST_TYPE_ID

Columns

Name
GPA_TYPE
GPA_TIMEFRAME
SESSIONID
BATCH_ID