Target Table: STUD_ATT_SUM
Data Submission Schedule: 40 Day, 80 Day, 120 Day, End of Year (EOY)
Grain: One record per district / location / school year / attendance period
Load Sequence/Dependencies:
1. Student Required
Template Description – This template will be used to track student attendance data. Only students active as of each reporting period should be included in this template. If a student exited prior to the reporting period, NO student summary attendance records for that student should be recorded for the reporting period. Only students submitted in the Student Snapshot for each respective reporting period should be submitted in the complementary Student Summary Attendance template for that period. Do not submit for K3P reporting or End of Year (EOY). This template must be submitted incrementally at each reporting period rather than cumulatively. For example, the 80D submission should only include attendance since 40D.
School Year 2019-2020 Changes:
- No Changes
File Name Format: DDD_STUD_ATT_SUM_YYYYMMDDHHMM.fff
File Name Format Example: 001_STUD_ATT_SUM_201907071201.csv
| Field Number | Field Name | Data Type, Required, Code | Valid Values |
|---|---|---|---|
| 1 | DISTRICT CODE | CHARACTER, REQUIRED, KEY | |
| 2 | LOCATION CODE | CHARACTER, REQUIRED, KEY | |
| 3 | SCHOOL YEAR DATE | DATE, REQUIRED, KEY |
|
| 4 | STUDENT ID | CHARACTER, REQUIRED, KEY | enter the 9 digit student ID |
| 5 | PERIOD START DATE | DATE, REQUIRED, KEY |
|
| 6 | PERIOD END DATE | DATE, REQUIRED, KEY |
|
| 7 | DAYS PRESENT | NUMBER (1 decimal), REQUIRED, UPDATEABLE | |
| 9 | DAYS ENROLLED | NUMBER (1 decimal), REQUIRED, UPDATEABLE | |
| 10 | DAYS ABSENT WITHOUT EXCUSE | NUMBER (1 decimal), REQUIRED, UPDATEABLE |
FAQs
- What is the definition for Attendance?
If a student attends school for one-half or less of the total instructional time, the student will be counted as having attended for one-half day. If the student attends school for more than one-half of the total instructional time, the student will be counted as having attended for a full day. - How should I count the days from reporting period to reporting period?
The days should be counted from the first day after the last reporting date (for submittal on 80D reporting of SY2017, you would count October 13th through December 1; for 120D submittal, you will count December 2nd through February 8th, etc.) The date fields submitted in the file should follow the rules in the manual. They will not be the same as the actual dates you are using for the counts. - Who is a “habitual truant” student?
A habitual truant student is a student who has accumulated the equivalent of ten or more full-day unexcused absences within a school year. - What is an unexcused absence?
Each district locally defines what a full- and half-day unexcused absence is. - Why do schools have to report unexcused absences?
This data will be used to calculate annual habitual truancy rates.