All Multilingual Learners Templates: How to Complete Template 019
Overview:
Here are the quick instructions for utilizing Template 019 Student Program Multilingual Learners Program.
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.
Instructions:
1. Enter the EdOrgID.
This is 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 |
2. Enter the STN.
Note: Any STNs beginning with a zero will need the field or entire column to be formatted as TEXT to hold the nine digits being reported. Leading zeros will be dropped upon reopening the csv file.
3. For ProgramEdOrgID, enter in this number exactly: 1088000000
4. For MultilingualLearnersProgramTypeDescriptor, enter this phrase exactly (case and space-sensitive): Multilingual Learners
5. Select the ProgramName from the following options on the chart below.
Note: these program names are both space and case sensitive.
6. Enter the BeginDate.
This is usually the date the student starts their enrollment in the program, or first day of the school year.
Note: Spreadsheets will often auto-format dates. Be sure to format the cell to “TEXT”, then type the date [MM/DD/YYYY]
7. If necessary, enter the EndDate.
This may be if the student graduates or if student changes programs (i.e. ESL to Regular Education).
Schools DO NOT report end dates to the Multilingual Learner program when a student exits the school (transfers).
Note: Spreadsheets will often auto-format dates. Be sure to format the cell to “TEXT”, then type the date [MM/DD/YYYY]
8. If you entered an EndDate, you must provide a ReasonExitedDescriptor.
The available Code Values, along with their meaning, can be found on the chart below.
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.