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.

VIEW: APPS.IGSBV_AD_ACT_STATS_SUBSCORE

Source

View Text - Preformatted


SELECT PEA.PE_PERSON_ID PERSON_IDENTIFIER, (SELECT SEGMENT_GROUP FROM IGS_LOOKUP_VALUES LKP, IGS_AD_TEST_SEGMENTS TSG WHERE LKP.LOOKUP_TYPE ='ACT_STATISTIC_CATEGORY' AND LKP.LOOKUP_CODE =ACTST.STATISTIC_CATEGORY AND LKP.MEANING = TSG.TEST_SEGMENT_NAME AND DECODE(ACTST.TEST_TYPE,'D','ACT-DANTES','F','ACT-INTERNATIONAL','I','ACT-INSTITUTION','R','ACT-RESIDUAL','S','ACT-STATE','Z','ACT-ARRANGED','N','ACT-NATIONAL')=TSG.ADMISSION_TEST_TYPE ) SEGMENT_GROUP , ACTST.REPORTING_YEAR REPORTING_YEAR, ACTST.ACT_IDENTIFIER ACT_IDENTIFIER, ACTST.TEST_TYPE TEST_TYPE, ACTST.TEST_DATE_TXT TEST_DATE_TXT, ACTST.STATISTIC_CATEGORY STATISTIC_CATEGORY_CODE, '_LA:ACTST.STATISTIC_CATEGORY:IGS_LOOKUP_VALUES:ACT_STATISTIC_CATEGORY:MEANING' "_LA:STATISTIC_CATEGORY", '_LA:ACTST.STATISTIC_CATEGORY:IGS_LOOKUP_VALUES:ACT_STATISTIC_CATEGORY:DESCRIPTION' "_LA:STATISTIC_CATEGORY_DESC", ACTST.SCORE SCORE, ACTST.NATIONAL_NORM NATIONAL_NORM, ACTST.LOCAL_NORM LOCAL_NORM, ACTST.CREATED_BY CREATED_BY, ACTST.CREATION_DATE CREATION_DATE, ACTST.LAST_UPDATED_BY LAST_UPDATED_BY, ACTST.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_AD_ACT_STATISTICS ACTST, IGS_PE_ALT_PERS_ID PEA WHERE ACTST.STATISTIC_TYPE = 'TEST_SUB_SCORE' AND DECODE(SUBSTR(ACTST.ACT_IDENTIFIER,1,1),'-',SUBSTR(ACTST.ACT_IDENTIFIER,2), ACTST.ACT_IDENTIFIER) = PEA.API_PERSON_ID (+) AND PEA.PERSON_ID_TYPE(+) = 'ACTID' WITH READ ONLY

View Text - HTML Formatted

SELECT PEA.PE_PERSON_ID PERSON_IDENTIFIER
, (SELECT SEGMENT_GROUP
FROM IGS_LOOKUP_VALUES LKP
, IGS_AD_TEST_SEGMENTS TSG
WHERE LKP.LOOKUP_TYPE ='ACT_STATISTIC_CATEGORY'
AND LKP.LOOKUP_CODE =ACTST.STATISTIC_CATEGORY
AND LKP.MEANING = TSG.TEST_SEGMENT_NAME
AND DECODE(ACTST.TEST_TYPE
, 'D'
, 'ACT-DANTES'
, 'F'
, 'ACT-INTERNATIONAL'
, 'I'
, 'ACT-INSTITUTION'
, 'R'
, 'ACT-RESIDUAL'
, 'S'
, 'ACT-STATE'
, 'Z'
, 'ACT-ARRANGED'
, 'N'
, 'ACT-NATIONAL')=TSG.ADMISSION_TEST_TYPE ) SEGMENT_GROUP
, ACTST.REPORTING_YEAR REPORTING_YEAR
, ACTST.ACT_IDENTIFIER ACT_IDENTIFIER
, ACTST.TEST_TYPE TEST_TYPE
, ACTST.TEST_DATE_TXT TEST_DATE_TXT
, ACTST.STATISTIC_CATEGORY STATISTIC_CATEGORY_CODE
, '_LA:ACTST.STATISTIC_CATEGORY:IGS_LOOKUP_VALUES:ACT_STATISTIC_CATEGORY:MEANING' "_LA:STATISTIC_CATEGORY"
, '_LA:ACTST.STATISTIC_CATEGORY:IGS_LOOKUP_VALUES:ACT_STATISTIC_CATEGORY:DESCRIPTION' "_LA:STATISTIC_CATEGORY_DESC"
, ACTST.SCORE SCORE
, ACTST.NATIONAL_NORM NATIONAL_NORM
, ACTST.LOCAL_NORM LOCAL_NORM
, ACTST.CREATED_BY CREATED_BY
, ACTST.CREATION_DATE CREATION_DATE
, ACTST.LAST_UPDATED_BY LAST_UPDATED_BY
, ACTST.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_AD_ACT_STATISTICS ACTST
, IGS_PE_ALT_PERS_ID PEA
WHERE ACTST.STATISTIC_TYPE = 'TEST_SUB_SCORE'
AND DECODE(SUBSTR(ACTST.ACT_IDENTIFIER
, 1
, 1)
, '-'
, SUBSTR(ACTST.ACT_IDENTIFIER
, 2)
, ACTST.ACT_IDENTIFIER) = PEA.API_PERSON_ID (+)
AND PEA.PERSON_ID_TYPE(+) = 'ACTID' WITH READ ONLY