Universe Description
This universe contains information related to student and course grades. Grades are provided for each student per course.
Universe Objects
Course Information
Course number associated with the subject for the course - usually 4 numbers and sometimes a 5th character. Source: Health Banner Table:SCBSRSECourse Number
Most recent course name for selected course. Source: Health Banner Table: SCBCRSECourse Title Current
Related course number is derived from the course number. It is the first 4 characters of the course number. Source: Health Banner Table: DerivedRelated Course Number
Main instructional subject area for this course Source: Health Banner Table: STVSUBJSubject
Date when data was last updated.Record Refresh Date
Part of Term Information
This field identifies the Part of Term Code for the Term. Source: Health Banner Table: SOBPTRM Part of Term Code
This field identifies the description of Part of Term Code for the Term. Source: Health Banner Tables: SOBPTRMPart of Term Description
Date part of term ends. Source: Health Banner Tables: SOBPTRM.Part of Term End Date
Date part of term start. Source: Health Banner Tables: SOBPTRM.Part of Term Start Date
Part of Term Weeks duration in weeks. Source: Health Banner Tables: SOBPTRM.Part of Term Weeks
Date when data was last updated.Record Refresh Date
This field identifies the term referenced in the Catalog. Source: Health Banner Table: STVTERMTerm
This field identifies the term code referenced in the Catalog, Recruiting, Admissions, Gen. Student, Registration. Source: Health Banner Table: STVTERMTerm Code
This field identifies the term end date and is fomatted DD-MON-YY. Source: Health Banner Table: STVTERMTerm End Date
This field identifies the term start date and is formatted DD-MON-YY. Source: Health Banner Table: STVTERMTerm Start Date
Program Information
The campus description associated with the campus code for the degree program. Source: Health Banner Table: STVCAMPCampus
Campus code for the degree program. Source Health Banner Table: SMRPRLECampus Code
The description associated to the college code. This is Banner's highest administrative unit. Source: Health Banner Table: STVCOLLCollege
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: STVCOLLCollege Code
The description (e.g. Bachelor of Business Administration, Master of Arts, Juris Doctor, etc.) of the associated degree code. Source: Health Banner Table: STVDEGCDegree
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: STVDEGCDegree Code
The description associated with the major code. Source: Health Banner Table: STVMAJRMajor
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: STVMAJRMajor 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: SMRPRLELevel Code
This field specifies the student level (e.g. undergraduate, graduate, professional) associated with the student level code. Source: Health Banner Table: STVLEVLLevel Course
The description (e.g. undergraduate, graduate, professional) associated with the student level code. Source: Health Banner Table: STVLEVLLevel Student
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: STVLEVLLevel Student Code
Date when data was last updated.Record Refresh Date
Student Information
This field identifies the application decision value associated with the application decision status. Source: Health Banner Table: SARAPPDAdmission Status
This field identifies the application decision value associated with the application decision status code. Source: Health Banner Table: SARAPPDAdmission Status Code
Description of Citizen Type Code Source: Health Banner Table: STVCITZCitizenship
Person Citizen Type Source: Health Banner Table: SPBPERSCitizenship Code
Students degree code (BS, BA, etc.). Source: Health Banner Table: SHRDGMRDegree Status Current
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: STVDEGCDegree Code
This field specifies the ethnic group associated with the ethnic code. Source: Health Banner Table: STVETHNEthnicity
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: SPBPERSEthnicity Code
This field maintains the sex of person. Valid values are: M - Male, F - Female, N - Unknown. Source: Health Banner Table: SPBPERSGender
Full description of Cohort Code when a student is currently expected to graduate or has graduated. Source: Health Banner Table: STVCHRTGraduation Cohort Current
Code denoting the year when a student is currently expected to graduate or has graduated. Source: Health Banner Table: SGRCHRTGraduation Cohort Code Current
Graduation Date. Graduation date of student. Source: Health Banner Table: SHRDGMRGraduation Date Current
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: DerivedIs Admitted
This field identifies the first name of the person. Source: Health Banner Table: SPRIDENName - First
This field defines the last name of the person. Source: Health Banner Table: SPRIDENName - Last
This field identifies the middle name of the person. Source: Health Banner Table: SPRIDENName - Middle
This field identifies the internal identification number of the applicant. Source: MDBanner Table: SPRIDENPDIM
Date when data was last updated.Record Refresh Date
This field defines the identification number used to access a person in Health Banner. WARNING: There are some historical situations where this may contain an SSN, though normally it is a generated ID or a USF U-Number. Source: MDBanner Table: SPRIDENSPRIDEN ID
Attribute assigned to the student, currently it is used to determine the different Curriculum Programs of SLCT and CORE. Previously it was also used to determine which year of coursework a student was taking. Source: Health Banner Table: SGRCHRTStudent Attribute Code Current
Description of Student Attribute Code assigned to the student. Currently it is used to determine the different Curriculum Programs of Select and Core. Previously it was also used to determine which year of coursework a student was taking. Source: Health Banner Table: STVATTSStudent Attribute Current
This field specifies the nation code for the issued Visa. Source: Health Banner Table: GORVISAVisa Nation Code Issue
This field specifies the nation/country associated with the nation code. Source: Health Banner Table: GORVISAVisa Nation Issue
This field specifies the visa type (e.g. student visa, resident alien, exchange scholar) associated with the visa type code. Source: Health Banner Table: STVVTYPVisa Type
This field identifies the visa type code referenced on the International Information Form (GOAINTL). Source: Health Banner Table: STVVTYPVisa Type Code
Course Grade Information
Institutional Course Credit Hours. Credit hours associated with grade of the course. Source: Health Banner Table: SHRTCKGCredit Hours
Institutional Course Credit Hours. Credit hours associated with grade of the course. Source: Health Banner Table: SHRTCKGContact Hours
Grade Code Abbreviation. Source: Health Banner Table: SHRGRDECourse Grade Abbrev Final
This field specifies the reason for grade change associated with the grade change reason code. Source: Health Banner Table: STCGCHGCourse Grade Change
Institutional Course Final Grade Code. Grade code associated with the course. Source: Health Banner Table: SHRTCKGCourse Grade Code Final
Institutional Course Sequence Number. Internal sequence number of the course associated with the grade. Source: Health Banner Table: SHRTCKGCourse 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: SHRTCKGGrade Seq No
Date when data was last updated.Record Refresh Date
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: SCRSCHDSchedule Type
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.