Classic View: CO State Reporting > Data Pipeline > SPED IEP Interchange > Special Education Child
Search Terms: SPED IEP Interchange
The Special Education Child Report captures and verifies the attributes of students who have disabilities as of the annual count date.
Special Education Child Extract
Report Logic
At least one of the following must be true in order for a student to be reported:
- At least one date (Special Education Start Date, Special Education End Date) falls within the reporting period.
- The student has an active and locked IEP AND at least one date of the plan falls within the reporting period.
- The student has an active and locked Evaluation AND the Effective Date of the evaluation falls within the reporting period.
Only one record per administrative unit code reports for the student.
This report does not include students who have an ILP or other plan type that is not an IEP.
Records are not included when:
- The student's enrollment record is marked as a No Show.
- The enrollment record is marked as State Exclude.
- The Grade Level of enrollment is marked as State Exclude.
- The Calendar selected is marked as State Exclude.
Report Editor
| Field | Description |
|---|---|
| Report Type | Selection determines the Special Education Interchange report that generates. Choose Special Education Child. |
| Ad hoc Filter | Select a saved ad hoc filter to only include those students in the filter in the report, assuming those students meet the reporting logic and business rules of this report. |
| Start Date/End Date | The entered date is auto-populated to the current first and last dates of the selected calendar in the Campus toolbar. Students who have an Evaluation or IEP during the entered date range, even when the enrollment record is ended during the date range, are included on the report. |
| Report Legal Name | When marked, the student's name and gender report from the Protected Identity Information section on the student's Identities record. |
| Report Format | This report can be generated in either CSV or HTML formats. |
| Calendar Selection | At least one calendar needs to be selected in order to generate the report. Reports can be selected by Active Year, School or Year. |
| Report Generation | Use the Generate Report button to display the results of the report immediately. Use the Submit to Batch option to determine when the report generates. Submit to Batch is helpful when generating the report for multiple calendars and a large range of dates. |
Generate the Report
- Select the Special Education Child option from the Report Type field.
- If desired, select students from an existing Ad hoc Filter.
- Enter the desired Start and End Dates.
- Mark the Report Legal Name, if desired.
- Select the Report Format of the report.
- Select the Calendar(s) from which to report information.
- Click the Generate Extract button or the Submit to Batch button. The report displays in the desired format.
Special Education Child Report, CSV Format
Special Education Child Report, HTML Format
Report Layout
| Data Element | Description | Location |
|---|---|---|
Administrative Unit | The Administrative Unit Code assigned to the school by the Colorado Department of Education. This code is entered on the School tab. Numeric, 5 digits | System Administration > Resources > School > School Detail > Admin Unit Code School.adminUnitCode |
LASID | The district-defined local student ID. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > Local Student Number Person.studentNumber |
SASID | The unique 10 digit number assigned to each student by the Colorado Department of Education. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
| First Name | Reports the student's first name. When the Report Legal Name checkbox is marked, the student's First Name reports from the Legal First Name field. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > First Name Identity.first Name Census > People > Identities > Protected Identity Information > Legal First Name Identity.legalFirstName |
| Middle Name | Reports the student's middle name. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > Middle Name Identity.middleName Census > People > Identities > Identities Editor > Middle Name Identity.legalMiddleName |
| Last Name | Reports the student's last name. When the Report Legal Name checkbox is marked, the student's Last Name reports from the Legal Last Name field. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > Last Name Identity.last Name Census > People > Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
| Gender | Reports the student's gender.
When the Report Legal Name checkbox is marked, the student's Gender reports from the Legal Gender field. Numeric, 2 digits | Census > People > Demographics > Person Information > Gender Identity.gender Census > People > Identities > Protected Identity Information > Legal Gender Identity.legalGender |
Birth Date | The student's date of birth. Date field, 8 characters (MMDDYYYY) | Census > People > Demographics > Person Information > Birth Date Identity.birthDate Census > People > Identities > Identities Editor > Birth Date |
ELL | Indicates if the student is Limited English Proficient (LEP) or an English Language Learner (ELL). The most recently created LEP Services record with an End Date equal to or greater than the Effective Date entered on the Report Editor reports as follows:
Numeric, 1 digit | Student Information > General > Program Participation > LEP > LEP Services Lep.LEP |
Hispanic or Latino | Indicates if the student has a race ethnicity of Hispanic/Latino. This includes students of Cuban, Mexican, Puerto Rican, South or Central American or other Spanish culture or origin, regardless of race. If the student is Hispanic/Latino, this field reports 1. If not, this field reports 0. Numeric, 1 digit | Census > People > Demographics > Person Information > Race Ethnicity > Is the Individual Hispanic/Latino? Identity.hispanicEthnicity Census > People > Identities > Identities Editor > Race/Ethnicity > Is the Individual Hispanic/Latino? |
American Indian or Alaskan Native | Indicates if the student has a race ethnicity of American Indian or Alaskan Native. If yes, this field reports as 1. If not, this field reports 0. Numeric, 1 digit | Census > People > Demographics > Person Information > Race Ethnicity > American Indian or Alaskan Native Identity.raceEthnicity Census > People > Identities > Identities Editor > Race/Ethnicity > American Indian or Alaskan Native |
Asian | Indicates if the student has a race ethnicity of Asian. If yes, this field reports 1. If not, this field reports 0. Numeric, 1 digit | Census > People > Demographics > Person Information > Race Ethnicity > Asian Identity.raceEthnicity Census > People > Identities > Identities Editor > Race/Ethnicity > Asian |
Black or African American | Indicates if the student has a race ethnicity of Black or African American. If yes, this field reports 1. If not, this field reports 0. Numeric, 1 digit | Census > People > Demographics > Person Information > Race Ethnicity > Black or African American Identity.raceEthnicity Census > People > Identities > Identities Editor > Race/Ethnicity > Black or African American |
White | Indicates if the student has a race ethnicity of White. If yes, this field reports 1. If not, this field reports 0. Numeric, 1 digit | Census > People > Demographics > Person Information > Race Ethnicity > White Identity.raceEthnicity Census > People > Identities > Identities Editor > Race/Ethnicity > White |
Native Hawaiian or Other Pacific Islander | Indicates if the student has a race ethnicity of Native Hawaiian or Other Pacific Islander. If yes, this field reports 1. If not, this field reports 0. Numeric, 1 digit | Census > People > Demographics > Person Information > Race Ethnicity > Native Hawaiian or Other Pacific Islander Identity.raceEthnicity Census > People > Identities > Identities Editor > Race/Ethnicity > Native Hawaiian or Other Pacific Islander |
| Student's District of Residence | Reports the four-digit code of the school where the student resides. If this field is null or is less than four digits, the value reports from the State District Number field. Numeric, 4 digits | Student Information > General > Enrollments > State Reporting Fields > Resident District or State Enrollment.residentDistrict |
| Parents Resident or Non-Resident Students State | Reports the two-character state code if the Resident District or State field is populated with a two-digit state code. Otherwise, the field reports 00. Numeric, 2 digits | Student Information > General > Enrollments > State Reporting Fields > Resident District or State Enrollment.residentDistrict |
| District Parents Residence | Reports the four-digit code indicating the student's district of residence if the field is populated. Otherwise, the field reports 0000. Numeric, 4 digits | Student Information > General > Enrollments > State Reporting Fields > Resident District or State Enrollment.residentDistrict |
