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: APPS.IGS_PR_ACAD_LOAD_V

Source

View Text - Preformatted


SELECT p.party_number person_number, spa.person_id, spa.course_cd, crv.course_type, ci2.description acad_description, ci2.alternate_code acad_alternate_code, ci.cal_type load_cal_type, ci.sequence_number load_ci_sequence_number, ci.description load_description, ci.alternate_code load_alternate_code, ci.start_dt load_start_dt, ci.end_dt load_end_dt, IGS_PR_ACAD_DETAILS.GET_LOAD_GPA( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) term_gpa, IGS_PR_ACAD_DETAILS.GET_LOAD_GPA_CP( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) term_gpa_cp, IGS_PR_ACAD_DETAILS.GET_LOAD_GPA_QP( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) term_gpa_qp, IGS_PR_ACAD_DETAILS.GET_LOAD_EARNED_CP( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) term_earned_cp, IGS_PR_ACAD_DETAILS.GET_LOAD_ATTEMPTED_CP( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) term_attempted_cp, IGS_PR_ACAD_DETAILS.GET_CUM_GPA( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) cum_gpa, IGS_PR_ACAD_DETAILS.GET_CUM_GPA_CP( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) cum_gpa_cp, IGS_PR_ACAD_DETAILS.GET_CUM_GPA_QP( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) cum_gpa_qp, IGS_PR_ACAD_DETAILS.GET_CUM_EARNED_CP( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) cum_earned_cp, IGS_PR_ACAD_DETAILS.GET_CUM_ATTEMPTED_CP( spa.person_id, spa.course_cd, ci.cal_type, ci.sequence_number) cum_attempted_cp FROM hz_parties p, igs_en_stdnt_ps_att spa, igs_ps_ver crv, igs_ca_inst ci, igs_ca_inst_rel cir, igs_ca_inst ci2, igs_ca_type ct2, igs_ca_stat cs2 WHERE p.party_id = spa.person_id AND spa.course_cd = crv.course_cd AND spa.version_number = crv.version_number AND ci.cal_type = cir.sub_cal_type AND ci.sequence_number = cir.sub_ci_sequence_number AND ci2.cal_type = cir.sup_cal_type AND ci2.sequence_number = cir.sup_ci_sequence_number AND ci2.cal_type = ct2.cal_type AND ct2.s_cal_cat = 'ACADEMIC' AND ci2.cal_status = cs2.cal_status AND cs2.s_cal_status = 'ACTIVE' AND EXISTS ( SELECT 'X' FROM igs_en_su_attempt sua, igs_ps_unit_ver uv, igs_ca_teach_to_load_v ttl, IGS_PS_PRG_UNIT_REL pur WHERE sua.person_id = spa.person_id AND sua.course_cd = spa.course_cd AND sua.cal_type = ttl.teach_cal_type AND sua.ci_sequence_number = ttl.teach_ci_sequence_number AND ci.cal_type = ttl.load_cal_type AND ci.sequence_number = ttl.load_ci_sequence_number AND uv.unit_cd = sua.unit_cd AND uv.version_number = sua.version_number AND sua.unit_attempt_status IN ('COMPLETED','DUPLICATE','ENROLLED','DISCONTIN') AND (sua.student_career_transcript = 'Y' OR (sua.student_career_transcript IS NULL AND pur.unit_type_id = uv.unit_type_id AND pur.student_career_level = crv.course_type AND pur.student_career_transcript = 'Y')))

View Text - HTML Formatted

