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: IGS_PR_ACAD_EXAM_CREDIT_V
Product: IGS - Student System
Description: This view contains the details of credit granted through advanced standing based on the Admissions Exam structure. The credit is shown only as an aggregated summary figure.
Implementation/DBA Data:
APPS.IGS_PR_ACAD_EXAM_CREDIT_V
View Text
SELECT SPA.PERSON_ID , PE.PARTY_NUMBER , SPA.COURSE_CD PROGRAM_CD , ATSR.ADMISSION_TEST_TYPE , ATSR.TEST_TYPE_DESCRIPTION ADMISSION_TEST_DESCRIPTION , ATSR.TEST_DATE , ATSR.TEST_SEGMENT_NAME , ATSR.SEG_DESCRIPTION TEST_SEGMENT_DESCRIPTION , ATSR.TEST_SCORE , ATSR.TST_RSLT_DTLS_ID , SUM(ADV.CREDIT_POINTS) CREDIT_POINTS FROM IGS_AD_TEST_SEG_RESULTS_V ATSR , IGS_EN_STDNT_PS_ATT_ALL SPA , HZ_PARTIES PE , ( SELECT ASU.PERSON_ID , TST_RSLT_DTLS_ID , AS_COURSE_CD , ACHIEVABLE_CREDIT_POINTS CREDIT_POINTS FROM IGS_AV_STND_UNIT_ALL ASU WHERE ASU.TST_RSLT_DTLS_ID IS NOT NULL AND ASU.S_ADV_STND_GRANTING_STATUS = 'GRANTED' AND ASU.S_ADV_STND_RECOGNITION_TYPE = 'CREDIT' UNION ALL SELECT ASUL.PERSON_ID , TST_RSLT_DTLS_ID , AS_COURSE_CD , CREDIT_POINTS CREDIT_POINTS FROM IGS_AV_STND_UNIT_LVL_ALL ASUL WHERE ASUL.TST_RSLT_DTLS_ID IS NOT NULL AND ASUL.S_ADV_STND_GRANTING_STATUS = 'GRANTED' ) ADV WHERE ATSR.PERSON_ID = SPA.PERSON_ID AND PE.PARTY_ID = SPA.PERSON_ID AND ADV.PERSON_ID = SPA.PERSON_ID AND ADV.AS_COURSE_CD = SPA.COURSE_CD AND ADV.TST_RSLT_DTLS_ID = ATSR.TST_RSLT_DTLS_ID GROUP BY SPA.PERSON_ID , PE.PARTY_NUMBER , SPA.COURSE_CD , ATSR.ADMISSION_TEST_TYPE , ATSR.TEST_TYPE_DESCRIPTION , ATSR.TEST_DATE , ATSR.TEST_SEGMENT_NAME , ATSR.SEG_DESCRIPTION , ATSR.TEST_SCORE , ATSR.TST_RSLT_DTLS_ID
Columns
Name
PERSON_ID
PARTY_NUMBER
PROGRAM_CD
ADMISSION_TEST_TYPE
ADMISSION_TEST_DESCRIPTION
TEST_DATE
TEST_SEGMENT_NAME
TEST_SEGMENT_DESCRIPTION
TEST_SCORE
TST_RSLT_DTLS_ID
CREDIT_POINTS