[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view gives the detailed description for the test scores for the Students. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ATT.ROWID ROW_ID
, ATT.TEST_RESULTS_ID
, ATT.PERSON_ID
, ATT.ADMISSION_TEST_TYPE TEST_TYPE
, ATT.TEST_DATE TEST_DATE
, DECODE(ATT.SCORE_SOURCE_ID
, NULL
, NULL
, (SELECT NAME FROM IGS_AD_CODE_CLASSES WHERE ATT.SCORE_SOURCE_ID=CODE_ID AND CLASS ='SYS_SCORE_SOURCE')) SCORE_SOURCE
, ATT.SCORE_TYPE SCORE_TYPE
, DECODE(ATR.TEST_SEGMENT_ID
, NULL
, NULL
, (SELECT TEST_SEGMENT_NAME FROM IGS_AD_TEST_SEGMENTS WHERE ATR.TEST_SEGMENT_ID=TEST_SEGMENT_ID )) TEST_SEGMENT
, ATR.TEST_SCORE SEGMENT_SCORE
, ATT.COMP_TEST_SCORE COMBINED_SCORE
, ATT.ACTIVE_IND ACTIVE_IND
, ATT.CREATION_DATE CREATION_DATE
, ATT.CREATED_BY CREATED_BY
, ATT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ATT.LAST_UPDATED_BY LAST_UPDATED_BY
, ATT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, L1.MEANING SCORE_TYPE_MEANING
, ATS.SEGMENT_TYPE SEGMENT_TYPE
, ATS.SEGMENT_GROUP SEGMENT_GROUP
FROM IGS_AD_TEST_RESULTS ATT
, IGS_AD_TST_RSLT_DTLS ATR
, IGS_AD_TEST_SEGMENTS ATS
, IGS_LOOKUP_VALUES L1
WHERE ATT.TEST_RESULTS_ID = ATR.TEST_RESULTS_ID (+)
AND ATS.TEST_SEGMENT_ID (+) = ATR.TEST_SEGMENT_ID
AND ATT.SCORE_TYPE = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE(+) = 'TEST_SCORE_TYPE'