Educational Data Warehouse Course Exam Scores Universe
Universe Description
This universe contains information related to students and scores for exams offered within a course. Scores are provided for each student per course.
Universe Objects
Course Information
Course Global Department Name
Global Department Name associated with the Course Banner department name.
Source: Health Banner Table: SCBCRSE
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
Subject Code
Subject code for selected course - usually 3 characters.
Source: Health Banner Table: SCBCRSE
Subject - Course Number
Subject code and Course number for selected course.
Source: Derived
Record Refresh Date
Date when data was last updated.
Course Test Scores
Exam Name
This field identifies the name used to describe the test or assessment.
Source: Examsoft and NBME Downloads
Test Date
This field identifies the date the test was taken.
Source: Health Banner, Examsoft, and NBME Downloads
Test Score
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.
Test Score Percentage
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
Test Sequence
This field identifies the order the test was administered within course or it's type.
- 1-4: Course Exams, source of Examsoft
- 20-23: Anatomy Practical Exams, source of Examsoft
- 30 and 31: EBCR Exams, source of Examsoft
- 75: Remediation Exams that may cover more than 1 original exam topic, source of Examsoft
- 99: Course Comprehensive Exams, currently administered as NBME Flexible Blueprint
Source: Examsoft exam to course mapping (provided by MCOM Exam Administrator) or NBME (hard coded)
Test Sequence Type
This field identifies the type of the test as listed below.
- 1-4: Course Exams, source of Examsoft
- 20-23: Anatomy Practical Exams, source of Examsoft
- 30 and 31: EBCR Exams, source of Examsoft
- 75: Remediation Exams that may cover more than 1 original exam topic, source of Examsoft
- 99: Course Comprehensive Exams, currently administered as NBME Flexible Blueprint
Source: Derived in the Universe
Test Source
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.
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
Matriculation Term
Matriculation Term
The full description of the effective term of matriculation - the term the student began classes in their current program.
Source: Health Banner Table: SGBSTDN
Matriculation Term Code Current
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
Matriculation Term End Date
This field identifies the term end date and is fomatted DD-MON-YY.
Source: Health Banner Table: STVTERM
Matriculation Term Start Date
This field identifies the term start date and is formatted DD-MON-YY.
Source: Health Banner Table: STVTERM
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 Status Code Current
Status of students degree, for example sought, awarded, etc.
Source: MDBanner Table: SHRDGMR
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
Global Department Name
Student's Global Department Name
Source: MDM_CURR
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
Latest Program
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
Latest Program Code
A latest student program code which represents a specific university program associated with the max effective term.
Source: Health Banner Table: SGBSTDN
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 - Last, First
Combination of the Name Last, Name First of the person.
Source: Health Banner Table: Derived
Name - Middle
This field identifies the middle name of the person.
Source: Health Banner Table: SPRIDEN
Name - Unique
Combined field of Name Last, Name First - U-Number
Source: Health Banner Table: Derived
Name Prefix
This field maintains the prefix (Mr, Mrs, etc) used before the person's name.
Source: Health Banner Table: SPBPERS
Name Suffix
This field maintains the suffix (Jr, Sr, etc) used after the person's name.
Source: Health Banner Table: SPBPERS
Resident
This field specifies the residency status associated with the residency code.
Source: Health Banner Table: STVRESD
SPRIDEN ID
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
Student Attribute Code Current
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
Student Attribute 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: STVATTS
Student Status Code
Code for student's current status; AS = Active, IG = Inactive-Graduated, IS = Inactive, UNKN = Unknown
Student Status Description
Description of student's current status: Active, Inactive, Inactive-Graduated, Unknown
Resident Code
This field identifies the residency classification of the applicant.
Source: Health Banner Table: SARADAP
UNumber
U-number for the student to uniquely identify them from other students.
Source: Health Banner Table: SPRIDEN
Record Refresh Date
Date when data was last updated.
Term Details
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 Start Date
This field identifies the term start date and is formatted DD-MON-YY.
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
Test time has multiple pieces of information about the test date including: Based on a calendar year (beginning in January) Based on Fiscal Year (beginning in July)Test Time
Used to show the exact count of students Source: Derived Table: Count of Unique U-NumbersMeasures
Unique Student Count
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. Data from NBME Downloads or Examsoft are updated each Saturday. Values in the systems 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.