View Public Events Calendar
NM Public Education Department logo
stripes illustration

Student Summary Attendance Template

  1. Home
  2. Offices and Programs
  3. Information Technology
  4. STARS Information, Manuals, and Supporting Documents
  5. Attendance Domain
  6. Student Summary Attendance Template

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
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
4 STUDENT ID CHARACTER, REQUIRED, KEY enter the 9 digit student ID
5 PERIOD START DATE DATE, REQUIRED, KEY
  • 2019-08-01 = 40D
  • 2019-10-02 = 80D
  • 2019-12-16 = 120D
  • 2020-03-02 = End of Year
6 PERIOD END DATE DATE, REQUIRED, KEY
  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2020-06-01 = End of Year
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

  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.