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_PROFILES_OOCA

Product:	IGS - Student System (Obsolete)
Description:	ACT profile components and category for type as Out of Class Accomplishments
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PEA. PE_PERSON_ID PERSON_IDENTIFIER
, ACTPR.REPORTING_YEAR REPORTING_YEAR
, ACTPR.ACT_IDENTIFIER ACT_IDENTIFIER
, ACTPR.TEST_TYPE TEST_TYPE
, ACTPR.TEST_DATE_TXT TEST_DATE_TXT
, ACTPR.PROFILE_CATEGORY PROFILE_CATEGORY_CODE
, '_LA:ACTPR.PROFILE_CATEGORY:IGS_LOOKUP_VALUES:ACT_PROFILE_CATEGORY:MEANING' "_LA:PROFILE_CATEGORY"
, '_LA:ACTPR.PROFILE_CATEGORY:IGS_LOOKUP_VALUES:ACT_PROFILE_CATEGORY:DESCRIPTION' "_LA:PROFILE_CATEGORY_DESC"
, ACTPR.CODE1 CODE1
, ACTPR.CODE2 CODE2
, ACTPR.CODE3 CODE3
, ACTPR.CODE4 CODE4
, ACTPR.CODE5 CODE5
, ACTPR.CODE6 CODE6
, ACTPR.CODE7 CODE7
, ACTPR.CREATED_BY CREATED_BY
, ACTPR.CREATION_DATE CREATION_DATE
, ACTPR.LAST_UPDATED_BY LAST_UPDATED_BY
, ACTPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_AD_ACT_PROFILES ACTPR
, IGS_PE_ALT_PERS_ID PEA
WHERE ACTPR.PROFILE_TYPE = 'OOCA'
AND DECODE(SUBSTR(ACTPR.ACT_IDENTIFIER
, 1
, 1)
, '-'
, SUBSTR(ACTPR.ACT_IDENTIFIER
, 2)
, ACTPR.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
PROFILE_CATEGORY_CODE
_LA:PROFILE_CATEGORY
_LA:PROFILE_CATEGORY_DESC
CODE1
CODE2
CODE3
CODE4
CODE5
CODE6
CODE7
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE