Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'stIDChg'

Student ID Change (SI)


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 1-7

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

1 = September 30th
2 = October 15th
3 = November 15th
4 = December 15th
5 = February 15th
6 = April 15th
7 = June 15th
cycle Num 2 Table 1-7

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:

60 = Pulaski County
01 = Little Rock School District
002 = Hall High School
lea Alpha 7 Appendix C 1-7

Date, Month, Day and Year - The student identification number is changed.

date date 8 MMDDYYYY 1-7

ID Information


Changed from ID - The SSN or assigned number currently being used to identify this student.

change_from_ssn_or_id Alpha 9 1-7

Changed to SSN or ID Number - The nine-digit Social Security Number of the student or 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.

change_to_ssn_or_id Alpha 9 1-7
No change Added Modified Deleted

Back to List