Tool Search: CDC Extract
The Excessive Absenteeism Monthly Collection reports the number of students enrolled in Kindergarten through 12th grade who were absent from school for more than two days (or the hourly equivalent) during the calendar month.
This extract is no longer collected. The information included in this extract has been incorporated into other extracts. It is available for reference.
Excessive Absenteeism CDC Extract
Report Logic
Reported Students
- All enrolled students, regardless of FTE, are included in the extract.
- Any student who meets the definition in the current month's count, even if the student met the definition and was reported in a previous month's count, is included.
State Exclude
- Students marked as State Exclude on their enrollment records are not included in the report.
- Students enrolled in Grade Levels marked as State Exclude are not included in the report.
- Calendars marked as State Exclude are not included in the report.
Calculations
The days absent for a K-12 student are reported within the selected calendar month report, except:
- For the August/September collection, days absent are calculated from the first day of enrollment in the school year through September 30th.
- For the May/June collection, days absent are calculated from May 1 through the last day of school.
Special consideration is not given to behavior events labeled Expulsion with Services or Suspension with Services. Standard attendance record logic during that time period is used.
Report Editor
The following fields are available on the Report Editor.
Field | Description |
|---|---|
Extract Type | Determines the extract that generates. Choose Excessive Absenteeism. |
Reporting Period | Indicates which month the absentee data is reported. August and September are included in one collection, as is the May/June option. All other months are generated individually. A reporting period must be selected in order to generate the report. |
Format | The Excessive Absenteeism report can be generated in CSV format or HTML format. |
Calendar Selection | At least one school calendar must be selected in order to generate the report. Calendars can be selected by Active Year, by School or by Year. |
Generate Extract | Selecting this button generates the extract immediately in the selected format. |
Submit to Batch | Selecting this button generates the extract at a designated time. See the Batch Queue information for more details on this option. |
Generate the Report
- Select the Extract Type as Excessive Absenteeism.
- Select the desired Reporting Period.
- Select the Format in which to generate the extract.
- Select the desired Calendars for which to report data.
- Click either the Generate Extract Button or the Submit to Batch button.
Report Layout
The Report Layout includes three types of records:
- A school record that provides totals for a school/calendar selected in the extract editor.
- A student detail record for each of the students in that school/calendar who meet the conditions to return in the extract, sorted by Student Name, then NDE Student ID.
- A district total record that provides a total across all schools/calendars selected for all state-required fields.
Days Absent
- For the August/September collection, the days absent is calculated from the first day of enrollment in the school year through September 30.
- For the May/June collection, the days absent from May 1 through the last day of school.
Students enrolled in the school selected that reports in field 1 are used in the calculation.
For the enhancement line, calculations for this extract are pulled from the Behavior Management tool.
School Level Record Layout
Data Elements | Description | Campus Location |
|---|---|---|
School | Name of the school calendar for which the data is being reported. Alphanumeric, 15 character | Calendar Information > Name calendar.name |
Student Count | Reports the number of students enrolled in Kindergarten through 12th grade who were absent from school for more than 2 days (or the hourly equivalent) during the calendar month.
Numeric, 4 digits | Calculated, value not stored |
Long-Term Suspensions | Exclusion of a student from attendance in all schools within the system for a period exceeding five school days but less than twenty school days.
Numeric, 4 digits | Calculation, value not stored |
Expulsions | Exclusion from attendance in all schools within the system for a period exceeding five school days but less than twenty school days.
Numeric, 4 digits | Calculated, value not stored |
Medical | Student was unable to attend school due to illness or other medical reason. Numeric, 4 digits | Calculated, value not stored |
Other | Number of students not meeting the definition of long-term suspensions, expulsions or medical. If any student had any other absences where the Excuse is not Exempt and not reported in the previous fields, a value of 1 is added to the reported number. Numeric, 4 digits | Calculated, value not stored |
Cumulative Count | Days the student has been absent for each reporting period prior to and including the reporting period selected in the Extract Editor for the reporting calendar only.
Numeric, 4 digits | Calculated, value not stored |
Referrals | Reports the number of referrals during the calendar month to the office of the county attorney for excessive absenteeism of a student enrolled in KG-12 grade. If a student was referred to the office of the county attorney for excessive absenteeism more than once during the time being reported, count each referral. Numeric, 4 digits | Calculated, value not stored |
Contacts | Reports the number of contacts with law enforcement officials during the calendar month by the district or system relative to a student enrolled in KG through 12 grades who is in the district or system. This does not include contacts with law enforcement officials employed by or contracted with the school district as school resource officers. Numeric, 4 digits | Calculated, value not stored |
School Level Record
Student Level Detail Record Layout
The Student Level Detail Record sorts by Student Name, then NDE Student ID.
Data Elements | Description | Campus Location |
|---|---|---|
Student Name | Name (Last Name, First Name) of student. Alphanumeric, 15 characters | Identities > Last Name Identities > First Name identity.lastName |
NDE Student ID | Nebraska Department of Education assigned student identifier. Numeric, 10 digits | Demographics >Person Identifiers > State ID person.stateID |
School Absences | Total minutes absent divided by the total minutes scheduled minus Exempt absences and expulsions with or without services.
Numeric, 4 digits | Calculated, value not stored |
Cumulative Absences School | Days the student has been absent for each reporting period prior to and including the reporting period selected in the Extract Editor for the reporting calendar only. Numeric, 4 digits | Calculated, value not stored |
Referrals | Reports the number of referrals during the calendar month to the office of the county attorney for excessive absenteeism of a student enrolled in kindergarten through 12th grade. If a student was referred to the office of the county attorney for excessive absenteeism more than once during the time period being reported, count each referral. Numeric, 4 digits | Calculated, value not stored |
Contacts | Reports the number of contacts with law enforcement officials during the calendar month by the district or system relative to a student enrolled in kindergarten through 12th grade who is in the district or system. This does not include contacts with law enforcement officials employed by or contracted with the school district as school resource officers. Numeric, 4 digits | Calculated, value not stored |
Student Level Record
District Level Total Record Layout
Data Elements | Description | Campus Location |
|---|---|---|
Unduplicated Count of Students | Reports the number of students enrolled in KG-12 grades who were absent from school for more than two days during the calendar month.
Numeric, 4 digits | Calculated, value not stored |
Long-Term Suspensions | Exclusion of a student from attendance in all schools within the system for a period exceeding five school days but less than 20 school days.
Numeric, 4 digits | Calculated, value not stored |
Expulsion | Exclusion from attendance in all schools within the system. Numeric, 4 digits | Calculated, value not stored |
Medical | Student was unable to attend school due to illness or other medical reason. Numeric, 4 digits | Calculated, value not stored |
Other | Number of students not meeting the definition of long-term suspensions, expulsions or medical. If any student had any other absences where the Excuse is not Exempt and not reported in the previous fields, a value of 1 is added to the reported number. Numeric, 4 digits | Calculated, value not stored |
Cumulative Count | Days the student has been absent for each reporting period prior to and including the reporting period selected in the Extract Editor for the reporting calendar only.
Numeric, 4 digits | Calculated, value not stored |
Referrals | Reports the number of referrals during the calendar month to the office of the county attorney for excessive absenteeism of a student enrolled in KG-12 grade. If a student was referred to the office of the county attorney for excessive absenteeism more than once during the time being reported, count each referral. Numeric, 4 digits | Calculated, value not stored |
Contacts | Reports the number of contacts with law enforcement officials during the calendar month by the district or system relative to a student enrolled in KG through 12 grades who is in the district or system. This does not include contacts with law enforcement officials employed by or contracts with by the school district as school resource officers. Numeric, 4 digits | Calculated, value not stored |
District Level Record
