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 |
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 |
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 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 | 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. |
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 |