Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'spcederlyinterv1'

Special Education Early Intervening Services 1 (School Age Only) (EI)


ID Element Name Type Size Values Cycle



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

fy Num 2 Table 7

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

7 = June 15th
cycle Num 2 Table 7

LEA, District/Coop -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, and cooperative. 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:

60 = Pulaski County
01 = Little Rock School District
000 = N/A (zeroes for district)
lea Alpha 7 Appendix B,D 7

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

Special Education Early Intervening Services (School Age Only) –Services provided to “students in kindergarten through grade 12…who have not been identified as needing special education or related services but need additional academic and behavioral supports to succeed in a general education environment” IDEA, Sec. 612, (f) (1).


First Name - The student's first name.

fname Alpha 20 7

Middle Name - The student's middle name.

mname Alpha 15 7

Last Name - The student's middle name.

lname Alpha 25 7

State Unique Identifier - The unique 10-digit Triand identifier generated for the student by the state

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

Date, Birth - The student's date of birth.

birth_date Date 8 MMDDYYYY 7

Race - The general racial or ethnic heritage with which the individual most identifies from the following codes:

YNNNNN = Hispanic
NYNNNN = Native American/Alaskan Native
NNYNNN = Asian
NNNYNN = Black/African American
NNNNYN = Native Hawaiian/Pacific Islander
NNNNNY = White

Y in more than one combination will be considered 2 or more races.

race_ethnic Alpha 6 NNNNNN 7

Federal Race Category - The categories used for reporting race to the US Department of Education.

1 = Hispanic
2 = American Indian/Alaskan Native
3 = Asian
4 = Black (non-Hispanic)
5 = Hawaiian/Pacific Islander
6 = White (non-Hispanic)
7 = Two or more races

fedrace Alpha 1 Table 7

Gender - The sexual classification of the staff person.

M = Male
F = Female
gender Alpha 1 Table 7

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

Status, English Language Learner (ELL) - Student has a language background other than English, and his or her proficiency in English is such that the probability of the student's academic success in an English-only classroom is below that of native English language students.

ell Alpha 1 7

Resident LEA - Indicate the LEA number of the district where the student resides. (Required for all students).

res_lea Alpha 7 ###### 7

Entry Date - Indicate the date the student entered Special Education Early Intervening Services Program.

entry_date Date 8 MMDDYYYY 7

Withdrawal Date -Indicate the date on which Intervening Services ended.

withd_date Date 8 MMDDYYYY 7

Withdrawal/Exit Code - Indicate the reason the student withdrew or exited Early Intervening Services.

SN = Services no longer needed
SP = Placed into Special Education
MD = Moved
DO = Dropped out of school
DP = Services discontinued at parent's request
GR = Graduated
RP = Reached Program Eligibility
DI = Died

exit_code Alpha 2 Table 7
No change Added Modified Deleted

Back to List