Closing out the School Year (Year End Enrollment)
Closing out the School Year (Year End Enrollment) ↑
The following functions and process MUST be completed after the end of the school year to ensure clean data reporting to CALPADS.
- Process Matriculating students – see the following for more information:
EOY2: Reporting Matriculating Students to CALPADS
- Process Graduating students – see following for more information:
FAQ: How does a district report graduating or matriculating students?
- Run the Calculate College Entrance Requirements button on the Graduation/College Readiness Dashboard page to update the “UC/CSU Course Completer” fields. Or run Macro Update College Entrance Requirements to update the “UC/CSU Course Completer” fields in Client.
- The STU.CCO (Course Completer Over-ride) field can be used when the information available in Aeries does not match the reality of the student's course history and/or how that course history reflects his UC/CSU Course Completion Status.
- Run the End of Year Enrollment Update
- SENR submission to close out enrollments
- The extract will submit an E155 Exit code (Year End Enrollment Exit) for all active students when the last school day is within 14 calendar days (or less) from the current date. This code will not display in Aeries. This code will be included in the CALPADS SENR extract.
- The only exceptions to this rule are the following:
- Open Enrollment records for students with Next Grade (STU.NG) = 13 (graduating seniors) will be excluded from this process and will NOT have an E155 exit submitted. If the End of Year (STU.EOY) or the Completion Status (STU.HSG) fields are blank, the student's SENR record will NOT contain an exit code. This is by design, because every 12th grade students needs to have the correct End of Year or Completion Status code submitted. If the 12th grade student will be returning to school the follo, their Next Grade field needs to be changed from 13 to 12. The student will be rolled into the new year database.
- Open Enrollment records for Secondary Students will be closed out with the exit code of E170 as required by CALPADS.
- The extract will submit an E156 (GD12ContinuedED) exit code for all active students with a STU.GR = 12, the STU.NG = 12 and the extract is within 14 Days Before the End of the School Year. This code will not display in Aeries. This code will be included in the CALPADS SENR extract.
- In order to not extract E155 or E156 codes prior to the last day of school, an option is available on the Other Options tab. See Student Data Management - E155, E156 and E150 Exit Codes for details.
- The option "Do not extract future dates" will suppress any future enrollment dates from being extracted in SENR. This option also includes suppressing the End of Year and Completer codes from being extracted when populated. However, it is not recommended to populate the EOY and HSG fields until the school year has officially ended. Pre-populating these fields prior to the end of the school year can cause issues for testing in TOMS which will cause the student to no longer be enrolled as well as more cleanup for students that leave the school before the last day of the school year resulting in negatively impacting your Cohort data on the CA Dashboard.
- This option will also suppress extracting the E155 and E156 codes even if the Auto-close E155/E156 option on Other Options tab is selected.
- SELA submission to report the end of year RFEP re-designated students
- SPRG submission to close out all open Participation records
- The extract will populate an end date in the SPRG extract for Education Program Codes of 101, 108, 113, 122, 162, 174 and 185 when the last school day is within 30 calendar days (or less) from the current date.
- SPRG submission to close out Free and Reduced records
- The extract will populate an end date in the SPRG extract for Free and Reduced (code 181 or 182) students when the last school day is within 30 calendar days (or less) from the current date.
- SENR submission to close out enrollments
Matriculating Students ↑
Matriculating students need to be coded correctly in Aeries in order to close out the student’s enrollment in the prior year. A matriculating student is a student who has completed the highest grade level in the school and will be moving on to the next school in your district.
Matriculating Students MUST have the Grad Status (STU.HSG) field populated with a 480 or 480. Optionally, the Date Graduated (STU.DG) can be populated, but it is not required.
An end of year Enrollment Update (SENR File) must be performed to report the Enrollment for Matriculating Students to CALPADS.
The End Of Year (STU.EOY) field should not be populated.
Code Values ↑
For Matriculating Students, you MUST populate the STU.HSG (Grad Status) field with a code of 480 - Promoted (matriculated to CA public schls) or 485 Promoted (matriculated Out of CA public schls) for each of the highest grade level students at that school. These codes must be mapped to the CALPADS code value. For more information on this process reference the CALPADS Extracts - Code Translations document.
Data Population ↑
The STU.HSG code of 480 can be mass added to the matriculating students by using the following query:
CHANGE STU STU.HSG TO 480 IF STU.HSG = " " AND GR = X (Replace X with highest grade level in that school). Students who have been retained should be reviewed individually.
IMPORTANT – Fix ENR Records process needs to be run after the Query CHANGES.
AERIES will automatically populate the Exit Reason with the E230 Completion Code, as well as the exit date (as the last active day of school year) in the CALPADS extract when the 480 code is in the STU.HSG field.
Graduating Students ↑
Graduating students need to be coded in Aeries in order to correctly report them to CALPADS. All graduating students must have the Completion Status code (STU.HSG), Completion Date (STU.DG) and Graduation Exemption Indicator fields populated. The Completion Status code must be mapped to the CALPADS Completion Status code translated on the Code Translations form in Aeries.
An end of year Enrollment Update (SENR File) must be performed to report the Enrollment for Graduating Students to CALPADS. As of 2023-2024 school year, the Graduation Exemption Indicator must also be populated. See CALPADS 2023-2024 changes.
See Mass Update Graduation Status for instructions on mass updating the graduation status code and date.
CODE VALUE TRANSLATIONS
The Code Value Translations tab on the Create CALPADS Extracts form MUST be verified in each school year you are extracting from. Below is an example of the Completer Status code set.
GRADUATES ATTENDANCE
It is not recommended to give a regular graduating senior a leave tag OR an attendance leave record. If the STU.HSG and STU.DG fields are populated, the CALPADS extracts will add a CALPADS exit reason of E230 – Completer Exit.
Queries can be run to mass populate the STU.HSG and STU.DG fields for 12th graders:
CHANGE STU STU.HSG TO 100 IF GR = 12 AND STU.HSG = " "
CHANGE STU DG TO MM/DD/YYYY IF GR = 12 AND DG = NULL
NOTE: Do not mass change these fields until the end of the current school year. Mass changing them prior to the end of the school year can cause errors in CALPADS extracts.
IMPORTANT – Fix ENR Records process needs to be run after the Query CHANGES.
EARLY GRADUATES
In addition to the STU.HSG and STU.DG fields populated, early graduates need to have an exit tag and an attendance leave record with the exit reason of "230". Early grads are the only graduates that need an attendance leave record.
CALPADS Codes ↑
Below is a chart of the codes that CALPADS uses for School Completion Status:
Code | Description | Long Description |
100 | Graduated, standard HS diploma | The student left school after meeting all state and local high school graduation requirements and received a standard high school diploma, or a student in foster care who met the state and local graduation requirements of a district they previously attended, as specified in Education Code Section 51225.3. |
120 | Special Education certificate of completion | A student with exceptional needs (having an individualized education program [IEP] left school after receiving a certificate or document of educational achievement or completion meeting the requirements of Education Code Section 56390. |
250 | Adult Ed High School Diploma | The student left school and the district has acceptable documentation of the student having received a high school diploma through an adult basic education program. |
320 | Completed GED (and no standard HS diploma) | Student left school and the district has acceptable document of the student having received a General Educational Development (GED) certificate. |
330 | Passed CHSPE (and no standard HS diploma) | Student left after passing the California High School Proficiency Exam (CHSPE), and the district has acceptable documentation. |
360 | Completed grade 12 without completing graduation requirements, not grad | Student completed grade 12 or exceeded the maximum age for high school attendance but did not meet the state and/or local high school graduation requirements, and there is no evidence that the student is in an academic program leading toward a high school diploma or its equivalent. This does not include students who did not graduate because of failure to pass the California High School Exit Exam. |
480 | Promoted (matriculated to CAPubSchl) | The student completed the highest grade level offered at a school (excluding high school completion), left the school, and was expected to attend another California public school. |
485 | Promoted (matriculated Out of CA public Schls) | The student completed the highest grade level offered at a school (excluding high school completion), left the school, and was expected to attend another California public school but moved out of CA public schools. |