Report Description
The HBDQ-Student Data Quality report (short for Health Banner Data Quality) displays data fields that are improperly coded, missing, incorrect or different between Banner and OASIS. This dashboard is retrieving Academic Program’s data from Health Banner and OASIS monthly so they can incrementally review, verify, and correct more regularly.
Student Address
Filters
Program Code
A program code which represents a specific university program: MD for MD Program, PA for Physician Assistant Program, PH for PharmD Program, and PT for DPT Program.
Source: Health Banner Table: SMRPRLE
Data Quality Month
Month in which the data errors were identified. All details available for the error are from the source when it was run that month.
Source: Health Banner Table: SARAPPD
Matriculation Term Code
Matriculation Term Code is a six digit code: the four digit year of matriculation, followed by the two digit month/term of matriculation, i.e. 201807
Visualizations
Health Banner Incomplete Address
Visualization to display the count of the flag for "N" if all items of the Banner address have not been completed. Incomplete address is if at least one out of four address elements is missing (street line 1, city, state or zip).
OASIS Incomplete Address
Visualization to display the count of the flag for "N" if all items of the OASIS address have not been completed. Incomplete address is if at least one out of four address elements is missing (street line 1, city, state or zip).
Address Inconsistent
Visualization displays the count of students for the flag with "N" selected if the Banner and OASIS addresses do not match for a specific student.
* Address match - only if all four address elements match (street line 1 & 2, city, state and zip)
Differences in address standards like NE vs North East, Street vs St, Drive vs Dr etc. will produce mismatch.
Details
SPRIDEN ID
This field defines the number used to access a person's record in Health Banner. This will usually include a U-Number for admitted students.
Source: Health Banner Table: SPRIDEN
APPLICANT ID
This field identifies the unique applicant number of the admissions record. Generally this is the unique identifier from the CAS system where the student completed the application.
Source: Health Banner Table: GORADID
Last Name
This field defines the last name of the person.
Source: Health Banner Table: SPRIDEN
First Name
This field defines the first name of the person.
Source: Health Banner Table: SPRIDEN
Initial
This field identifies the initial of the middle name of person.
Source: Health Banner Table: SPRIDEN
Admission Status
This field identifies the student's admission status associated to the most recent application for this application year.
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
Data Quality Month
Month in which the data errors were identified. All details available for the error are from the source when it was run that month.
Source: Health Banner Table: SARAPPD
Applicants with Degree Not Mapped for SUDS
A clustered column graph displaying the total count of applicants with degree not mapped for SUDS. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
Total Applicants with Multiple Primary Institutions
Card visualization that displays the Total of Applicants with multiple primary institutions.
Data Refreshed On
Data in this report is not live. Health Banner and OASIS data is refreshed once a month. The date on the bottom right of the report displays the most recent day the data was pulled from the source.
Disclaimer
This report displays student information as in USF Health Banner and OASIS on the refresh date. 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.