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_EXAMINATION_V

Product:	IGS - Student System (Obsolete)
Description:	XML element ExaminationProvides Student"s basic examination information test type, dates, scores. All Examination information can be excluded with ETS feature value set to Y.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ATR.ADMISSION_TEST_TYPE
, TO_CHAR(ATR.TEST_DATE
, 'YYYY-MM-DD')
, ATR.COMP_TEST_SCORE
, DR.BATCH_ID
, ATR.PERSON_ID
, ATR.TEST_RESULTS_ID
FROM IGS_AD_TEST_RESULTS_V ATR
, IGS_DA_RQST DR
WHERE ATR.ACTIVE_IND = 'Y'
AND NOT EXISTS (SELECT 'X'
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.BATCH_ID = DR.BATCH_ID
AND DRF.FEATURE_CODE = 'ETS'
AND NVL(DRF.FEATURE_VALUE
, 'N') = 'Y')

Columns

Name
TEST_TYPE
TEST_DATE
TEST_COMPOSITE_SCORE
BATCH_ID
PERSON_ID
TEST_RESULTS_ID