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_STU_ACAD_V

Source

View Text - Preformatted


SELECT spa.person_id person_id, p.party_number person_number, spa.course_cd course_cd, crv.course_type course_type, ci2.cal_type acad_cal_type, ci2.sequence_number acad_sequence_number, ci2.alternate_code acad_alternate_code, ci2.description acad_description, ci.cal_type load_cal_type, ci.sequence_number load_sequence_number, ci.alternate_code load_alternate_code, ci.description load_description, ci.start_dt load_start_dt, ci.end_dt load_end_dt, st.stat_type stat_type, st.description stat_type_desc, igs_pr_acad_details.get_load_gpa(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) term_gpa, igs_pr_acad_details.get_load_gpa_cp(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) term_gpa_cp, igs_pr_acad_details.get_load_gpa_qp(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) term_gpa_qp, igs_pr_acad_details.get_load_earned_cp(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) term_earned_cp, igs_pr_acad_details.get_load_attempted_cp(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) term_attempted_cp, igs_pr_acad_details.get_cum_gpa(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) cum_gpa, igs_pr_acad_details.get_cum_gpa_cp(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) cum_gpa_cp, igs_pr_acad_details.get_cum_gpa_qp(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) cum_gpa_qp, igs_pr_acad_details.get_cum_earned_cp(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) cum_earned_cp, igs_pr_acad_details.get_cum_attempted_cp(spa.person_id,spa.course_cd,ci.cal_type,ci.sequence_number,st.stat_type) cum_attempted_cp, igs_pr_get_class_std.get_class_standing(spa.person_id,spa.course_cd,'N',NULL,NULL,NULL) class_standing, igs_pr_get_class_std.get_class_standing(spa.person_id,spa.course_cd,'Y',NULL,NULL,NULL) predictive_class_standing, igs_en_prc_load.enrp_get_prg_att_type(spa.person_id,spa.course_cd,ci2.cal_type,ci2.sequence_number) attendance_type, igs_pr_gen_006.get_antcp_compl_dt(spa.person_id, spa.course_cd) enrl_antcp_compl_dt 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, igs_pr_stat_type st, igs_ca_type ct, igs_ca_stat cs 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 ci.cal_type = ct.cal_type AND ct.s_cal_cat = 'LOAD' AND ci.cal_status = cs.cal_status AND cs.s_cal_status = 'ACTIVE' AND EXISTS ( SELECT 'X' FROM igs_en_su_attempt sua, igs_ca_teach_to_load_v ttl 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 sua.unit_attempt_status IN ('COMPLETED','DUPLICATE','ENROLLED','DISCONTIN') ) AND st.closed_ind = 'N' AND (EXISTS (select 'X' from igs_pr_org_stat os where st.stat_type = os.stat_type and crv.responsible_org_unit_cd = os.org_unit_cd) OR EXISTS (select 'X' from igs_pr_inst_stat ins where st.stat_type = ins.stat_type ) )

View Text - HTML Formatted

SELECT SPA.PERSON_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, SPA.COURSE_CD COURSE_CD
, CRV.COURSE_TYPE COURSE_TYPE
, CI2.CAL_TYPE ACAD_CAL_TYPE
, CI2.SEQUENCE_NUMBER ACAD_SEQUENCE_NUMBER
, CI2.ALTERNATE_CODE ACAD_ALTERNATE_CODE
, CI2.DESCRIPTION ACAD_DESCRIPTION
, CI.CAL_TYPE LOAD_CAL_TYPE
, CI.SEQUENCE_NUMBER LOAD_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE LOAD_ALTERNATE_CODE
, CI.DESCRIPTION LOAD_DESCRIPTION
, CI.START_DT LOAD_START_DT
, CI.END_DT LOAD_END_DT
, ST.STAT_TYPE STAT_TYPE
, ST.DESCRIPTION STAT_TYPE_DESC
, IGS_PR_ACAD_DETAILS.GET_LOAD_GPA(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) TERM_GPA
, IGS_PR_ACAD_DETAILS.GET_LOAD_GPA_CP(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) TERM_GPA_CP
, IGS_PR_ACAD_DETAILS.GET_LOAD_GPA_QP(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) TERM_GPA_QP
, IGS_PR_ACAD_DETAILS.GET_LOAD_EARNED_CP(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) TERM_EARNED_CP
, IGS_PR_ACAD_DETAILS.GET_LOAD_ATTEMPTED_CP(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) TERM_ATTEMPTED_CP
, IGS_PR_ACAD_DETAILS.GET_CUM_GPA(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) CUM_GPA
, IGS_PR_ACAD_DETAILS.GET_CUM_GPA_CP(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) CUM_GPA_CP
, IGS_PR_ACAD_DETAILS.GET_CUM_GPA_QP(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) CUM_GPA_QP
, IGS_PR_ACAD_DETAILS.GET_CUM_EARNED_CP(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) CUM_EARNED_CP
, IGS_PR_ACAD_DETAILS.GET_CUM_ATTEMPTED_CP(SPA.PERSON_ID
, SPA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, ST.STAT_TYPE) CUM_ATTEMPTED_CP
, IGS_PR_GET_CLASS_STD.GET_CLASS_STANDING(SPA.PERSON_ID
, SPA.COURSE_CD
, 'N'
, NULL
, NULL
, NULL) CLASS_STANDING
, IGS_PR_GET_CLASS_STD.GET_CLASS_STANDING(SPA.PERSON_ID
, SPA.COURSE_CD
, 'Y'
, NULL
, NULL
, NULL) PREDICTIVE_CLASS_STANDING
, IGS_EN_PRC_LOAD.ENRP_GET_PRG_ATT_TYPE(SPA.PERSON_ID
, SPA.COURSE_CD
, CI2.CAL_TYPE
, CI2.SEQUENCE_NUMBER) ATTENDANCE_TYPE
, IGS_PR_GEN_006.GET_ANTCP_COMPL_DT(SPA.PERSON_ID
, SPA.COURSE_CD) ENRL_ANTCP_COMPL_DT
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
, IGS_PR_STAT_TYPE ST
, IGS_CA_TYPE CT
, IGS_CA_STAT CS
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 CI.CAL_TYPE = CT.CAL_TYPE
AND CT.S_CAL_CAT = 'LOAD'
AND CI.CAL_STATUS = CS.CAL_STATUS
AND CS.S_CAL_STATUS = 'ACTIVE'
AND EXISTS ( SELECT 'X'
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_CA_TEACH_TO_LOAD_V TTL
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 SUA.UNIT_ATTEMPT_STATUS IN ('COMPLETED'
, 'DUPLICATE'
, 'ENROLLED'
, 'DISCONTIN') )
AND ST.CLOSED_IND = 'N'
AND (EXISTS (SELECT 'X'
FROM IGS_PR_ORG_STAT OS
WHERE ST.STAT_TYPE = OS.STAT_TYPE
AND CRV.RESPONSIBLE_ORG_UNIT_CD = OS.ORG_UNIT_CD) OR EXISTS (SELECT 'X'
FROM IGS_PR_INST_STAT INS
WHERE ST.STAT_TYPE = INS.STAT_TYPE ) )