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	Accepted Values: MARCH OCTOBER
7	Projection Type	True	Mapped ID	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
9	Final Projection	False	Integer
10	Difference	False	Integer (Small)	A calculated column which shows the difference between the LEA Projection and Final Projection.

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
Calculated Column	Column which is calculated based on other data (provided in submission or otherwise); these columns can be left blank
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.

• No common errors