Discipline Extract (Massachusetts) [.2144 - .2235]

Tool Search: Extracts

The Discipline Extract collects Resolution assigned to Offenders in behavior Offenses. 

Image 1: Discipline Extract Editor

Report Logic

A record will report for each student with a Role = 'Offender' and a Relationship to school with a dictionary value of 'student' on the Behavior Event that also meets the following criteria:

  • A Participant has a Primary enrollment on the 'Date of Incident' in order to report a record.
  • A Behavior Resolution is connected to the student offender with:
    • The Resolution Start Date is between the 1st instructional day of the Incident calendar and the Effective Date, AND a resolution is mapped to a proper state code (Behavior > Admin > Resolution Type > State Resolution Code (Mapping))

      OR

    • The student offender has a Behavior Event mapped to state event code

One record will report per resolution with a valid State Resolution Code mapped. 

Generating the Extract

  1. Select Discipline Extract as the Extract Type.
  2. Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date. This field will auto-populate to the current date.
  3. Select the Format in which the report should generate. Select State Format (CSV) for submission to the state or HTML format for data review and verification.
  4. Mark the Header Off checkbox if the header row should not be included in the extract.
  5. Select an Ad hoc Filter to limit report results.
  6. 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 Discipline 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.

 

Image 2: Example of the Report in HTML Format

Extract Layout

Element Name

Description

Location

OFF ID

The Incident Number.


Numeric, 6 digits

BehaviorEvent.incidentID


Behavior > Behavior Management > Incident > Incident ID

OFF DATE

The date the incident occurred.


Date field, 10 character (MM/DD/YYYY)

BehaviorEvent.timestamp


Behavior > Behavior Management > Incident > Date of Incident

SASID

The state-assigned identification number of the student.


Numeric, 10 digits 

Person.stateID


Census > People > Demographics > Person Identifiers > State ID

FN

The participant's first name.


Alphanumeric, 50 characters

Identity.firstName


Census > People > Demographics > First Name

LN

The participant's last name.


Logic reports the student's last name. Only hyphens, periods or apostrophes will report for the last name.



Alphanumeric, 50 characters

Identity.lastName


Census > People > Demographics > Last Name

DOB

The participant's date of birth.


Date field, 10 characters (MM/DD/YYYY )

Identity.birthDate


Census > People > Demographics > Date of Birth

PST

Indicates if the participant is involved in special education according to the Primary enrollment active on the Date of Incident.

  • Reports as 2 if the participant has a locked IEP with an abbreviation = IEP
  • If the student associated with the Resolution has a non-null value in the Special Ed Setting field, a value of 2 is reported
  • Otherwise, reports as 1.
 

The enrollment viewed is the enrollment that was active on the Date of Incident, with priority given to the Primary enrollment.


Numeric, 1 digit

Calculated, not dynamically stored


Student Information > Special Ed > Documents; Student Information > General > Enrollments > Special Ed Fields > Special Ed Setting

DAT

Reports the Disciplinary action taken (Behavior Resolution) code.


Logic reports the code with the highest calculated DM value, when the resolution is mapped to a state code of 1-5. If more than one resolution is mapped to a state code of 1-5 qualifies as the highest DM value, reports the highest mapped state code. 


If the resolution is mapped to a state code of 6, reports as 6.


Numeric, 1 digit

BehaviorResolution.code


Behavior > Behavior Management > Incident > Resolution

BI OFF

This field reports blank.

N/A

SD

The Start Date of the disciplinary action. 


Report 1 record per resolution with a State Resolution Code Mapping 1-6.


Date field, 10 characters (MM/DD/YYYY)

BehaviorRevolution. discAssignDate


Behavior > Behavior Management > Incident > Resolution > Resolution Date

RD

The date the participant returned to school.

Reporting logic is as follows:

  • Report the date in Behavior Management > Incident Management Editor > Events and Participants > Resolution Details > Resolution End Date.



Date field, 10 characters (MM/DD/YYYY)


BehaviorResolution. endDate


Behavior Management > Incident Management Editor > Events and Participants > Resolution Details > Resolution End Date

ERD

Reports as blank.

N/A

DM

This field reports number of school days missed based on the calculations below

  • When RD (Resolution End Date) Not = Null, report the number of instructional days (instruction = Checked) between the SD and RD (Resolution End Date) when Resolution Type is NOT 3089
  • When RD (Resolution End Date) = Null and Return Date <> Null, report the number of instructional days between the SD and the Return Date when Resolution Type is NOT 3089
  • When RD (Resolution End Date) and Return Date = Null, AND the enrollment End Date <> Null, report the number of instructional days between the SD and Enrollment End Date when Resolution Type is NOT 3089
  • When Return Date, RD (Resolution End Date) and AND Enrollment End Date = Null, report the number of instructional days between the SD and the Effective Date when Resolution Type is NOT 3089 1-6.
    1. The enrollment viewed is the enrollment that was active on the Date of incident, with priority given to the Primary enrollment.
    2. Note:  If no end date or return date provided, the value will continue to change depending on effective date entered.
  • When (RD) Resolution End Date  = NULL, day count between either the Resolution Start Date (SD) and the Enrollment End Date, OR the Resolution Start Date (SD) and Return Date, whichever field has an earlier date.
  • Counts all unique removed instructional days for the reported resolution assigned to the student on the event with Resolution State Code that is NOT mapped to 3089

Numeric, 3 digits

BehaviorResolution.
discAssignDate


Student Information > General > Behavior Tab > Behavior Resolution > Resolution Date

AEINC

This field reports blank.

N/A

AE

