Tool Search: Disciplinary Actions

The Disciplinary Actions Extract reports Behavior Resolutions.

Disciplinary Actions Extract Editor

Report Logic

Reports a record for each enrolled student assigned a reportable resolution that falls within the extract Date range based on the following criteria.

Resolutions must be mapped to a State Resolution Code to report.
If multiple reportable resolutions are entered for the same incident or event, multiple records report.

Calendar, Grade Levels and Enrollments marked as State Exclude are not included in the extract.

The reporting resolution's event must have a classification of Weapon or Drug in order to assign a Weapon, Drug or Alcohol event to a participant.

Generating the Extracts

Enter a Start Date to limit behavior records reported to those on or after that date within the selected calendar(s).
Enter an End Date to limit behavior records reported to those on or before that date within the selected calendar(s).
Mark the Required Disciplinary Actions checkbox report only resolutions defined by the state as required.
Select an Ad hoc Filter to limit the information reported to events or resolutions within the selected filter.
Select the Format in which the extract should generate. Options are CSV and HTML.
Select the Calendar(s) that should be included in the report.
Click Generate Extract to view the report in the selected format or Submit to Batch to schedule when the report will generate.

Users have the option of submitting a Disciplinary Actions report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Extract Examples

Screenshot of an example of the Disciplinary Actions extract in CSV format.

Disciplinary Actions Extract - CSV Format

Screenshot of an example of the Disciplinary Actions extract in HTML format.

Disciplinary Extract - HTML Format

Extract Layout

Element Name	Description & Format	Campus Location
idStuId	The state-assigned identification number. Alphanumeric, 9 characters	Census > People > Demographics > Person Identifiers > Student State ID Person.stateID
incidentId	The Campus-generated identifier for the resolution of record. Numeric, 6 digits	Behavior > Behavior Management > Incident > Incident ID BehaviorDetail.incidentID
actionDate	The date the resolution began. Date field, 10 characters, MM/DD/YYYY	Behavior > Behavior Management > Resolution Details > Resolution Start Date BehaviorResolution.startDate
actionId	The identification number of the disciplinary action. Numeric, 12 digits	Behavior > Behavior Management > Resolution Details > Resolution ID BehaviorResolution.number
primaryAction	The mapped State Resolution Code of the type of disciplinary action taken. Only actions greater than half a day are required to be reported. Numeric, 3 digits	Behavior > Behavior Management > Resolution Details > Resolution Type (Behavior > Admin > Resolution Types > State Code) BehaviorResolution.stateResCode
origDuration	Report Duration in School Days value rounded to 1/2 day Reports as 0 with 0 entered in Duration in School Days Reports as 0.5 when >0 and <=.5 duration Reports as 1.0 when >.5 and <-1 Rounds up to the nearest half day If Duration in School Days is null: Counts the number of dates flagged as School on the Calendar > Day editor - Non-school days must be excluded. Report in whole day increments from Resolution Start Date to Resolution End Date If Start Date = End Date, report as 1 If Resolution End Date is Null, report as 0 Numeric, 5 characters, nnn.n	Behavior > Behavior Management > Resolution Details > Duration in School Days BehaviorResolution.duration
reportingDistrictId	The state-assigned district number of the district providing educational services to the student at the time of the incident and who will oversee the disciplinary action. Numeric, 3 digits	System Administration > Resources > District Information > State District Number District.number
responsibleDistrictId	Reports the Serving District from the student's Primary enrollment. If null, reports State District Number. Numeric, 3 digits	Student Information > General > Enrollments > State Reporting Fields > Serving District; System Administration > Resources > District Information > State District Number Enrollment.servingDistrict District.number
schoolId	The state-assigned school number of the school providing educational services to the student. Numeric, 4 digits	System Administration > Resources > School > State School Number School.number
IEP	Indicates if the student has an active IEP at the time of the disciplinary action. Alphanumeric, 1 character, Y or N	Student Information > Special Ed > Documents > IEP or ID State Reporting Data Entry Plan Not dynamically stored
interimReason	The reason the student with disabilities was removed from an interim alternative education setting. Required for Resolution Types of URI or RHO. If IEP = Y and State Event Code is DRG, ALC, SBI, WPN or WPU reports state resolution code. If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU and Injury is 4, reports SBI If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is Null, Injury is not 4 and Drugs Involved is marked, reports DRG If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is either Null or No, Injury is not 4, Drugs Involved is not marked and Alcohol Involved is marked, reports ALC. If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is either Null or No, Injury is not 4 and neither Drugs Involved or Alcohol Involved is marked, reports as OTH. If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is not Null or No and any participant in the event has an Injury of 2 or 3, reports as WPU. If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is not Null or No and any participant in the event does not have an Injury of 2 or 3, reports as WPN. Alphanumeric, 3 characters	Behavior > Behavior Management > Resolution Details > Resolution Type BehaviorResolution.stateResCode
weapon	Indicates if the incident triggering the disciplinary action involved a weapon. If any offenders have a weapon code that is not null or NO (no weapon) in the event for which the reporting resolution was entered, reports a value of Y. Otherwise, reports N. The reporting resolution's event must have a classification of Weapon in order to assign a Weapon to a participant. Alphanumeric, 1 character, Y or N	Behavior > Behavior Management > Incident > Events and Participants > Participant Details > Weapon BehaviorWeapon.weaponCode
weaponType	If a weapon was involved, the type of weapon. If the Weapons Code assigned to the first offender of record is not null or NO, reports the first code entered. If the first offender of the record does not have a weapons code that is not null or NO: All other offenders on the reporting event (from first entered to last), if the weapons code is not null or NO, the first code entered reports. If all offenders do not have a weapons code entered other than null or NO, reports as NO. This field only reports if the weapon code was entered on the event for which the reporting resolution was entered. The reporting resolution's event must have a classification of Weapon in order to assign a Weapon to a participant. Numeric, 2 digits	Behavior > Behavior Management > Incident > Events and Participants > Participant Details > Weapon BehaviorWeapon.weaponCode
justiceSystem	Indicates if the justice system was involved in the incident triggering the action. Alphanumeric, 1 character, Y or N	Behavior > Behavior Management > Incident > Events and Participants Event Details > Justice System Involved BehaviorEvent.justiceSystemInvolved
modDuration	Report Modified Duration rounded to nearest 1/2 day (.05 or 0) only if a value is entered Rounds up to the nearest half-day Reports as 0.5 if <.5 Reports as 1.0 if >.5 or <=1.0 Else report as Null Numeric, 5 characters, nnn.n	Behavior > Behavior Management > Resolution Details > Modified Duration BehaviorResolution.modificationLength
modDurationReason	If the original duration was modified, reports the reason it was modified. Numeric, 2 digits	Behavior > Behavior Management > Resolution Details > Modified Duration Reason BehaviorResolution.modificationReason
zeroTolerance	Indicates if the disciplinary action was taken as a result of state or local zero tolerance policies. Alphanumeric, 1 character, Y or N	Behavior > Behavior Management > Events and Participants > Event Details > Zero Tolerance BehaviorEvent.zeroTolerancePolicy
services	Indicates if educational services were provided to the student during removal. Alphanumeric, 1 character, Y or N	Behavior > Behavior Management > Resolution Details > Educational Services After Removal BehaviorResolution.educationalServices
notes	Reports text as entered in BehaviorResolution.modificationDescription ONLY when Modified Duration Reason = 12 Else reports as Null	N/A

