SB3 PowerSchool SIS Texas
SB3 PowerSchool SIS Texas
Breadcrumbs

Discipline

Student discipline data refers to the information collected and managed regarding student behavior and disciplinary actions within a school or district.

Key components of student discipline data in Ed-Fi include:

  1. Incident Details: Information about the disciplinary incident, such as date, time, location, and description.

  2. Participants: Details about the students involved, including their roles (e.g., offender, victim, witness).

  3. Actions Taken: Records of the disciplinary actions administered, such as suspensions, detentions, or other interventions.

  4. Outcomes: The results or consequences of the disciplinary actions, including any follow-up actions or support provided to the students involved.

Resource Output

  • A student record is published for each student enrolled in the district in the year for the Term selected in the PowerSchool UI.

  • The student resource is not dependent on the prior publishing of other Ed-Fi resources.
    Note: After a student record is uploaded, it cannot be modified until a studentSchoolAssociation record in the Student Enrollment category has also been uploaded for the same student.

    • This establishes a relationship between the school, the associated LEA, and the student.

    • The LEA then has permission to modify the previously uploaded Student record.

  • LEAs and Schools may upload (publish) data to the ODS in real-time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.


disciplineIncident

Primary PowerSchool Source Data

Tables

INCIDENT (inc), INCIDENT_DETAIL (ind), INCIDENT_LU_CODE (ilc), INCIDENT_LU_SUB_CODE (ils), S_TX_INC_X

Selection Criteria

Publishes one record for each incident where:

  • Incidenttypecode = 'Discipline^'

  • Incident has Incident_Detail where refernced ilc.Code_Type = 'incidenttypecode' and ilc.Incident_Category = 'Discipline^'

  • The incident occurred during the selected school year

  • The student was an offender who was enrolled in the district during the year

  • There was a state-reportable behavior and a state-reportable action for the same student

  • There may be multiple behaviors or actions, only one of each is needed

  • State-reportable codes have state detail report code that is a descriptor value

  • Some local codes have a state detail report code defined (distirct mapped local code to state code)

Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments


schoolId


E0782

CAMPUS-ID-OF-ENROLLMENT

Enrolled school on incident date (normally same as inc.school_number)

State-assigned school id based on STUDENTS.schoolid or STUDENTS.enrollment_schoolid or REENROLLMENTS.schoolid

Y



incidentIdentifier

E1016

DISCIPLINARY-INCIDENT-NUMBER

S_TX_INC_X.State_Incident_Id

Y



incidentDate

LZ


inc.incident_ts

Y

trunc(inc.incident_ts,'DD')


incidentDescription



derived from inc.incident_title and inc.incident_detail_desc

N

substr(inc.incident_title || '.  ' || substr(inc.incident_detail_desc,1,252),1,255)


incidentLocation

E1083

BEHAVIOR-LOCATION-CODE

ils.state_detail_report_code, ilc.code_type = 'locationcode'

TX

