Enrollment Projections

Documentation

Purpose

DC PCSB asks for enrollment projections for each campus and grade, as well as for each UPSFF funded category at each campus, for multiple points during a school year.

Data Quality Checks

Because enrollment projections are a cohesive set of data, any of the errors below will cause the entire set of projections to be rejected. For each projection period: - The total number of students projected in enrollment grades must be less than or equal to the LEA’s enrollment ceiling - The number of students projected to be at risk must be less than or equal to the total number of students projected at the campus - The number of students projected to be english learners must be less than or equal to the total number of students projected at the campus - The number of students projected to be students with disabilities must be less than or equal to the total number of students projected at the campus - The number of students projected to be residential must be less than or equal to the total number of students projected at the campus, where applicable - The number of students projected to be both residential and english learners must be less than or equal to the total number of students projected as residential at the campus - The number of students projected to be both residential and students with disabilities must be less than or equal to the total number of students projected as residential at the campus For extended school year projections: - The total number of students projected in extended school year special education must be less than or equal to the highest number students projected to be special education in a single projection period

Multiple Projection Periods (2017-11-01)

In 2018-2019, DC PCSB asked LEAs to project enrollment for multiple times during the year. These different periods are represented in the projection periods column. Some projections (e.g. Extended School Year) are only projected at specific points in the year. For 2019-2020, DC PCSB returned to asking for only October projections.

---

Key Information

• Users Can Submit Data During Submission Window Only
• Users Cannot Create, Can Update Rows

---

Collection Template

Position	Column Name	Required	Format	Description
0	Data Type	True	Text	Enrollment Projections
1	LEA ID	True	Integer (Small)
2	LEA	False	Text
3	Campus ID	True	Integer (Small)
4	Campus	False	Text
5	School Year	True	Text	YYYY-YYYY
6	Projection Period	True	Mapped ID	The time period the record refers to; this field must remain exactly as-is. Accepted Values: MARCH OCTOBER
7	Projection Type	True	Mapped ID	The type of projection the record refers to; this field must remain exactly as-is. Accepted Values: 01 02 03 04 05 06 07 08 09 1 10 2 3 4 5 6 7 8 AT RISK - ALL STUDENTS AT RISK - OVER 40% CONCENTRATION SUPPLEMENT AT RISK - OVER 70% CONCENTRATION SUPPLEMENT (EXCLUDES OVER 40%) AT RISK - OVER-AGE STUDENTS - HIGH SCHOOL (GRADES 9-12) ENGLISH LEARNER - ELEMENTARY (ALL GRADES EXCLUDING 6-12) ENGLISH LEARNER - SECONDARY (GRADES 6-12) PK3 PK4 RESIDENTIAL - ENGLISH AS A SECOND LANGUAGE (LEP/NEP)
8	LEA Projection	False	Integer	The LEA's projection for the funding category and period. This is the only field for which the LEA must provide data.
9	Final Projection	False	Integer	The final projection made by DC PCSB. This number is reported to the City Council.
10	Difference	False	Integer (Small)	The difference between the Final Projection and the LEA's Projection.. Can be left empty.
11	Optional Explanation for Significant/Unusual Changes	False	Text	Please explain here any significant or unusual changes from the prior school year. While this field is optional, completing it may reduce the need to engage in subsequent conversation or correspondence.

Shading Key

Primary Key Column	Column(s) which uniquely define the row, and is required in all submissions
Expected Column	Column which is expected in a complete submission; in case where the data are missing and the column is not required, these columns may be left blank
Non-Required Column	Column which is not required; these columns contain data that are loaded, but are not required for a row to be considered complete
Non-Loaded Column	Column which is not loaded; these columns are provided to support use of the table, but can be left blank in submissions

---

Common Errors

Click on the error type to get more information.

• Row Not Associated With Realm

• Submission Constraint (During Window Only)