Overview:
Here are the quick instructions for utilizing Template 014 (link) Student Enrollment Student School Associations.
Make sure to read the general reporting information for templates before proceeding. Failure to follow these guidelines will result in errors and/or data validation issues.
Before Beginning, Note:
All steps will be completed in Row 7, downwards.
This data is not reported by non-public schools. Do not complete this template if you are a non-public school.
Instructions:
1. Enter the SchoolYear for the data being submitted (2024).
This is NOT the calendar year.
2. Enter the SchoolID.
See the chart below for more details.
School ID: Public vs. Non-Public Schools | |
|---|---|
Public | Non-Public |
School ID is a ten digit number comprised from current Corporation and State assigned ID ALL School ID’s start with 10 Next current state assigned Corporation ID - example 1234 Last ends with state assigned School ID 6789 Example School ID: 1012346789 | School ID is a ten digit number comprised from current Corporation and State assigned ID ALL School ID’s start with 10 Next Corporation ID is always four zeros - example 0000 Last ends with state assigned School ID A456 with Alpha converted to number
Example: School ID: 1000001456 |
3. Enter the STN.
Note: Any STNs beginning with a zero will need the field or entire column to be formatted to hold the nine digits being reported. Leading zeros will be dropped upon reopening the csv file.
4. Enter the GradeLevelDescriptor.
Refer to the chart below.
Note: the descriptors must be entered accurately and are both space and case-sensitive.
For example, enter “02”, not “2”.
Spreadsheets will often eliminate leading zeroes. To prevent, format the column of cells as “TEXT”.
Note: Make sure to enter the descriptor on the left, not the definition on the right.
5. Enter the EntryDate.
This is the first day the student attends classes “in person” whether physically or virtually. Again, this is NOT the date the student enrolls; but the date they actually begin attending classes.
Note: Spreadsheets will often auto-format dates. Be sure to format the cell to “TEXT”, then type the date [MM/DD/YYYY].
6. Enter the ExitWithdrawDate, if necessary.
This is the last day the student attended classes “in person” whether physically or virtually. This is not the date the parent comes in to complete withdrawal or exit paperwork, or when you receive a records request from another school or other form of notice regarding the student exiting.
Note: Spreadsheets will often auto-format dates. Be sure to format the cell to “TEXT”, then type the date [MM/DD/YYYY].
7. If an ExitWithdrawDate has been provided Enter the ExitWithdrawTypeDescriptor.
You will enter an allowable numerical code listed that corresponds with the appropriate “ExitWithdrawTypeDescriptor” listed on the chart below.
CodeValue | ShortDescription | Description |
1 | Transferred to Regular Education | Transferred to Regular Education (no longer eligible or parent revoked consent) |
2 | Attained the goals identified in the students ISP. | Attained the goals identified in the students Individual Service Plan (ISP). |
3 | Made satisfactory progress toward goals identified in the ISP. | Made satisfactory progress toward goals identified in the ISP. |
4 | Did not make satisfactory progress toward ISP but remained in the program. | Did not make satisfactory progress toward goals in their ISP but remained in the program. |
5 | Transferred/returned to other school setting prior to completing program. | Transferred / returned to other school setting prior to completing the alternative education program. |
6 | Dropped out of program, not returning to any educational setting. | Dropped out of alternative education program, not returning to any educational setting. |
7 | Expelled from program, not returned to any educational setting. | Expelled from alternative education program, not returned to any educational setting. |
10 | Incarcerated | Incarcerated |
11 | Earned High School Diploma | Earned High School Diploma |
12 | Received Certificate | Received Certificate |
13 | Reached Maximum Age of 22 | Reached Maximum Age of 22 |
14 | Deceased | Deceased |
15 | Dropout | Dropout |
16 | Moved, KNOWN to be continuing in an Educational Program ONLY | Moved, KNOWN to be continuing in an Educational Program ONLY |
17 | Moved, but continuing Special Education services under IDEA in Indiana | Moved, but continuing Special Education services under IDEA in Indiana |
99 | No longer qualifies | No longer qualifies |
End of Year (EOY) | End of Year (EOY) | End of Year (EOY) |
Definitions of exit codes can be found here.
Remember: Templates must be saved as a CSV file (with cells formatted as TEXT) inside of a Compressed Zipped Folder, in order to process correctly.