Incident Management Validation Extract File

Contents

Introduction

This file displays potential errors for the Discipline File. The report may be run at the district or school level.

This reports displays potential errors for the Consolidated Collections Student Discipline report. Incomplete incident records need to be easily identified. An incomplete record has specific attributes that can be checked by the validation report.

. The report will generate a list of incidents that have one or more of the following errors:

The incident has an offender with no Behavior incident element attached.
The incident has an offender with no Action incident element attached.

The incident does not have an Incident Date.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables that occurred during the current school year, based on the following criteria:

When a selection of students is provided to the report then that selection is used.
When a start date and end date are provided to the report then students with enrollments within the date range are selection for report inclusion.
The Start Date must be on or before the last day of the current term.
The End Date must be on or after the last day of the current term.
The Start Date must be before the End Date.
The Report Run Date must be between the student enrollment start and end Date.

Incident Selection

When a start date and end date are provided to the report then Incidents within the date range are selected for report inclusion.

Back to Top

Report Input

To generate the Incident Management Validation Extract File report, do the following:

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools*	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include*	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 (Default) – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Report Start Date*	Enter a date in the format mm/dd/yyyy.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Data Type	Field Length
1	Incident ID	Value of the incident ID	[Incident]Incident_Id	Int	10
2	Incident Title	Title for the incident.	[Incident]Incident_Title	varchar	80
3	Incident Date	The incident date.	[Incident]Incident_ts	date	10
4	Error-NoBehavior-ForOffender	List of offenders that have no behavior element attached. When the incident has multiple offenders with this error the offenders are separated by “;”. The format is student number–student full name.	[Students]Student_number [Students]LastFirst	varchar	4000
5	Error-NoActions-ForOffender	List of offenders that have no action element attached. When the incident has multiple offenders with this error the offenders are separated by “;”. The format is student number–student full name.	[Students]Student_number [Students]LastFirst	varchar	4000
6	Error-NoIncidentDate	“Y” for incidents that have no date associated with the incident.	[Incident]Incident_ts	varchar	1

Back to Top