Student Discipline Incident Behavior

Resource Overview

Ed-Fi endpoint: /data/v3/StudentDisciplineIncidentBehaviorAssociations
Published view/entity: Student Discipline Incident Behavior
Purpose: Students related to a discipline incident, including victims, perpetrators, witnesses and reporters
Source query: StudentIncBehaAssociation
Dependencies: disciplineIncidents, students

studentDisciplineIncidentBehaviorAssociations

This association indicates those students who were victims, perpetrators, witnesses, and/or reporters of a discipline incident.

Primary PowerSchool Source Data

[Incident]
[Incident_Detail]
[Incident_LU_Code]
[Students]

Selection Criteria

Records are published if the following criteria are met:

The incident must refer to an incident published in a preceding disciplineIncident resource.
The student must not be excluded from state reporting.
The student must have an active school enrollment.
The incident date falls within the year for the Term selected in the PowerSchool UI.

Resource Output

Data Element (Ed-Fi target)	Data View Column Name	Submission	[Table]Field (PowerSchool Source)	Business Rules	Comments
behaviorDescriptor	BehaviorDescriptor_DX	Y	[Incident_LU_code]State_Aggregate_Rpt_Code; Transformation: case when ilc.state_aggregate_rpt_code is not null then CST_PUBWORKFLOW_LIB.getCodeSetValue(p_profileid, 'behaviorDescriptors', ilc.state_aggregate_rpt_code) else CST_PUBWORKFLOW_LIB.getCodeSetValue(p_profileid, 'behaviorDescriptors', 'Other') end	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: BehaviorDescriptor_dx.
disciplineIncidentReference.incidentIdentifier	IncidentIdentifier	Y	[Incident]Incident_Id	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: IncidentIdentifier.
disciplineIncidentReference.schoolId	SchoolOrgID	Y	Publishing framework or supporting query Query alias: SchoolOrgID	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: SchoolOrgID.
studentReference.studentUniqueId	StudentUID	Y	[Students]DCID; Transformation: EDFI_TN_LIB.getStudentUniqueId(p_profileid, s.dcid)	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: StudentUID.
behaviorDetailedDescription	BehaviorDetailedDesc	Y	[Incident_LU_code]Incident_category	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: behaviorDetailedDesc.
disciplineIncidentParticipationCodes[].disciplineIncidentParticipationCodeDescriptor	DiscIncPart_DX	Y	[Incident_LU_code]Incident_Category; [Incident_Detail]Incident_Id; [Incident]Incident_Id; [Incident_Detail]Incident_Detail_Id; [Students]Role_Incdetail_Id; [Incident_LU_code]LU_Code_Id; [Incident_Detail]LU_Code_Id; Transformation: (select case ilc.incident_category when 'Offender' then 'Perpetrator' when 'Victim' then 'Victim' when 'Reporter' then 'Reporter' when 'Witness' then 'Witness' else null end from incident inc JOIN incident_detail ind ON ind.incident_id = inc.incident_id and ind.incident_detail_id =s.role_Incdetail_id JOIN incident_lu_code ilc ON ilc.lu_code_id = ind.lu_code_id)	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: discIncPart_dx.