Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT TRD.ROWID ROW_ID
, TRD.TST_RSLT_DTLS_ID TST_RSLT_DTLS_ID
, TRD.TEST_RESULTS_ID TEST_RESULTS_ID
, TRD.TEST_SEGMENT_ID TEST_SEGMENT_ID
, TS.TEST_SEGMENT_NAME TEST_SEGMENT_NAME
, TRD.TEST_SCORE TEST_SCORE
, TRD.PERCENTILE PERCENTILE
, TRD.NATIONAL_PERCENTILE NATIONAL_PERCENTILE
, TRD.STATE_PERCENTILE STATE_PERCENTILE
, TRD.PERCENTILE_YEAR_RANK PERCENTILE_YEAR_RANK
, TRD.SCORE_BAND_LOWER SCORE_BAND_LOWER
, TRD.SCORE_BAND_UPPER SCORE_BAND_UPPER
, TRD.IRREGULARITY_CODE_ID IRREGULARITY_CODE_ID
, CC.NAME IRREGULARITY_CODE_NAME
, TRD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TRD.ATTRIBUTE1 ATTRIBUTE1
, TRD.ATTRIBUTE2 ATTRIBUTE2
, TRD.ATTRIBUTE3 ATTRIBUTE3
, TRD.ATTRIBUTE4 ATTRIBUTE4
, TRD.ATTRIBUTE5 ATTRIBUTE5
, TRD.ATTRIBUTE6 ATTRIBUTE6
, TRD.ATTRIBUTE7 ATTRIBUTE7
, TRD.ATTRIBUTE8 ATTRIBUTE8
, TRD.ATTRIBUTE9 ATTRIBUTE9
, TRD.ATTRIBUTE10 ATTRIBUTE10
, TRD.ATTRIBUTE11 ATTRIBUTE11
, TRD.ATTRIBUTE12 ATTRIBUTE12
, TRD.ATTRIBUTE13 ATTRIBUTE13
, TRD.ATTRIBUTE14 ATTRIBUTE14
, TRD.ATTRIBUTE15 ATTRIBUTE15
, TRD.ATTRIBUTE16 ATTRIBUTE16
, TRD.ATTRIBUTE17 ATTRIBUTE17
, TRD.ATTRIBUTE18 ATTRIBUTE18
, TRD.ATTRIBUTE19 ATTRIBUTE19
, TRD.ATTRIBUTE20 ATTRIBUTE20
, TRD.CREATED_BY CREATED_BY
, TRD.CREATION_DATE CREATION_DATE
, TRD.LAST_UPDATED_BY LAST_UPDATED_BY
, TRD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TRD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TS.SEGMENT_TYPE SEGMENT_TYPE
, TS.SEGMENT_GROUP SEGMENT_GROUP FROM IGS_AD_TST_RSLT_DTLS TRD
, IGS_AD_TEST_SEGMENTS TS
, IGS_AD_CODE_CLASSES CC
WHERE TRD.TEST_SEGMENT_ID = TS.TEST_SEGMENT_ID AND CC.CODE_ID (+) = TRD.IRREGULARITY_CODE_ID