Can't report location for certain behaviors.  District record for local tracking but reporting excludes/modifies location according to TEA rules, need to do same in Ed-Fi.  See TWEDS Business Context Rules 44425-0050 and 0051.

  • if behaviorDescriptor in 21, 22, 23, 41, 55, 56, 61 then publish '00' Not Applicable (rule 44425-0050)

  • if behaviorDescriptor in 09, 10 then publish '04' Off Campus > 300 ft (rule 44425-0051)

  • other location rules are district responsibility, publish data as entered (44425-0055 -44425-0060


behaviors



[Array]

TX




behaviorDescriptor

E1006

DISCIPLINARY-ACTION-REASON-CODE

ils.state_detail_report_code, ilc.code_type = 'behaviorcode'.  

TX

Publish each distinct behavior descriptor associated with the incident; state detail report code values are descriptor codeValues


TX Extensions




TX




safeSupportiveSchoolProgramTeamReview

E1734

SAFE-SUPPORTIVE-SCHOOL-PROGRAM-TEAM-REVIEW

ils.state_detail_report_code
where ils.sub_category = iaa.text_attribute
and iaa.incident_detail_id = ind.incident_detail_id
and ils.lu_code_id = ilc.lu_code_id
and ilc.lu_code_id = ind.lu_code_id
and ilc.code_type = 'actionattribute'
and ilc.state_aggregate_rpt_code = 'SafeSuppSchPrgReview'

TX

added 3-22; action attribute added in PSSR-293405
ilc.incident_category = 'E1734 Safe Supportive School Program Team Review^'
only if not null; state_detail_report_code is '1' or '0'

  • required if incident has action code in (01, 02, 03, 04, 05, 06, 07, 13, 14, 25, 26, 27, 28, 50, 51, 52, 53, 54, 60)

  • default to 0 (false)

  • otherwise not published


additional fields for display only











sch.school_name


district view only

studentDisciplineIncidentBehaviorAssociations


Primary PowerSchool Source Data

Tables:  INCIDENT (inc), INCIDENT_DETAIL (ind), INCIDENT_LU_CODE (ilc), INCIDENT_LU_SUB_CODE (ils), INCIDENT_PERSON_ROLE (ipr), INCIDENT_PERSON_DETAIL (ipd), INCIDENT_ACTION (iac), INCIDENT_PERSON_ACTION (ipa), STUDENTS (s), S_TX_INC_X

Selection Criteria

Publish one record for each incident/student combination where:

  • The incident is published (see criteria above)

  • Enrolled student is the offender and has a state-reportable behavior and a state-reportable action

  • The behavior is either the only state-reportable behavior for the student or is flagged as the primary behavior

  • TEA: only one state-reportable behavior is allowed for each student/incident combination

Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments


disciplineIncidentReference




Y




schoolId

E0782

CAMPUS-ID-OF-ENROLLMENT

Enrolled school on incident date (normally same as inc.school_number)

Y

State-assigned school id based on STUDENTS.schoolid or STUDENTS.enrollment_schoolid or REENROLLMENTS.schoolid



incidentIdentifier

E1016

DISCIPLINARY-INCIDENT-NUMBER

S_TX_INC_X.State_Incident_Id

Y



studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

derived from ipr.studentid

Y

State-assigned number for student  (s.state_studentnumber) but not collected by TEA


behaviorDescriptor

E1006

DISCIPLINARY-ACTION-REASON-CODE

ils.state_detail_report_code where ilc.code_type = 'behaviorcode'.  

TX

behavior must either be the only one for the student or associated ind.primary_indicator must be 'primary'


additional fields for display only











sch.school_name


district view only






s.student_number








s.lastfirst








inc.incident_ts


trunc(inc.incident_ts,'DD'

disciplineActions


Primary PowerSchool Source Data

 Tables:  INCIDENT (inc), INCIDENT_DETAIL (ind), INCIDENT_LU_CODE (ilc), INCIDENT_LU_SUB_CODE (ils), INCIDENT_PERSON_ROLE (ipr), INCIDENT_PERSON_DETAIL (ipd), INCIDENT_ACTION (iac), INCIDENT_PERSON_ACTION (ipa), INCIDENT_ACTION_ATTRIBUTE (iaa), STUDENTS (s), S_TX_INC_X

Selection Criteria

Publish one record for each state-reportable discipline action where:

  • State-reportable behavior exists for student in same incident

  • Incident is in selected school year (action may be in subsequent year)

  • Action references published studentDisciplineIncidentAssociation

Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments


responsibilitySchoolId

E1037

CAMPUS-ID-OF-DISCIPLINARY-RESPONSIBILITY

ils.state_detail_report_code
where ils.sub_category = iaa.text_attribute
and iaa.incident_detail_id = ind.incident_detail_id
and ils.lu_code_id = ilc.lu_code_id
and ilc.lu_code_id = ind.lu_code_id
and ilc.code_type = 'actionattribute'
and ilc.state_aggregate_rpt_code = 'CampusOfResp'

Y

state_detail_report_code is state-assigned school id


assignmentSchoolId

E1003

CAMPUS-ID-OF-DISCIPLINARY-ASSIGNMENT

ils.state_detail_report_code
where ils.sub_category = iaa.text_attribute
and iaa.incident_detail_id = ind.incident_detail_id
and ils.lu_code_id = ilc.lu_code_id
and ilc.lu_code_id = ind.lu_code_id
and ilc.code_type = 'actionattribute'
and ilc.state_aggregate_rpt_code = 'CampusOfAssignment'

TX

state_detail_report_code is state-assigned school id


studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

derived from ipr.studentid

Y

State-assigned number for student  (s.state_studentnumber)


disciplineActionIdentifier

E1004

DISCIPLINARY-ACTION-NUMBER

incremental action number unique by campus and student, left-zero-pad to 3 chars, e.g. '001', '002'.. for each student/school combination during the year

Y



disciplineDate

E1036

DATE-OF-DISCIPLINARY-ACTION

iac.action_plan_begin_dt

Y

format date


disciplineActionLengthDifferenceReasonDescriptor

E1009

DISCIPLINARY-LENGTH-DIFFERENCE-REASON-CODE

ilc.state_aggregate_rpt_code where code_type = 'durationcode'

TX



disciplines



[Array]

Y

Only one published per record



disciplineDescriptor

E1005

DISCIPLINARY-ACTION-CODE

ils.state_detail_report_code  where ilc.code_type = 'actioncode'

Y



studentDisciplineIncidentBehaviorAssociations



[Array]

Y

array, but TEA only allows one



incidentIdentifier

E1016

DISCIPLINARY-INCIDENT-NUMBER

S_TX_INC_X.State_Incident_Id

Y




SchoolId

E0782

CAMPUS-ID-OF-ENROLLMENT

Enrolled school on incident date (normally same as inc.school_number)

Y

State-assigned school id based on STUDENTS.schoolid or STUDENTS.enrollment_schoolid or REENROLLMENTS.schoolid



studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

derived from ipr.studentid

Y

State-assigned number for student  (s.state_studentnumber)



behaviorDescriptor

E1006

DISCIPLINARY-ACTION-REASON-CODE

ils.state_detail_report_code where ilc.code_type = 'behaviorcode'.  

TX

behavior must be flagged as primary if more than one for student in incident


TX Extensions




TX




officialLengthOfDisciplinaryAssignment

E1007

OFFICIAL-LENGTH-OF-DISCIPLINARY-ASSIGNMENT

iac.duration_assigned

TX

replaces disciplineActionLength, Oct 1 spec



actualLengthOfDisciplinaryAssignment

E1008

ACTUAL-LENGTH-OF-DISCIPLINARY-ASSIGNMENT

iac.duration_actual

TX

replaces actualDisctiplneActionLength, Oct 1 spec



inconsistentCodeOfConduct

E1656

INCONSISTENT-CODE-OF-CONDUCT-INDICATOR-CODE

ils.state_detail_report_code
where ils.sub_category = iaa.text_attribute
and iaa.incident_detail_id = ind.incident_detail_id
and ils.lu_code_id = ilc.lu_code_id
and ilc.lu_code_id = ind.lu_code_id
and ilc.code_type = 'actionattribute'
and ilc.state_aggregate_rpt_code = 'CodeOfConduct'

TX

ilc.incident_category = 'E1656 Inconsistent Code of Conduct Indicator^'
only if not null; state_detail_report_code is '1' or '0'



nonMembershipDisciplineRestraintIndicator

E1725

NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE

ils.state_detail_report_code
where ils.sub_category = iaa.text_attribute
and iaa.incident_detail_id = ind.incident_detail_id
and ils.lu_code_id = ilc.lu_code_id
and ilc.lu_code_id = ind.lu_code_id
and ilc.code_type = 'actionattribute'
and ilc.state_aggregate_rpt_code = 'NonMembershipInd'

TX

Calculated - FYI true if ADA code = 0 and student is Special Ed on date of incident
ilc.incident_category = 'E1725 Non-Membership Discipline Ind^'
publish only if state_detail_report_code = '1'


additional fields for display only











sch.school_name (responsibility school)


district view only






s.student_number








s.lastfirst











restraintEvents

Primary PowerSchool Source Data

Tables:  S_TX_STU_RESTRAINT_C, STUDENTS (s)

Selection Criteria:

Publish all restraint/seclusion events from S_TX_STU_RESTRAINT_C where:

  • Student is enrolled during school year and event date is during school year

  • Student is enrolled in Special Education program

  • OR Police Officer restraint (restraintStaffType = '02')

  • Exclude if EXCLUDE_FROM_PEIMS = 1 or student otherwise excluded from publishing

 Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments


restraintEventIdentifier

E1035

RESTRAINT-INSTANCE-NUMBER

E1035_INSTANCE_NUMBER

Y



schoolId


E1032

CAMPUS-ID-OF-RESTRAINT-EVENT

E1032_CAMPUS_ID

Y

State-assigned school id, dependency if none found


studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

derived from StudentsDCID

Y

State-assigned number for student  (s.state_studentnumber)


eventDate

E1034

DATE-OF-RESTRAINT-EVENT

E1034_RESTRAINT_DATE

Y

format date


restraintEventReasonDescriptor

E1033

RESTRAINT-REASON-CODE

E1033_RESTRAINT_REASON

TX



TX Extensions




TX




restraintStaffTypeDescriptor

E1516

RESTRAINT-STAFF-TYPE-CODE

E1516_RESTRAINT_STAFF_TYPE

TX




nonMembershipDisciplineRestraintIndicator

E1725

NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE

E1725_NON_MEM_RES_IND

TX

Filed value will be calculated


additional fields for display only











sch.school_name


district view only






s.student_number








s.lastfirst