VIEW: APPS.IGS_AD_TEST_SCORES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'