How to Complete Template 009

Overview:

Here are the quick instructions for utilizing Template 009 (link) Staff Association Staff EdOrg Contact 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
EdOrgID (Corp/LEA) is a ten digit number comprised from current Corporation assigned ID ALL School ID’s start with 10 Next current state assigned Corporation ID - example 1234 Last ends with 0000 Example School ID: 1012340000	EdOrgID is a ten digit number comprised from current CorpID 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 A=1, B=2, C=3, D=4 Example: School ID: 1000001456

2. Enter the SPN for each staff member.

Note: Make sure these cells are formatted as “TEXT”.

3. Enter the phrase “Unified Access” (without quotations) under ContactTitle for every row.

Note: Unified Access is case and space sensitive.

4. Enter the Email Address for each person under ElectronicMailAddress.

This is the staff’s work/school email address (not a personal email address). The email is utilized for single sign on (SSO) to IDOE systems. Please make sure the provided email address is accurate, as this will be utilized to login to the Link Portal and Data Exchange.

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.