Universe Description
This universe contains information related to student and course grades.
Universe Objects
Course Information
Course Number
Course number associated with the subject for the course - usually 4 numbers and sometimes a 5th character.
Source: Health Banner Table:SCBSRSE
Course Title Current
Most recent course name for selected course.
Source: Health Banner Table: SCBCRSE
Related Course Number
Related course number is derived from the course number. It is the first 4 characters of the course number.
Source: Health Banner Table: Derived
Subject
Main instructional subject area for this course
Source: Health Banner Table: STVSUBJ
Record Refresh Date
Date when data was last updated.
Part of Term Information
Part of Term Code
This field identifies the Part of Term Code for the Term.
Source: Health Banner Table: SOBPTRM
Part of Term Description
This field identifies the description of Part of Term Code for the Term.
Source: Health Banner Tables: SOBPTRM
Part of Term End Date
Date part of term ends.
Source: Health Banner Tables: SOBPTRM.
Part of Term Start Date
Date part of term start.
Source: Health Banner Tables: SOBPTRM.
Part of Term Weeks
Part of Term Weeks duration in weeks.
Source: Health Banner Tables: SOBPTRM.
Record Refresh Date
Date when data was last updated.
Term
This field identifies the term referenced in the Catalog.
Source: Health Banner Table: STVTERM
Term Code
This field identifies the term code referenced in the Catalog, Recruiting, Admissions, Gen. Student, Registration.
Source: Health Banner Table: STVTERM
Term End Date
This field identifies the term end date and is fomatted DD-MON-YY.
Source: Health Banner Table: STVTERM
Term Start Date
This field identifies the term start date and is formatted DD-MON-YY.
Source: Health Banner Table: STVTERM
Program Information
Campus
The campus description associated with the campus code for the degree program.
Source: Health Banner Table: STVCAMP
Campus Code
Campus code for the degree program.
Source Health Banner Table: SMRPRLE
College
The description associated to the college code. This is Banner's highest administrative unit.
Source: Health Banner Table: STVCOLL
College Code
The code for the college or school offering the degree program. Referenced in the Catalog, Class Schedule, Recruiting, Admissions, General Student, Registration, Academic History and Degree Audit Modules.
Source: Health Banner Table: STVCOLL
Degree
The description (e.g. Bachelor of Business Administration, Master of Arts, Juris Doctor, etc.) of the associated degree code.
Source: Health Banner Table: STVDEGC
Degree Code
The degree code of the degree the student is pursuing or has obtained at USF Health. Referenced in the Recruiting, Admissions, Gen. Student, Registration, Academic History and Degree Audit Modules.
Source: Health Banner Table: STVDEGC
Major
The description associated with the major code.
Source: Health Banner Table: STVMAJR
Major Code
Identifies the major code of the student. Referenced in the Catalog, Class Schedule, Recruiting, Admissions, General Student, Registration, and Academic History Modules.
Source: Health Banner Table: STVMAJR
Level Code
Identifies the level code of the degree program. Referenced in the Catalog, Recruiting, Admissions, General Student, Registration, and Academic History Modules.
Source: Health Banner Table: SMRPRLE
Level Course
This field specifies the student level (e.g. undergraduate, graduate, professional) associated with the student level code.
Source: Health Banner Table: STVLEVL
Level Student
The description (e.g. undergraduate, graduate, professional) associated with the student level code.
Source: Health Banner Table: STVLEVL
Level Student Code
Identifies the student level code of the degree program. Referenced in the Catalog, Recruiting, Admissions, General Student, Registration, and Academic History Modules.
Source: Health Banner Table: STVLEVL
Record Refresh Date
Date when data was last updated.
Student Information
Admission Status
This field identifies the application decision value associated with the application decision status.
Source: Health Banner Table: SARAPPD
Admission Status Code
This field identifies the application decision value associated with the application decision status code.
Source: Health Banner Table: SARAPPD
Citizenship
Description of Citizen Type Code
Source: Health Banner Table: STVCITZ
Citizenship Code
Person Citizen Type
Source: Health Banner Table: SPBPERS
Degree Status Current
Students degree code (BS, BA, etc.).
Source: Health Banner Table: SHRDGMR
Degree Code
The degree code of the degree the student is pursuing or has obtained at USF Health. Referenced in the Recruiting, Admissions, Gen. Student, Registration, Academic History and Degree Audit Modules.
Source: Health Banner Table: STVDEGC
Ethnicity
This field specifies the ethnic group associated with the ethnic code.
Source: Health Banner Table: STVETHN
Ethnicity Code
This field identifies the ethnic code defined by the U.S. government. The valid values are 1 - Not Hispanic or Latino, 2 - Hispanic or Latino, or empty.
Source: Health Banner Table: SPBPERS
Gender
This field maintains the sex of person. Valid values are: M - Male, F - Female, N - Unknown.
Source: Health Banner Table: SPBPERS
Graduation Cohort Current
Full description of Cohort Code when a student is currently expected to graduate or has graduated.
Source: Health Banner Table: STVCHRT
Graduation Cohort Code Current
Code denoting the year when a student is currently expected to graduate or has graduated.
Source: Health Banner Table: SGRCHRT
Graduation Date Current
Graduation Date. Graduation date of student.
Source: Health Banner Table: SHRDGMR
Is Admitted
If Admission Status Code is 'AD', 'A', 'AS', or 'AW' then it will display 'Y' otherwise it will be 'N'. This field is known to have significant issues for some cohorts/matriculation terms.
Source: Health Banner Table: Derived
Name - First
This field identifies the first name of the person.
Source: Health Banner Table: SPRIDEN
Name - Last
This field defines the last name of the person.
Source: Health Banner Table: SPRIDEN
Name - Middle
This field identifies the middle name of the person.
Source: Health Banner Table: SPRIDEN
Course Grade Information
Credit Hours
Institutional Course Credit Hours. Credit hours associated with grade of the course.
Source: Health Banner Table: SHRTCKG
Contact Hours
Institutional Course Credit Hours. Credit hours associated with grade of the course.
Source: Health Banner Table: SHRTCKG
Course Grade Abbrev Final
Grade Code Abbreviation.
Source: Health Banner Table: SHRGRDE
Course Grade Change
This field specifies the reason for grade change associated with the grade change reason code.
Source: Health Banner Table: STCGCHG
Course Grade Code Final
Institutional Course Final Grade Code. Grade code associated with the course.
Source: Health Banner Table: SHRTCKG
Course Seq No
Institutional Course Sequence Number. Internal sequence number of the course associated with the grade.
Source: Health Banner Table: SHRTCKG
Grade Seq No
Institutional Course Grade Sequence Number. Sequence number of the grade for the course with highest sequence number being most recent grade.
Source: Health Banner Table: SHRTCKG
Record Refresh Date
Date when data was last updated.
Schedule Type
This field defines the schedule type codes which can be authorized for a course. Each course must be authorized to be offered for at least one schedule type. An unlimited number of schedule types can be authorized for a course.
Source: Health Banner Table: SCRSCHD
Data Refreshed On
Data in this report is not live, but refreshed once daily. The date on the bottom right of the report displays the last day the data was refreshed from USF Health Banner.
Disclaimer
This report only displays values as the are currently in USF Health Banner. Those values are subject to change over time. Unauthorized use of this report is prohibited. If you log on to this computer system, you acknowledge your awareness of and concurrence with the University of South Florida policies. The University will prosecute violators to the full extent of the law.