VIEW: APPS.IGS_PR_ACAD_EXAM_CREDIT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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