Related Services Management Report (RSMR)
The Related Services Management Report (RSMR) is an advanced report with a graphical representation that compares the time special education service is prescribed on a student’s Individualized Education Program (IEP) to the amount of time the service is provided. The report is based on data entered by the service provider via Service Capture.
The report offers bar charts for the amount of time (in minutes) and types of services prescribed and delivered per month over the report duration. The report also summarizes critical data like the Total Instruction Days within the reporting duration, Total Prescribed and delivered service minutes, Percentage of Services Completed, and Productivity Percentage.
Submission Requirements
Students must have an IEP with prescribed IEP services and service records logged for the given service to get listed on this report. To generate a report for all services delivered to a student within a specific date range, the user needs to select the reporting duration.
Users can select the reporting duration, Start and End date using the Process Schedule option.
Generate Report
From the Reporting menu, choose Advanced Reports.
Click RSMR, then click Part B Related Services Management Summary Report.
Click Process Schedule.
Enter a Start Date and End Date manually or select the dates using the calendar icon for the reporting duration.
Click Process Now In Foreground.
To review the latest data, click Unprocess and repeat steps 3 to 5.
Click the numbered cells to view the student services and service capture details. The columns here are customizable. User can add columns or fields using the Customize Columns For This Drilldown option.
Drill-Down Report Field Description and Criteria
Data Element | Description | Data Source (Profile/Form, Field Name) | Database Field Name |
---|---|---|---|
Current Assigned Provider | The system displays the provider name assigned to the IEP service record, not the provider stored in the Service Record Part B profile. | Profile: Service Record Part B | {AssignedProvider.First/middle/lastname} |
USI | The system displays the student's USI number. | Profile: Demographics Part B, USI | {StateID} |
Student Name | The system displays the student’s full name. | Profile: Demographics Part B, Student’s Name | {@CHARACTER(FirstName+" "+MiddleName+" "+LastName+" ")} |
Grade | The system displays the student's grade. | Profile: LEA Entry/Exit Part B, Grade | {EnrollmentGrade:!} |
Date of Birth | The system displays the student's birth date. | Profile: Demographics Part B, Date of Birth | {BirthDate} |
Event ID | The system displays the Special Education Data System generated document ID number. The system reports the IDT values of the latest IEP document created within the PowerSchool Special Programs or the latest migrated IEP PDF document added to the system. | N/A | N/A |
IEP Begin Date | The system displays the student’s IEP start date. | Profile: Special Education Part B, IEP Start Date | {IEPCompletionDate} |
IEP End Date | The system displays the student’s IEP end date. | Profile: Special Education Part B, IEP End Date | {IEPAnnualReviewDueDate} |
Prescribed Service | Displays the Related and Consultation Service prescribed on the Student’s IEP and is delivered. For example: Occupation Therapy. Only the services have a service record linked to it. | Profile: Part B IEP Services, IEP Service | N/A |
Prescribed Amount | Displays the Part B IEP Service duration (hours, minutes, and frequency fields). | Profile: Part B IEP Services, Duration Hours and Duration Minutes | Hours: {DurationHrs} |
Total Prescribed Minutes | The system displays the total number of minutes the student can receive the services within the IEP service date range, considering the number of hours and minutes and the frequency of the service (daily or weekly). | Profile: IEP Services Part B, Record that is linked to the service capture record | N/A |
Delivered Services Minutes | This is the total number of minutes provided to the student for the particular IEP service record. | Profile: IEP Services Part B, Record that is linked to the service capture record | N/A |
% Services Completed | This value equals the delivered services minutes divided by the total prescribed minutes. | Profile: IEP Services Part B, Completed | {Completed: M"SDX"} |
% Productivity | The value is calculated as follows: | Profile: Service Records Part B | N/A |
The drill-down report about the Total Prescribed Minutes and each month’s total minutes match the Prescribed Service Details Report columns except the Prescribed Min column.
The drill-down report about the total Delivered Services Minutes and each month’s total minutes match the Delivered Services Details Report columns except the Delivered Min column.