Tool Search: ISEE Extracts

The Student Attendance extract reports district-level attendance data for all students actively enrolled at any time during the date range selected.

Image of extract options for Idaho ISEE Extract Student Attendance (ISEE Extract Editor)

Student Attendance Extract Logic

Report Population

All students with an active enrollment and an active roster record at any time during the extract date range are included in the report with the student's School of Primary Responsibility or the student's JDC Attendance School reporting in the schoolId field.
- A set of records reports for each M-F day in the date range for each student with an active enrollment and active roster record.
Students only report if they are in a grade with a State Grade Level of PK, KG or 01-12.
- Non-Public Home Schooled students should be mapped to their actual State Grade Level and flagged as Alternative Attendance on their enrollments. Attendance reports based on the unique calendar of the School of Primary Responsibility as derived in the District Calendar report via a DR calendar type.
- Students with a grade level of PK will only be included in the report if "Exclude PK" is not marked on the extract editor.
Students marked as State Exclude, in a grade level marked as State Exclude, or in a calendar marked as State Exclude do not report attendance data from excluded enrollments, grade levels, or calendars.
Students only report if the calendar of the student's School of Primary Responsibility or the student's JDC Attendance calendar is selected in the extract editor.
For JDC attendance reporting: mark the student as full-day absent in the student's School of Primary Responsibility on each date of reported JDC Attendance. All enrollment Start and End Dates must be captured in the JDC calendar. Adding an enrollment End Date for the School of Primary Responsibility enrollment is no longer necessary.

Report and Field Logic

Records are grouped by student's State ID, then School of Primary Responsibility, then derived calendarId, then Date. All attendance data reports from the student's School of Primary Responsibility on a given day, or from the student's enrollment in a JDC Attendance calendar.
Attendance is counted as "Day Minutes" minus "Absent Minutes."
- "Absent Minutes" are counted for any period with an attendance code that has a status of Absent and an excuse of Excused, Unexcused, or Unknown. "Day Minutes" are calculated as the number of period minutes from all Instructional, Attendance-Taking periods that the student is scheduled in for that day across all enrollments.
Attendance values are calculated based on the type of calendar of the School of Primary Responsibility or JDC Attendance calendar in which the student is enrolled.
- Calendar Type I: Instructional (Regular) with or without Summer School flagged and in a State Grade Level of PK or 01-12: attendance is reported as Whole Day/Half Day values, 1.0, 0.5 or 0.0.
- Calendar Type of A: Alternative with or without Summer School flagged and a State Grade Level of PK or 01-12: attendance is reported in hours to three decimal places (derived minutes present/60).
- Calendar Type of I: Instructional (Regular) who are enrolled in at least one section will report a Calendar Type of DR: attendance is reported in hours to three decimal places.
- State Grade Level of KG: Kindergarten with a Calendar Type of R: Instructional, SR: Summer Instructional, A: Alternative, SA: Summer Alternative, or K: Kindergarten and a Kindergarten Code of 3-9: attendance is reported as Whole Day values, 1.0 or 0.0.
- State Grade Level of KG: Kindergarten with a Calendar Type of R: Instructional, SR: Summer Instructional, A: Alternative, SA: Summer Alternative, or K: Kindergarten and a Kindergarten Code of 1 or 2: attendance is reported as Half Day values, 0.5 or 0.0
On days when a Staff Development or Emergency Closure Day Event occurs in the School of Primary Responsibility, student Attendance values are limited to the maximum number of instructional minutes on the day:
- If the Calendar has a Day Event selected for a day, Instructional Minutes must be greater than 0 for instruction time to report.
  - To report Half-Time KG as 0.5 time, Instructional Minutes must be greater than or equal to 150. If less than 150, reports instruction as 0.0.
  - To report Full Day KG as having 1.0 instruction time, Instructional Minutes must be greater than or equal to 150. If less than 150, reports instruction as 0.0.
  - To report students in Grades 01-12 as having 1.0 instruction time, Instructional Minutes must be greater than or equal to 240. To report as having 0.5 instruction time, Instructional Minutes must be between 239 and 150. If less than 150, reports instruction as 0.0.
For calendars returning a Whole Day/Half Day calculation, the following rules apply by Grade Level:
- For students in grades 01-12:
  - Reports 1.0 if the student has >= 240 Attendance Minutes
  - Reports 0.5 if the student has between 239 and 150 Attendance Minutes
  - Reports 0.0 if the student has <150 Attendance Minutes
- For students in a grade with a Kindergarten Session Code:
  - Kindergarten Code 3-9 (whole day)
    - Reports 1.0 if the student has >= 150 Attendance Minutes
  - Kindergarten Code 1 or 2 (half day)
    - Reports 0.5 if the student has >= 150 Attendance Minutes
  - Reports 0.0 if the student has <150 Attendance Minutes
For calendars returning Attendance Minutes calculated as Hours, the following rules apply:
- For students in an enrollment flagged as Alternative Attendance, or enrolled in an alternative calendar:
  - Day Minutes minus Absent Minutes report relative to the specific day and the period schedule for that day, even when there are multiple period schedules in the calendars. Hours are reported to three decimal places.
Records are reported for each entry/exit into a calendar flagged as JDC Attendance. A record reports regardless of the Service Type of the enrollment. The JDC Attendance calendar must have a Type of I: Instructional or A: Alternative to report.
Absence Reason only reports a value if a student has zero present minutes.
- Reports NULL if attendance < > 0.0
- Reports Absence Reason if attendance = 0.0 on the date of record
  - For Derived Calendar Sets where attendance reports hours to the thousandths:
    - Count period minutes mapped to Absent Excused and Absent Unexcused (state codes are not used)
    - Report EA if Excused Period Minutes > Unexcused Period Minutes
    - Report UA if Unexcused Period Minutes > Excused Period Minutes
    - Report UA if Unexcused Period Minutes = Excused Period Minutes
  - For Derived Calendar Sets where attendance reports in Modified Whole/Half Day:
    - Report NA if a student does not have enough present minutes in a day to report attendance > 0
    - Report EA if Excused Period Minutes > Unexcused Period Minutes
    - Report UA if Unexcused Period Minutes > Excused Period Minutes
    - Report UA if Unexcused Period Minutes = Excused Period Minutes

School of Primary Responsibility

The School of Primary Responsibility is the school that receives funding for a student, compared to other schools where the student may have partial enrollments. To determine the student's School of Primary Responsibility, all primary enrollments active at the same time are considered.

If only one enrollment is flagged as Primary on a given date, that enrollment identifies the School of Primary Responsibility.
If more than one enrollment is flagged as Primary on a given date, the School of Primary Responsibility whose calendar has the highest calendarID.
If the student has no primary enrollments on a given date, the School of Primary Responsibility is the one of the secondary enrollment whose calendar has the highest calendarID.
Enrollments in a calendar marked as JDC Attendance are not considered when determining a student's School of Primary Responsibility.

Day records report the same derived calendarID value as long as their School of Primary Responsibility enrollment remains active. A new value reports if the student's enrollment transitions. If a dual-enrolled student has an attendance record on a day when their School of Primary Responsibility is closed (reporting isntructionTime as 0.0 in the District Calendar extract), a record does not report for that day in this extract.

Report Editor Field Descriptions

Field	Description
Report Type	Select Student Attendance. The following ISEE extract types are also available: District Calendar Student Demographics Student Course Enrollment Special Education Students Gifted and Talented Students Staff Demographics Staff Assignment
Start Date	The earliest date from which data is pulled for the report. It is recommended that the Start Date be the first day of the week because partial-time enrollments such as Kindergarten are often totaled into the first instructional day of the week. (Required)
End Date	The latest date from which data is pulled for the report. (Required)
Exclude PK	This checkbox indicates that students with a State Grade Level of PK should not be included in the report.
Ad Hoc Filter	This field allows users to use an Ad hoc filter that was created in the Ad hoc Filter Designer. Only one Ad hoc filter may be selected.
Format	The format in which the report will generate. Options include CSV and HTML.
Select Calendars	The calendar(s) from which data is pulled for the report. Can be set to display only the active year's calendars, or be sorted by school or by year.
Batch Queue	Users have the option of submitting a District Calendar report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Student Attendance Extract Layout

Column	Description & Format	Campus Location
idStuId	The student's unique Idaho Student Identification Number. Numeric, 9 digits	Census > People > Demographics > Person Identifiers > Student State ID Person.stateID
SchoolId	The SDE assigned school code in the Idaho Education Directory for the school claiming the student. Only one school can claim the student on any given day. Alphanumeric, 4 characters	System Administration > Resources > School > State School Number School.number
CalendarId	A unique identifier for different calendars in use within the district. See the Derived CalendarID Logic section for more information. Numeric, 9 digits	System Administration > Calendar > Calendar > Calendar ID; System Administration > Calendar > Schedule Structure > Structure ID; System Administration > Calendar > Grade Levels > Kindergarten Code Calculated, not dynamically stored.
Date	The calendar day for the current record. Date Field, MM/DD/YYYY, 10 characters	System Administration > Calendar > Calendar > Days Day.date
Calendar Minutes	This field reports in HTML format only. Reports the calculated district-level attendance minutes based on the calendar type. Reports either in hours (rounded to the tenth decimal) or as a whole/half day. Numeric, 6 digits	Calculated, not dynamically stored
Attendance	The district-level attendance for the student on the selected day. The logic for this field is different based on the Calendar Type, Grade Level, and Kindergarten Session Type of the reporting student and the "Day Minutes" on the reporting day. See the Extract Logic section for more information. Alphanumeric, 5 characters in NN.NNN	Calculated, not dynamically stored
Absence Reason	Indicates the reason that zero was reported for daily attendance on the selected instructional day. The logic for this field is different based on how attendance reports for Derived Calendar sets on the reporting day. See the Extract Logic section for more information. Alphanumeric, 4 characters	Calculated, not dynamically stored
Self Dir Learn	Indicates if the student is considered a Self-Directed Learner. Reports as Y if the student has a Self-Directed Learner record that is active on the reporting date of the attendance where the Participation School selected on the record matches the school reported for BaseSchoolID. Otherwise reports as N. Alphanumeric, 1 character	Student Information > Program Participation > State Programs > Self-Directed Learner PlanOfStudy.startDate PlanOfStudy.endDate

Derived CalendarID Logic

Calendar Type: System Administration > Calendar > Calendar > Type
Summer School: System Administration > Calendar > Calendar > Summer School
JDC Attendance: System Administration > Calendar > Calendar > JDC Attendance
Calendar ID and Structure ID are Campus-generated identification numbers.
Alternative Attendance: Student Information > General > Enrollments > Alternative Attendance
Grade Level: Student Information > General > Enrollments > Grade Level
State Grade Level Code: System Administration > Calendar > Grade Levels > State Grade Level Code
Kindergarten Code: System Administration > Calendar > Grade Levels > Kindergarten Code
Instructional Start Date Override: System Administration > Calendar > Grade Levels > Instructional Start Date Override
Instructional End Date Override: System Administration > Calendar > Grade Levels > Instructional End Date Override

See the District Calendar (ISEE Extracts) (Idaho) article for Derived CalendarID Logic details.

Save

Student Attendance (ISEE Extracts) (Idaho)