Element Name

Description & Format

Campus Location

idStuId

The state-assigned identification number.

Alphanumeric, 9 characters

Census > People > Demographics > Person Identifiers > Student State ID

Person.stateID

incidentId

The Campus-generated identifier for the resolution of record.

Numeric, 6 digits

Behavior > Behavior Management > Incident > Incident ID

BehaviorDetail.incidentID

actionDate

The date the resolution began.

Date field, 10 characters, MM/DD/YYYY

Behavior > Behavior Management > Resolution Details > Resolution Start Date

BehaviorResolution.startDate

actionId

The identification number of the disciplinary action.

Numeric, 12 digits

Behavior > Behavior Management > Resolution Details > Resolution ID

BehaviorResolution.number

primaryAction

The mapped State Resolution Code of the type of disciplinary action taken. Only actions greater than half a day are required to be reported.

Numeric, 3 digits

Behavior > Behavior Management > Resolution Details > Resolution Type (Behavior > Admin > Resolution Types > State Code)

BehaviorResolution.stateResCode

origDuration

Report Duration in School Days value rounded to 1/2 day

Reports as 0 with 0 entered in Duration in School Days
Reports as 0.5 when >0 and <=.5 duration
Reports as 1.0 when >.5 and <-1
- Rounds up to the nearest half day

If Duration in School Days is null:

Counts the number of dates flagged as School on the Calendar > Day editor - Non-school days must be excluded.
- Report in whole day increments from Resolution Start Date to Resolution End Date
  - If Start Date = End Date, report as 1
  - If Resolution End Date is Null, report as 0

Numeric, 5 characters, nnn.n

Behavior > Behavior Management > Resolution Details > Duration in School Days

BehaviorResolution.duration

reportingDistrictId

The state-assigned district number of the district providing educational services to the student at the time of the incident and who will oversee the disciplinary action.

Numeric, 3 digits

System Administration > Resources > District Information > State District Number

District.number

responsibleDistrictId

Reports the Serving District from the student's Primary enrollment. If null, reports State District Number.

Numeric, 3 digits

Student Information > General > Enrollments > State Reporting Fields > Serving District; System Administration > Resources > District Information > State District Number

Enrollment.servingDistrict
District.number

schoolId

The state-assigned school number of the school providing educational services to the student.

Numeric, 4 digits

System Administration > Resources > School > State School Number

School.number

IEP

Indicates if the student has an active IEP at the time of the disciplinary action.

Alphanumeric, 1 character, Y or N

Student Information > Special Ed > Documents > IEP or ID State Reporting Data Entry Plan

Not dynamically stored

interimReason

The reason the student with disabilities was removed from an interim alternative education setting. Required for Resolution Types of URI or RHO.

If IEP = Y and State Event Code is DRG, ALC, SBI, WPN or WPU reports state resolution code.
If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU and Injury is 4, reports SBI
If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is Null, Injury is not 4 and Drugs Involved is marked, reports DRG
If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is either Null or No, Injury is not 4, Drugs Involved is not marked and Alcohol Involved is marked, reports ALC.
If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is either Null or No, Injury is not 4 and neither Drugs Involved or Alcohol Involved is marked, reports as OTH.
If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is not Null or No and any participant in the event has an Injury of 2 or 3, reports as WPU.
If IEP = Y, State Event Code is not DRG, ALC, SBI, WPN or WPU, Weapon is not Null or No and any participant in the event does not have an Injury of 2 or 3, reports as WPN.

Alphanumeric, 3 characters

Behavior > Behavior Management > Resolution Details > Resolution Type

BehaviorResolution.stateResCode

weapon

Indicates if the incident triggering the disciplinary action involved a weapon.

If any offenders have a weapon code that is not null or NO (no weapon) in the event for which the reporting resolution was entered, reports a value of Y. Otherwise, reports N.

The reporting resolution's event must have a classification of Weapon in order to assign a Weapon to a participant.

Alphanumeric, 1 character, Y or N

Behavior > Behavior Management > Incident > Events and Participants > Participant Details > Weapon

BehaviorWeapon.weaponCode

weaponType

If a weapon was involved, the type of weapon.

If the Weapons Code assigned to the first offender of record is not null or NO, reports the first code entered.
If the first offender of the record does not have a weapons code that is not null or NO:
- All other offenders on the reporting event (from first entered to last), if the weapons code is not null or NO, the first code entered reports.
If all offenders do not have a weapons code entered other than null or NO, reports as NO.

This field only reports if the weapon code was entered on the event for which the reporting resolution was entered.

The reporting resolution's event must have a classification of Weapon in order to assign a Weapon to a participant.

Numeric, 2 digits

Behavior > Behavior Management > Incident > Events and Participants > Participant Details > Weapon

BehaviorWeapon.weaponCode

justiceSystem

Indicates if the justice system was involved in the incident triggering the action.

Alphanumeric, 1 character, Y or N

Behavior > Behavior Management > Incident > Events and Participants Event Details > Justice System Involved

BehaviorEvent.justiceSystemInvolved

modDuration

Report Modified Duration rounded to nearest 1/2 day (.05 or 0) only if a value is entered

Rounds up to the nearest half-day
- Reports as 0.5 if <.5
- Reports as 1.0 if >.5 or <=1.0
Else report as Null

Numeric, 5 characters, nnn.n

Behavior > Behavior Management > Resolution Details > Modified Duration

BehaviorResolution.modificationLength

modDurationReason

If the original duration was modified, reports the reason it was modified.

Numeric, 2 digits

Behavior > Behavior Management > Resolution Details > Modified Duration Reason

BehaviorResolution.modificationReason

zeroTolerance

Indicates if the disciplinary action was taken as a result of state or local zero tolerance policies.

Alphanumeric, 1 character, Y or N

Behavior > Behavior Management > Events and Participants > Event Details > Zero Tolerance

BehaviorEvent.zeroTolerancePolicy

services

Indicates if educational services were provided to the student during removal.

Alphanumeric, 1 character, Y or N

Behavior > Behavior Management > Resolution Details > Educational Services After Removal

BehaviorResolution.educationalServices

notes

Reports text as entered in BehaviorResolution.modificationDescription ONLY when Modified Duration Reason = 12

Else reports as Null

N/A

Save

Disciplinary Actions Extract (Idaho)

Report Logic

Generating the Extracts

Extract Examples

Extract Layout

Related Articles