Discipline Report

Contents

Introduction

Use the Discipline Report report to report discipline actions taken involving suspensions and/or removals.

Selection Criteria

Selection criteria determine which database records are used in the report:

School Selection

The report selects which school records to use based on the following criteria:

The school is not excluded from state reporting.
The school must be associated with a student included in the report.

Student Selection

Student is not excluded from State reporting
Student has reportable discipline events:
- Incident Date is within the report start and end dates
- Incident Type is not blank
- Action Taken is either an in-school suspension, out-of-school suspension, or removals to Interim Alternative Educational settings by either school personnel or due process.

Note: If Duration is not reported (null or 0) for a reportable Action Taken, the record will extract with a null or 0 value, respectively. (True for primary and secondary fields)

Back to Top

Report Input

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.
Select Students	The default option is All students. Use this option to filter the extract by a selected group of students.
Report Start Date	Enter the Start Date for this report.
Report End Date	Enter the End Date for this report.
Scheduling Options	Description
Scheduling – Run Now	Leave Run Now selected to run the report now.
Submit	Click Submit to run the report now.
Scheduling – Please Select When to run	Click the Schedule button to schedule this report to run.
Please Select Schedule Settings	Enter the Start Date and Start time. Click the Repeat button.
Please select repeat cycle options.	Choose the applicable option.
Please select end date range option	Enter the appropriate information.
Submit	Click Submit to schedule the report

Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.

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.

Column	Data Element	Description	[Table]FieldName	Field Type	Field Length
A	SASID	This field contains the student's state identification code. This field is extracted from the Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]State_StudentNumber	Text	10
B	LASID	The student's local school identification code as noted on Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]Student_Number	Text	16
C	DISTCODE	The district code assigned to the school district reporting the student information as noted on District Setup page, Start Page > District Setup > District Information.	[Pref]DistrictNumber	Text	2
D	SCHCODE	The five-digit RIDE ID for the school that the student attends as noted on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.	[S_RI_SCH_X]Ride_ID	Text	5
E	LASTNAME	The last name of the student as noted on the General Demographics page, Start Page > Student Selection > General Demographics, or if the legal last name is populated on the Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]Last_Name OR [StudentCoreFields]PSCore_Legal_Last_Name	Text	50
F	INFRACTION	The field contains the primary category of infraction committed as noted on the Log Entries page, Start Page > Student Selection > Log Entry	[Log]Discipline_IncidentType	Text	2
G	INFRACTION_DATE	This field contains the date on which the infraction occurred (MM/DD/YYY) as noted on the Log Entries page, Start Page > Student Selection > Log Entry	[Log Discipline_IncidentDate	Date
H	DISCIPLINE	This field contains the method of punitive or corrective action taken by the school or court authority to reprimand or rehabilitate a student after an offense is committed as noted on the Log Entries page, Start Page > Student Selection > Log Entry	[Log]Discipline_ActionTaken	Text	1
I	DURATION	This field contains the discipline duration as the number of full days as noted on the Log Entries page, Start Page > Student Selection > Log Entry. Valid values: 1 to 180 (no half days – round to the next highest whole number; less than 1 day should not be reported as a suspension). If value entered is > .5 but less than 1 - 1 will be extracted, else 0.	[Log]Discipline_DurationAssigned	Text	3
J	WEAPON	This field contains the type of weapon involved in a weapons-related infraction as noted on the Log Entries page, Start Page > Student Selection > Log Entry. (required for Infraction=39, also applicable to Infraction = 03, 04, 10, 18, 22, 26, 27, 29, 42, 43, etc.)	[Log]Discipline_WeaponType	Text	1
K	REASON	This field contains a description of the type of infraction as noted on the Log Entries page, Start Page > Student Selection > Log Entry, if it does not fall under any of the listed Infraction Codes. (when Infraction=33)	[Log]Discipline_IncidentTypeDetail	Text	250
L	INJURY	This field may contain data if physical injury occurred as a result of the incident as noted on the Log Entries page, Start Page > Student Selection > Log Entry. Valid values: M = Minor, S= Serious, or N = None	[Log]Discipline_LikelyInjuryFlag	Text	1
M	DISCIPLINE_SEC	This field contains the secondary method of punitive or corrective action taken by the school or court authority to reprimand or rehabilitate a student after an offense is committed as noted on the Log Entries page, Start Page > Student Selection > Log Entry. Only valid for In-School or Out-of-School Suspensions.	[S_RI_LOG_X]Discipline_ActionTaken_2	Text	1
N	DURATION_SEC	This field contains the discipline duration as the number of full days as noted on the Log Entries page, Start Page > Student Selection > Log Entry. Valid values: 1 to 180 (no half days – round to the next highest whole number; less than 1 day should not be reported as a suspension). If value entered is > .5 but less than 1 - 1 will be extracted, else 0.	[S_RI_LOG_X]Discipline_DurationAssigned_2	Numeric	3

Back to Top