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

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

View Text

SELECT ATD.TST_RSLT_DTLS_ID
, ATD.TEST_RESULTS_ID
, APT.PERSON_ID
, APT.ADMISSION_TEST_TYPE
, ATD.TEST_SEGMENT_ID
, ATD.TEST_SCORE
, ATD.PERCENTILE
, ATD.NATIONAL_PERCENTILE
, ATD.STATE_PERCENTILE
, ATD.PERCENTILE_YEAR_RANK
, ATD.SCORE_BAND_LOWER
, ATD.SCORE_BAND_UPPER
, ATD.IRREGULARITY_CODE_ID
, '_DF:IGS:IGS_AD_TEST_RSLT_DTLS_FLEX:ATD'
, ATD.CREATED_BY
, ATD.CREATION_DATE
, ATD.LAST_UPDATED_BY
, ATD.LAST_UPDATE_DATE
FROM IGS_AD_TST_RSLT_DTLS ATD
, IGS_AD_TEST_RESULTS APT
WHERE ATD.TEST_RESULTS_ID = APT.TEST_RESULTS_ID WITH READ ONLY

Columns

Name
TST_RSLT_DTLS_ID
TEST_RESULTS_ID
PERSON_ID
ADMISSION_TEST_TYPE
TEST_SEGMENT_ID
TEST_SCORE
TEST_SCORE_PERCENTILE
NATIONAL_PERCENTILE
STATE_PERCENTILE
PERCENTILE_YEAR_RANK
SCORE_BAND_LOWER
SCORE_BAND_UPPER
IRREGULARITY_CODE_ID
"_DF"
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE