Student Behavior and Administrative Response (SBAR) Collection (Legacy)
Contents
Report Description
Use this extract to report incidents, participants, and actions taken by the administration as part of the student behavior data required by Virginia DOE.
The information is generated in the following format:
A Record - Header Record
B Record - Event Record
C Record - Student Behavior Record
D Record - Administrative Response Record
E Record - Victim Record
Incident Management Setup is required prior to running this report. For more information on setup, reference State Reporting Setup - Incident Management Setup for State Reporting.
Selection Criteria
Selection criteria determine which database records are used in the report. For the Student Behavior and Administrative Response (SBAR) Collection, the incident records with an Incident Type of VA State Reporting^ are selected.
School Selection
The report selects school records that are not excluded from state reporting and includes all incident records that meet the selection criteria (including incidents created at the District Office). If run at the school level, the report includes all incident records associated with the current school that meet the selection criteria.
Student Selection
The report selects which student records to use based on the following criteria:
- The student must not be excluded from state reporting.
- The student must have a school enrollment during the selected reporting period.
- The student must be associated with an incident of type VA State Reporting^.
- Unknown Offenders must be associated with an incident of type of VA State Reporting^.
Incident Selection
The report selects VA State Reporting^ incidents that fall within the Report Start Date and Report End Date values entered.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
| Select Schools | All Schools: Run the report for all schools. Includes all incident records that meet the selection criteria (including incidents created at the District Office). School Selection: If run at the school level, the report includes all incident 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 another school from the list. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
If running the report for a single student, or group of students, select the students prior to running a report. Unknown Offenders are included by default. |
| Select School Year | Select the school year from the list. |
Report Start Date | Enter start date for the reporting period. Students with an active school enrollment / incident on or after the start date are included in the report. |
Report End Date | Enter end date for the reporting period. Students with an active school enrollment / incident on or before the end date are included in the report. |
| File Submission Type | Select Preliminary (17), Pre-Submission (9), or EOY (3) |
| Sender's Email Address | Enter the email address |
| Include Header Labels in output file? | Valid values are Yes and No. For validation purposes choose Yes, and for state reporting select No. Headers cannot be submitted to the state. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Data Element | Description | [Table]FieldName | Field Length |
| Record A - Fixed Length | |||
| Record Type | The value 'A' is reported. | NA | 1 |
| File Submission Type | The code to describe the submission. The values '3' and '17' are reported. | NA | 1 |
| Beginning School Year | A four-digit year for the beginning of the school. | NA | 4 |
| Division Number | The leading zeroes must be included. For example, 005. | NA | 3 |
| Record B - Incident Record - Tab Delimited | |||
| Record Type | The value 'B' is reported. | NA | 1 |
| Local Incident ID | The ID is used to identify specific incidents. This ID must be unique at the division level. | [PSRW_INCIDENT]incident_id | 11 |
| Incident Division | Three or four-digit state-assigned Division number that identifies the division, center, or agency where the incident occurred. If Location is 5 - Other District School, 6 - Off-Campus School-Sponsored Event, or 7 - Off Campus Other Location/Social Media, then Incident Division is reported as the first three or four digits before the hyphen entered in Location Comment. | [PREFS]District_Number | 4 |
| Incident School | Four-digit state-assigned School number that identifies the school, center, program, or placement where the incident occurred. If Location is 5 - Other District School, 6 - Off-Campus School-Sponsored Event, or 7 - Off Campus Other Location/Social Media, then Incident School is reported as the last four digits after the hyphen entered in Location Comment. | [PSRW_INCIDENT]School_Number | 4 |
| Date of Incident | The date of the incident. | [psrw_incident]incident_ts | 10 |
| Time of Incident | The time that the incident occurred. | [psrw_incidenttimeframe]state_aggregate_rpt_code | 1 |
| Location of Incident | The location of the incident. | [psrw_incidentlocation] state_aggregate_rpt_code | 1 |
| Firearms Confiscated | The number of firearms confiscated at the incident. | [psrw_incidentobject]object_quantity | 2 |
| Weapons Confiscated | The number of non-firearm weapons confiscated at the incident. | [psrw_incidentobject]object_quantity | 2 |
| Not collected | NA | NA | NA |
| Not collected | NA | NA | NA |
| Not collected | NA | NA | NA |
| Not collected | NA | NA | NA |
Record C - Student Behavior Record - Tab Delimited C records identify each Behavior by each Offender involved in the Incident. At least one C record for every B record. The C and D records include offending students enrolled in another school within the district. | |||
| Record Type | The value 'C' is reported. | NA | 1 |
| Local Incident ID | The ID used to identify specific incidents. This ID must be unique at the division level. | [psrw_incident]incident_id | 11 |
| State Testing ID | The State Testing ID assigned to the student. | [Students]State_StudentNumber | 10 |
| Behavior Code | The code that best describes the student behavior exhibited during this specific incident. | [psrw_participantbehavior]state_detail_report_code | 6 |
| Not collected | NA | NA | NA |
| Unknown Offender Code | The type of offender, if the offender is not a student within the school division. Note: The offender must have a behavior and action code. | [psrw_participantattr]state_detail_report_code | 1 |
| Enrolled Division | Three-digit state-assigned Division number that identifies the division, center, or agency in which the student is enrolled. | [Prefs]District_Number | 3 |
| Enrolled School | Four-digit state-assigned School number that identifies the school, center, program, or placement in which the student is enrolled. | [Students]Enrollment_SchoolId | 4 |
| Aggravating Circumstances Flag | A flag that recognizes if the behavior met one of the following criteria: (1) resulted in a threat assessment determination of serious harm or credible threat of serious harm, or (2 pose an ongoing and unreasonable risk to school safety, or (3) be persistent and unresponsive to intervention. Valid values:
Default value: N | [psrw_incidentactionattribute]state_detail_report_code | 1 |
| Law Enforcement Flag | A flag to identify if law enforcement was notified of this behavior. Valid values:
Default value: N | [psrw_incidentactionattribute]state_detail_report_code | 1 |
| Notified of Charges Filed Flag | Indicates the school or division was notified that the student was charged with an offense relating to the Commonwealth's laws, or with an offense that is required to be disclosed to the superintendent of the school division pursuant to subsection G of 16.1-260. This field must be Yes if the Behavior code is BESO18 Valid values:
Default value: N | [psrw_incidentactionattribute]state_detail_report_code | 1 |
| Notified of Conviction Flag | Indicate the school or division was notified that the student was found guilty or not innocent of an offense relating to the Commonwealth's laws on weapons, alcohol, or drugs, or of a crime that resulted in or could have resulted in injury to others, or of an offense that is required to be disclosed to the superintendent of the school division pursuant to subsection G of 16.1-260. This field cannot be Yes if the Notified of Charges Filed Flag is No. Valid values:
Default value: N | [psrw_incidentactionattribute]state_detail_report_code | 1 |
| Not Collected | NA | NA | NA |
| Not Collected | NA | NA | NA |
Record D - Administrative Response Record - Tab Delimited D Records specify every Intervention, Support, or Sanction for each Behavior of each Offender. At least one D record for every C record. The C and D records include offending students enrolled in another school within the district. | |||
| Record Type | The value 'D' is reported. | NA | 1 |
| Local Incident ID | The ID used to identify specific incidents. This ID must be unique at the division level. | [PSRW_INCIDENT]incident_id | 11 |
| State Testing ID | The State Testing ID assigned to the student. | [Students]State_StudentNumber | 10 |
| Behavior Code | The code that best describes the student behavior exhibited during this specific incident. | [psrw_participantbehavior]state_detail_report_code | 6 |
| Behavioral Intervention Code | Specific intervention that addresses the specific student behavior. | [psrw_participantbehavioraction]state_detail_report_code | 2 |
| Instructional Support Code | The disciplinary sanction given to the student for this behavior as related to this incident. | [psrw_participantbehavioraction]state_detail_report_code | 1 |
| Disciplinary Sanction Code | The disciplinary sanction given to this student for this behavior as related to this incident. | [psrw_participantbehavioraction]state_detail_report_code | 4 |
| Days Sanctioned | The total number of school days of the sanction. | [psrw_participantbehactdur]duration_actual | 3 |
| Alternate Placement Educational Agency | Three-digit state-assigned division number that identifies the alternative center or program where the student was placed for educational services in lieu of attending their Enrolled School. | [psrw_incidentactionattribute]state_detail_report_code | 3 |
| Alternate Placement School | Four-digit state-assigned School number that identifies the school, center, program, or placement where the student was placed for educational services in lieu of attending their Enrolled School. | [psrw_incidentactionattribute]state_detail_report_code | 4 |
| Hours Sanctioned | Displays the offender's action in hours. If there is no value then a blank is reported. | [psrw_participantbehactdur].duration_actual | 3 |
| Not Collected | NA | NA | NA |
| Not Collected | NA | NA | NA |
| Not Collected | NA | NA | NA |
Record E - Victim Record - Tab Delimited E records are required for specific Behaviors and are optional for all others. One E record for every B record. | |||
| Record Type | The value 'E' is reported. | NA | 1 |
| Local Incident ID | The ID used to identify specific incidents. This ID must be unique at the division level. | [PSRW_INCIDENT]incident_id | 11 |
| Student Victims | The number of school-aged victims harmed in the incident. | Counted by psrw_incidentattribute.sub_category = 'STUDENT VICTIMS^' | 4 |
| Staff Victims | The number of victims employed by the school division harmed in the incident. | Counted by psrw_incidentattribute.sub_category = 'STAFF VICTIMS^' | 5 |
| Other Adult Victims | The number of victims employed by the school division harmed in the incident. | Counted by psrw_incidentattribute.sub_category = 'OTHER ADULT VICTIMS^' | 6 |
| Other/Unknown Victims | The number of victims of unknown age harmed in the incident. | Counted by psrw_incidentattribute.sub_category = 'OTHER/UNKNOWN VICTIMS^' | 7 |
| Indeterminate Victim Flag | A flag to indicate that the number of victims is unspecified or indeterminate. | Determined by psrw_incidentattribute.sub_category = 'INDETERMINATE VICTIM FLAG^' | 1 |
| Not Collected | NA | NA | NA |
| Not Collected | NA | NA | NA |
| Not Collected | NA | NA | NA |
| Not Collected | NA | NA | NA |