CASEMIS Extract B

Introduction

California Special Education Management Information System Software (CASEMIS) Extract B is designed to report student service record data to the California Department of Education (CDE). The extract file contains the following records:

At least one record for each student in CASEMIS Extract A, except those students with an IEP type of 80 or 90.
One record for each service received by the student.

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 not be excluded from state reporting.
The student's school enrollment must not be excluded from state reporting.
The student's school must not be excluded from state reporting.
The student must have a CALPADS Program Enrollment with the Education Program Code 144 during the Submission timeframe chosen at report runtime.

Program Service Records

The report selects program service records from the [S_CA_STU_PrgServices_C] table based on the following criteria:

The service must be associated with an active student who meets the selection criteria above.
The service Start Date must occur during the Submission timeframe chosen at report runtime.
The service must be active during the Submission timeframe chosen at report runtime.

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.
Submission	Choose the appropriate submission from the pop-up menu: December – Choose this submission to run the report for students who were enrolled in the school on December 1^st of the reported school year. End of Year – Choose this submission to run the report for students who were enrolled in the school between July 1^st and June 30^th of the year selected in the years and terms dropdown.
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
B-1	REPT_DATE	The date of the report.	N/A	D	8
B-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
B-3	STUDENT_ID	The student's local student identification number.	[Students]Student_Number	C	16
B-4	SSID	The student's statewide student identifier.	[Students]State_StudentNumber	C	10
B-5	SERVICE	The service code entered on the CASEMIS Student Service page.	[S_CA_STU_SPEDPrgServices_C]ServiceCode	C	3
B-6	PROVIDER	The provider code entered on the CASEMIS Student Service page.	[S_CA_STU_SPEDPrgServices_C]ProviderCode	C	3
B-7	LOCATION	The location code entered on the CASEMIS Student Service page.	[S_CA_STU_SPEDPrgServices_C]LocationCode		3
B-8	FREQUENCY	The frequency entered on the CASEMIS Student Service page. This field should be populated for infants only.	[S_CA_STU_SPEDPrgServices_C]FrequencyCode	C	2
B-9	DURATION	The duration entered on the CASEMIS Student Service page. This field should be populated for infants only.	[S_CA_STU_SPEDPrgServices_C]Duration	C	4