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:
Not implemented in this database
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