Support HubWorkSync Schedule Report Variations
This folder contains documentation for each variation of the WorkSync schedule report scripts. The WorkSync family provides zone-based schedule layouts for operational management with different focuses and configurations.
Available Reports
Core WorkSync Reports
| Report | Description | Key Features |
|---|---|---|
| Base WorkSync | Foundation template with all three shifts | Basic zone organization, Three-shift layout |
| WorkSync V3 | Enhanced version with dynamic zone processing | Dynamic zone counting, Enhanced data organization |
| Riverview WorkSync | Customized for Riverview location with WG4 zones | Location-specific, WG4 zones, Position filtering |
Shift-Specific Reports
| Report | Description | Key Features |
|---|---|---|
| Day Shifts Only | Morning operations focus (06:00-13:59) | Day shift focus, Morning operations |
| Evening Shifts Only | Afternoon operations focus (14:00-18:59) | Evening shift focus, Afternoon operations |
| Night Shifts Only | Overnight operations focus (19:00-05:59) | Night shift focus, Midnight-spanning logic |
Comprehensive Reports
| Report | Description | Key Features |
|---|---|---|
| WorkSync Comprehensive All Shifts | Most detailed report with separate table processing | Maximum detail, Separate table processing |
| WorkSync Alternative Version | Alternative implementation with unified output | Unified output, Shift type identification |
Processing Modules
| Report | Description | Key Features |
|---|---|---|
| WorkSync Zones Configuration | Zone configuration and testing utility | Zone setup, Testing utility |
| WorkSync Day Shifts Processing | Day shift processing module with position filtering | Day shift module, Position filtering |
| WorkSync Evening Shifts Processing | Evening shift processing module | Evening shift module, Reusable component |
| WorkSync Night Shifts Processing | Night shift processing module with midnight logic | Night shift module, Midnight logic |
Key Features by Version
Base WorkSync
- Simple three-shift layout
- Basic zone organization
- Foundation for all variations
WorkSync V3
- Dynamic zone counting and processing
- Enhanced data organization
- Temporary table storage for complex layouts
- Configurable zone filtering
Shift-Specific Versions
- Day Only: Simplified morning operations view
- Evening Only: Afternoon/evening focus with transition planning
- Night Only: Overnight operations with midnight-spanning logic
Comprehensive Versions
- All Shifts Comprehensive: Separate table processing for maximum detail
- Alternative Version: Unified output with shift type identification
Zones Versions
- Zones Configuration: Utility for zone setup and testing
- Shift Processing Modules: Reusable components for individual shift types
Location-Specific Versions
- Riverview: Work Group 4 zones, specific position filtering, day shifts only
Common Parameters
@MIN/@MAX- Date range for the report- Zone filtering through table variables (
@WESTBloom,@LZones) - Work group filtering (WG1, WG3, WG4, WG5)
- Position filtering for location-specific needs (
@POSITIONS)
Usage Guidelines
- Choose the Right Version: Select based on operational needs (all shifts vs. specific shifts)
- Configure Zones: Modify zone filtering tables for your facility layout
- Set Date Ranges: Use appropriate date parameters for your reporting period
- Review Output: Understand the specific format and organization of each variation
- Consider Performance: Comprehensive versions require more resources
Technical Architecture
All WorkSync reports share common technical patterns:
- Common Table Expressions (CTEs) for data organization
- Zone-based filtering and organization
- Time range filtering for shift categorization
- UNION operations to combine scheduled and open shifts
- ROW_NUMBER() or DENSE_RANK() functions for proper data alignment
Report Selection Guide
For Quick Operations
- Base WorkSync - Simple overview
- Day Shifts Only - Morning focus
- Evening Shifts Only - Afternoon focus
- Night Shifts Only - Overnight focus
For Detailed Analysis
- WorkSync V3 - Enhanced processing
- Comprehensive All Shifts - Maximum detail
- Alternative Version - Unified view
For Development/Testing
- Zones Configuration - Zone setup utility
- Day Shifts Processing - Day shift module
- Evening Shifts Processing - Evening shift module
- Night Shifts Processing - Night shift module
For Location-Specific Needs
- Riverview WorkSync - Riverview facility
Tip: Start with the base version to understand the core functionality, then move to V3 for enhanced features, and finally to shift-specific versions for focused operational needs.