Student Discipline File Layout
The following table shows the CALPADS field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Student Discipline State file.
Field # | Field Name | Required? | eSchoolPlus | eSchoolPlus Column | Where to find data in eSchoolPlus |
---|---|---|---|---|---|
4.01 | Record Type Code | Y |
|
| Not found in eSchoolPlus. This value will always be SDIS. |
4.02 | Transaction Type Code | N |
|
| Not found in eSchoolPlus. This field tells CALPADS if the data being sent is an update, deletion or new record. |
4.03 | Local Record ID | N |
|
| Not being sent in files created in eSchoolPlus |
4.04 | Reporting LEA | Y | reg_entry_with | building | First 7 characters of State Equivalency Code for the building on the Entry/Withdrawal record being reported for the student. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel. |
4.05 | School of Attendance | Y | reg_entry_with | building | Last 7 characters of State Equivalency Code for the building on the Entry/Withdrawal record being reported for the student. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel. |
4.06 | Academic Year ID | Y |
|
| From the School Year prompt on CALPADS extract/download page. |
4.07 | SSID | Y | reg_personal | state_report_id | Registration > Entry & Reports > Student Demographic > Personal—SSID field. |
4.08 | Local Student ID | Y | reg_entry_with | student_id | Student ID field |
4.09 | Student Legal First Name | Y | reg | first_name | Registration > Entry & Reports > Student Demographic > Registration—First Name field. Since the State file may only include Alphabetic letters, numbers, periods, hyphens and apostrophes any other characters in this field will be stripped out for the State File. |
4.10 | Student Legal Last Name | Y | reg | last_name | Registration > Entry & Reports > Student Demographic > Registration—Last Name field. Since the State file may only include Alphabetic letters, numbers, periods, hyphens and apostrophes any other characters in this field will be stripped out for the State File. |
4.11 | Student Birth Date | Y | reg | birthdate | Registration > Entry & Reports > Student Demographic > Registration—Birth Date field. |
4.12 | Student Gender Code | Y | reg | gender | Registration > Entry & Reports > Student Demographic > Registration—Gender field |
4.13 | Disciplinary Incident ID Local | Y | disc_incident | incident_id | Interventions > All > Office > Incident Detail > click appropriate Incident link – Number field |
4.14 | Disciplinary Incident Occurrence Date | Y | disc_incident | incident_date | Interventions > All > Office > Incident Detail > click appropriate Incident link – Date field. |
4.15 | Student Offense Code | Y | disc_off_code converted to disc_incident_code | offense_code converted to state_code_equiv | Interventions > All > Office > Incident Detail > click appropriate Incident link > Offenders panel – Offense field. |
4.16 | Incident Most Severe Offense Code | Y | disc_user converted to disc_incident_code | field_value where page_number = 200, page_type = I, and field_number = 1 | To view the Most Severe Offense discipline incident district-defined page, select Interventions > All > Office > Incident Detail > click appropriate Incident link > Other Incident Information panel > Most Severe Offense – Most Severe Offense field. |
4.17 | Weapon Category Code | If Student Offense Code = 100, 101, 103, 104, or 105, then Y. Else N | disc_off_weapon converted to disctb_weapon | weapon_code converted to state_code_equiv | Interventions > All > Office > Incident Detail > click appropriate Incident link > Offenders panel > click View Detail > General panel – Weapon field |
4.18 | Incident Disciplinary Action Taken Code | Y | disc_off_action converted to disctb_off_action | action_code converted to state_code_equiv | Interventions > All > Office > Incident Detail > click appropriate Incident link > Offenders panel > click View Detail > Actions panel – Action Code field. |
4.19 | Disciplinary Action Authority Code | Required if Education Program Code = 144 and Disciplinary Action Taken Code < > 300 | disc_user | field_value where page_number = 200, page_type = O, and field_number = 2 | Interventions > All > Office > Incident Detail > click appropriate Incident link > Offenders panel > click View Detail > Other Offender Information panel > CA Offender – Disp Action Authority Code field. |
4.20 | Incident Disciplinary Action Duration Days | If Incident Disciplinary Action Taken Code < > 300, then Y; else N. | disc_off_action | actual_duration | Interventions > All > Office > Incident Detail > click appropriate Incident link > Offenders panel > click View Detail > Actions panel – Actual Duration field. |
4.21 | Student Instructional Support Indicator | If Education Program Code = 144 and Incident Disciplinary Action Taken Code < > 300, then Y. | disc_user | field_value where page_number = 200, page_type = O, and field_number = 3 | Interventions > All > Office > Incident Detail > click appropriate Incident link > Offenders panel > click View Detail > Other Offender Information panel > CA Offender – Student Inst Support Indicator field. |
4.22 | Disciplinary Action Modification Category Code | If Disciplinary Action = 200, then Y; else N. | disc_off_action converted to disctb_reason | reason_code converted to state_code_equiv | Interventions > All > Office > Incident Detail > click appropriate Incident link > Offenders panel > click View Detail > Actions panel – Reason For Difference field. |
4.23 | Removal to Interim Alternative Setting Reason Code | N | disc_user | field_value where page_number = 200, page_type = O, and field_number = 4 | Interventions > All > Office > Incident Detail > click appropriate Incident link > Offenders panel > click View Detail > Other Offender Information panel > CA Offender – Removal to Interim Alternative field. |