UAConnect: Calculating Students’ Hours

Important Notes:

  • All formulas are for the STDNT_CAR_TERM table unless otherwise indicated.
  • When querying hours by students and by careers, you will need to group by EMPLID and Academic Career, and then sum the hours. When querying hours by student, you will need to group by EMPLID and sum the hours.
  • For Sum[UNT_TAKEN_NOGPA], Sum[UNT_INPROG_NOGPA], Sum[TRF_PASSED_NOGPA]:
    • When querying hours for a term, you will need to group by EMPLID and Academic Career (depending on if you are looking for hours by students, or hours by students and by careers) and criteria the term/articulation term equal to the term that you are looking for.
      For example, if you are looking for Sum[UNT_TAKEN_NOGPA] in Spring 2006, you will need to group EMPLID and criteria term = 1063 to calculate UNT_TAKEN_NOGPA in Spring 2006.
    • When querying hours cumulatively, you will need to group by EMPLID and Academic career (depending on if you are looking for hours by students or hours by students by careers) and criteria the term/articulation term less than or equal to the term that you are using to sum the hours.
      For example, if you are looking for Sum[UNT_TAKEN_NOGPA] of a student as of Spring 2006, you will need group by EMPLID and criteria term <=1063 to calculate cumulative UNT_TAKEN_NOGPA as of Spring 2006.

Definitions and Formulas

  • Term hours attempted (Do not use for GPA calculation):
    • Definition: The hours a student attempts in a semester. These hours do not include hours withdrawn, hours dropped, hours audited, transfer hours, test credit hours or other credit hours. It does include I, F, S, R, CR.
    • Formula: [UNT_TAKEN_GPA]+[UNT_TAKEN_NOGPA]+[UNT_INPROG_GPA]+[UNT_INPROG_NOGPA]
  • Cumulative hours attempted (Do not use for GPA calculation):
    • Definition: The cumulative hours that a student attempts. These hours do not include hours withdrawn, hours dropped, hours audited, transfer hours, test credit hours or other credit hours. They do include I, F, S, R, CR.
    • Formula: [TOT_TAKEN_GPA]+Sum[UNT_TAKEN_NOGPA]+[TOT_INPROG_GPA]+Sum[UNT_INPROG_NOGPA].
  • Term hours earned:
    • Definition: The hours a student earns in a semester. These hours do not include transfer hours, test credit hours, other credit hours or hours audited.
    • Formula: [UNT_PASSD_GPA]+[UNT_PASSD_NOGPA]
  • Cumulative hours earned:
    • Definition: The cumulative hours a student earns. These include hours calculated into GPA, hours not calculated into GPA, cumulative transfer hours, cumulative test credit hours and cumulative other credit hours. Audit hours are not included in cumulative hours earned.
    • Formula: TOT_CUMULATIVE.
  • Term hours earned calculated into GPA:
    • Definition: The hours a student earns and calculates into their GPA for a semester. These hours do not include transfer hours, test credit hours, other credit hours and hours audited.
    • Formula: UNT_PASSD_GPA
  • Cumulative hours earned calculated into GPA:
    • Definition: The cumulative hours a student earns and calculates into their GPA. These hours do not include transfer hours, test credit hours, other credit hours and hours audited.
    • Formula: TOT_PASSD_GPA
  • Term hours earned not calculated into GPA:
    • Definition: The hours a student earns and is not calculated into their GPA in a semester. These hours do not include transfer hours, test credit hours or other credit hours.
    • Formula: UNT_PASSD_NOGPA
  • Cumulative hours earned not calculated into GPA:
    • Definition: The cumulative hours a student earns and is not calculated into their GPA. These hours include hours not calculated into their GPA, transfer hours, test credit hours and other credit hours. Audit hours are not included.
    • Formula: Sum[UNT_PASSD_NOGPA]+ Sum[TRF_PASSED_NOGPA] from TRNS_CRSE_TERM table where MODEL_STATUS =”P” + Sum[TRF_PASSED_NOGPA] from TRNS_TEST_TERM table where MODEL_STATUS =”P” + Sum[TRF_PASSED_NOGPA] from TRNS_OTHR_TERM table where MODEL_STATUS =”P”
  • Term transfer hours:
    • Definition: The hours a student transfers in a semester. All transfer hours are posted to the first term at the University of Arkansas after the work is completed. These hours reflect that articulation term.
    • Formula: Sum[TRF_PASSED_NOGPA] from TRNS_CRSE_TERM table where MODEL_STATUS = “P”
  • Cumulative transfer hours:
    • Definition: The cumulative hours a student transfers.
    • Formula: Sum[TRF_PASSED_NOGPA] from TRNS_CRSE_TERM table where MODEL_STATUS =”P”
  • Term test credit hours:
    • Definition: These are test credit hours of a student in a semester. Test credit is awarded for CLEP, AP, etc.
    • Formula: Sum[TRF_PASSED_NOGPA] from TRNS_TEST_TERM table where MODEL_STATUS = “P” 
  • Cumulative test credit hours:
    • Definition: These are cumulative test credit hours of a student.
    • Formula: Sum[TRF_PASSED_NOGPA] from TRNS_TEST_TERM table where MODEL_STATUS = “P”
  • Term other credit hours:
    • Definition: These are other credit hours of a student in a semester. Other credit is awarded for ROTC, Life Experience etc.
    • Formula: Sum[TRF_PASSED_NOGPA] from TRNS_OTHR_TERM table where MODEL_STATUS = “P”
  • Cumulative other credit hours:
    • Definition: These are cumulative other credit hours.
    • Formula: Sum[TRF_PASSED_NOGPA] from TRNS_OTHR_TERM table where MODEL_STATUS = “P”
  • Term audit hours:
    • Definition: The hours a student audits in a semester.
    • Formula: UNT_AUDIT
  • Cumulative audit hours:
    • Definition: The cumulative hours a student has audited.
    • Formula: TOT_AUDIT
  • Cumulative hours earned at U of A:
    • Definition: The cumulative hours that a student earns at University of Arkansas. These hours do not include transfer hours, test credit hours or other credit hours.
    • Formula: [TOT_CUMULATIVE] – Sum[TRF_PASSED_NOGPA]
  • Term GPA:
    • Definition: The GPA of a student for a semester.
    • Formula: CUR_GPA
  • Cumulative GPA:
    • Definition: The cumulative GPA of student.
    • Formula: CUM_GPA
  • Term attempted toward GPA:
    • Formula: UNT_TAKEN_GPA
  • Cumulative attempted toward GPA:
    • Formula: TOT_TAKEN_GPA

Term Statistics Page in Term History

Navigation: Home> Records and Enrollment > Student Term Information > Term History and the term information is on the Term Statistics tab.

calculate-student-hours-1

 

Updated 05/23/2018


Was this helpful?

Yes    No

IT Services