CASEMIS Extract C

Introduction

This extract is designed to report discipline incidents for students receiving special education services. The extract contains one record for each incident in which the student is involved. There may be more than one record per student if the student was involved in more than one incident during the report date range. By default, the report uses the date range July 1 – June 30 of the school year selected at the top of the page at report runtime.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects student records from the [Students] table based on the following criteria:

The student must have a CALPADS Program Enrollment with the Education Program Code 144 between the incident Action Begin and Action End dates.
The 144 CALPADS Program Enrollment must have an Education Program Membership Code of 1 (Eligible) or 3 (Participating).
The student must be assigned an IEP Type of 10 (IEP or IFSP) or 20 (ISP, grade K and higher).
The student must not be excluded from state reporting.
The student's school enrollment for the report date range must not be excluded from state reporting.
The student's school enrollment entry date must occur on or before 6/30/YYYY.
The student's school enrollment exit date must occur after 7/01/YYYY.
The student's school enrollment exit date must occur after the entry date (excludes no-shows).
The student's school for the report date range must not be excluded from state reporting.

Discipline Incident Records

The report selects discipline incident records based on the following criteria:

The incident must be associated with a student that meets the criteria above.
The student must be identified as an offender in the incident.
The student must be assigned to a behavior code in the incident.
The student's behavior in the incident must be assigned an action code of Suspension, In-School Suspension, or Expulsion.
The incident must be assigned an Action Authority Code of 10, 20, 30, or 31.
The Incident Type must be CA State Reporting or CA State Reporting^.
The discipline Action Begin and Action End dates must occur within the report date range.

Report Input

This report is run at the School and District level.

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to runningreport.
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
SELPA Code	Enter the Special Education Local Plan Area (SELPA) Code.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Report Output Format: The report output format for this report is comma delimited.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
C-1	REPT_DATE	The date the report completes; usually the current date.	N/A	D	8
C-2	SELPA_CODE	The Special Education Local Plan Area (SELPA) code entered at report runtime. This is the administrative unit under which a student receives special education and related services and through which special education funding is allocated.	N/A	C	4
C-3	STUDENT_ID	The student’s locally assigned student identification number.	[Students]Student_Number	C	16
C-4	SSID	The student’s statewide student identifier.	[Students]State_StudentNumber	C	10
C-5	DSPL_DATE	The date that the student was suspended or expelled. This is the Begin Date value for the Action Date Range associated with the student’s action code.	[Incident_Action]Action_Plan_Begin_Dt	D	8
C-6	DSPL_TYPE	The discipline action resulting from the incident. This is the action code assigned to the student’s behavior. To be reported, the behavior code must be assigned to the student and the action code must be assigned to the behavior. Valid values: 10 – In-School Suspension 20 – Out-of-School Suspension 30 – Expulsion See the Appendix for CASEMIS values in relation to the CALPADS values displayed in PowerSchool.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code]Incident_Category	C	2
C-7	DSPL_BY	The authority responsible for assigning the discipline action. This is the Action Authority Code associated with the student’s action code. Valid values: 10 – School or District Personnel 20 – Court Order 30 – Hearing Officer 31 – Hearing Officer – non-injury reason (CASEMIS)	[Incident_LU_Code]Code_Type=actionattribute [Incident_LU_Code]Incident_Category [Incident_LU_Code]State_Aggregate_RPT_Code = 4.19	C	2
C-8	DSL_DAYS	The number of days the discipline action was effective, i.e. the number of days the student was suspended or expelled. This is the Actual Duration value associated with the student’s action code.	[Incident_Action]Duration_Actual	C	3
C-9	REASON1	The primary reason for the discipline action. This is the primary behavior code assigned to the student for this incident. The suspension or expulsion action must be assigned to the behavior that was considered to be primary for that student in the incident. See the Appendix for valid values.	[Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code]State_Aggregate_RPT_Code [Incident_LU_Code]Incident_Category [Incident_Detail]Primary_Indicator	C	2
C-10	REASON2	An additional non-primary behavior assigned to the student for this incident. Reason2 and Reason3 are selected at random if there are multiple behaviors. See the Appendix for valid values.	[Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code]State_Aggregate_RPT_Code [Incident_LU_Code]Incident_Category	C	2
C-11	REASON3	An additional non-primary behavior assigned to the student for this incident. Reason2 and Reason3 are selected at random if there are multiple behaviors. See the Appendix for valid values.	[Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code]State_Aggregate_RPT_Code [Incident_LU_Code]Incident_Category	C	2
C-12	DSPL_STAT	The status of the student as the result of the discipline action. This is the Discipline Status value associated with the student’s action code. See the Appendix for valid values.	[Incident_LU_Code]Code_Type=actionattribute [Incident_LU_Code]Incident_Category [Incident_LU_Code]State_Aggregate_RPT_Code = 100	C	2