Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'medical_immun'

Medical Immunization (MI)

[medical_immun]

ID Element Name Type Size Values Cycle

Key

MI0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2021-2022 reporting year fy must be = 32

fy Num 2 Table 3
MI0020

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

3 = November 15th
cycle Num 2 Table 3
MI0030

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 C 3
MI0040

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 ######### 3

General

MI0050

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

uniq_stu_id Alpha 10 ########## 3
MI0055

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 3
MI0060

Immunization Code - The type of immunization administered. Options:

  • DTap
  • HepB
  • HPV
  • MCV4
  • Measles
  • Mumps
  • IPV/OPV
  • Polio
  • Rubella
  • Tdap
  • Varicella
  • COVID MOD
  • COVID PFR
  • COVID JSN
  • MENB
immune_code Alpha 10 Table 3
MI0070

Immunization Exemption Code - The type of exemption a student may have excusing the student from an immunization. Options:

M = Medical
P = Philosophical
R = Religious
N = Not Applicable

immune_exmpt Alpha 1 Table 3
MI0080

Immunization Code Date - The Date this immunization was given

immune_date Date 8 MMDDYYYY 3
MI0090

Had Disease - This field is pulled when a student has actually had the disease for which immunizations have been given. (Currently only Varicella is being extracted.)

had_disease Alpha 1 Y/N 3
No change Added Modified Deleted

Back to List