PowerSchool SIS Georgia
PowerSchool SIS Georgia
Breadcrumbs

Student Discipline

Information describing student discipline incidents, actions taken, and associated behaviors

Discipline Incidents

Events classified as warranting disciplinary action.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [psrw_incident]

  • [psrw_incident_behavior]

  • [s_ga_disc_x]

Selection Criteria

Business logic for publishing this resource:

  • Incident must be at the school being published

  • One record per discipline incident

  • Incident location maps to specific descriptor

  • Incident timing (before/during/after school) determined by start date/time

Resource Output

Expected output from the selection criteria:

  • SchoolReference - Reference to school

  • IncidentIdentifier - Unique incident ID

  • IncidentDate - Date of incident

  • IncidentLocationDescriptor - Location in/around school

  • Behaviors - Array of behavior descriptors

  • IncidentTimingDescriptor - GA extension: Before/during/after school

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

schoolReference

Reference to the school where incident occurred

customobject

[PSRW_Incident]schoolid

incidentIdentifier

Unique identifier for the discipline incident

string

[Incident]Incident_ID

incidentDate

Date the discipline incident occurred

datetime

[Incident]Incident_Date

incidentLocationDescriptor

Ed-Fi descriptor for where incident occurred (e.g., Classroom, Hallway, Cafeteria, Playground, Bus, Parking Lot, On the Way to/from School) (optional)

string

IncidentLoc from [PSRW_Incident]Location (optional)

behaviors

Array of behavior descriptors associated with this incident

array

[PSRW_Incident_Behavior] Joined by incident ID

behaviorDescriptor

Ed-Fi descriptor for behavior type (e.g., Assault, Attendance/Truancy, Bullying, Disrespect, Possession of Weapon, etc.) (nested in behaviors)

string

[PSRW_Incident_Behavior]BehaviorDescriptor

incidentTimingDescriptor

GA extension: Descriptor for timing of incident (Before School, During School, After School, School-Sponsored Event) (nested in _ext.Gadoe, optional)

string

TimingDescriptor_DX from [S_GA_DISC_X]Incident_Timing (optional)

Discipline Actions

Actions taken after a disruptive event recorded as a discipline incident.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [PSRW_Action]

  • [PSRW_Action_Discipline]

  • [PSRW_Action_Staff]

  • [S_GA_DISC_ACT_X]

  • [Students]

Selection Criteria

Business logic for publishing this resource:

  • Action must be associated with a student

  • Action taken by school responsible for discipline

  • Includes reference to original incident and behaviors

  • May reference alternate school if action involves school transfer

Resource Output

Expected output from the selection criteria:

  • responsibilitySchoolReference - School responsible for discipline

  • assignmentSchoolReference - School where action applied (optional)

  • studentReference - Reference to disciplined student

  • disciplineActionIdentifier - Unique action ID

  • disciplineDate - Date action taken

  • disciplines - Array of discipline types (e.g., Expulsion, Suspension)

  • studentDisciplineIncidentBehaviorAssociations - Link to behaviors

  • staffs - Array of staff members reporting discipline

  • disciplineActionLength - Duration of suspension/expulsion (optional)

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

responsibilitySchoolReference

Reference to the school responsible for the discipline action

customobject

[PSRW_Action]SchoolId

assignmentSchoolReference

Reference to school where student is assigned as result of action (e.g., alternate school for expulsion)

customobject

[S_GA_DISC_ACT_X]AlternateSchoolID (optional)

studentReference

Reference to the student receiving discipline

customobject

[Students]ID

disciplineActionIdentifier

Unique identifier for this discipline action

string

[PSRW_IncidentAction]Action_ID

disciplineDate

Date when discipline action was taken

datetime

[PSRW_IncidentAction]Discipline_Date

disciplines

Array of discipline actions taken (e.g., Suspension, Expulsion, Detention, Other)

array

[PSRW_Action_Discipline] Joined by Action ID

disciplineDescriptor

Ed-Fi descriptor for specific discipline type (nested in disciplines)

string

[PSRW_Action_Discipline]DisciplineDescriptor

studentDisciplineIncidentBehaviorAssociations

Array linking this action to incident behaviors (nested associations)

array

[PSRW_Action_Incident_Behaviorr] Joins to Incident Behaviors

behaviorDescriptor

Behavior descriptor from original incident (nested in studentDisciplineIncidentBehaviorAssociations)

string

[PSRW_Incident_Behavior]BehaviorDescriptor

staffs

Array of staff members reporting the discipline action

array

[PSRW_Action_Staff]References

staffUniqueId

Unique ID of staff member reporting discipline (nested in staffs)

string

[Users]DCID from [PSRW_Action_Staff]

receivedEducationServicesDuringExpulsion

Boolean indicator of whether student received education services during expulsion

boolean

[S_GA_DISC_ACT_X]ReceivedEdServices (optional)

disciplineActionLength

Duration of suspension or expulsion in days

number

[S_GA_DISC_ACT_X]DisciplineActionLength (optional)

dataTypeIndicatorDescriptor

GA extension: Descriptor indicating data type (nested in _ext.Gadoe, optional)

string

[S_GA_DISC_ACT_X]DataTypeIndicatorDesc (optional)

disciplineProcessTypeDescriptor

GA extension: Descriptor for discipline process type (nested in _ext.Gadoe, optional)

string

[S_GA_DISC_ACT_X]DisciplineProcessTypeDesc (optional)

incidentSeverityLevelDescriptor

GA extension: Descriptor for incident severity level (nested in _ext.Gadoe, optional)

string

[S_GA_DISC_ACT_X]IncidentSeverityLevelDesc (optional)

disciplineStaffUniqueId

GA extension: Unique ID of staff member initiating discipline (nested in _ext.Gadoe, optional)

string

[S_GA_DISC_ACT_X]DisciplineStaffId (optional)

alternateSchoolId

GA extension: School ID for alternate placement (nested in _ext.Gadoe, optional)

number

[S_GA_DISC_ACT_X]AlternateSchoolID (optional)

disciplineActionAuxiliaryDescriptor

GA extension: Auxiliary discipline descriptor (nested in _ext.Gadoe, optional)

string

[S_GA_DISC_ACT_X]DisciplineActionAux_Dx (optional)

Discipline Behavior Associations

Behaviors of a student associated with a specific discipline incident.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [psrw_incident_behavior]

  • [psrw_incident]

  • [students]

Selection Criteria

Business logic for publishing this resource:

  • One record per incident-student-behavior triplet

  • Incident must belong to the school being published

  • References the original discipline incident

Resource Output

Expected output from the selection criteria:

  • behaviorDescriptor - Behavior type descriptor

  • disciplineIncidentReference - Reference to incident

  • studentReference - Reference to student involved

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

behaviorDescriptor

Ed-Fi descriptor for behavior type observed (e.g., Assault, Bullying, Insubordination, etc.)

string

[PSRW_IncidentParticipant]Behavior_Code

disciplineIncidentReference

Reference to the discipline incident with which this behavior is associated

customobject

[PSRW_Incident]IncidentIdentifier and [PSRW_Incident]SchoolID

incidentIdentifier

Unique identifier of the incident (nested in disciplineIncidentReference)

string

[PSRW_Incident]IncidentIdentifier

studentReference

Reference to the student whose behavior is reported

customobject

[Students]State_StudentNumber

studentUniqueId

Unique identifier of the student (nested in studentReference)

string

[Students]State_StudentNumberor ID