Data Pipeline Interchanges - Student

Overview

The Student Interchange is a set of four files, Student Demographic, Student School Association, Graduation Guidelines and Adjustment files, which contain student information for a school year. This information is used in the following collections: Student October, Special Education December Count, Special Education Discipline, Student End of Year, and Student Biographical Data.

Deadlines

The 2022-2023 Student Interchange files are open for uploads. The 2023-2024 Student Interchange will open on July 17, 2023.

• Student Interchange Timeline (PDF) (posted 8/16/2022)
  • ​This document provides a broad overview of the Student Interchange and how it is utilized throughout school year for data collections.

File Layout and Definitions

• Historical Student Interchange File Layouts

2023-2024

• 2023-2024 Student Demographic File Layout (PDF) (posted 3/28/2023)
• 2023-2024 Student School Association File Layout (PDF) (posted 3/28/2023)
• 2023-2024 Graduation Guidelines File Layout (PDF) (posted 3/28/2023)
• 2023-2024 Adjustment File Layout (PDF) (posted 3/28/2023)
  • ​Only used in specific circumstances during the Student End of Year Collection
  • Opens in May with the start of the Student End of Year Collection

2022-2023

• 2022-2023 Student Demographic File Layout (PDF) (updated 2/2/2023)
• 2022-2023 Student School Association File Layout (PDF) (posted 3/31/2022)
• 2022-2023 Graduation Guidelines File Layout (PDF) (posted 3/31/2022)
• 2022-2023 Adjustment File Layout (PDF) (posted 3/31/2022)
  • ​Only used in specific circumstances during the Student End of Year Collection
  • Opens in May with the start of the Student End of Year Collection

Business Rules

2023-2024

• 2023-2024 Student Demographic Business Rules (XLSX) (posted 5/1/2023)
• 2023-2024 Student School Association Business Rules (XLSX) (posted 5/1/2023)
• 2023-2024 Graduation Guidelines Business Rules (XLSX) (posted 5/1/2023)
• 2023-2024 Adjustment File Business Rules (XLSX) (posted 5/1/2023)

2022-2023

• 2022-2023 Student Demographic Business Rules (XLSX) (updated 3/29/2023)
• 2022-2023 Student School Association Business Rules (XLSX) (updated 3/29/2023)
• 2022-2023 Graduation Guidelines Business Rules (XLSX) (updated 3/29/2023)
• 2022-2023 Adjustment File Business Rules (XLSX) (posted 2/7/2023)

Templates

2023-2024

• 2023-2024 Student Demographic Template (XLSX)
• 2023-2024 Student School Association Template (XLSX)
• 2023-2024 Graduation Guidelines Template (XLSX)
• 2023-2024 Adjustment File Template (XLSX)
  • Adjustment File Instructions (PDF) (posted 3/11/2023)
• ​2023-2024 Exception Request Template and Instructions (XLSX)
  • July 2023 - December 2023, Contact Brooke Wenzel 
  • January 2024 - December 2024, Contact Reagan Ward
• Mid-Year EL Coding Changes Additional Documentation
  • This form is used when a student's EL coding is changing after October Count in the same school year and same district with an EL history > 2 years (3 Student October, 2 Student End of Year collections).
  • Contact Reagan Ward

2022-2023

• 2022-2023 Student Demographic Template (XLSX)
• 2022-2023 Student School Association Template (XLSX)
• 2022-2023 Graduation Guidelines Template (XLSX)
• 2022-2023 Adjustment Template (XLSX)
  • Adjustment File Instructions (PDF) (posted 3/11/2023)
• 2022-2023 Exception Request Template and Instructions (XLSX)
  • July 2022 - December 2022, Contact Brooke Wenzel 
  • January 2023 - December 2023, Contact Reagan Ward
• Mid-Year EL Coding Changes Form (updated 3/30/2023)
  • This form is used when a student's EL coding is changing after October Count in the same school year and same district with an EL history > 2 years (3 Student October, 2 Student End of Year collections).
  • Contact Reagan Ward

Training

Webinars

• Graduation Guidelines: Reporting GG File Overview (PPT) (Recording) (posted 4/6/2022)
• Office Hours Presentation (PPT) (Recording) (posted 8/17/2022)
• 2022-2023 Collaborative Monitoring of Graduation Guidelines (PPT) (Recording) (posted 11/15/2022)
• EL Coding Training (PPT) Recording (posted 9/9/2022)

Short Bytes

• English Learners: Overview & Progression (Recording) (PPT) (posted 5/23/2023)
• English Learner Exceptions: October to Student End of Year (Recording) (PPT) (posted 3/31/2023)
• Student Interchange New Respondent Overview (Recording) (posted 4/3/2023)
• Entry & Exit Types/Dates (Recording) (PPT) (posted 4/24/2023)
  • ​SEY Entry/Exit Code Guide (PDF)
• Foster Care (Recording) (PPT) (posted 5/26/2023)
• Grade Level Checks: Retention Codes & Grade Reassignments (Recording) (PPT) (posted 4/24/2023)

Additional Resources

• Cognos Report Guide (PDF) (posted 5/10/2022)
• Graduation Guidelines Website
  • Graduation Guidelines FAQ
  • Graduation Guidelines Menu of Options
• 2022-2023 Graduation Guidelines: Excel File Formatting Guide (PDF) (posted 8/23/2022)
• Graduation Guidelines File: General Information and District Considerations (PDF) (posted 4/7/2023)
• Guide to Keeping Leading Zeros in Excel (updated 2/8/2022)
• How to format cells in Excel (if you've lost your leading zeros) (PDF) (posted 8/15/2022)
• Language Instruction Program Descriptions (PDF) (updated 1/12/2022)
• Special Education Transition Students: Coding Guide (updated 4/26/2021)
• Steps to upload files in Data Pipeline (PDF) (updated 11/17/2020)
• Student End of Year: Entry/Exit Code Guide (PDF) (updated 3/29/2023)
• Tagging Interchange Files (PDF) (posted 6/1/2022)
• Troubleshooting File Uploads/Snapshots (PDF) (posted 3/16/2023)

For Student School Association or Student Demographic questions, contact: Brooke Wenzel, wenzel_b@cde.state.co.us 
For Graduation Guidelines or Adjustment questions, contact: Reagan Ward, ward_r@cde.state.co.us