Skip to Content

Student Summary Attendance Template

Student Summary Attendance Template 2019-06-13T16:07:31-06:00

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 NumberField NameData Type, Required, CodeValid Values
1DISTRICT CODECHARACTER, REQUIRED, KEY
2LOCATION CODECHARACTER, REQUIRED, KEY
3SCHOOL YEAR DATEDATE, REQUIRED, KEY
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
4STUDENT IDCHARACTER, REQUIRED, KEYenter the 9 digit student ID
5PERIOD START DATEDATE, REQUIRED, KEY
  • 2019-08-01 = 40D
  • 2019-10-02 = 80D
  • 2019-12-16 = 120D
  • 2020-03-02 = End of Year
6PERIOD END DATEDATE, REQUIRED, KEY
  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2020-06-01 = End of Year
7DAYS PRESENTNUMBER (1 decimal), REQUIRED, UPDATEABLE
9DAYS ENROLLEDNUMBER (1 decimal), REQUIRED, UPDATEABLE
10DAYS ABSENT WITHOUT EXCUSENUMBER (1 decimal), REQUIRED, UPDATEABLE

FAQs

  1. 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.
  2. 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.
  3. 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.
  4. What is an unexcused absence?
    Each district locally defines what a full- and half-day unexcused absence is.
  5. Why do schools have to report unexcused absences?
    This data will be used to calculate annual habitual truancy rates.
Page last updated June 13, 2019