Reports the Alternative Education code selected.

  • - Educational Services Plan not Offered
  • 1 - Home Tutoring
  • 2 - In-district education services (specify in AEX)
  • 3 - Out-of-district education services (specify in AEX)
  • 6 - Distance learning
  • 7 - Saturday School
  • 9 - Student refused the offer of education services
  • 10 - Student did  not respond to the offer of education services
  • 11 - Student moved or transferred

Numeric, 2 digits

BehaviorResolution. 
altPlacement


Behavior > Behavior Management > Incident > Resolution > Alt Ed Code

ARREST

Indicates a school-related arrest referring to an arrest of a student for any activity conducted on school grounds, or during off-campus activities (including while taking school transportation), or due to a referral by any school official. All school-related arrests are considered referrals to law enforcement. 

  • When the resolution code is "3089" or if the Arrest checkbox is checked, report "Y"
  • Else, report "N"

Alphanumeric, 1 character (Y or N)

dbo.BehaviorResoltuion. stateResCode

dbo.CampusAttribute WHERE object = 'BehaviorResolution' AND element = 'lawEnforcement'


Behavior > Behavior Management > Add/Edit Resolution > Resolution Details > Arrest


LAWENFREF
  1. If event has both resolution codes of MA61 and MA62, report 03
  2. If event only has resolution code of MA61, report 01
  3. If event only has resolution code of MA62, report 02
  4. Else, report 00

Alphanumeric, 2 characters

BehaviorResolution.code

Student Information > General > Behavior Tab > Behavior Resolution > Behavior Resolution
APPEAL

Reports a null value.

N/A
AEXReports a null value.N/A
SOT1

Reports the first valid Offense ID (Event Type Code).


From across all Behavior Events associated with this Incident, logic reports the Standard Code for the State Event Mapped Code of the first valid Event Type Code. This Code reports from the lowest Event ID that has a state valid code.

  • If the student has a Behavior Event associated with an Event Type with State Event Mapping Code = 3700, report the 4-digit Standard Code selected for Weapon Type.

For Standard Code 9000 (old code of 18):

  • When a Behavior Resolution mapped to 1 through 7 is NOT connected to the Behavior Event mapped to standard code 9000, this Behavior Event must not be considered to report.
  • When SOT1 = 9000, SOT2 - SOT5 reports 500

 

Standard Code 9000 may only be reported in SOT1. SOT1 cannot report the same value as any other SOT field.

 

Field reports the same value reported in OT1 of the Offense Report.


Alphanumeric, 3 characters

BehaviorEvent.code1

Behavior > Behavior Management > Incident > Event > State Code
SOT2

Reports the 2nd valid Offense ID.


From across all Behavior Events associated with this Incident, logic reports the Standard Code for the State Event Mapped Code of the second valid Event Type Code. This Code should report from the 2nd lowest Event ID that has a valid Standard state code.

  • If the student has a Behavior Event associated with an Event Type with State Event Mapping Code = 3700, report the 4-digit Standard Code selected for Weapon Type.
  • If Standard Code = 9000 for SOT2, report 500.
  • SOT2 cannot report the same value as any other SOT field unless they report as 500.

When there is no second valid standard state code, report 500.

 

Field reports the same value reported in OT2 of the Offense Report.


Alphanumeric, 3 characters

BehaviorEvent.code2

Behavior > Behavior Management > Incident > Event > State Code
SOT3

Reports the 3rd valid Offense ID.


From across all Behavior Events associated with this Incident, logic reports the Standard Code for the State Event Mapped Code of the third valid Event Type Code. This Code should report from the third lowest Event ID that has a valid Standard state code.

  • If the student has a Behavior Event associated with an Event Type with State Event Mapping Code = 3700, report the 4-digit Standard Code selected for Weapon Type
  • If Standard Code = 9000 for SOT3, report 500.
  • SOT3 cannot report the same value as any other SOT field unless they report as 500.

When there is no third valid standard state code, report 500.

 

Field reports the same value reported in OT3 of the Offense Report.


Alphanumeric, 3 characters

BehaviorEvent.code3

Behavior > Behavior Management > Incident > Event > State Code
SOT4

Reports the 4th valid Offense ID.


From across all Behavior Events associated with this Incident, logic reports the State Event Mapped Code of the fourth valid Event Type Code. This Code should report from the 4th lowest Event ID that has a state valid code.

  • If the student has a Behavior Event associated with an Event Type with State Event Mapping Code = 3700, report the 4-digit Standard Code selected for Weapon Type.
  • If Standard Code = 9000 for SOT4, report 500.
  • SOT4 cannot report the same value as any other SOT field unless they report as 500.

When there is no fourth valid standard state code, report 500.

 

Field reports the same value reported in OT4 of the Offense Report.


Alphanumeric, 3 characters

BehaviorEvent.code4

Behavior > Behavior Management > Incident > Event > State Code
SOT5

Reports the 5th valid Offense ID.


From across all Behavior Events associated with this Incident, logic reports the Standard Code for the State Event Mapped Code of the fifth valid Event Type Code. This Code should report from the fifth lowest Event ID that has a valid Standard state code.

  • If the student has a Behavior Event associated with an Event Type with State Event Mapping Code = 3700, report the 4-digit Standard Code selected for Weapon Type.
  • If Standard Code = 9000 for SOT5, report 500.
  • SOT5 cannot report the same value as any other SOT field unless they report as 500.

When there is no fifth valid standard state code, report 500.

 

Field reports the same value reported in OT5 of the Offense Report.


Alphanumeric, 3 characters


BehaviorEvent.code5

Behavior > Behavior Management > Incident > Event > State Code

Previous Versions

Discipline Extract (Massachusetts) [.2036 - .2140]
Discipline Extract (Massachusetts) [.2028 - .2032]