SIS Handbook | Database Table SchemaStudent Attendance

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 'student_att'

Student Attendance (SS)

[student_att]

ID	Element	Name	Type	Size	Values	Cycle
	Key
SS0010	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
SS0020	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
SS0030	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	3,5,6,7
SS0040	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
SS0045	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
	Student Transportation Status
SS0050	Status, Transportation - Indicates that the student is eligible to ride a bus tofrom school. A transported student is one who lives 2 or more miles from their assigned school. T = Transported N = Non-Transported	bus	Alpha	1	Table	3,5,6,7
	General
SS0051	Transportation - Indicates means of transporting the student to/from school. B-Bus D-Drives self G-Parentguardian P-District paid transportation	trans_status	Alpha	1	Table	3,5,6,7
	Attendance Days Present - The number of days the student arrived at school each quarter (1-4) of the current school year. Days Absent - The number of days the student was not in school each quarter (1-4) of the current school year.
SS0060	Days Present Quarter 1	days_prs_qtr1	Dec	8,2	######.##	3
SS0070	Days Absent Quarter 1	days_abs_qtr1	Dec	8,2	######.##	3
SS0120	Days Present Quarter 2	days_prs_qtr2	Dec	8,2	######.##	5
SS0130	Days Absent Quarter 2	days_abs_qtr2	Dec	8,2	######.##	5
SS0180	Days Present Quarter 3	days_prs_qtr3	Dec	8,2	######.##	6
SS0210	Days Absent Quarter 3	days_abs_qtr3	Dec	8,2	######.##	6
SS0240	Days Present Quarter 4	days_prs_qtr4	Dec	8,2	######.##	7
SS0250	Days Absent Quarter 4	days_abs_qtr4	Dec	8,2	######.##	7

No change

Added

Modified

Deleted