Overview:
Here are the quick instructions for utilizing Template 020 Student Program Student Program 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.
Instructions:
1. 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 |
2. 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.
3. For ProgramEdOrgID, enter in this number exactly: 1088000000
4. Enter the appropriate ProgramTypeDescriptor the student is participating in or needs to be associated with.
Students may have more than one program associated to them which will require more than one record provided. The allowable Program Types can be found below on the chart provided.
Note: These program types are case and space sensitive.
Program Type Descriptors
Program Types*: | Description / Notes: |
|---|---|
Curricular Material Reimbursement | October Certification - Curricular Materials Assistance |
Foreign Exchange | July Certification - Additional Student Programs |
Foster Care | July Certification - Additional Student Programs |
High Ability | July Certification - Additional Student Programs |
Homebound | July Certification - Homebound |
Homeless | July Certification - Additional Student Programs |
Parent in Military | July Certification - Additional Student Programs |
Refugee | October Certification - Multilingual Learner Program |
Section 504 Placement | July Certification - Additional Student Programs |
School Food Services | October Certification - Curricular Materials Assistance and Pupil Enrollment |
Unaccompanied Youth | July Certification - Additional Student Programs |
Virtual Education | October and February Certification - Membership |
*These programs are the only programs provided on Template 020. Other program associations; Special Education, Title I, Multilingual Learner, Curricular Material, and Alternative Education have a separate template for reporting.
5. Enter the appropriate ProgramName the student is participating in or needs to be associated with.
Students may have more than one program associated to them which will require more than one record provided. The allowable Program Names associated to each Program Type can be found below on the chart provided.
Note: These program names are case and space sensitive.
Program Names
Program Types*: | Program Names | Description / Notes: |
|---|---|---|
Curricular Material Reimbursement | Curricular Material Reimbursement | October Certification - Curricular Materials Assistance |
Foreign Exchange | Foreign Exchange | July Certification - Additional Student Programs |
Foster Care | Foster Care | July Certification - Additional Student Programs |
High Ability | General Intellectual | July Certification - Additional Student Programs |
High Ability | High Ability Language Arts | July Certification - Additional Student Programs |
High Ability | High Ability Math | July Certification - Additional Student Programs |
High Ability | High Ability Other | July Certification - Additional Student Programs |
Homebound | Homebound/Hospitalized | July Certification - Homebound |
Homeless | Homeless Doubled-up | July Certification - Additional Student Programs |
Homeless | Homeless Hotels/Motels | July Certification - Additional Student Programs |
Homeless | Homeless Shelters and Transitional Housing | July Certification - Additional Student Programs |
Homeless | Homeless Unsheltered | July Certification - Additional Student Programs |
Parent in Military | Parent in Military | July Certification - Additional Student Programs |
Refugee | Refugee | October Certification - Multilingual Learners Program |
Section 504 Placement | Section 504 Placement | July Certification - Additional Student Programs |
School Food Services | School Food Services Free Lunch | October Certification - Curricular Materials Assistance and Pupil Enrollment |
School Food Services | School Food Services Reduced Price Meals | October Certification - Curricular Materials Assistance and Pupil Enrollment |
Unaccompanied Youth | Unaccompanied Youth | July Certification - Additional Student Programs |
Virtual Education | Virtual Education | October and February Certification - Membership |
*These programs are the only programs provided on Template 020. Other program associations; Special Education, Title I, Multilingual Learner, Curricular Material, and Alternative Education have a separate template for reporting.
5. Enter the BeginDate.
This is the date the student starts participating 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]
6. If necessary, enter the EndDate.
This may be the last day of the school year, the last day the student attends the school, or the last day the student is participating in the program.
Note: Spreadsheets will often auto-format dates. Be sure to format the cell to “TEXT”, then type the date [MM/DD/YYYY]
7. 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.
Utilize code 99 when a student is no longer participating in the program or exits the school before the end of the school year.
Utilize code 99 when a student changes program names under the same program type.
Utilize End of Year (EOY) when a student participates in the program until the last day of the school year.
These code values are case and space sensitive.
Reason Exited Descriptors
ReasonExitedDescriptor CodeValue | Short Description |
|---|---|
99 | No longer qualifies |
End of Year (EOY) | End of Year (EOY) |
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.