Support Hub Documentation

Welcome to the comprehensive documentation site for the Support Hub. This documentation provides detailed information about all T-SQL scripts, reports, utilities, and payroll exports used in our time & attendance system.

📚 Documentation Sections

📊 Reports

Go to Reports documentation →

Comprehensive documentation for all reports, organized by category:

• Coverage Budget - Workforce planning and budget analysis reports
• Employee Information - HR data and employee management reports
• Incident - Incident tracking and analysis reports
• Pay Information - Compensation and payroll processing reports
• Perfect Attendance - Perfect attendance tracking and recognition reports
• PPACA - Affordable Care Act (ACA) compliance reports
• Schedule - Time and schedule management reports
• System Information - Database administration and system monitoring
• Table Query - Ad-hoc data retrieval and analysis
• Users Information - User access, permissions, and audit trail reports
• WorkSync - WorkSync integration and data synchronization reports
• Cancellation - Reports related to cancellations

💾 Info Exports

Go to Info Exports documentation →

Exports of information for external system consumption:

💰 Payroll Exports

Go to Payroll Exports documentation →

Specialized payroll exports for external payroll system integration:

� HEF Files

Go to HEF Files documentation →

HEF (Hourly Employee File) format documentation and exports for payroll integration.

🔍 Hyper-Query

Go to Hyper-Query documentation →

Advanced query templates and hyperQuery examples for complex data retrieval and filtering.

🌐 REST API

Go to REST API documentation →

REST API collections and documentation for AOD system integration:

• Bruno Collection - Complete MSS (Mobile Self Service) API collection
• Employee Management - Employee data and assignment endpoints
• Attendance & Scheduling - Shift and schedule management APIs
• System Information - Period calculations and system data

🔌 SOAP API

Go to SOAP API documentation →

SOAP API collections and documentation for legacy system integration:

• Absence Management - Employee benefits and absence operations
• Access Accounts - Account and permission management

�🔧 Utilities

Go to Utilities documentation →

Documentation for utility and maintenance scripts, categorized by function:

• Database Analysis & Information - Schema analysis and data discovery tools
• Data Maintenance & Cleanup - Data integrity and cleanup utilities
• Database Administration - Performance and system maintenance scripts
• Time & Attendance Processing - Automated time processing and transfer scripts
• Development & Testing - Data anonymization and testing utilities

📊 Documentation Statistics

🤝 Contributing

email Jason with screenshots, browser exports, and any other relevant information.

📞 Support

For questions about specific scripts or documentation:

• Check the individual script documentation first
• Call John Bokach 😛

---

This documentation is maintained alongside the SQL and AOD repositories to ensure accuracy and completeness.