Support HubSchedule Reports
Schedule Reports
This folder contains documentation for all schedule-related report scripts. These scripts generate reports about employee schedules, shifts, and related scheduling information.
Available Reports
Core Schedule Reports
| Report | Description | Key Features |
|---|---|---|
| Daily Nurse Schedule | Comprehensive daily nursing schedule by shift times | Day/Evening/Night shifts, Open positions, Training roles |
| Worked vs Schedule Diff | Compares actual worked hours vs scheduled hours | Overtime detection, Schedule accuracy analysis |
| Schedule Hours by Day of Week | Weekly breakdown of scheduled hours per employee | Monday-Sunday hours, Weekly totals |
| Daily Posting Report | Daily staffing summary by position | Scheduled vs actual hours, Position-based analysis |
| Regular vs Benefit Schedule by Week | Compares regular vs benefit schedules over 6 weeks | Work time vs PTO analysis, Weekly trending patterns |
Schedule Analysis Reports
| Report | Description | Key Features |
|---|---|---|
| Multiple Schedules Per Day | Identifies scheduling conflicts | Conflict detection, Quality control |
| Schedule Edits by Edit Date | Audit trail of schedule modifications | Edit tracking, User activity analysis |
Schedule Grouping Reports
| Report | Description | Key Features |
|---|---|---|
| Weekly Schedule Group by Shift String | Groups employees by identical shift patterns | Pattern analysis, String aggregation |
| Weekly Schedule Group by Shift XML | XML output of grouped shift patterns | Machine-readable format, API integration |
| Weekly Schedule Custom | Customizable weekly schedule layout | Flexible formatting, Custom filtering |
Common Use Cases
- Daily Operations - Monitor current day staffing and coverage
- Schedule Planning - Analyze patterns and plan future schedules
- Compliance Monitoring - Ensure adequate staffing levels
- Audit and Quality Control - Track changes and identify issues
- Reporting and Analytics - Generate management reports and insights
Technical Notes
- Most reports support date range parameters (
{mindate},{maxdate}) - Work group filtering is commonly used for department-specific reports
- Time range filtering uses
CONVERT(TIME)for precise shift categorization - Many reports include both scheduled employees and open shifts
- XML and string aggregation reports support system integration
Getting Started
- Choose the appropriate report based on your needs
- Review the parameter requirements in each report's documentation
- Modify date ranges and filtering as needed
- Execute the corresponding SQL script from the
scripts/reports/schedule/folder