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, Student Discipline and Student Biographical Data.

Deadlines

The 2023-2024 and the 2024-2025 Student Interchange files are open for uploads.

Student Interchange Timeline (PDF) (updated 7/12/2024)
- 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

2024-2025

2024-2025 Student Demographic File Layout (PDF) (posted 3/7/2024)
2024-2025 Student School Association File Layout (PDF) (updated 3/22/2024)
2024-2025 Graduation Guidelines File Layout (PDF) (updated 10/4/2024)
2024-2025 Adjustment File Layout (PDF) (posted 3/7/2024)
- Only used in specific circumstances during the Student End of Year Collection (opens in May with the start of the SEY Collection)

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 SEY Collection)

Business Rules

2024-2025

2024-2025 Student Demographic Business Rules (XLS) (posted 7/8/2024)
2024-2025 Student School Association Business Rules (XLS) (updated 9/9/2024)
2024-2025 Graduation Guidelines Business Rules (XLS) (posted 7/8/2024)
2024-2025 Adjustment File Business Rules (XLS) (posted 7/8/2024)

2023-2024

2023-2024 Student Demographic Business Rules (XLS) (updated 8/9/2023)
2023-2024 Student School Association Business Rules (XLS) (updated 4/10/2024)
2023-2024 Graduation Guidelines Business Rules (XLS) (updated 8/9/2023)
2023-2024 Adjustment File Business Rules (XLS) (updated 5/1/2024)

Templates

2024-2025

2023-2024

Exception Requests

Exception Request Template (XLS)
Exception Request Instructions (PDF)
- 2024-2025
  - July 2024 - December 2024, Contact [email protected]
  - January 2025 - December 2025, Contact [email protected]
- 2023-2024
  - July 2023 - December 2023, Contact [email protected]
  - January 2024 - December 2024, Contact [email protected]
Mid-Year EL Coding Changes Additional Documentation (DOC)
- 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 [email protected]

Training

Webinars

Webinars are offered periodically with recordings posted for reference.

2024-2025 Student Interchange Office Hours (PPT) (posted 8/15/2024)
2024-2025 Student Interchange Office Hours (Recording)
Graduation Guidelines: Reporting GG File Overview (PPT) (posted 4/6/2022)
Graduation Guidelines: Reporting GG File Over (Recording)
Collaborative Monitoring of Graduation Guidelines (PPT) (posted 11/15/2022)
Collaborative Monitoring of Graduation Guidelines (Recording)

Short Bytes

Short Bytes are pre-record 5 to 15 minute recordings covering frequently asked questions.

CEDAR/COGNOS Introduction (Recording) (June 2023)
English Learners
- Overview & Progression (Recording) (Feb 2024)
- Exceptions: July to October (Recording) (Feb 2024)
- Exceptions: October to Student End of Year (Recording) (Feb 2024)
- English Learner Coding Guide (PDF)
Entry & Exit Types/Dates (Recording) (Apr 2023)
- Student Enrollment Record Guide (PDF)
Foster Care (Recording) (May 2023)
Retention Codes & Grade Reassignments (Recording)
Postsecondary Programs
- ASCENT (Recording) (Feb 2024)
- ASCENT (PPT)
- PTECH (Recording) (June 2023)
- P-TECH (PPT)
- TREP (Recording) (Feb 2024)
- TREP (PPT)
- Other Programs (Recording) (June 2023)
- Other Programs (PPT)

Additional Resources

ASCENT Participation Cap Update (PDF) (posted 9/19/2024)
Contract Agreement Students: Impact of Pupil Attendance Information (PDF) (posted 9/26/2024)
Date First Enrolled in US: SSA data field (PDF) (posted 5/7/2024)
English Learner Coding Guide (PDF) (posted 6/12/2024)
Gifted and Talented: SSA data field (PDF) (posted 8/1/2024)
Graduation Guidelines File: General Information and District Considerations (PDF) (posted 4/7/2023)
Graduation Guidelines Website
- Graduation Guidelines FAQ
- Graduation Guidelines Menu of Options
SAT Math Graduation Guidelines Benchmark Change; Technical Information (PDF) (posted 9/25/2024)
Graduation Guidelines: Excel File Formatting Guide (PDF) (posted 8/23/2022)
Preschool Student Data Reporting (PDF) (posted 3/11/2024)
Steps to upload files in Data Pipeline (PDF) (updated 5/24/2024)
Student Interchange Cognos Report Guide (PDF) (updated 4/22/2024)
Student Enrollment Record Guide (PDF) (updated 9/27/2024)
Tagging Interchange Files (PDF) (updated 5/24/2024)
Troubleshooting File Uploads/Snapshots (PDF) (updated 5/24/2024)

For Student Demographic or Student School Association questions, contact: [email protected]
For Graduation Guidelines or Adjustment questions, contact: [email protected]