PATH: AZ State Reporting > Estimated Enrollment Extract
Search Term: Estimated Enrollment Extract
The Charter School Estimated Enrollment Extract reports students actively enrolled as of the Effective Date selected on the report editor for the school selected in the Campus toolbar. The report can only be generated in .CSV format.
This report is no longer collected by the Arizona Department of Education and remains within Campus for retrieval of historical data which can be sent to the state for auditing purposes.
Note: Charter schools are still allowed to use the Estimated Enrollment Extract for sending information to the Arizona Department of Education.
Users should submit data to the state via Ed-Fi (AZeds) functionality. For more information about Ed-Fi, see the following article: Arizona Ed-Fi Information.
Charter School Estimated Enrollment Extract Editor
Report Logic
- The first row of the report includes header fields and all remaining rows contain student data.
- Student enrollment records marked as No Show are NOT included.
- Students are NOT included if the student's enrollment record is marked as State Exclude.
- Students are NOT included if the Grade Level of enrollment is marked as State Exclude.
- Students are NOT included if the Calendar of enrollment is marked as State Exclude.
Extract Example
Charter School Estimated Enrollment Extract Example
Report Header
| Field | Definition | Campus UI and Database Location |
|---|---|---|
| CTDS Number | The County-Type-District-Site ID. This number is created by combining the District Number and School Number. | System Administration > Resources > District Information > District Number System Administration > Resources > School District.number School.number |
| Charter Name | The name of charter holder. This field reports from Resources > School > Agency. If the Agency field is null, the District > Name reports. | System Administration > Resources > School > Agency OR District > Name District.name |
| Charter Site Name | The name of the charter site. | System Administration > Resources > School > School Detail > Name School.name |
| Contact Name | The contact to whom questions are addressed. | System Administration > Resources > School > Principal Name School.principalName |
| Contact Telephone | Phone number of contact. | System Administration > Resources > School > Phone School.phone |
| Contact Email | E-mail address of contact. | System Administration > Resources > School > Principal Email School.email |
Extract Layout
Element Name | Description | Type, Format and Length | Campus UI and Database Location |
|---|---|---|---|
| First Name | The student's first name. | Alphanumeric, 20 characters | Census > People > Demographics > First Name Identity.firstName |
| Middle Initial | The student's middle initial. | Alphanumeric, 1 character | Census > People > Demographics > Middle Name Identity.middleName |
| Last Name | The student's last name. | Alphanumeric, 30 characters | Census > People > Demographics > Last Name Identity.lastName |
| Birth Date | The student's date of birth. | Date field, 10 characters mm/dd/yyyy | Census > People > Demographics > Birth Date Identity.birthDate |
| Grade Level | The student’s grade for the upcoming school year. | Numeric, 2 digits | Student Information > General > Enrollments > Grade Enrollment.grade |
| SPED Category | The SPED Category reports from the most recent/current locked Plan as of the Effective Date of the report. If a student's Special Ed Status has been ended (IEP End Date, Exit Date) on or before the Effective Date entered on the report editor, no value is reported. A value is reported only if an IEP is active as of the effective date selected in the extract editor.
| Alphanumeric, | Student Information > Special Ed > General > Documents > Enrollment Status > Primary Disability OR Student Information > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Documents > Plan record > Education Plan > IEP End Date Student Information > General > Documents > Eval record > Evaluation Editor > Exit Date Enrollment.disability1 |
| ELL Status | Identifies whether ELL services will be provided. Report 'Y' if the student has an EL Service record with A Service Type matching one of the following: A1, B1, B2, B3, A2, A4, A5 Otherwise, report a value of 'N'. | Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL Services > Service Type Not dynamically stored |
| AOI Status | Identifies whether the student is Non AOI, AOI Full-Time, or AOI Part-Time. If Local Service Type on enrollment that is effective as of the effective date selected in the extract editor is 'T:AOI', report 'AOI Full-Time' Else, report 'Non AOI' | Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reporting fields > Local Service Type EnrollmentAZ.localServiceType |
