Discipline Log Entries Verification Report

Field

Description

Select Schools

Select one, all, or a selection of schools from the multi-select list. Use Ctrl+Shift on your keyboard to select multiple schools.

If running the report from District Office, all schools in the district are available. If running the report from a school, only that school is available.

Select Students

Indicate which students to include in the report by selecting one of the following options:

• The Selected [number] Students Only – Run the report for students in the current selection.

• All Students – Run the report for all students in the current school or district that meet the selection criteria.

If running the report for a single student, or group of students, select the students prior to running the report.

Log Start Date

Enter the report start date.

Log End Date

Enter the report end date.

Log Entries to Include

Indicate which log entries to include in the report by selecting one of the following options:

• All Discipline – Run the report for all discipline log entries.

• Removals Only – Run the report for only log entries which include student removals (Action Taken field value is 1-6).

Sort Order

Choose the sort order for the report output:

• Student Name, Log Date

• Log Date, Student Name

• Log School, Log Date, Student Name

Item #

Data Element

Description

[Table]FieldName

Field Type

Max Length

1

Local ID

The locally assigned student identifier.

[Students]Student_Number

A

20

2

State ID

The student’s state assigned identifier.

[Students]State_StudentNumber

N

10

3

Last Name

The student’s last name.

[Students]Last_Name

A

60

4

First Name

The student’s first name.

[Students]First_Name

A

60

5

Middle Name

The student's middle name.

[Students]Middle_Name

A

60

6

Grade Level

The student’s grade level at the time of the incident.

[Students]Grade_Level

[ReEnrollments]Grade_Level

A

2

7

Log Date

The date of the log entry.

[Log]Entry_Date

D

N/A

8

Incident Date

The date the incident took place.

[Incident]Incident_TS

D

6

9

Log Author

The incident log entry author.

[Incident]Entry_Author

A

50

10

Title

A short description of the incident.

[Incident]Incident_Title

A

80

11

School #

The school number. If the report outputs no school number, the incident is a district incident.

[Incident]School_Number

A

4

12

E0005

Incident Number

The behavior incident number.

[S_IA_LOG_X]Behavior_Incident_Number

A

10

13

Log Subtype

The log subtype code for this violation.

[Log]Subtype

A

20

14

E0022

Problem Behavior

The problem behavior that caused the action.

[S_IA_LOG_X]Problem_Behavior

I

2

15

E0032 - Assault

Indicates if the incident involved assault.

Valid values:

• Y - Yes

• N - No

[S_IA_LOG_X]Incident_Assault

A

1

16

E0034 - Property Damage

Indicates if the incident involved property damage.

Valid values:

• Y - Yes

• N - No

[S_IA_LOG_X]Incident_Prop_Damage

A

1

17

E0036 - Bodily Injury

Indicates if the incident involved bodily injury.

Valid values:

• Y - Yes

• N - No

[S_IA_LOG_X]Incident_Body_Injury

A

1

18

E0032 - Assault

Indicates whether the incident involved assault.

Valid values:

• Y - Yes

• N - No

[S_IA_LOG_X]Incident_Assault

A

1

19

E0034 - Property Damage

Indicates whether the incident involved damage to property.

[S_IA_LOG_X]Incident_Prop_Damage

A

1

20

E0036 - Bodily Injury

Indicates whether the incident involved bodily injury.

[S_IA_LOG_X]Incident_Body_Injury

A

1

21

Consequence

The consequence the offender received for the behavior.

[Log]Consequence

A

20

22

E0012

Action Taken

The action taken against the offender.

See the Appendix for valid values.

[S_IA_LOG_X]Action_Taken

I

2

23

Duration Assigned

The duration of the disciplinary action.

[Incident_Action]Duration_Assigned

N

10

24

E0040

Length of Removal

The duration of the assigned removal.

[S_IA_LOG_X]Duration_Assigned

N

5

25

Action Date

The date the disciplinary action began.

[Incident_Action]Action_Plan_Begin_DT

D

N/A

26

E0050

Date of Removal

The date the student was removed.

[S_IA_LOG_X]Date_Of_Removal

D

10

27

E0025

Zero Tolerance

Indicates if the expulsion was due to a zero tolerance policy.

[S_IA_LOG_X]Zero_Tol_Expulsion

I

2

28

E0060

Weapon Type

The type of weapon involved in the incident.

Valid values:

• N – Not Applicable

• B – Bomb

• F – Other firearm

• H – Handgun

• K – Knife

• L – Look alike or fake weapon

• O – Other weapon not listed

• R – Rifle or shotgun

[Log]Discipline_WeaponType

A

1

29

Incident Location

The location where the incident took place.

[S_IA_LOG_X]Incident_Location

I

2

30

Motivation

The reason the offender displayed problem behavior.

[S_IA_LOG_X]Motivation

I

2

31

Restrained/Seclusion

Indicates whether the student was restrained/secluded after the behavior.

[S_IA_LOG_X]Restrained_Or_Seclusion

I

2

32

Major/Minor

Indicates whether the referral was for a major or minor incident.

[S_IA_LOG_X]Major_Or_Minor

I

2

33

Instructional Format

The instructional format at the time of the behavior.

[S_IA_LOG_X]Instructional_Format

I

2

34

Victim 1 ID

The student number for the first victim.

[S_IA_LOG_VICTIM_C]Student_Numer

I

10

35

Victim 1 Name

The first victim student's name. (Last, First, Middle Initial).

[S_IA_LOG_VICTIM_C]StudentName

A

135

36

Victim 1 Grade

The first victim student's grade level.

[S_IA_LOG_VICTIM_C]Grade_Level

I

2

37

Victim 1 School of Enrollment

The school number of the first victim.

Additional victims involved in the incident appear as Victim 2, Victim 3, etc.

[S_IA_LOG_VICTIM_C]SchoolID

I

2