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 incident -
Ed-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 |