Report Description
The Health Banner Data Quality Report displays data fields that are improperly coded, missing, incorrect or would produce errors in SUDS. This dashboard is retrieving Academic Program’s data from Health Banner and OASIS monthly so they can incrementally review, verify, and correct more regularly.
Admission Status
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
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
Applicant Year
The 4-digit year for the beginning of the application period.
Source: Health Banner Table: SARAPPD
Visualizations
Total by Admission Status
A bar graph showing the count of students with a given Admission Status for all filters selected. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations
Applicants with SGASTDN Record by Admission Status
A Clustered column chart that displays the Total of applicants with a Student Record in SGASTDN in their respective Admission status code. The user can hover over the graph to view more information and can also interact with the other visualizations in the report by clicking the bars.
Total Applicants with SGASTDN
Card that displays the Total Applicants with a Record is SGASTDN.
Total Applicants
Card visualization that displays the Total of Applicants from any Admission Status.
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
Last Institution
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
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
Applicant Year
The 4-digit year for the beginning of the application period.
Source: Health Banner Table: SARAPPD
Visualizations
Multiple Institution Last Attended
A clustered column graph displaying the total count of applicants with multiple institution last attended . Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
Attendance Dates Past August of the Matriculation Year
A clustered column graph displaying the total count of applicants with attendance dates past August of the matriculation year . Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
Invalid FICE codes for last institution attended
A clustered column graph displaying the total count of applicants with Invalid FICE codes for last institution attended . 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.
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
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
Multiple Institution Last Attended
This field identifies if the applicant has multiple institution last attended.
Past August Attendance
This field identifies if the applicant's first attendance is past August.
Source: Health Banner Table: SARAPPD
Invalid FICE code for last Institution Attended
This field identifies if the applicant has an Invalid FICE code for last Institution Attended.
Source: Health Banner Table: SARAPPD
Last Inst Code
This field identifies if the applicant has a code for last Institution Attended.
Source: Health Banner Table: SORDEGR
Last Inst Description
This field displays the applicant description for last Institution Attended.
Source: Health Banner Table: STVSBGI
Degree Attended to Date
Used to determine the date attended of the most recent school. Since some applicants attend multiple schools at the same time previous school information is also sorted by Date Attended To.
Source: Health Banner Table: SORDEGR
Primary Indicator
Used to determine when an applicant has selected more than one institution as a the Primary institution.
Source: Health Banner Table: SORDEGR
Invalid Last Inst
This field displays the description for an Invalid Institution Attended.
Source: Health Banner Table: STVSBGI
Invalid Last FICE
This field displays the invalid FICE for the last Institution Attended.
Source: Health Banner Table: SORDEGR
Highest Degrees
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
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
Applicant Year
The 4-digit year for the beginning of the application period.
Source: Health Banner Table: SARAPPD
Visualizations
Applicants with No Degree in Health Banner
A clustered column graph displaying the total count of applicants with no degree in Health Banner . Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
Applicants with Multiple Institutions Issuing Highest Degree
A clustered column graph displaying the total count of applicants with multiple institution issuing Highest Degree. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
Applicants with Invalid FICE Code for Institution Granting Highest Degree
A clustered column graph displaying the total count of applicants with invalid FICE code for institution granting highest degree. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
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.
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
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
No Degree
This field identifies if the applicant doesn't have a degree in Health Banner.
Source: Health Banner Table: SORDEGR
Multiple Degree
This field identifies the applicants with multiple institutions issuing highest degree.
Source: Health Banner Table: SORDEGR
Invalid FICE Code for Institution Granting Highest Degree
This field identifies if the applicant has an Invalid FICE code for institution granting highest degree.
Source: Health Banner Table: SORDEGR
Degree Not Mapped for SUDS
This field identifies if the applicant has a degree not mapped for SUDS.
Source: Health Banner Table: SORDEGR
Inst Code
This field identifies if the applicant has a code for the Institution Attended.
Source: Health Banner Table: SORDEGR
Inst Description
This field displays the applicant description for the Institution Attended.
Source: Health Banner Table: STVSBGI
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, OASIS, or determined by last year's SUDS logic 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.