Wisconsin Ed-Fi Data v3.3 - Student Discipline Incidents Associations

Tool Search: Ed-Fi

This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery). A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Reports a behavior incident when the incident's Status is marked and saved as "Complete" and the following criteria is met:

  • There is a student with a role mapped to the Ed-Fi Value: perpetrator.
  • There is a resolution that is mapped to an Ed-Fi Value and that generates a Discipline Actions record.
  • Do not send if the student's enrollment is marked with any of the following:

    1. No Show
    2. State Exclude
    3. WISE Exclude
    4. Parent Placement Pri. School = Yes
    5. School Override set to a different School from enrollment school
  • Do not send if the calendar is marked Summer School.
  • Do not send if the calendar is marked as exclude.
  • Do not send if the School is marked as exclude.
  • Only send a record if the Ed-Fi Config profile = Public.
  • Students with an active AND Locked IEP that overlaps the resolution start date AND Resolution in ISS, OS, EX, or ES (Ed-Fi codes 02, 03, 04).
  • IEP Print Format should start with WI IEP OR WI Imported Plan.
  • Students with NO active AND Locked IEP Must have a Resolution in OS, EX, or ES (Ed-Fi codes 02, 03, 04).
  • Only send a record if the students State Enrollment Type = Primary.
  • Do not send a record for students who do not have an active locked IEP that overlaps the date of the incident and resolution AND the SPED Exit Date on enrollment is NULL or after the date of incident when they have a mapped discipline action (behavior resolution) <> OS, EX, or ES (Ed-Fi codes 02, 03, 04)
    1. If the Resolution is mapped to IS: In-School Suspension, only report if the student has a locked IEP that overlaps the date of the Incident AND the SPED Exit Date on enrollment is NULL or after the date of the incident.
    2. If SPED Exit Date on enrollment is after the enrollment start date and on or before the date of the incident, do not report.
Put

When any field not part of the Natural Key is changed:

  • When the Incident Date is updated.
  • When the Behavior Event is updated.
  • When the seriousBodilyInjury is updated.
DeleteWhen the student's enrollment is no longer reportable; marked
  1. No Show
  2. State Exclude
  3. WISE Exclude
  4. Parent Placement Pri. School = Yes
  5. School Override set to a different School from enrollment school
  6. State Enrollment type is changed to not = Primary
DeleteWhen the participants are removed or Role is changed so there is no longer a perpetrator.
DeleteIf the Discipline Action that triggered the Incident is deleted or modified so it is no longer eligible to report.
DeleteWhen all Student Discipline Incident Associations are deleted that are associated with this Discipline Incident record.
DeleteWhen the student's Student School Association is deleted.
Delete/Post

When data that is part of the Natural Key is changed:

  • If the Date of Incident is changed and saved.
  • If the Event Type is changed and saved.
Delete/Post

When the Incident's status is changed.

  • Delete when the status is changed from Completed to In Progress.
  • Post when the status is changed from In Progress to Completed.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
ResyncIf a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
ResyncIf a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

ActionTrigger
Post/Delete

Natural Key changes:

  • If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
Delete/PostIf the Incident is deleted all dependent resources will delete.
Dependent ResourcesDiscipline Action


Scope Year Logic

This table describes scope year logic of this object.

Logic

Discipline records will only send to the school year that the incident date is aligned to based on the School Year Start and End dates.

  • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
  • If School Year End Date is NULL, 6/30/xxxx will be the default end date used.
  • Data will only send for the years that have valid configuration.


Resource Preferences

Data Element LabelMapping Needed
Behavior Event RoleStudent Participation Code Descriptor
Removal ReasonBehavior Descriptor

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
behaviorEventPost/Put/DeleteThe primary table for sending data for this resource.

Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field
idThe unique identifier of the resource.
M

discipline Incident Reference A reference to the related Discipline Incident resource.
  1. Reports the fields that are part of the Natural Key for the Discipline Incident resource.
M

studentReferenceA reference to the related Student resource.
  1. Reports the data that is part of the Natural Key for the Student resource.
M

behaviorsAn unordered collection of disciplineIncidentBehaviors. This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery). A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.
  1. See array section below for logic.
O

studentParticipationCodeDescriptor
The role or type of participation of a student in a discipline incident; for example: Victim Perpetrator Witness Reporter.
  1. Report the mapped Ed-Fi Code from the Role that is selected for the Student being reported.
    • If the student has more than 1 role with different Ed-Fi Code values, the last one to sync wins.
    • If the role is not mapped, do not report.
MBehavior > Behavior Management > Participant details > Rolebehaviorevent.role
seriousBodilyInjury
(studentDisciplineIncidentAssociationExtension)
Incident resulted in serious bodily injury. Serious Bodily Injury involves a substantial risk of death; extreme physical pain; protracted and obvious disfigurement; or protracted loss or impairment of the function of a bodily member, organ, or faculty (18 USC Section 1365 (3)(h)).
  1. If the Resolution type is mapped to SP: Placement in IAES - School Personnel:
    • If any participant in the same Event has an Injury that is indicated as 4: Serious Bodily Injury, report TRUE.
    • Otherwise if there are no injuries or no injuries that are Serious Bodily Injury, report FALSE.
  2. For any other Resolution Type, do NOT report.
CBehavior Management > Incident > Event > Participant > Injury
etagA unique system-generated value that identifies the version of the resource.
O

Arrays

Click here to expand...
Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field
Behavior Descriptor

This descriptor holds the categories of behavior describing a discipline incident.

  1. Report the mapped Ed-Fi value for the Removal Reason on the student's reported resolution.
 MBehavior Management > Incident > Event > Participant > Resolution > Removal Reason


Detailed DescriptionSpecifies a more granular level of detail of a behavior involved in the incident.
  1. If there is a weapon added on the Incident:
    • Report the Firearms Comments from the Behavior resolution.
    • If there are multiple comments in the multiple resolutions for the same student with the same Removal Reason, report only 1 set- from the resolution with the lowest ID.
      • If the comment with the lowest resolutionID has a null value, report from the next lowest ID.
  2. Truncate after 1024 characters, and end with the final characters "..."
    • Any tab or line break will be counted as a space, not a line break.
  3. Otherwise, report blank.
 O Behavior Management > Incident > Event > Participant > Resolution > Details > Firearms Comment


Type/Descriptors

Click here to expand...

Behavior Descriptors

Code

Ed-Fi Code Value

Ed-Fi Short Description

HG01

Handgun

SG02

Shotgun or Rifle

OF03

Other Firearm

DW04

Dangerous Weapon - Not Firearm

AS05Assault
AE06Endangering Behavior
DG07Drug-Related
AL08Alcohol-Related
SR09

Other Violation of School Rules

Student Participation Code Descriptor

Ed-Fi Code Value

Ed-Fi Short Description

Namespace

01

Perpetrator

uri://dpi.wi.gov/StudentParticipationCodeDescriptor