Charter Estimated Counts
The Charter Estimated Counts report is used to report student school enrollment information to ADE for Charter Schools before the 40th Day.
The report lists all students enrolled in school on the Snapshot Date. It is designed to run after the PowerSchool End-of-Year process is performed for the previous school year.
Before running this report, verify that students have school enrollments for the current school year, and have been enrolled in their applicable Student SPED Service Participation and Student Language Program Participation Needs.
This report is designed to run at the School level and not at the District Office.
This report is updated to consider Concurrent Enrollments created using the Functions > Create New Concurrent Enrollment function (or through import). Students will be included in the concurrently enrolled school's report as well as their HOME school report if enrolled in two or more schools at the same time.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the [Students] and [ReEnrollments] and [S_AZ_STU_CONENR_C] tables based on the following criteria:
- The student must be enrolled in the school on the report run date, or on the first day of the upcoming school year if the report is run before the start of the school year.
- The student is not excluded from state reporting ([Students]State_ExcludeFromReporting does not equal 1)
- The student's exit date (ExitDate) does not equal his entry date (EntryDate).
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Report Parameters | Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Select All from the pop-up menu. To clear all checkboxes, choose Clear All. |
Charter Holder Name * | Enter the Charter Holder Name for the Charter School. |
Contact Name * | Enter the name of the contact to address questions. |
Contact Telephone * | Enter the phone number of the contact listed above. |
Contact Email * | Enter the email address of the contact listed above. |
Bypass Validation Mode * | Choose one of the following from the pop-up menu:
|
Snapshot Date* | Enter a date for determining student enrollment. Any students active on the date entered will be included. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Data Element | Description | [Table]FieldName |
|---|---|---|
Data Header Definition | ||
CTDS Number | The CTDS number (county-type-district-school number). | [S_AZ_SCH_X]CTDSOverride or [Prefs]Value [Prefs]Name=districtnumber [Schools]School_Number |
Charter Name | The Charter Holder Name entered at run-time is reported. | N/A |
Charter Site Name | The School Name at the top of the page is reported. | [Schools]Name |
Contact Name | The Contact Name entered at run-time is reported. | N/A |
Contact Telephone | The Contact Telephone entered at run-time is reported. | N/A |
Contact Email | The Contact Email entered at run-time is reported. | N/A |
Student List Definition | ||
First Name | Student's first name | [Students]First_Name |
MI | Student's middle initial. The first character of the student's middle name is reported. | [Student]Middle_Name |
Last Name | Student's last name | [Students]Last_Name |
Birth Date | Student's date of birth. Data Format: Numeric (MMDDYY) 6-digits | [Students]DOB |
Previous LEA | The name of the district or charter school the student attended in the previous school year OR the ISE / Non-ISEP data if applicable. Previous LEA is calculated as follows:
Note: For Charter Schools receiving Indian School Equalization Program (ISEP) funds, see page 91 of this document. | Calculated. [Students]AZ_PreviousLEA [ReEnrollments]AZ_PreviousLEA [S_AZ_STU_CONENR_C]PREVIOUSLEA [ReEnrollments]Schoolid [ReEnrollments]ExitCode [Schools]Name |
Grade Level | Student's grade level Note:
| [Students]Grade_Level [ReEnrollments]Grade_Level [S_AZ_STU_CONENR_C]GRADE_LEVEL [Students]UngradedElementary [Reenrollments]UngradedElementary [S_AZ_STU_CONENR_C]UngradedElementary |
SPED Category | Student's primary SPED Service Participation Need Code active on count date. If a student has more than one applicable 14 Need record, the Federal Primary Need is reported. If no 14 Need is designated as the Federal Primary, then the Primary Concurrency record is reported. | [AZ_StudentSPED_Service]EntryDate [VirtualTablesData]user_defined_date [AZ_StudentSPED_Service]SPEDNeedCode [VirtualTablesData]user_defined_text |
Service Type | Student's primary SPED Service Participation Need Code. The Service Code value of the SPED Service Participation Need reported above. | [AZ_StudentSPED_Service]SPEDServiceCode [VirtualTablesData]user_defined_text2 |
ELL Status | Indicates if ELL Services will be provided to the student.
| [AZ_StudentLanguageProgramParticipation]EntryDate [VirtualTablesData]user_defined_date |
AOI Status | Indicated if a student is Non AOI, AOI Full-Time, or AOI Part-Time.
| Calculated [Students]EnrollmentType [ReEnrollments]EnrollmentType [S_AZ_STU_CONENR_C]ENROLLMENTTYPE [Students]Fteid [ReEnrollments]Fteid [S_AZ_STU_CONENR_C]FTEID [FTE]Value |
Validation Option
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Error Message | Description |
DOB cannot be blank. | Each student must have a date of birth.
|
Enrollment Type Value is incorrect for the student's Enrollment School Type. AOI Students must have an EnrollmentType value of T (Online). | Students attending an Online School (Schools.AZSchoolType = 2) must have an Enrollment Type value of Online (Students/ReEnrollments.EnrollmentType = T).
|