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.

[Home] [Help]

View: IGSFV_AD_ACT_STATS_INTEREST

Product:	IGS - Student System (Obsolete)
Description:	ACT Statistical Test Components and category details for type as Interest
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PEA.PE_PERSON_ID PERSON_IDENTIFIER
, 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.STANDARD_SCORE STANDARD_SCORE
, ACTST.PERCENTILE_RANK PERCENTILE_RANK
, 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 = 'INTEREST'
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

Columns

Name
PERSON_IDENTIFIER
REPORTING_YEAR
ACT_IDENTIFIER
TEST_TYPE
TEST_DATE_TXT
STATISTIC_CATEGORY_CODE
_LA:STATISTIC_CATEGORY
_LA:STATISTIC_CATEGORY_DESC
SCORE
STANDARD_SCORE
PERCENTILE_RANK
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE