You are here

Data Pipeline Snapshots - End of Year


The Student End of Year snapshot collects student enrollment information throughout the school year.  This information includes student demographic identifiers, codes indicating the way students enroll and withdrawal from a district, and services students received.  This information is used to calculate dropout, graduation, and completion rates. Additional information about the rates generated by this collection is provided in the rate and report information section below.


The 2020-2021 Student End of Year collection opens on Wednesday, May 12, 2021. 

The collection is in a soft open phase March 1, 2021 through May 12, 2021. Business rules and documentation will continue to be updated through the spring.

The EOY collection is broken into three phases. Please see the relevant sections below for more specific instructions for that phase.

File Layout and Definitions


Business Rules and Exceptions

Regular Process

During the regular process, districts must upload the Student Demographic, Student School Association, and the Graduation Guidelines files for the Student End of Year Snapshot. More information about those interchange files can be found on the Student Interchange page (link).

Please see the Snapshot file layout for more information about which students are included in the EOY collection 


2020-2021 - Training Schedule

Trainings will be offered from March to October 2021. Trainings will cover a variety of topics (please see calendars below). If you are unable to attend a training, the recording and PPT will be posted below after.

Training Materials


Cross LEA process

The Cross LEA process validates if a student previously enrolled in a district have been recovered by another Colorado School district or completed a High School Equivalency Diploma test after exiting the prior district. During this phase most SE700 level warnings are elevated to errors and require district attention. 

EOY Adjustment File - File Layout, Template, Business Rules

The EOY Adjustment file is used to provide additional information about students who were previously enrolled in a district and did not enroll in the current school year. It is typically loaded to address Cross LEA errors, although it can be loaded anytime in the collection.


Adjustment File Instruction for SE700 Errors

Post-Cross LEA Validation Instructions

Adequate Documentation of Transfer

Post Cross LEA SE903 Errors require districts to provide adequate documentation for students who are reported as transferring out of district who were not subsequently reported in another district. More information and templates are provided on the page below.

Rate and Report Information

The End of Year collection provides the data used to calculate graduation, completion, dropout and mobility rates for districts on our Educational Statistics page. This information is published online in January the following year in compliance with state and federal law. Districts have access to advanced reports that provide tentative calculations through the Cognos system in the data pipeline.

Graduation and Completion Rates

Dropout Rates

Mobility/Stability Rates


Contact: Jesse Cooper at: