Beginning the fall of 2009, URR will be reporting term GPA’s only for those students that have at least one course with a GPA grade (A, B, C, D, F, etc.) for the term in question and will be reporting cumulative GPA’s only for those students that have at least one course with a GPA grade at IU. For those students that do not have at least one course with a GPA grade, the GPA in URR files will be a blank and will be reported in a category of “<2.0 or No GPA”. There are instances where a student’s status changes from enrolled to another status where grades are not applied. An example of this is when a student changes from enrolled status to waitlist status for the term. There are instances where a student could be classified as dropped but still have courses with GPA grades. Typically these grades are F’s. In this situation we will report a term GPA of 0. Below is the logic that will be instituted starting with the fall of 2009.
Term GPA
Term GPA’s will be reported for the following groups of students
- Enrolled
- Dropped, but with at least one course with a GPA Grade (A, B, C, D, F)
- Deceased, but with at least one course with a GPA grade
Cumulative GPA
The cumulative GPA will be reported for students that have at least one class with a GPA grade. Because of the way that Peoplesoft calculates the cumulative GPA the correct cumulative GPA will be on the alphabetically last campus for that term when there are multiple enrollments for a term. The following logic will be used:
- Select students that have at least one course with a GPA grade
- Select the max term that is <= to the term in question
- If there are multiple enrollments across campuses for the same term select the CUM GPA from the alphabetically last campus.
SQL
Sample SQL for selecting term GPA
select a.prsn_univ_id,a.inst_cd,a.ACAD_CAREER_CD,b.STU_IUGPA_CUR_GPA_NBR,b.stu_drv_enrl_stat_ind
from dss_rds.IR_CEN_TRM_SNPSHT_GT a,
dss_rds.sr_stu_term_st b
where a.prsn_univ_id = b.prsn_Univ_id
and a.inst_cd = b.inst_cd
and a.ACAD_TERM_CD = b.acad_term_cd
and a.ACAD_CAREER_CD = b.ACAD_CAREER_CD
and a.acad_term_cd = '4098'
and a.acad_term_prd_desc like 'Off%'
and a.inst_cd = 'IUBLA'
and b.stu_drv_enrl_stat_ind in ('E','D','X')
and b.STU_IUGPA_UNT_TKN_GPA_NBR > 0 // at least one course has a GPA grade assigned to it
Sample SQL for selecting the cumulative GPA
select a.PRSN_UNIV_ID, a.inst_cd,b.STU_IUGPA_CUM_GPA_NBR
from dss_rds.ir_cen_trm_snpsht_gt a,
dss_rds.sr_stu_Term_st b
where a.PRSN_UNIV_ID = b.PRSN_UNIV_ID
and a.ACAD_CAREER_CD = b.ACAD_CAREER_CD
and a.acad_term_cd = '4098'
and a.acad_term_prd_desc like 'Off%'
and a.inst_cd in ('IUBLA')
and b.acad_term_cd = (select max(acad_term_cd)
from dss_rds.sr_stu_Term_st c
where a.PRSN_UNIV_ID = c.PRSN_UNIV_ID
and a.ACAD_CAREER_CD = c.ACAD_CAREER_CD
and c.acad_term_cd <= a.acad_term_cd
and stu_drv_enrl_stat_ind in ('E','D','X'))
and b.inst_cd = (select max(inst_cd)
from dss_rds.sr_stu_Term_st c
where a.PRSN_UNIV_ID = c.PRSN_UNIV_ID
and a.ACAD_CAREER_CD = c.ACAD_CAREER_CD
and b.acad_Term_cd = c.acad_term_cd)
and STU_IUGPA_TOT_UNT_TKN_GPA_NBR > 0 // at least one course has a GPA grade assigned to it
order by a.PRSN_UNIV_ID, a.inst_cd
