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/default.shtm
Only data entered on the Vision page with a Test Date (VSN.TD) between June 1 and May 31 of the current school year will be included on this report.
Select School(s) and Grade level(s) to further filter the report as options.
Configurations ↑
This report relies on the fixed codes being used for several fields on the Vision page (VSN 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 will not be counted on this report.
Navigate to Medical > Vision page to enter the vision results as follows.
Fields and values used for this report:
| Field | Fixed Codes (Required Values) | Vision Screening Report Column |
| Grd (VSN.GR) | P-12 | Grades |
| Date (VSN.TD) | All data entered on the Vision page with a Test Date (VSN.TD) between June 1 and May 31s of the current school year will be included on this report. | A0 Number Screened A1 Number Screened with Correction A2 Number Screened w/Auto Screening Device |
| Results P/F (VSN.PF) | P Pass F Fail Blank | B0 Number Failed B1 Number Failed w/Auto Screening Device |
| Dr Ref(VSN.DR) | Y Yes N No Blank | C0 Number Referred C1 Number Referred w/Auto Screening Device |
| Vision Appraisal (VSN.VA) & | Only Reported if referred (VSN.DR = Y) 1 No Problem 2 Treatment 3 Not Examined 4 Treatment Refused 5 Transferred | E0, E1 No Problem F0, F1 Treatment G0, G1 Referred Not Examined G0, G1 Referred Not Examined D0, D1 Number Transferred |
| Vision Screen (VSN.SCN) | HI Hirschberg HO HOTV OT Other PS Photoscreening SC Snellen L SE Snellen E SL Sloan SN Snellen TI Titmus | Used for All Columns referencing w/Auto Screening Device. (A2,B1,C1,D1,E1,F1,G1) If a value of HI, PS, or TI is selected in this field, the student will be counted in the w/Auto Screening Device column(s) where they also meet the other criteria. |
Calculations ↑
Students with Vision Test Dates (VSN.TD) between June 1 and May 31 of the current school year will be included on this 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 (VSN.GR) | Count for each Grade |
| A0 Total Number Screened | Date (VSN.TD) | Count if (VSN.TD) between June 1 and May 31s of the current school year |
| A1 Number Screened with Correction | Date (VSN.TD) & VSN Glasses Fields | Count if ANY of the following fields are NOT blank or NULL(VSN.RGF, VSN.LGF, VSN.BGF, VSN.RG, VSN.LG, VSN.BG) |
| A2 Number Screened w/Auto Screening Device | Date (VSN.TD) & Scr VSN.SCN | Count if VSN.SCN = HI (Hirschberg, PS (Photoscreening), or TI (Titmus) |
| B0 Number Failed B1 Number Failed w/Auto Screening Device | Results P/F (VSN.PF) & & Scr VSN.SCN | Count if VSN.PF = F Count if VSN.PF = F AND VSN.SCN = HI (Hirschberg, PS (Photoscreening), or TI (Titmus) |
| C0 Number Referred C1 Number Referred w/Auto Screening Device | Dr Refer (VSN.DR) & Scr VSN.SCN | Count if VSN.DR = Y Count if VSN.DR = Y AND VSN.SCN = HI (Hirschberg, PS (Photoscreening), or TI (Titmus) |
| D0 Number Transferred D1 Number Transferred/Auto Screening Device | Vision Appraisal (VSN.VA) & Scr VSN.SCN | Count if VSN.DR = Y AND VSN.VA = 5 Count if VSN.DR = Y AND VSN.VA = 5 AND VSN.SCN = HI (Hirschberg, PS (Photoscreening), or TI (Titmus) |
| E0 Professional Exam No Problem E1 No Problemw/Auto Screening Device | Vision Appraisal (VSN.VA) & Scr VSN.SCN | Count if VSN.DR = Y AND VSN.VA = 1 Count if VSN.DR = Y AND VSN.VA = 1 AND VSN.SCN = HI (Hirschberg, PS (Photoscreening), or TI (Titmus) |
| F0 Specialist Exam Treatment F1 Treatmentw/Auto Screening Device | Vision Appraisal(VSN.VA) & Scr VSN.SCN | Count if VSN.DR = Y AND VSN.VA = 2 Count if VSN.DR = Y AND VSN.VA = 2 AND VSN.SCN = HI (Hirschberg, PS (Photoscreening), or TI (Titmus) |
| G0 Referred Not Examined G1 Referred Not Examined w/Auto Screening Device | Vision Appraisal (VSN.VA) & Scr VSN.SCN | Count if VSN.DR = Y AND VSN.VA = 3,4, or blank Count if VSN.DR = Y AND VSN.VA = 3,4, or blank AND VSN.SCN = HI,PS, or TI |
NOTE:
Total #Number Screened (Column A0) must be greater than or equal to Number Failed(B0)+ Number Referred(C0)
The Number Failed(B0) must be greater than or equal to Number Referred(C0)
The Number Referred(C0) must be equal to the sum of Number Transferred(D0) + Professional Exam No Problem(E0) + Treatment(F0) + Referred Not Examined(G0)
Total #Number Screened (Column A0) must be greater than or equal to the Number Screened with Correction(A1)
Query to see a list of students counted on the report:
Be sure to check 'Include Inactive Students'
LIST STU VSN STU.SC STU.ID VSN.TD STU.NM VSN.GR VSN.PF VSN.DR VSN.VA VSN.SCN BY STU.SC VSN.GR STU.LN IF VSN.TD >= "06/01/2022" AND VSN.TD <= "05/31/2023"
Query to find students who Failed the Screening:
LIST STU VSN STU.SC STU.ID VSN.TD STU.NM VSN.GR VSN.PF VSN.DR VSN.VA VSN.SCN BY STU.SC VSN.GR STU.LN IF VSN.PF = "F" AND VSN.TD >= "06/01/2022" AND VSN.TD <= "05/31/2023"
Query to find transferred students: Were screened at school/district but withdrew from the district.
Be sure to check 'Include Inactive Students'
LIST STU VSN STU.SC STU.ID VSN.TD STU.NM VSN.GR VSN.PF VSN.DR VSN.VA VSN.SCN IF VSN.VA = "5" AND VSN.TD >= "06/01/2022" AND VSN.TD <= "05/31/2023" AND STU.TG # " "
Query to find students enrolled as of census who were not screened for vision:
Step 1: Keep students for specific grades. This example is all 1st grade students who were enrolled as of census date:
KEEP STU ENR IF ENR.GR = 1 AND ENR.YR = "2022" AND ENR.ED <= "10/28/2022" AND ( ENR.LD = NULL OR ENR.LD > "10/28/2022" )
Make sure to check ‘Include Inactive Students’
Step 2: Skip the students who have a vison record this year.
SKIP STU VSN IF VSN.TD >= "06/01/2022" AND VSN.TD <= "05/31/2023"
Make sure to check ‘Include Inactive Students’
Step 3: Navigate to the Vision Page & scroll through these students one by one or run a LIST query to get a list of Students with or without all of their Vision records:
- LIST STU
- See a list of all Vision Records for these students:
LIST STU VSN STU.SC STU.ID VSN.TD STU.NM VSN.GR VSN.PF VSN.DR VSN.VA VSN.SCN BY STU.SC STU.LN - Use Mass Add Medical Tests to create a Vision record with the same test date and P/F status
- An Aeries Administrator may use the Mass Add Student Related Data