Universe Description
This universe contains information related to students and exam scores not taken as part of a course. Scores are provided for each student per exam per attempt.
Universe Objects
Graduation Cohort Information
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
This field identifies the application decision value associated with the application decision status. Source: Health Banner Table: SARAPPD This field identifies the application decision value associated with the application decision status code. Source: Health Banner Table: SARAPPD Description of Citizen Type Code Source: Health Banner Table: STVCITZ Person Citizen Type Source: Health Banner Table: SPBPERS Students degree code (BS, BA, etc.). Source: Health Banner Table: SHRDGMR Status of students degree, for example sought, awarded, etc. Source: MDBanner Table: SHRDGMR This field specifies the ethnic group associated with the ethnic code. Source: Health Banner Table: STVETHN 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 This field maintains the sex of person. Valid values are: M - Male, F - Female, N - Unknown. Source: Health Banner Table: SPBPERS Student's Global Department Name Source: MDM_CURR Graduation Date. Graduation date of student. Source: Health Banner Table: SHRDGMR 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 Program description which further describes the latest program code which represents a specific university program associated with the max effective term. Source: Health Banner Table: SMRPRLE A latest student program code which represents a specific university program associated with the max effective term. Source: Health Banner Table: SGBSTDN This field identifies the first name of the person. Source: Health Banner Table: SPRIDEN This field defines the last name of the person. Source: Health Banner Table: SPRIDEN Combination of the Name Last, Name First of the person. Source: Health Banner Table: Derived This field identifies the middle name of the person. Source: Health Banner Table: SPRIDEN Combined field of Name Last, Name First - U-Number Source: Health Banner Table: Derived This field maintains the prefix (Mr, Mrs, etc) used before the person's name. Source: Health Banner Table: SPBPERS This field maintains the suffix (Jr, Sr, etc) used after the person's name. Source: Health Banner Table: SPBPERS This field specifies the residency status associated with the residency code. Source: Health Banner Table: STVRESD 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: SPRIDEN 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: SGRCHRT 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: STVATTS Code for student's current status; AS = Active, IG = Inactive-Graduated, IS = Inactive, UNKN = Unknown Description of student's current status: Active, Inactive, Inactive-Graduated, Unknown This field identifies the residency classification of the applicant. Source: Health Banner Table: SARADAP U-number for the student to uniquely identify them from other students. Source: Health Banner Table: SPRIDEN Date when data was last updated.Student Information
Admission Status
Admission Status Code
Citizenship
Citizenship Code
Degree Status Current
Degree Status Code Current
Ethnicity
Ethnicity Code
Gender
Global Department Name
Graduation Date Current
Is Admitted
Latest Program
Latest Program Code
Name - First
Name - Last
Name - Last, First
Name - Middle
Name - Unique
Name Prefix
Name Suffix
Resident
SPRIDEN ID
Student Attribute Code Current
Student Attribute Current
Student Status Code
Student Status Description
Resident Code
UNumber
Record Refresh Date
The campus description associated with the campus code for the degree program. Source: Health Banner Table: STVCAMP Campus code for the degree program. Source Health Banner Table: SMRPRLE The description associated to the college code. This is Banner's highest administrative unit. Source: Health Banner Table: STVCOLL 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 The description (e.g. Bachelor of Business Administration, Master of Arts, Juris Doctor, etc.) of the associated degree code. Source: Health Banner Table: STVDEGC 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 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 This field specifies the student level (e.g. undergraduate, graduate, professional) associated with the student level code. Source: Health Banner Table: STVLEVL The description (e.g. undergraduate, graduate, professional) associated with the student level code. Source: Health Banner Table: STVLEVL 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 The description associated with the major code. Source: Health Banner Table: STVMAJR 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 Program description which further describes program code. Source: Health Banner Table: SMRPRLE A program code which will represent a specific university program. Source: Health Banner Table: SMRPRLEProgram Information
Campus
Campus Code
College
College Code
Degree
Degree Code
Level Code
Level Course
Level Student
Level Student Code
Major
Major Code
Program
Program Code
The full description of the effective term of matriculation - the term the student began classes in their current program. Source: Health Banner Table: SGBSTDN Code of the effective term of matriculation - the term the student began classes in their current program. The first 4 digits are the year the term began. Source: Health Banner Table: SGBSTDN This field identifies the term end date and is fomatted DD-MON-YY. Source: Health Banner Table: STVTERM This field identifies the term start date and is formatted DD-MON-YY. Source: Health Banner Table: STVTERMMatriculation Term
Matriculation Term
Matriculation Term Code Current
Matriculation Term End Date
Matriculation Term Start Date
There can be multiple records for a given test type code in the dimension table (due to different test max/min/pass values or effective dates). Current Indicator represents the current/active record, out of those multiple records for a given test type. Source: Derived or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE The first day of the year used for Testing Purposes Source: Derived or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE The last day of the year used for Testing Purposes Source: Derived or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE Highest score possible on a specific test Source: Health Banner or WH_USR Table: STVTESC or TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE Lowest score possible on a given test Source: Health Banner or WH_USR Table: STVTESC or TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE Test Score/Value for a specific test. Source: Defaulted to 0 or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE The full exam name given Source: Health Banner Table: STVTESC Abbreviated Exam Names for given exam Source: Health Banner Table: STVTESCTest Type
Current Indicator
Effective From Date
Effective To Date
Test Maximum Value
Test Minimum Value
Test Pass Value
Test Type
Test Type Code
The age at which the student was when the Exam was taken. Source: Derived from date of birth in Health Banner and test date. If an individual student takes the same test multiple times, each attempt gets an attempt number. The first attempt chronologically by test date is 1, subsequent attempts would be 2, 3, 4, etc. Source: Health Banner, Examsoft (Derived), NBME Downloads (Derived) The result given for a specific Exam (P, F, etc...) Source: Health Banner, Examsoft (Derived) Table: SORTEST, File loads This field identifies the score obtained in the exam. If the score is not provided, it is defaulted to zero. Source: Health Banner, Examsoft (derived, sum of all correct answers), and NBME downloads. This field identifies the score percentage obtained in the exam. Source: Health Banner, Examsoft (derived, Test Score as a percentage of all answers), NBME Downloads This field identifies the source of the test data. ‘EXMS’ for data from Examsoft. ‘NBME’ for data from NBME Downloads provided by the MCOM Exam Administrators.Test Information
Age at Time of Test
Test Attempt
Test Result
Test Score
Test Score Percentage
Test Source
This field identifies if the data load has been successful. This field identifies when the data did not run properly and displays a warning message. Date when data was last updated. Data Load Details
Data Load Success
Data Message
Record Refresh Date
Disclaimer
This universe only displays values as they were in USF Health Banner at the last refresh date. Those values are subject to change over time. Unauthorized use of this universe 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.