Resource Overview
-
Ed-Fi endpoint:
/data/v3/disciplineIncidents -
Published view/entity: Discipline Incident
-
Purpose: Events classified as warranting disciplinary action
-
Source query:
DisciplineIncident -
Dependencies: No resource dependency is declared.
disciplineIncident
This resource 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. A single event (for example, a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting disciplinary action.
Primary PowerSchool Source Data
-
[Incident]
-
[incident_LU_Sub_Code]
-
[Teachers]
Selection Criteria
Records are published if the following criteria are met:
-
The incident date falls within the year for the Term selected in the PowerSchool UI.
-
The student must not be excluded from state reporting.
-
The student must have an active school enrollment.
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
schoolReference.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. |
|
staffReference.staffUniqueId |
StaffUniqueId |
Y |
[Teachers]Users_DCID; Transformation: CST_PUBWORKFLOW_LIB.getStaffUniqueId(p_profileid, u.users_dcid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StaffUniqueId. |
|
incidentIdentifier |
|
Y |
[Incident]Incident_Id |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: IncidentIdentifier. |
|
incidentDate |
IncidentDate |
Y |
[Incident]Incident_Date Transformation: to_char(l.Entry_Date, 'YYYY-MM-DD') |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: IncidentDate. |
|
incidentDescription |
IncidentDescription |
Conditional |
[Incident]Incident_Detail_Desc Transformation: substr(to_char(l.Entry), 1, 300) |
Submit when the source alias is populated and the parent structure is applicable. Title + detail description (max 255 Chars) |
JSON type: string. Query alias: IncidentDescription. |
|
behaviors[].behaviorDescriptor |
Behavior_DX |
Y |
[Incident_LU_Sub_Code]State_Detail_Report_Code; Transformation: CST_PUBWORKFLOW_LIB.getCodeSetValue(p_profileid, 'behaviorDescriptors', ils.State_Detail_Report_Code) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: Behavior_DX. |