Tool Search: SIRS Extracts
The Student Digital Access extract reports individual student digital equity survey information collected during a school year.
Report Logic
One record reports:
- per student,
- per K-12 enrollment, (This includes ungraded elementary K-6, secondary students (GED, Alternative), and partial enrollments)
- per school.
- Student must have an enrollment record within the set school year's start and end dates and align with Student Lite records.
- Record dates cannot overlap.
- Students with no survey records do not report.
Using the survey date on the Digital Equity tool, data reports from the most recent record that falls within a school year enrollment date for the student.
- The most recent survey date between the start and end date reports.
- If there are multiple surveys, the most recent reports.
Reports by the student enrollment and the assigned (enrolled) School Building Code
- All students are reported who are actively enrolled within a school year start and end date
- When a student is enrolled in a new building location, a new record is reported with that new building information.
| If a student is enrolled in more than one building AND has multiple enrollments... | Data from... |
|---|---|
| in the same school | the most recent enrollment is used. |
| in different schools | the primary enrollment is used. |
Extract Editor Fields
| Field | Description |
|---|---|
| Extract Type | The SIRS Extract to be generated. |
| Start Date End Date | The first and last date on which the report looks for attendance events. |
| Included State Grade Levels | Identifies the state grade levels to include in the report. |
| Format | The Format in which the report should generate. Options are State Format (CSV) and HTML. Use State Format for reporting information to the state and the other types for data review and verification. |
| Ad Hoc Filter | Selecting a filter limits the results to only those included in the filter. The following extracts do NOT use this field: Attendance Code, Day Calendar, Location Marking Period Code, and Marking Period Code. |
| Select Calendars | Identifies which Calendar(s) should be included in the report. Calendars can be sorted by active year, by school or by year. |
Generate Extract/ Submit to Batch | Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of immediately generating the report by clicking Generate Extract. The batch process allows 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. |
Report Layout
| # | Element | Description | Location | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | District Code | The code that identifies the district and its schools for reporting purposes.
Alphanumeric, 8 characters | School Information > BEDS Code | ||||||||
| 2 | Location Code | The building code of the building in which the student is enrolled. Numeric, 6 digits | Enrollment School Information > Location Code customSchool.value | ||||||||
| 3 | School Year | The school year reports as June 30 of the reported school year. Date field, 10 characters | Calendar Information > School Year >Start / End Date System Administration > Calendar > School Year calendar.endYear | ||||||||
| 4 | Student ID | The student's Local Student Number. Alphanumeric,12 characters | Demographics > Person Identifiers > Local Student Number Person.studentNumber | ||||||||
| 5 | Reporting Date | Reports blank | N/A | ||||||||
| 6 | Primary Learning Device Type Code | The type of device the student uses most often to complete learning activities away from school. Alphanumeric, 3 characters | Student Information > Program Participation > State Programs > Digital Equity | ||||||||
| 7 | School Provided Device Indicator | Indicates of whether the school or district issued the student a dedicated school-owned or district-owned device for the student’s use during the school year. Alphanumeric, 20 Characters | Student Information > Program Participation > State Programs > Digital Equity | ||||||||
| 8 | Primary Learning Device Provider Code | The provider of the primary learning device. Alphanumeric, 20 Characters | Student Information > Program Participation > State Programs > Digital Equity | ||||||||
| 9 | Primary Learning Device Access Code | The primary learning device is shared or not shared with another individual. Alphanumeric, 20 Characters | Student Information > Program Participation > State Programs > Digital Equity | ||||||||
| 10 | Primary Learning Device Sufficiency Indicator | The primary learning device is sufficient for the student to fully participate in learning activities away from school. Alphanumeric, 3 Characters | Student Information > Program Participation > State Programs > Digital Equity | ||||||||
| 11 | Internet Access In Residence Indicator | The student is able to access the internet in their primary place of residence to participate in school requirements. Alphanumeric, 3 characters | Student Information > Program Participation > State Programs > Digital Equity | ||||||||
| 12 | Internet Access Barrier Code | An indication of the primary barrier to having internet access in the student's primary place of residence. Alphanumeric, 25 characters | Student Information > Program Participation > State Programs > Digital Equity | ||||||||
| 13 | Internet Access Type Code | The primary type of internet service used in the student's primary place of residence. Alphanumeric, 20 characters | Student Information > Program Participation > State Programs > Digital Equity | ||||||||
| 14 | Internet Performance Code | Indicates whether the student can complete the full range of learning activities, including video streaming and assignment upload, without interruptions caused by poor internet performance in their primary place of residence. Alphanumeric, 25 characters | Student Information > Program Participation > State Programs > Digital Equity | ||||||||
| 15 | SurveyDate | The actual date on which the survey information was collected. Alphanumeric, 10 characters | Student Information > Program Participation > State Programs > Digital Equity |
