All Staff Assignment and Contact Templates: How to Complete Template 008

Owned by
IDOE
Last updated: Oct 02, 2023
2 min read

Overview:

Here are the quick instructions for utilizing Template 008 Staff Association Staff EdOrg Assignment Association.

Before Beginning, Note:

  • All steps will be completed in Row 7, downwards.

Instructions:

1. Enter the EdOrgID.

  • You will either report the Corp ID or School ID, depending upon the staff classification (refer to the chart immediately below).

  • Refer to charts in Step 3 to determine whether to report the Corp ID or School ID by utilizing the “Report with” column.

EdOrgID: Public vs. Non-Public Schools

Corp ID Public

School ID Public

Corp ID Non-Public

School ID 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

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

  • 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

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

  • 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 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.

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.