Overview:
Here are the quick instructions for utilizing Template 008 (link) Staff Association Staff EdOrg Assignment Association.
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 school corporation or LEA Id. See Chart below for more details.
EdOrgID: Public vs. Non-Public Schools | |
|---|---|
Public | Non-Public |
|
|
2. Enter the SPN for each staff member.
Note: Make sure these cells are formatted as “TEXT”.
3. Enter the StaffClassificationDescriptors.
The roles/classifications available for reporting can be found below on the green chart(s) provided.
Please refer to guidance documentation here for more detailed information on staff classifications and their uses.
Note: Staff may have more than one classification assigned and requires a separate record for each one associated to the staff.
Note: These descriptors are case and space sensitive.
Staff Classification Descriptors: KEY Contacts (these do not give access to Data Exchange) | Ed Org ID for reporting |
|---|---|
504 Coordinator | Corp ID |
Assistant Principal | School ID |
Assistant Superintendent | Corp ID |
Chief Technology Officer | Corp ID |
Corporation Test Coordinator | Corp ID |
Data Exchange Contact | Corp ID |
Financial Contact | Corp ID |
Principal | School ID |
Special Education Director | Corp ID |
Superintendent | Corp ID |
Title IX Coordinator | Corp ID |
Staff Classifications: Data Exchange Access (these give access to Data Exchange) | Ed Org ID for reporting |
|---|---|
LEA Administrator* | Public Corp ID |
Financial Administrator* | Corp ID |
School Administrator* | Public Corp or Non-Public School ID |
Data Certification | Corp ID |
Data Administrator | Corp ID |
Data Viewer | Corp ID |
*These Classifications also require Data Certification IF those staff are responsible for Certification of Data. Also, these Classifications can be reported by themselves when those staff are not responsible for Certification of Data.
Additional Staff Classifications for providing Staff Assignment Data** | Ed Org ID for reporting |
|---|---|
Assistant Principal | School ID |
Assistant Superintendent | Corp ID |
Chief Technology Officer | Corp ID |
Corporation Test Coordinator | Corp ID |
Counselor | School ID |
Instructional Aide | School ID |
LEA Administrator | Corp ID |
Librarians/Media Specialists | School ID |
Nurse | School ID |
Operational Support | School ID |
Other | School ID |
Principal | School ID |
Psychologist | School ID |
School Administrator | School ID |
School Health | School ID |
School Leader | School ID |
Social Worker | School ID |
Special Education Director | Corp ID |
Substitute Teacher | School ID |
Superintendent | Corp ID |
Support Services Staff | School ID |
Teacher | School ID |
**These staff classifications determine numbers on the Staff Assignment (formerly CP) when reported in conjunction with staff employment.
Miscellaneous Staff Classifications available for providing roles to IDOE*** | Ed Org ID for reporting |
Board Member | Corp ID |
Board President | Corp ID |
Board Secretary | Corp ID |
Board Treasurer | Corp ID |
Board Vice President | Corp ID |
Grant Contributor | Corp ID |
Grant Viewer | Corp ID |
Job Poster | Corp ID |
School Safety Specialist | Corp or School ID |
School Test Coordinator | School ID |
Secondary Corporation Test Coordinator | Corp ID |
Transportation Coordinator | Corp ID |
***These staff classifications DO NOT determine numbers on the Staff Assignment (formerly CP) report.
Staff Classifications**** | Link Portal Access | Ed Org ID for reporting |
Student Support Plan | EdPlan Tile (IIEP and/or ILP) | Corp ID |
****These staff classifications DO NOT determine numbers on the Staff Assignment (formerly CP) report
4. Enter the BeginDate and if necessary, the EndDate of the Staff Member’s employment.
Providing the EndDate is only necessary if the staff member has left your EdOrgId’s employment.
Formatting Note: Excel will often auto-format dates. Be sure to format the cell to “TEXT”, then type the date [MM/DD/YYYY].
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.