Table of Contents
Overview
- 4-year-olds (by 9/1)
- Kindergartners
- Any other first time entrants (4-years through 12th grade)
See https://www.dshs.texas.gov/vhs/require.shtm
Only data entered on the Hearing page with a Test Date (HRN.TD) between June 1 and May 31st of the school year will be included on this report.
Navigate to Reports > Hearing Screening State Report
Select School(s) and Grade level(s) to further filter the report as options.
Configurations ↑
This report relies on fixed codes being used for several fields on the Hearing page (HRN table).
The Update Code Table page may be used to add custom codes, however, these custom values will NOT appear on this report and any students coded with those values may not be counted on this report.
Navigate to Medical > Hearing to enter the hearing results as follows.
Fields and values used for this report:
| Field | Fixed Codes (Required Values) | Hearing Screening Report Column |
| Grd (HRN.GR) | P-12 | Grades |
| Date (HRN.TD) | All data entered on the Hearing page with a Test Date (HRN.TD) between June 1 and May 31 of the current school year will be included on this report. | A Total Number Screened |
| Results P/F (HRN.PF) | P Pass F Fail Blank | B Number Failed |
| Dr Refer (HRN.DR) | Y Yes N No Blank | C Number Referred |
| Case Type (HRN.CT) | 1 No Problem 2 Treatment 3 Not Examined 4 Treatment Refused 5 Transferred Blank | E No Problem F Treatment G Referred Not Examined G Referred Not Examined D Number Transferred G Referred Not Examined |
Calculations ↑
Students with Hearing Test Dates (HRN.TD) between June 1 and May 31 of the current school year will be included on the report as follows. The report will include inactive students if they were testing during the current school year.
| Report Column | Aeries Fields | Calculation |
| Grade | Grade (HRN.GR) | None |
| A Total Number Screened | Date (HRN.TD) | Count if HRN.TD between June 1 and May 31 of the current school year |
| B Number Failed | Results P/F (HRN.PF) | Count if HRN.PF = F |
| C Number Referred | Dr Refer (HRN.DR) | Count if HRN,DR = Y |
| D Number Transferred | Case Type (HRN.CT) | Count if HRN.DR = Y AND Count if HRN.CT = 5 |
| E Specialist Exam No Problem | Case Type (HRN.CT) | Count if HRN.DR = Y AND Count if HRN.CT = 1 |
| F Specialist Exam Treatment | Case Type (HRN.CT) | Count if HRN.DR = Y AND Count if HRN.CT = 2 |
| G Referred Not Examined | Case Type (HRN.CT) | Count if HRN.DR = Y AND (HRN.CT = 3,or 4 or blank/null) |
| Late Exam Results From Last Year (E & F Columns) | No calculation | This data is not entered for the past so it was determined not needed. |
NOTE: The Number Failed (Column B) must be greater or equal to the Number Referred (C).
The Number Referred (C) must equal the total of Number Transferred, Specialist Exam (No problem or Treatment), and Referred not Examined (D-G) 
Query to see a list of students counted on the report:
This query includes every hearing record between the test dates specified. The report only includes the most recent if more than one during the reporting period.
LIST STU HRN STU.SC STU.ID HRN.TD STU.NM HRN.GR HRN.PF HRN.DR HRN.DT HRN.CT IF HRN.TD >= "06/01/2022" AND HRN.TD <= "05/31/2023"
Query to find students who Failed the Screening:
LIST STU HRN STU.SC STU.ID HRN.TD STU.NM HRN.GR HRN.PF HRN.DR HRN.DT HRN.CT IF HRN.PF = "F" AND HRN.TD >= "06/01/2022" AND HRN.TD <= "05/31/2023"
Query to find transferred students:
Students who were screened with case type = 5-Transferred but withdrew from the district. Must run this query at the District Level and check Include Inactive Students checkbox.
LIST STU HRN STU.SC STU.ID HRN.TD STU.NM HRN.GR HRN.PF HRN.DR HRN.DT HRN.CT IF HRN.CT = "5" AND HRN.TD >="06/01/2022" AND HRN.TD <= "05/31/2023" AND STU.TG # " "