SELECT P.PARTY_NUMBER PERSON_NUMBER
, SPA.PERSON_ID
, SPA.COURSE_CD
, CRV.COURSE_TYPE
, CI2.DESCRIPTION ACAD_DESCRIPTION
, CI2.ALTERNATE_CODE ACAD_ALTERNATE_CODE
, CI.CAL_TYPE LOAD_CAL_TYPE
, CI.SEQUENCE_NUMBER LOAD_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION LOAD_DESCRIPTION
, CI.ALTERNATE_CODE LOAD_ALTERNATE_CODE
, CI.START_DT LOAD_START_DT
, CI.END_DT LOAD_END_DT
, IGS_PR_ACAD_DETAILS.GET_LOAD_GPA( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) TERM_GPA
, IGS_PR_ACAD_DETAILS.GET_LOAD_GPA_CP( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) TERM_GPA_CP
, IGS_PR_ACAD_DETAILS.GET_LOAD_GPA_QP( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) TERM_GPA_QP
, IGS_PR_ACAD_DETAILS.GET_LOAD_EARNED_CP( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) TERM_EARNED_CP
, IGS_PR_ACAD_DETAILS.GET_LOAD_ATTEMPTED_CP( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) TERM_ATTEMPTED_CP
, IGS_PR_ACAD_DETAILS.GET_CUM_GPA( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) CUM_GPA
, IGS_PR_ACAD_DETAILS.GET_CUM_GPA_CP( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) CUM_GPA_CP
, IGS_PR_ACAD_DETAILS.GET_CUM_GPA_QP( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) CUM_GPA_QP
, IGS_PR_ACAD_DETAILS.GET_CUM_EARNED_CP( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) CUM_EARNED_CP
, IGS_PR_ACAD_DETAILS.GET_CUM_ATTEMPTED_CP( SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) CUM_ATTEMPTED_CP
FROM HZ_PARTIES P
, IGS_EN_STDNT_PS_ATT SPA
, IGS_PS_VER CRV
, IGS_CA_INST CI
, IGS_CA_INST_REL CIR
, IGS_CA_INST CI2
, IGS_CA_TYPE CT2
, IGS_CA_STAT CS2
WHERE P.PARTY_ID = SPA.PERSON_ID
AND SPA.COURSE_CD = CRV.COURSE_CD
AND SPA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND CI.CAL_TYPE = CIR.SUB_CAL_TYPE
AND CI.SEQUENCE_NUMBER = CIR.SUB_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE = CIR.SUP_CAL_TYPE
AND CI2.SEQUENCE_NUMBER = CIR.SUP_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE = CT2.CAL_TYPE
AND CT2.S_CAL_CAT = 'ACADEMIC'
AND CI2.CAL_STATUS = CS2.CAL_STATUS
AND CS2.S_CAL_STATUS = 'ACTIVE'
AND EXISTS ( SELECT 'X'
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_PS_UNIT_VER UV
, IGS_CA_TEACH_TO_LOAD_V TTL
, IGS_PS_PRG_UNIT_REL PUR
WHERE SUA.PERSON_ID = SPA.PERSON_ID
AND SUA.COURSE_CD = SPA.COURSE_CD
AND SUA.CAL_TYPE = TTL.TEACH_CAL_TYPE
AND SUA.CI_SEQUENCE_NUMBER = TTL.TEACH_CI_SEQUENCE_NUMBER
AND CI.CAL_TYPE = TTL.LOAD_CAL_TYPE
AND CI.SEQUENCE_NUMBER = TTL.LOAD_CI_SEQUENCE_NUMBER
AND UV.UNIT_CD = SUA.UNIT_CD
AND UV.VERSION_NUMBER = SUA.VERSION_NUMBER
AND SUA.UNIT_ATTEMPT_STATUS IN ('COMPLETED'
, 'DUPLICATE'
, 'ENROLLED'
, 'DISCONTIN')
AND (SUA.STUDENT_CAREER_TRANSCRIPT = 'Y' OR (SUA.STUDENT_CAREER_TRANSCRIPT IS NULL
AND PUR.UNIT_TYPE_ID = UV.UNIT_TYPE_ID
AND PUR.STUDENT_CAREER_LEVEL = CRV.COURSE_TYPE
AND PUR.STUDENT_CAREER_TRANSCRIPT = 'Y')))