SIS Handbook | Database Table SchemaAledays - Days in ALE

Main Overview Data Submission Cycles Cycle Reports Data Sources Database Table Schema Previous Table Schema Appendices Handbook Changes Handbook Downloads

Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'aledays '

Aledays - Days in ALE (AL)

[aledays ]

ID	Element	Name	Type	Size	Values	Cycle
	Key
AL0010	Fiscal Year - The fiscal year that this reporting represents: For the 2024-2025 reporting year fy must be = 35	fy	Num	2	Table	3,5,6,7
AL0020	Cycle - The reporting cycle for which the data is submitted: 3 = November 15^th 5 = February 15^th 6 = April 15^th 7 = June 15^th	cycle	Num	2	Table	3,5,6,7
AL0030	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: 6001001 60 = Pulaski County 01 = Little Rock School District 001 = Hall High School	lea	Alpha	7	Appendix C	3,5,6,7
AL0040	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,5,6,7
	General
AL0045	State Reporting ID - The unique 10-digit Triand identifier generated for the student by the state.	uniq_stu_id	Alpha	10	##########	3,5,6,7
AL0050	Alternative Education (ALE) Entry Date - The date the student entered the Alternative Education (ALE)* learning environment.*	entry_date	Date	8	MMDDYYYY	3,5,6,7
AL0055	Alternative Education (ALE) Exit Date - The date the student exited the Alternative Education (ALE) learning environment.	exit_date	Date	8	MMDDYYYY	3,5,6,7
AL0060	Consecutive Days Flag - This flag indicates the student has been in the Alternative Education (ALE)* learning environment for at least 20 consecutive days.*	consec_flag	Alpha	1	#	3,5,6,7
AL0065	Number of Days in Alternative Education (ALE) - The total number of days in the Alternative Education (ALE)* curriculum for the cycle.*	ale_days	Dec	5,2	###.##	3,5,6,7
AL0070	Special Education Status - Was the student active in the Special Education School Age program anytime during the Alternative Education (ALE)* Entry Date and Alternative Education (ALE) Exit Date?*	sped_status	Alpha	1	Y/N	3,5,6,7
AL0080	*Alternative Education (ALE) Program Type -* This indicates the type of the Alternative Education (ALE) Program the student is in T - Traditional H - Hybrid (A.C.A 6-48-101)	ale_type	Alpha	1	T/H	3,5,6,7

No change

Added

Modified

Deleted