Student Discipline File (P)

Student Discipline File (P) - (No longer an active data file)
Beginning with the 2018-19 school year this file is no longer active.
Student Discipline Exclusion Data is submitted through File (R) beginning with the 2018-19 school year.

The following table shows the CEDARS field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Student Discipline File (P) State file.

Field #	Field Name	Required?	eSchoolPlus Table	eSchoolPlus Column	Where to find data in eSchoolPlus
P01	School Year	Yes			From the School Year prompt on Create CEDARS Downloads & Extract Files page
P02	Serving County District Code	Yes	reg_district	state_code_equiv	Administration > General Setup > District > District: State Equivalency Code field
P03	District Student ID	Yes	reg_entry_with	student_id	Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > click School Year link: Student ID field
P04	State Student ID	Yes	reg_personal	state_report_id	Registration > Entry & Reports > Student Demographic > Personal: State ID field.
P05	Location ID	Yes	reg_entry_with converted to reg_building	building converted to state_code_equiv	Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > click School Year link: Building field
P06	Incident Date	Yes	disc_incident	incident_date	Interventions > All > Office > Incident Detail > click Incident link > Incident panel: Date
P07	Behavior Code	Yes	disc_off_code converted to disc_incident_code	offense_code converted to state_code_equiv	Interventions > All > Office > Incident Detail > click Incident link > Offenders panel: Offense field If the student has multiple offenses for the incident, report the offense with the highest Severity Order in the Incident Codes Discipline validation table, 1 being the highest-priority value.
P08	Corrective or Disciplinary Action Date	Required if P09 has a value	disc_off_action	start_date	Interventions > All > Office > Incident Detail > Offenders panel: Scheduled Start Date field
P09	Corrective or Disciplinary Action Applied	Yes	disc_off_action converted to disctb_off_action	action_code converted to state_code_equiv	Interventions > All > Office > Incident Detail > Offenders panel: Action Code field If the student has multiple Actions for the incident, report the action with the highest Severity Order in the Offense Actions Discipline validation table, 1 being the highest-priority value.
P10	Number of Intervention Days	Required if P09 has a value	disc_off_action	actual_duration	Interventions > All > Office > Incident Detail > Offenders panel: Actual Duration field The state accepts this value only in whole or half-day increments, such as 1, 2, or 1.5. The WA District page's Intervention Days should be setting determines how the CEDARS Download handles decimal values that are not in increments of 0.5. If there are multiple Action Codes, total Actual Duration days for all actions that (1) have State Code Equivs and (2) are listed in the WA District page's Disciplinary Actions field.
P11	Incident ID	Yes	disc_incident	incident_id	Interventions > All > Office > Incident Detail > Incident panel: Incident ID field
P12	Weapon Type	Required if P07 has value of 8 – Possession of a Weapon	disc_off_weapon	weapon_code	Interventions > All > Office > Incident Detail > Offenders panel: Weapon field
P13	Interim Alternative Education Setting	Required if student is reported as special ed. Services in Student Special Education Programs file	disc_user	field_value where screen_type = O, screen_number = 420 and column_number = 1	Interventions > All > Office > Incident Detail > Offenders panel > click View Detail > Other Offender Information panel > WA Offender Information: Interim Alternative Education field
P14	Emergency Expulsion	Yes	Calculated	Calculated	If the Corrective or Disciplinary Action Applied (P09) is EE – Emergency Expulsion, set this value to Y – Yes. Otherwise, report N – No.
P15	Emergency Expulsion Days to Conversion	Required if P14 is Y and P09 is not EE	disc_off_action	actual_duration or schd_duration	Interventions > All > Office > Incident Detail > Offenders panel: Actual Duration or Scheduled Duration
P16	Other Behaviors	No	disc_off_code converted to disc_incident_code	offense_code converted to state_code_equiv	Comma delimited list of additional disciplinary offenses (behaviors) associated with the incident for the reported student. This is in addition to the behavior reported in field P07. Interventions > All > Office > Incident Detail > Offenders panel
P17	Academic Services	Conditional. Required if P09 is SS, LS, or EX	disc_user	field_value where screen_type = O, screen_number = 420 and column_number = 2	Interventions > All > Office > Incident Detail > Offenders panel > click View Detail > Other Offender Information panel > WA Offender Information: Academic Services field
P18	Behavior Services	Conditional. Required if P09 is SS, LS, or EX	disc_user	field_value where screen_type = O, screen_number = 420 and column_number = 3	Interventions > All > Office > Incident Detail > Offenders panel > click View Detail > Other Offender Information panel > WA Offender Information: Behavior Services field
P19	Date Petition for Readmission Submitted	No	disc_user	field_value where screen_type = O, screen_number = 420 and column_number = 4	Interventions > All > Office > Incident Detail > Offenders panel > click View Detail > Other Offender Information panel > WA Offender Information: Petition Readmission Submitted field
P20	Date Petition for Readmission Granted	No	disc_user	field_value where screen_type = O, screen_number = 420 and column_number = 5	Interventions > All > Office > Incident Detail > Offenders panel > click View Detail > Other Offender Information panel > WA Offender Information Petition Readmission Granted field
P21	Petition to Exceed More Than One Year	Conditional. Required if P09 is LS or EX	disc_user	field_value where screen_type = O, screen_number = 420 and column_number = 6	Interventions > All > Office > Incident Detail > Offenders panel > click View Detail > Other Offender Information panel > WA Offender Information: Petition to Exceed > 1 Year field
P22	Date Reengagement Meeting Held	No	disc_user	field_value where screen_type = O, screen_number = 420 and column_number = 7	Interventions > All > Office > Incident Detail > Offenders panel > click View Detail > Other Offender Information panel > WA Offender Information: Reengagement Meeting Held field
P23	Reengagement Plan	Conditional. Required if P09 is SS, LS, or EX	disc_user	field_value where screen_type = O, screen_number = 420 and column_number = 8	Interventions > All > Office > Incident Detail > Offenders panel > click View Detail > Other Offender Information panel > WA Offender Information: Reengagement Plan field
P24	Appeal Code	Conditional. Required if P09 is LS or EX	disc_user	field_value where screen_type = O, screen_number = 420 and column_number = 9	Interventions > All > Office > Incident Detail > Offenders panel > click View Detail > Other Offender Information panel > WA Offender Information: Appeal Code field