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
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:
APPS.IGS_DA_XML_EXAMINATION_V
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