Resource Overview
-
Ed-Fi endpoint:
/data/v3/disciplineActions -
Published view/entity: Discipline Action
-
Purpose: Actions taken after a disruptive event recorded as a discipline incident
-
Source query:
DisciplineAction -
Dependencies:
students
disciplineActions
This event resource represents actions taken by an education organization after a disruptive event that is recorded as a discipline incident.
Primary PowerSchool Source Data
-
[Incident]
-
[Incident_Action]
-
[Incident_lu_Code]
-
[Students]
Selection Criteria
Records are published if the following criteria are met:
-
The discipline action record must refer to an incident published in a preceding disciplineIncident and studentDisciplineIncidentBehaviorAssociation resources.
-
The studentUniqueId is populated in PowerSchool.
-
The student must not be excluded from state reporting.
-
The student must have an active school enrollment.
-
The incident and discipline action dates fall 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 |
|---|---|---|---|---|---|
|
responsibilitySchoolReference.schoolId
|
SchoolOrgID |
Y |
[Students]Schoolid; Transformation: EDFI_TN_LIB.FormatLEASchoolid(p_profileid,s.schoolid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SchoolOrgID. |
|
assignmentSchoolReference.schoolId
|
SchoolOrgID |
Y |
[Students]Schoolid; Transformation: EDFI_TN_LIB.FormatLEASchoolid(p_profileid,s.schoolid) |
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. |
|
disciplineActionIdentifier
|
ActionIdentifier |
Y |
[Incident_Action]Incident_Action_Id |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: ActionIdentifier. |
|
disciplineDate
|
DisciplineDate |
Y |
[Incident_Action]Discipline_Actiondate; Transformation: to_char(l.discipline_actiondate, 'YYYY-MM-DD') |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: DisciplineDate. |
|
disciplineActionlength
|
DisciplineLength |
Conditional |
[Incident_Action]Discipline_DurationAssigned |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: DisciplineLength. |
|
actualDisciplineActionLength
|
ActualLength |
Conditional |
[Incident_Action]Discipline_DurationActual |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: ActualLength. |
|
relatedToZeroTolerancePolicy
|
RelatedToZeroTolerancePolicy
|
Conditional |
[PSRW_Incidentactionattribute]State_Detail_Report_Code; Transformation: case when att.STATE_DETAIL_REPORT_CODE ='Y' then 1 when att.STATE_DETAIL_REPORT_CODE ='N' then 0 end |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: relatedToZeroTolerancePolicy. |
|
disciplines[].disciplineDescriptor
|
DisciplineDescriptor |
Y |
[Incident_LU_code]Discipline_ActionTaken |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: DisciplineDescriptor. |
|
studentDisciplineIncidentBehaviorAssociations[].studentDisciplineIncidentBehaviorAssociationReference.behaviorDescriptor
|
BehaviorDescriptor |
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. |
|
studentDisciplineIncidentBehaviorAssociations[].studentDisciplineIncidentBehaviorAssociationReference.incidentIdentifier
|
IncidentIdentifier |
Y |
[Incident]Incident_Id |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: IncidentIdentifier. |
|
studentDisciplineIncidentBehaviorAssociations[].studentDisciplineIncidentBehaviorAssociationReference.schoolId
|
SchoolOrgID |
Y |
[Students]Schoolid; Transformation: EDFI_TN_LIB.FormatLEASchoolid(p_profileid,s.schoolid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SchoolOrgID. |
|
studentDisciplineIncidentBehaviorAssociations[].studentDisciplineIncidentBehaviorAssociationReference.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. |
|
staffs[].staffReference.staffUniqueId
|
StaffUID |
Y |
Publishing framework or supporting query Query alias: StaffUID |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StaffUID. |
|
iepPlacementMeetingIndicator
|
IepPlacementIndicator |
Conditional |
Publishing framework or supporting query Query alias: IepPlacementIndicator |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: IepPlacementIndicator. |
|
receivedEducationServicesDuringExpulsion
|
ReceivedEdServicesDuringExp |
Conditional |
Publishing framework or supporting query Query alias: ReceivedEdServicesDuringExp |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: ReceivedEdServicesDuringExp. |