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:
Incident Details: Information about the disciplinary incident, such as date, time, location, and description.
Participants: Details about the students involved, including their roles (e.g., offender, victim, witness).
Actions Taken: Records of the disciplinary actions administered, such as suspensions, detentions, or other interventions.
Outcomes: The results or consequences of the disciplinary actions, including any follow-up actions or support provided to the students involved.
disciplineIncident
eSP Source Data
Tables: DISC_INCIDENT (di), DISC_NON_STUDENT (ns), REG_ENTRY_WITH(rew), REG_BUILDING(rb)
Selection Criteria
Publishes one record for each incident where:
The incident occurred during the selected school year
There was an offender who was a student enrolled in the district during the year
There was a state-reportable behavior and a state-reportable action
State-reportable codes have non-ull state_code_equiv
There may be multiple behaviors or actions, only one of each is needed
Resource Output
The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
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.
Resource | Data Element | Description | TX Element | TX Element Name | eSP Source | Required? | Comments |
disciplineIncident | |||||||
schoolId | E0782 | CAMPUS-ID-OF-ENROLLMENT | rb.state_code_equiv of rew.building where di.incident_date falls between rew.entry_date and rew.withdrawal_date | Y | State-assigned school id | ||
incidentIdentifier | E1016 | DISCIPLINARY-INCIDENT-NUMBER | di.incident_id | Y | |||
incidentDate | Local | di.incident_date | Y | ||||
incidentDescription | di.comments | N | base profile, not reqired | ||||
incidentLocation | E1083 | BEHAVIOR-LOCATION-CODE | disctb_location.state_code_equiv where disctb_location.code = di.location | TX | |||
behaviors | [Array] | TX | |||||
behaviorDescriptor | E1006 | DISCIPLINARY-ACTION-REASON-CODE | disc_incident_code.state_code_equiv where disc_incident_code.code = di.incident_code | TX | |||
reportedToLawEnforcement | di.police_notified | N | base profile, not reqired; true if 'Y' | ||||
reporterDescriptionDescriptor | di.is_student | N | base profile, not reqired; if 'Y' then 'Student', if 'S' then 'Staff', when ns.staff_member = 'Y' then 'Non-school personnel' else 'Other' | ||||
reporterName | derived from di.is_student | N | base profile, not reqired; if 'Y then reg first & last name, if 'S' then reg_staff first & last name, if 'N' then disc_non_student first & last name | ||||
staffUniqueId | when di.is_student = 'S' then di.person_id | N | base profile, not reqired; get staff UniqueId if school staff | ||||
TX Extensions | TX | ||||||
safeSupportiveSchoolProgramTeamReview | E1734 | SAFE-SUPPORTIVE-SCHOOL-PROGRAM-TEAM-REVIEW | dosc_user.field_value where screen_number 1, field_number 3 | TX | added 3-22
| ||
additional fields for display only | |||||||
sch.school_name | district view only | ||||||
studentDisciplineIncidentBehaviorAssociations
eSP Source Data
Tables: DISC_OFFENDER (dof), DISC_OFF_CODE (doc), DISC_INCIDENT_CODE (dic)
Selection Criteria
Publishes 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 state-reportable action
Building not transfer building, not out-of-district
One record for each DISC_OFFENDER in current year
TEA: only one state-reportable behavior is allowed for each student/incident combination
Resource Output
The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
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.
Resource | Data Element | Description | TX Element | TX Element Name | eSP Source | Required? | Comments |
studentDisciplineIncidentBehaviorAssociations | |||||||
disciplineIncidentReference | Y | ||||||
schoolId | E0782 | CAMPUS-ID-OF-ENROLLMENT | rb.state_code_equiv of rew.building where di.incident_date falls between rew.entry_date and rew.withdrawal_date | Y | State-assigned school id | ||
incidentIdentifier | E1016 | DISCIPLINARY-INCIDENT-NUMBER | dof.incident_id; dv.incident_id; dw.incident_id | Y | |||
studentUniqueId | E1523 | TX-UNIQUE-STUDENT-ID | ru.field_value where ru.screen_number = 10165, ru.field_number = 1 | Y | State-assigned number for student but not collected by TEA | ||
behaviorDescriptor | E1006 | DISCIPLINARY-ACTION-REASON-CODE | doc.code, dic.state_cove_equiv | TX | behavior must be either the only one for the student or the primary one | ||
behaviorDetailedDescription | doc.offense_comment | N | |||||
additional fields for display only | |||||||
district view only | |||||||
trunc(inc.incident_ts,'DD' | |||||||
disciplineActions
eSP Source Data
Tables: DISC_OFFENDER (dof), DISC_OFF_ACTION (doa), DISCTB_OFF_ACTION (dtoa)
Selection Criteria
Publishes one record for each state-reportable discipline action where:
Student was offender, enrolled during school year
Building is not transfer building, not out-of-district
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
May be multiple records per student per incidentEd-Fi spec allows multiple disciplines in a record but publish separate record for each incident_action
Resource Output
The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
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.
Resource | Data Element | Description | TX Element | TX Element Name | eSP Source | Required? | Comments |
disciplineActions | |||||||
responsibilitySchoolId | E1037 | CAMPUS-ID-OF-DISCIPLINARY-RESPONSIBILITY | doa.resp_building | Y | State-assigned school id, dependency if none found | ||
assignmentSchoolId | E1003 | CAMPUS-ID-OF-DISCIPLINARY-ASSIGNMENT | doa.assign_building | TX | |||
studentUniqueId | E1523 | TX-UNIQUE-STUDENT-ID | ru.field_value where ru.screen_number = 10165, ru.field_number = 1 where ru.student_id = dof.person_id (is_student = 'Y') | Y | State-assigned number for student | ||
disciplineActionIdentifier | E1004 | DISCIPLINARY-ACTION-NUMBER | legacy TX eSP uses an incremented action number unique by campus and student, e.g. 1, 2, 3.. for each student/school combination during the year | Y | Replicate legacy TX eSP if practical, otherwise use base profile: dof.incident_id + '-' + dof.offender + '-' + doa.action_number | ||
disciplineDate | E1036 | DATE-OF-DISCIPLINARY-ACTION | doa.start_date | Y | format date | ||
disciplineActionLengthDifferenceReasonDescriptor | E1009 | DISCIPLINARY-LENGTH-DIFFERENCE-REASON-CODE | disctb_reason.state_code_equiv where disctb_reason.code = doa.reason_code | TX | |||
disciplines | [Array] | Y | Only one published per record | ||||
disciplineDescriptor | E1005 | DISCIPLINARY-ACTION-CODE | doa.action_code, dtoa.state_code_equiv | Y | |||
studentDisciplineIncidentBehaviorAssociations | [Array] | TX | Replaces studentDisciplineIncidentAssociations array, TEA allows only one | ||||
incidentIdentifier | E1016 | DISCIPLINARY-INCIDENT-NUMBER | dof.incident_id | Y | |||
SchoolId | E0782 | CAMPUS-ID-OF-ENROLLMENT | rb.state_code_equiv of rew.building where di.incident_date falls between rew.entry_date and rew.withdrawal_date | Y | State-assigned school id | ||
studentUniqueId | E1523 | TX-UNIQUE-STUDENT-ID | dof.person_id (is_student = 'Y') | Y | State-assigned number for student | ||
behaviorDescriptor | E1006 | DISCIPLINARY-ACTION-REASON-CODE | doc.code, dic.state_cove_equiv | Y | behavior must be either the only one for the student or the primary one | ||
TX Extensions | TX | ||||||
officialLengthOfDisciplinaryAssignment | E1007 | OFFICIAL-LENGTH-OF-DISCIPLINARY-ASSIGNMENT | doa.schd_duration | TX | replaces disciplineActionLength, Oct 1 spec | ||
actualLengthOfDisciplinaryAssignment | E1008 | ACTUAL-LENGTH-OF-DISCIPLINARY-ASSIGNMENT | doa.actual_duration | TX | replaces actualDisctiplneActionLength, Oct 1 spec | ||
inconsistentCodeOfConductIndicator | E1656 | INCONSISTENT-CODE-OF-CONDUCT-INDICATOR-CODE | disc_act_user.field_value where disc_act_user.screen_number = '10100' and field_number = 1. join to doa on building,incident_id,action_number,off_vic_wit_id | TX | |||
nonMembershipDisciplineRestraintIndicator | E1725 | NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE | disc_act_user.field_value where disc_act_user.screen_number = '10100' and field_number = 2. join to doa on building,incident_id,action_number,off_vic_wit_id | TX | |||
additional fields for display only | |||||||
district view only | |||||||
restraintEvents
eSP Source Data
Tables: DISC_OFFENDER (dof), DISC_OFF_ACTION (doa), DISCTB_OFF_ACTION (dtoa)
Selection Criteria
Publishes one record for each state-reportable discipline action where:
Publishes all restraint/seclusion events 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')
Student is not excluded from publishing
Resource Output
The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
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.
Resource | Data Element | Description | TX Element | TX Element Name | eSP Source | Required? | Comments |
restraintEvents | |||||||
restraintEventIdentifier | E1035 | RESTRAINT-INSTANCE-NUMBER | tx_restraint.instance_number | Y | |||
schoolId | E1032 | CAMPUS-ID-OF-RESTRAINT-EVENT | reg_building.state_code_equiv where reg_building.building = tx_restraint.building | Y | |||
studentUniqueId | E1523 | TX-UNIQUE-STUDENT-ID | ru.field_value where ru.screen_number = 10165, ru.field_number = 1 where ru.student_id = tx_restraint.student_id | Y | State-assigned number for student | ||
eventDate | E1034 | DATE-OF-RESTRAINT-EVENT | tx_restraint.event_date | Y | format date | ||
restraintEventReasonDescriptor | E1033 | RESTRAINT-REASON-CODE | tx_restraint.reason | TX | |||
TX Extensions | TX | ||||||
restraintStaffTypeCodeDescriptor | E1516 | RESTRAINT-STAFF-TYPE-CODE | tx_restraint.staff_type | TX | |||
nonMembershipDisciplineRestraintIndicator | E1725 | NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE | tx_restraint.non_mem_disc_restraint | TX | |||
additional fields for display only | |||||||
district view only | |||||||