Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'medical_hearing'

Medical Hearing (MH)

[medical_hearing]

ID Element Name Type Size Values Cycle

Key
MH0010

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

 fy Num 2 Table 7
MH0020

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

7 = June 15th
 cycle Num 2 Table 7
MH0030

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
MH0040

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.

ssn Alpha 9 7
MH0041

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

 uniq_stu_id Alpha 10 7
MH0042

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
MH0060

Screening Date - The date of the student's hearing screening.

 screen_date Date 8 MMDDYYYY 7
MH0065

Right Ear - Hearing test results for the right ear.

 right_ear Alpha 1 P/F 7
MH0070

Left Ear - Hearing test results for the left ear..

 left_ear Alpha 1 P/F 7
MH0100

Referral - Referred to an healthcare professional because of failed screening.

P = Physician
S = School Nurse
U = Audiologist
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
MH0110

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

R = Refuse Referral
T = Re-Screened
N = Normal Exam
J = Treatment
X = Left District
I = In Process
NA = Not Applicable

 follow_up Alpha 2 Table 7
No change Added Modified Deleted

Back to List