Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'medical_vision'

Medical Vision (MV)

[medical_vision]

ID Element Name Type Size Values Cycle

Key

MV0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2024-2025 reporting year fy must be = 35

fy Num 2 Table 7
MV0020

Cycle - The reporting cycle for which the data is submitted:

 7 = June 15th
cycle Num 2 Table 7
MV0030

LEA, School -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, schools, cooperatives, and vocational institutions. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example:

6001002
60 = Pulaski County
01 = Little Rock School District
002 = Hall High School
lea Alpha 7 Appendix B,D 7
MV0040

SSN, Student - The nine-digit Social Security number of the student. If a student's SSN cannot be obtained, then the ADE assigned number as required by Arkansas Code Ann. 6-18-208 should be used. This number should remain the same throughout the student's school career.

ssn Alpha 9 7
MV0041

State Reporting ID - The unique 10-digit Triand identifier generated for the student by the state

uniq_stu_id Alpha 10 ########## 7
MV0042

Grade Level - The grade level in which the student is currently enrolled:

K = Kindergarten
01 = 1st Grade
02 = 2nd Grade
03 = 3rd Grade
04 = 4th Grade
05 = 5th Grade
06 = 6th Grade
07 = 7th Grade
08 = 8th Grade
09 = 9th Grade
10 = 10th Grade
11 = 11th Grade
12 = 12th Grade
EE = Non-Graded Elementary
SM = Non-Graded Middle/Jr.
SS = Non-Graded Secondary
grade_level Alpha 2 Table 7

General

MV0060

Screening Date - Date of initial vision screening.

screen_date Date 8 MMDDYYYY 7

For the following fields (MV0062 - MV0095), P - Pass, F - Fail, N - Not applicable

MV0062

External Exam - Any obvious anomaly of the eyes

 

ext_exam Alpha 1 P/F/N 7
MV0063

Vision 20 - Distance visual acuity screening using a Snellen Eye Chart at 20 feet.

vision20 Alpha 1 P/F/N 7
MV0066

Colorblind - The lack of perceptual sensitivity to certain colors.

colorblind Alpha 1 P/F/N 7
MV0073

Fusion Far - The binocularity of vision at far.

fusion_far Alpha 1 P/F/N 7
MV0075

Fusion Near - The binocularity of vision near.

fusion Alpha 1 P/F/N 7
MV0085

Lateral MB Near - The Lateral muscle balance at near.

lat_mb Alpha 1 P/F/N 7
MV0086

Lateral MB Far - The lateral muscle balance at far.

lateral_far Alpha 1 P/F/N 7
MV0090

Vertical MB Far - Vertical muscle balance at far only.

ver_mb Alpha 1 P/F/N 7
MV0095

Plus 2 Lens - A plus lens visual acuity screening test using a Snellen Eye Chart at twenty feet (20') or an age or developmentally appropriate chart at ten feet (10').

plus2_len Alpha 1 P/F/N 7
MV0100

Referral - Referred to an eye care professional because of failed screening.

P = Physician
E = Eye Doctor
S = School Nurse
G – Guardian (can ONLY be used when Colorblind is the only failure)
PR = Written Parent Refusal
UN = Unable to screen due to Perform Screening (SPED/Acute Disability)
VS = Virtual Student Not Screened
NA = Not Applicable
referral Alpha 2 Table 7
MV0110

Follow-up - The follow-up of the screening or referral.

R = Refuse Referral
T = Re-Screened
L = Lens Prescribed
N = Normal Exam
J = Treatment
A = Abex No Lens
X = Left District
I = In Process
NA = Not Applicable

follow_up Alpha 2 Table 7
MV0115

Auto Refractor - Indicates that an auto refractor was used during student’s eye exam.

auto_ref Alpha 1 Y/N 7
No change Added Modified Deleted

Back to List