Licensure
Column Title
Column Title
Column Title
Haven’t found what you’re looking for?
Target Table: SCHOOL_ENROLL
Data Submission Schedule: 40 Day, 80 Day, 120 Day, End of Year (EOY), and Summer
Grain: One record per district / location / school year / student / “mobility transaction”
Load Sequences/Dependencies:
Template Description – This template contains the student enrollment and withdrawal transactions at each school within each district across the school year. This template tracks student Mobility and the new Graduation Cohort rate as required by the USDE. Enrollment codes are also used to develop the list of potential dropouts for the subsequent school year’s Dropout Data Collection & Reporting system (DDCS). Submit all enrollment/mobility actions for all students throughout the school year, not just students active at the end of the year. At least one record should exist in this template for every student enrolled in a school within the same district or in a different district at any time during the school year. For purposes of analysis, most of your students will be coded with an Enrollment Code of E1. (E1’s are students who are in school for the first time during the current school year regardless of start date).
School Year 2019-2020 Changes:
File Name Format: DDD_SCHOOL_ENROLL_YYYYMMDDHHMM.fff
File Name Format Example: 001_SCHOOL_ENROLL_201907071201.csv
| Field Number | Field Name | Data Type, Required, Code | Valid Values |
|---|---|---|---|
| 1 | District Code | Character, Required, Key | |
| 2 | Location Code | Character, Required, Updateable | |
| 3 | School Year Date | Date, Required, Key |
|
| 4 | Student ID | Character, Required, Key | 9 digit student ID |
| 6 | Enrollment Date | Date, Required, Key | YYYY-MM-DD |
| 7 | Enrollment Code | Character, Required, Key |
|