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 Table	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. To view the State Equivalent Code, select Administration > General Setup > District > Validation Tables > select Discipline > Incident Codes – State Equivalent Code.
4.16	Incident Most Severe Offense Code	Y	disc_user converted to disc_incident_code or disc_off_code converted to disc_incident_code	field_value where page_number = 200, page_type = I, and field_number = 1 or offense_code for the Disciplinary Incident ID Local with the highest priority Severity Order in the Incident Codes validation table. This is based on a scale where 1 has the highest priority. The highest priority offense_code is converted to state_code_equiv	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. To view all Offenses associated with the incident, select Interventions > All > Office > Incident Detail > click appropriate Incident link > Offenders panel – review all listed Offenses. To see assigned Severity Orders for offenses, select Administration > General Setup > District > Validation Tables > select Discipline > Incident Codes – Severity Order field. To view the State Equivalent Code, select Administration > General Setup > District > Validation Tables > select Discipline > Incident Codes – State Equivalent Code.
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 To view the State Equivalent Code, select Administration > General Setup > District > Validation Tables > select Discipline > Weapons.
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. To view the State Equivalent Code, select Administration > General Setup > District > Validation Tables > select Discipline > Offense Actions.
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. If Disp Action Authority Code field is blank but at least one of the "Required If" conditions applies, then the Student Discipline file defaults a value of 10 – School or district personnel.
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. Must be populated if Disciplinary Action Duration is greater than 10 days.	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. If Disciplinary Action = 200 and Reason For Difference is blank, default 300 in this field for No Modification. This default is created by the Extract/State File processing.
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.