The Iowa EL Extract reports basic information for students participating in LEP programs.
EL Extract Editor
Report Logic
To report, a student must be actively enrolled in a calendar selected in the extract editor with an Enrollment Start Date on or before the extract Effective Date and an Enrollment End Date on or after the Effective Date. Students must also have an EL Status of 1, 2, or 8:
- EL Status = 1
- Student's EL record with the most recent Identified Date on or before the extract Effective Date has a Program Status of EL or Exited EL and a Program Exit Date of null or after the extract Effective Date.
- Date Parent Waived LIEP Services is after the extract Effective Date or null.
- Student has an EL Service record active on the extract Effective Date.
- Student Serviced Off Site is not checked.
- EL Status = 2
- Student's EL record with the most recent Identified Date on or before the extract Effective Date has a Program Status of EL.
- Date Parent Waived LIEP Services is on or before the extract Effeictive Date and is not null in the most recent EL record.
- Student Serviced Off Site is not checked.
- EL Status = 8
- Student's EL record has a Program Status of Pending.
- PK Potential English Language Learner and Student Serviced Off Site and not checked.
Generating the Extract
- Select the Extract Type to be generated, in this case EL Extract.
- Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date. The current date is entered by default.
- Select an Ad hoc Filter to limit the students in the report to those included in the filter.
- Select the Format in which the report should generate. The HTML format can be used to data review and verification, whereas the CSV format should be used when submitting data to the state.
- Indicate which Calendar(s) should be included in the report.
- Click Generate Extract to generate the report in the designated format or Submit to Batch to schedule when the report will generate.
Users have the option of submitting a EL Extract request to the batch queue by clicking Submit to Batch instead of Generate Extract. This 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.
EL Extract - CSV Format
EL Extract - HTML Format
Extract Layout
Element Name | Description | Campus UI and Database Location |
|---|---|---|
| District ID | The code assigned to the district submitting the report. Numeric, 8 digits | System Administration > Resources > District Info > State District Number District.number |
| School ID | The code assigned to each school building by the Iowa Department of Education. Numeric, 4 digits | System Administration > Resources > School > Number School.number |
| Student Last Name | The legal last name of the student. Alphanumeric, 60 characters | Census > People > Demographics > Last Name OR Census > Identities > Protected Identity Info > Last Name Identity.lastName |
| Student First Name | The legal first name of the student. Alphanumeric, 60 characters | Census > People > Demographics > First Name OR Census > Identities > Protected Identity Info > First Name Identity.firstName |
| Student Middle Name | The legal middle name of the student. Alphanumeric, 60 characters | Census > People > Demographics > Middle Name OR Census > Identities > Protected Identity Info > Middle Name Identity.middleName |
| Birth Date | The student's date of birth. Date field, 8 characters, MMDDYYYY | Census > People > Demographics > Birth Date Identity.birthDate |
| SSID | The state-assigned student identification number. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
| Grade | The student's current grade level. Alphanumeric, 2 characters | Student Information > General > Enrollments > Grade Enrollment.grade |
| Gender | Indicates the gender of the student. Alphanumeric, 1 character, M, F, or X | Census > People > Demographics > Gender Identity.gender |
| Hispanic or Latino Ethnicity | Indicates if the student is of Hispanic/Latino ethnicity. Alphanumeric, Y or N | Census > People > Demographics > Race/Ethnicity Identitiy. hispanicEthnicity |
| American Indian or Alaska Native | Indicates if the student is of American Indian or Alaska Native descent. Alphanumeric, Y or N | Census > People > Demographics > Race/Ethnicity Identity. |
| Asian | Indicates if the student is of Asian descent. Alphanumeric, Y or N | Census > People > Demographics > Race/Ethnicity Identity. |
| Black or African American | Indicates if the student is of Black or African American descent. Alphanumeric, Y or N | Census > People > Demographics > Race/Ethnicity Identity. |
| White | Indicates if the student is of White descent. Alphanumeric, Y or N | Census > People > Demographics > Race/Ethnicity Identity. |
| Native Hawaiian or Other Pacific Islander | Indicates if the student is of Native Hawaiian or Other Pacific Islander descent. Alphanumeric, Y or N | Census > People > Demographics > Race/Ethnicity Identity. |
| IEP Status | Indicates if the student is receiving services through an IEP. Reports as Y if IEP Level is 0, 1, 2, or 3. Reports as N if IEP Level is 99 or null. If null, reports default value if entered. Alphanumeric, Y or N | Student Information > General > Enrollments > Special Ed Fields > IEP Level Enrollment. specialEdSetting |
| English Learner Status | Indicates if the student is participating in an LEP program. Reports based on the student's most recent LEP record, with an Identified Date on or before the extract Effective Date. If the record has a Program Status of Pending and PK Potential English Language Learners (PELL) is not marked, reports as P. If the record has a Program Status of EL or Exited EL and has a Program End Date that is null or after the extract Effective Date, reports as Y. Alphanumeric, Y or P | Not dynamically stored |
| Paper Tester | Currently reports as null. | N/A |
| Section 504 | "Y" when the following are true:
Alphanumeric, Y or N | Section504.startDate Section504.endDate |
