[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | ACT Statistical Test Components and category details for type as Sub Test |
| Implementation/DBA Data: | Not implemented in this database |
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