Classic View: CA State Reporting > CALPADS Student Discipline
Search Terms: CALPADS Student Discipline
This extract is used to submit student discipline information in the End of Year 3 reporting period. There are three separate files included in this version:
- Student Incident File (SINC), which generates one record for every incident that has an event with a state code, a resolution with a state code, or a restraint/seclusion response associated to the incident.
- Student Incident Result File (SIRS), which generates one record for every resolution that has a state code or a restraint/seclusion response associated to the incident.
- Student Offense File (SOFF), which generates one record for each student associated to an incident that has an event with a state code.
Report Logic
All behavior incidents that are either tied to a Behavior Event that is assigned a State Code or a behavior response that is associated with a restraint or seclusion reports. The Reporting Year is July 1 through June 30.
All reportable events within the same Incident ID report and have the same Incident Number.
Each reportable Behavior Event has one record. When a student is assigned multiple Behavior Resolutions for the same event, all state resolutions associated with that event report, including behavior responses with restraints and seclusions.
The following students do not report:
- Student not marked as Offender.
- Students who do not have a State ID.
- Students who have Behavior Referrals that are in draft status or In-Progress Behavior Incidents.
- Students marked as state exclude, in grade levels marked as state exclude or in calendars marked as state exclude.
Incidents containing students marked as Offender with Behavior Events (State Event Code 100-105, 200-205, 300, 400-401, 403, 500-513, 600-602) with a resolution of Suspension or Expulsion (State Resolution Codes: 3, 100, 110, or 200) report. The Event Date must be during the current Reporting Year (July 1 to the following June 30).
- If a student has multiple reportable Offenses in an Incident, only one Offense needs to have a reportable Resolution associated with it. The same Resolution Code and other related data reports for all of the student's Offenses in the Incident.
Each applicable behavior event/resolution within the Incident has one record. Multiple records report with the same Incident ID if there are multiple Events with reportable codes (100-105, 200-205, 300, 400-401, 403, 500-513, 600-602). All students with reportable events/resolutions within the Incident report with the same Incident ID.
If the student has multiple reportable resolutions linked to the same event, only the final resolution reports. The final resolution is identified as:
- The reportable resolution with the most recent Start Date.
- If there are multiple reportable resolutions with the same start date, the order of priority is State Resolution Code 200 (1), 3 (2), 100 (3), 110 (4), 300 (5).
Non-Binary Gender Reporting
Schools can assign students a gender of M: Male, F: Female, X: Non-binary. This is done on the Identities tool and/or the Demographics tool.
CALPADS Extracts use the Legal Gender field included in the Protected Identity Information to report student and staff identity information.
To record a gender of X: Non-binary, on the Identities tool:
- Assign the Gender of X: Non-Binary in the standard identify fields.
- Assign the Protected Identity Information Legal Gender of M: Male, F: Female, or X: Non-binary.
- Save the record when finished.
Report Editor
The following fields are available on the Student Discipline Extract.
Field | Description |
---|---|
Report Type | Indicates which file generates. Select one of the following:
|
Transaction Type | Indicates the type of transaction that occurs - Replace or Delete. |
Format | Determines how the report generates. Select State Format (Caret Delimited) if submitting records to the state. Other formats available for testing and review purposes are CSV and HTML. |
Report Participants | When marked, reports a record for students if their behavior incident role is Participant the same way as if their behavior incident role is Offender. |
Ad hoc Filter | Select which students to include in the extract, if desired, by choosing a filter that was created in the Filter Designer. |
Calendar Selection | Select the calendar(s) of enrollment from which to pull student data. Calendars can be chosen by the active year, by the school name or by the year. |
Report Generation Options | Choose the Generate Extract to display the results of the chosen items immediately. Choose the Submit to Batch option to generate the report without affecting general system usage. This option is helpful when generating large amounts of data. |
Generate the Student Discipline File
- Select the desired Report Type from the dropdown list.
- Select the Transaction Type from the dropdown list: Replace or Delete.
- Select the Format of the file. Choose the State Format (Caret Delimited) when submitting records to CALPADS.
- Mark the Report Participants checkbox, if desired.
- Use the Ad hoc Filter to select students already included in a filter. This is not required. If not chosen, all students who have reportable behavior records are included.
- Select the Calendars to include in the file.
- Click the Generate Extract button. Or generate the extract through the Batch Queue using the Submit to Batch button. The file appears in a new window in the selected format.
Report Layout
Student Incident File
Data Elements | Description | Location |
---|---|---|
Record Type Code | Type of data record being submitted. Chosen on the extract editor. Reports a value of SINC. Alphanumeric, 4 characters | Not dynamically stored |
Transaction Type Code | Action the state should take with this record. Reports a value of D (Delete) if selected as the Transaction Type on the Extract Editor; otherwise, reports blank. Alphanumeric, 1 character | Not dynamically stored |
Local Record ID | This field reports blank. | N/A |
Reporting LEA | A unique identifier for the educational service institution in which the Staff person is employed. If the reporting calendar is from a School with Type = 15: Independently Reporting Charter, the State School Number reports (not the State District Number). This field reports the Secondary District Number when the reporting calendar has a School Type of 16: Secondary State District Number. Numeric, 7 digits | System Administration > Resources > District Information > State District Number District.number System Administration > Resources > School > School Number School. number System Administration > Resources > School > Type School.type |
School of Attendance | A unique identifier for the school that delivers a majority of educational instruction and services and is where the student attends. If the CDS Number field is populated on the School editor, that value reports.
Numeric, 7 digits | System Administration > Resources > School > State School Number System Administration > Resources > School > CDS Number School.Number |
Academic Year ID | A unique identifier assigned to a specific Academic Year. An Academic Year is the period during which school is in regular session and provides a required number of days of instruction. Date field, 9 characters (CCYY-CCYY) | System Administration > Calendar > School Years > Start Year/End Year Calendar.schoolYear |
SSID | The unique identifier for the student assigned by the first California district in which the student is enrolled in accordance with CDE established standards. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
Local Student ID | A unique identifier assigned to the student by a local educational agency. Numeric, up to 15 digits | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
First Name | Student's legal first name. If the Legal First Name field is populated on the earlier identity, information reports from that field. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > First Name Identity.firstName Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name Identity.legalFirstName |
Last Name | Student's legal last name. If the Legal Last Name field is populated on the earlier identity, information reports from that field. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name Identity.legalLastName |
Student Birth Date | Student’s date of birth. Date field, 8 characters (CCYYMMDD) | Census > People > Demographics > Person Information > Birth date Identity.birthDate |
Student Gender | Student’s gender. If the Legal Gender field is populated, information reports from that field. See the Non-Binary Gender Reporting section for additional information. Alphanumeric, 1 character (M or F) | Census > People > Demographics > Person Information > Gender Identity.gender Census > People > Identities > Identity Information > Protected Identity Information > Legal Gender Identity.legalGender |
Incident ID Local | A unique identifier for a Disciplinary Incident. Alphanumeric, 20 characters | Student Information > General > Behavior > Incident Detail > Incident ID Behavior.incidentID |
Incident Occurrence Date | The date on which a disciplinary incident occurred. Date field, 8 characters | Behavior Management > Incident Detail Information > Date of Incident Behavior.timestamp |
Statutory Offense Indicator | A coded value representing the Student Offense. Numeric, 3 digits | Behavior Management >Events and Participants > Add Event/Participant > Event Details > Event Type BehaviorEvent.code |
Student Instructional Support Indicator | An indicator of whether or not a student is receiving instructional support from the local educational agency during a disciplinary action. If the value for Disciplinary Action Taken is NOT 300:
When the value for Disciplinary Action Taken is 300, a blank value reports for this field. If there are multiple Event records within the Incident for the student, the same Instructional Support value reports for all records. This field is required to be populated for Special Ed-eligible students when the Disciplinary Action (Resolution) is other than 300. Alphanumeric, 1 character (Y or N) | Behavior > Behavior Management > Events and Participants > Resolution > Resolution Details > Instructional Support BehaviorResolution.service Provided |
Removal to Interim Alternative Setting Reason Code | A coded value representing the reason a student was removed to an interim alternative setting for 45 days or less. If an Interim Alternative Setting code is selected, that code reports if the student has a 144: Special ED Flag with a start date/eligibility start date on or after the active school year start and an end date/eligibility end date on or before the end date of the active school year end date. The Date of Offense must be between the Flag 144 start date/eligibility start date and Flag 144 end date/eligibility end date. The earliest date is used for the start date; the latest date is used for the end date. If the offense occurred outside of the Flag 144 start and end dates, it does not report. If Disciplinary Action Taken is reporting 300 (by the state code on the resolution or by mapping the resolution in the extract to 300) and the student has an active Flag 144 at the time of the incident, a value of 3 reports; otherwise, the selected Interim Alternative Setting reports. All special education students who report a value of 300 need to have an Interim Alternative Reason Setting Code. Available options are:
If the student does not have a 144: Special ED Flag, this field reports blank. If the student has a 144: Special ED Flag and the State Resolution Code is 300, then the Removal to Interim Alternative Setting Reason Code must be 3 (No Removal). If the State Resolution Code is anything other than 300, report as selected. Numeric, 1 digits | Behavior > Behavior Management > Events and Participants > Resolution > Resolution Details > Interim Alternative Setting Reason BehaviorResolution.altPlacement |
Student Incident Result File
Data Elements | Description | Location |
---|---|---|
Record Type Code | Type of data record being submitted. Chosen on the extract editor. Reports a value of SIRS. Alphanumeric, 4 characters | Not dynamically stored |
Transaction Type Code | Action the state should take with this record. Reports a value of D (Delete) if selected as the Transaction Type on the Extract Editor; otherwise, reports blank. Alphanumeric, 1 character | Not dynamically stored |
Local Record ID | This field reports blank. | N/A |
Reporting LEA | A unique identifier for the educational service institution in which the Staff person is employed. If the reporting calendar is from a School with Type = 15: Independently Reporting Charter, the State School Number reports (not the State District Number). This field reports the Secondary District Number when the reporting calendar has a School Type of 16: Secondary State District Number. Numeric, 7 digits | System Administration > Resources > District Information > State District Number District.number System Administration > Resources > School > School Number School.number System Administration > Resources > School > Type School.type |
School of Attendance | A unique identifier for the school that delivers a majority of educational instruction and services and is where the student attends. If the CDS Number field is populated on the School editor, that value reports.
Numeric, 7 digits | System Administration > Resources > School > State School Number System Administration > Resources > School > CDS Number School.number |
Academic Year ID | A unique identifier assigned to a specific Academic Year. An Academic Year is the period during which school is in regular session and provides a required number of days of instruction. Date field, 9 characters (CCYY-CCYY) | System Administration > Calendar > School Years > Start Year/End Year Calendar.schoolYear |
SSID | The unique identifier for the student assigned by the first California district in which the student is enrolled in accordance with CDE established standards. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
Local Student ID | A unique identifier assigned to the student by a local educational agency. Numeric, up to 15 digits | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
First Name | Student's legal first name. If the Legal First Name field is populated on the earlier identity, information reports from that field. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > First Name Identity.firstName Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name Identity.legalFirstName |
Last Name | Student's legal last name. If the Legal Last Name field is populated on the earlier identity, information reports from that field. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name Identity.legalLastName |
Student Birth Date | Student’s date of birth. Date field, 8 characters (CCYYMMDD) | Census > People > Demographics > Person Information > Birth date Identity.birthDate |
Student Gender | Student’s gender. If the Legal Gender field is populated, information reports from that field. See the Non-Binary Gender Reporting section for additional information. Alphanumeric, 1 character (M or F) | Census > People > Demographics > Person Information > Gender Identity.gender Census > People > Identities > Identity Information > Protected Identity Information > Legal Gender Identity.legalGender |
Incident ID Local | A unique identifier for a Disciplinary Incident. Alphanumeric, 20 characters | Student Information > General > Behavior > Incident Detail > Incident ID Behavior.incidentID |
Incident Result | Reports the State Code representing the resolution assigned to the student for the specific incident, in separate lines.
If the behavior incident has a behavior event for 501 and for 100, only two lines report for the incident, even if the behavior incident also contains a behavior response for Physical Restraint. Numeric, 3 digits | Behavior > Behavior Management > Incidents > Resolution > State Code BehaviorResolution.resolutionCode |
Incident Result Authority | Reports the code associated with the resolution. The default value set in the Attribute Dictionary reports, when a default value is assigned. When there is no default value, this field reports blank. When there are multiple Event records within the Incident for the student, the same Disciplinary Action Authority Code reports for all records. When the student was in a Program flagged with code 144 (Special Education) and Disposition Code (Resolution Field 14) 100, 110 or 200, this field reports blank. Numeric, 3 digits | Behavior Management > Behavior > Resolution > Incident Result Authority BehaviorResolution.auxillaryCode |
Incident Result Duration Days | The length of time, in school days, that a disposition for a student for a specific incident lasted. When the Disposition Code (Resolution, Field 14) is 100, 110 and 200:
When the Disposition Code field is not 100, 110 and 200, this field reports blank. Numeric, 6 characters which can include a decimal (N, N.N, N.NN, NN, NN.N, NN.NN, NNN, NNN.N, NNN.NN) | Behavior > Behavior Management > Events and Participants > Resolution > Resolution Details > Resolution Date and End Date or Duration in School Days (priority) BehaviorResolution.startDate BehaviorResolution.endDate BehaviorResolution.schoolDaysDuration |
Incident Result Modification Code | Describes a modification made to an expulsion order, such as shortening the term of the expulsion. If the Incident Result Code (Resolution, Field 14) reports a value of 200, that value reports. If Incident Result Code is not populated, reports a value of 300. For all other Resolutions, this field reports blank. If there are multiple Event records within the Incident for the student, the same Incident Result Action Modification Code must report on all records. Numeric, 3 digits | Behavior > Behavior Management > Events and Participants > Resolution > Resolution Details > Expulsion Modification BehaviorResolution.modificationReason |
Student Offense File
Data Elements | Description | Location |
---|---|---|
Record Type Code | Type of data record being submitted. Chosen on the extract editor. Reports a value of SOFF. Alphanumeric, 4 characters | Not dynamically stored |
Transaction Type Code | Action the state should take with this record. Reports a value of D (Delete) if selected as the Transaction Type on the Extract Editor; otherwise, reports blank. Alphanumeric, 1 character | Not dynamically stored |
Local Record ID | This field reports blank. | N/A |
Reporting LEA | A unique identifier for the educational service institution in which the Staff person is employed. If the reporting calendar is from a School with Type = 15: Independently Reporting Charter, the State School Number reports (not the State District Number). This field reports the Secondary District Number when the reporting calendar has a School Type of 16: Secondary State District Number. Numeric, 7 digits | System Administration > Resources > District Information > State District Number District.number System Administration > Resources > School > School Number School. number System Administration > Resources > School > Type School.type |
School of Attendance | A unique identifier for the school that delivers a majority of educational instruction and services and is where the student attends. If the CDS Number field is populated on the School editor, that value reports.
Numeric, 7 digits | System Administration > Resources > School > State School Number System Administration > Resources > School > CDS Number School.number |
Academic Year ID | A unique identifier assigned to a specific Academic Year. An Academic Year is the period during which school is in regular session and provides a required number of days of instruction. Date field, 9 characters (CCYY-CCYY) | System Administration > Calendar > School Years > Start Year/End Year Calendar.schoolYear |
SSID | The unique identifier for the student assigned by the first California district in which the student is enrolled in accordance with CDE established standards. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
Local Student ID | A unique identifier assigned to the student by a local educational agency. Numeric, up to 15 digits | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
First Name | Student's legal first name. If the Legal First Name field is populated on the earlier identity, information reports from that field. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > First Name Identity.firstName Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name Identity.legalFirstName |
Last Name | Student's legal last name. If the Legal Last Name field is populated on the earlier identity, information reports from that field. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name Identity.legalLastName |
Student Birth Date | Student’s date of birth. Date field, 8 characters (CCYYMMDD) | Census > People > Demographics > Person Information > Birth Date Identity.birthDate |
Student Gender | Student’s gender. If the Legal Gender field is populated, information reports from that field. See the Non-Binary Gender Reporting section for additional information. Alphanumeric, 1 character (M or F) | Census > People > Demographics > Person Information > Gender Identity.gender Census > People > Identities > Identity Information > Protected Identity Information > Legal Gender Identity.legalGender |
Incident ID Local | A unique identifier for a Disciplinary Incident. Alphanumeric, 20 characters | Student Information > General > Behavior > Incident Detail > Incident ID Behavior.incidentID |
Student Offense Code | A coded value representing the Student Offense. Numeric, 3 digits | Behavior Management >Events and Participants > Add Event/Participant > Event Details > Event Type BehaviorEvent.code |
Weapon Category Code | Reports the assigned weapon code. If the State Event Code is 100, 101, 103, 104 or 105, the value is reported from the Weapon Category field. Otherwise, this field reports blank. Numeric, 2 digits | Behavior > Behavior Management > Events and Participants > Participant Details > Weapon BehaviorWeaon.weaponCode |