Classic Path: KY State Reporting > Resolution Length Calculation Tool
Search Terms: Resolution Length Calculation Tool
The Resolution Length Calculation Tool allows you to manually recalculate the Duration in School Days value for all resolutions impacted by a change in the calendar after the resolution was created. This tool also generates a report detailing all Duration in School Days values modified during the recalculation.
Image 1: Resolution Length Calculation Tool Editor
Tool Rights
Path: System Administration > User Security > Users > Tool Rights > KY State Reporting > Resolution Calculation Tool
New Look of Campus Path: User Management > User Accounts > Tool Rights > Reporting > KY State Reporting > Resolution Calculation Tool
Read | Write | Add | Delete |
|---|---|---|---|
| User can run calculations and view the results report | User can run calculations and view the results report | User can run calculations and view the results report | User can run calculations and view the results report |
Generate the Report
To generate the report:
- Enter the Date Range. Only resolutions which overlap the selected date range will have the Duration in School Days field recalculated.
- Select a Report Format.
- Select which Calendars will have Duration in School Days field data recalculated.
- Click Run Test. This will run a test and generate a report of all Duration in School Days data that will be recalculated.
After reviewing the test run, select how the report will be generated:
Run Immediately initiates recalculation of the Duration in School Days field for all behavior resolutions within the Calendar and Date Range selected and generates the report in the designated format. Submit to Batch The report is sent to the batch queue where it will generate at a scheduled time. To avoid any system performance issues, use this option when a large amount of data will be changed.
Image 3: Example of the Report in HTML Format
Understand Report Results
Use the table below to better understand each column of the report.
| Data Element | Description | Format | Campus Application and Database |
|---|---|---|---|
| School | Name of the school reporting data. | Text | System Administration > Resources > School > Name School.name |
| State Student ID | Reports the unique identifier for a given student connected with the incident. | XXXXXXXXXX 10 digit number | Student Information > Demographics > Student State ID Person.stateID |
| Last Name | The last name of the incident participant. | Text | Census > People > Last Name Identity.lastName |
| First Name | The first name of the incident participant. | Text | Census > People > First Name Identity.firstName |
| Incident Title | The title of the behavior incident. | Text | Behavior > Behavior Management Tool > Incident > Title BehaviorIncident. |
| Incident Date | The date the behavior incident occurred. | DD/MM/YYYY (e.g. 11/24/2012) Leading zeros are not included in CSV format (e.g. 9/9/2012) | Behavior > Behavior Management Tool > Incident > Date BehaviorIncident. |
| Event ID | The unique behavior event ID for the behavior incident. | XXXXX Numeric, varying lengths. | Behavior > Behavior Management Tool > Incident > Event ID |
| Behavior Type | The local district behavior event type for the behavior incident. | Text | Behavior > Behavior Management Tool > Incident > Event Type BehaviorType.name |
| Resolution ID | The unique resolution ID for the behavior incident. | XXXXX Numeric, varying lengths. | Behavior > Behavior Incident Manager Tool > Incident > Resolution ID BehaviorResolution. |
| Resolution State Code | Indicates if the incident resulted in a state resolution. | Alpha-numeric code (e.g. SSP1) | Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code BehaviorResType. |
| Resolution Type | The local district resolution type for the behavior incident. | Text | Behavior > Behavior Management Tool > Incident > Resolution > Resolution Type BehaviorResType. |
| Resolution Start Date | The start date of the behavior resolution. | DD/MM/YYYY (e.g. 11/24/2012) Leading zeros are not included in CSV format (e.g. 9/9/2012) | Behavior > Behavior Management Tool > Incident > Resolution > Resolution Start Date BehaviorResolution. |
| Resolution Start Time | The start time of the behavior resolution. | HH:MM AA Alpha-numeric, leading zero for the hour is not included in CSV format (e.g. 9:15 AM) | Behavior > Behavior Management Tool > Incident > Resolution > Resolution Start Time BehaviorResolution. |
| Resolution End Date | The end date of the behavior resolution. | DD/MM/YYYY (e.g. 11/24/2012) Leading zeros are not included in CSV format (e.g. 9/9/2012) | Behavior > Behavior Management Tool > Incident > Resolution > Resolution End Date BehaviorResolution. |
| Resolution End Time | The end time of the behavior resolution. | HH:MM AA Alpha-numeric, leading zero for the hour is not included in CSV format (e.g. 9:15 AM) | Behavior > Behavior Management Tool > Incident > Resolution > Resolution End Time BehaviorResolution. |
| Previous Duration in School Days | The Duration in School Days for the resolution prior to the Resolution Length Calculation Tool being run.
| ##.## Numeric | Behavior > Behavior Incident Manager Tool > Incident > Resolution > Duration in School Days BehaviorResolution. |
| Current Duration in School Days | The current value in the Duration in School Days for the resolution (the value calculated after the Resolution Length Calculation Tool was run). The Duration in School Days is calculated as follows:
| ##.## Numeric | Behavior > Behavior Incident Manager Tool > Incident > Resolution > Duration in School Days BehaviorResolution. |
