Database Schema for Handbook 2021-2022

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 2021-2022 reporting year fy must be = 32

fy Num 2 Table 3,5,6,7
SS0020

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

3 = November 15th
5 = February 15th
6 = April 15th
7 = June 15th
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

Back to List