HBDQ Applicant Data Quality
- Miguel Gonzalez
- Nolan Rodriguez
- aross5
Report Description
The Health Banner Applicant Data Quality Report displays data fields that are improperly coded, missing, incorrect or would produce errors in SUDS.
Note
This dashboard is retrieving Academic Program’s data from Health Banner and OASIS for the current month.
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
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
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
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
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
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
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
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 FICE
This field displays the numeric code for an Invalid FICE.
Source: Health Banner Table: SORDEGR
Invalid Highest Inst
This field displays the description for the Highest Invalid Institution Attended.
Source: Health Banner Table: STVSBGI
Unmapped Degree Code
This field displays the Banner data field that does not have an existing mapping to the SUDS degree.
Source: Health Banner Table: SORDEGR
Unmapped Degree Description
This field displays the degree description information for the corresponding Unmapped Degree Code.
Source: Health Banner Table: STVDEGC
Race/Ethnicity Distribution
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
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
Visualizations
Applicants' Race in Banner
A bar graph showing the total count of race(s) selected by applicants as listed in Banner. One or more race may have been selected by an applicant. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations. See Records is available on this visualization.
Applicants' Ethnicity in Banner
A pie chart showing the total count of an ethnicity for applicants listed in Banner; an applicant will have only one ethnicity selected. Selecting part of the pie chart in this visualization will filter the relevant items in the details or highlight items in other visualizations. See Records is available on this visualization.
SUDS Race/Ethnicity Data
Waffle charts showing the percentage of the applicants for a particular SUDS race/ethnicity flag divided by the total number of applicants. The data in the waffle charts will change based on the filter selections or the selection of the Banner race/ethnicity visualizations.
Race/Ethnicity
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
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
Visualizations
Race Ethnicity Issue
A clustered column graph displaying the applicants with issues no race and no ethnicity listed in Banner, which will result in a SUDS No Race Reported flag for the SUDS submission. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
Total Applicants
Card visualization that displays the Total of Applicants from any Admission Status.
SUDS Unmapped Ethnicity
A clustered column graph displaying the applicants with no ethnicity mapped in SUDS. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
SUDS Unmapped Race
A clustered column graph displaying the applicants with no race mapped in SUDS. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
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
Missing Banner Ethnicity
This field identifies a flag for applicants with missing ethnicity data in Banner.
Source: Health Banner Table: SORDEGR
Missing Banner Race
This field identifies a flag for applicants with missing race data in Banner.
Source: Health Banner Table: SORDEGR
Unmapped SUDS Ethnicity
This field identifies a flag for applicants with unmapped ethnicity data in SUDS.
Source: Health Banner Table: SORDEGR
Unmapped SUDS Race
This field identifies a flag for applicants with unmapped race data in SUDS.
Source: Health Banner Table: SORDEGR
Names Special Characters
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
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
Visualizations
Last Name Errors
A clustered column graph displaying the total count of applicants with errors in the Last Name. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
First Name Errors
A clustered column graph displaying the total count of applicants with errors in the First Name. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
Applicants with Name Errors
A card visual displaying the total count of applicants with Name errors.
Last Name Errors Pie Chart
A pie chart visualization displaying the total count of applicants with errors in the Last Name. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
First Name Errors Pie Chart
A pie chart visualization displaying the total count of applicants with errors in the First Name. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
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
DOB/SSN
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
Visualizations
OASIS without DOB
A clustered column graph displaying the total count of applicants without a DOB in OASIS . Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
Health Banner without DOB
A clustered column graph displaying the total count of applicants without a DOB in Heath Banner. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
DOB Inconsistent
A clustered column graph displaying the total count of applicants with Inconsistent DOB in any system. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
OASIS without SSN
A clustered column graph displaying the total count of applicants without a SSN in OASIS . Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
Health Banner without SSN
A clustered column graph displaying the total count of applicants without a SSN in Health Banner . Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
SSN Inconsistent
A clustered column graph displaying the total count of applicants with Inconsistent SSN in any system. Selecting bar(s) in this visualization will filter the relevant items in the details or highlight items in other visualizations.
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
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
Health Banner DOB
This field identifies the applicant's date of birth in Health Banner.
Source: Health Banner Table: SPBPERS
Health Banner has DOB
This field identifies a flag for applicants that have a date of birth in Health Banner.
Source: Health Banner Table: SPBPERS
OASIS DOB
This field identifies the applicant's date of birth in OASIS.
Source: Health Banner Table: SPBPERS
OASIS has DOB
This field identifies a flag for applicants that have a date of birth in OASIS.
Source: Health Banner Table: SPBPERS
DOB Matches Both
This field identifies a flag for applicants that have a matching date of birth in Health Banner and OASIS.
Source: Health Banner Table: SPBPERS
Health Banner has SSN
This field identifies a flag for applicants that have a SSN in Health Banner.
Source: Health Banner Table: SPBPERS
OASIS has SSN
This field identifies a flag for applicants that have a SSN in OASIS.
Source: Health Banner Table: SPBPERS
SSN Matches Both
This field identifies a flag for applicants that have a matching SSN in Health Banner and OASIS.
Source: Health Banner Table: SPBPERS
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.