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)

[spcederlyinterv1]

ID Element Name Type Size Values Cycle

Key

EI0010

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

fy Num 2 Table 7
EI0020

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

7 = June 15th
cycle Num 2 Table 7
EI0030

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:

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

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).

EI0041

First Name - The student's first name.

fname Alpha 20 7
EI0042

Middle Name - The student's middle name.

mname Alpha 15 7
EI0043

Last Name - The student's middle name.

lname Alpha 25 7
EI0044

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

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

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

birth_date Date 8 MMDDYYYY 7
EI0050

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
EI0051

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
EI0060

Gender - The sexual classification of the staff person.

M = Male
F = Female
gender Alpha 1 Table 7
EI0065

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
EI0070

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
EI0080

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

res_lea Alpha 7 ###### 7
EI0090

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

entry_date Date 8 MMDDYYYY 7
EI0100

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

withd_date Date 8 MMDDYYYY 7
EI0110

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