Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'stIDChg'

Student ID Change (SI)

[stIDChg]

ID Element Name Type Size Values Cycle

Key
SI0010

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

 fy Num 2 Table 1,2,3,4,5,6,7
SI0020

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,2,3,4,5,6,7
SI0030

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 1,2,3,4,5,6,7
SI0040

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

 date date 8 MMDDYYYY 1,2,3,4,5,6,7

ID Information
SI0050

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

 change_from_ssn_or_id Alpha 9 1,2,3,4,5,6,7
SI0060

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,2,3,4,5,6,7
No change Added Modified Deleted

Back to List