Tool Search: 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
Read - View and generate the report.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights, see the Tool Rights article.
Report Logic
All students enrolled in the selected calendar in the toolbar are included when their Enrollment Start Date is before or equal to the Effective Date entered on the extract editor.
Students are NOT Included when:
- Their enrollment record is marked as No Show or State Exclude.
- They are enrolled in a Grade Level that is marked as State Exclude.
- They are enrolled in a Calendar that is marked as State Exclude or is a Summer School calendar
- Their Enrollment Start Status is E: NON-SAIS DISTRICT USE ONLY! or ZZZ: Same school calendar transfer - Do NOT report to state.
Generate the Report
- Enter an Effective Date in mm/dd/yyyy format, or use the calendar icon to select a date. The current date is pre-populated.
- Verify that .csv is selected for the Format.
- Click the Generate Extract button.
Estimated Enrollment Extract - CSV Format
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. When 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 | Location |
|---|---|---|
| School ID | Reports the School Entity ID. Numeric, 10 digits | System Administration > Resources > School > Entity ID School.entityID |
| 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. When 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 reports only when an IEP is active as of the effective date selected in the extract editor. Alphanumeric, 5 characters
| Student Information > Special Ed > General > Documents > Enrollment Status > Primary Disability 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. Reports a value of Yes when 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 No. Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL Services > Service Type |
| AOI Status | Identifies whether the student is Non AOI, AOI Full-Time, or AOI Part-Time. When the Local Service Type on enrollment that is effective as of the effective date selected in the extract editor is T:AOI, reports as AOI Full-Time. Otherwise, reports as Non AOI. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reporting fields > Local Service Type EnrollmentAZ.localServiceType |
