All Discipline Templates: How to Complete Template 028

Overview:

Here are the quick instructions for utilizing Template 028 Student Discipline Discipline Incident.

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 where the discipline incident occurred.

  • 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

  • A=1, B=2, C=3, D=4

Example: School ID: 1000001456

2. Create an IncidentIdentifier.

  • This is a custom field and will be utilized on Template 029, so make sure that your IncidentIdentifier is distinct and specific.

    • Example: Room Name + Date + Letter = A101July923A

  • No more than 20 alpha-numeric characters may be used.

3. Enter the IncidentDate.

  • Note: Make sure to format the dates as “TEXT” as [MM/DD/YYYY].

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

5. Enter the BehaviorDescriptor by utilizing the chart below.

  • Note: This is an required field.

6. Enter the CriminalGangRelatedEventDescriptor by utilizing 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.