Support HubCoverage Budget Reports
This folder contains documentation for all coverage and budget report scripts. These scripts generate reports about coverage, budgeting, and related financial planning information.
Available Reports
| Report | Description | Key Features |
|---|---|---|
| Coverage Budget Report | Weekly coverage budget report with department and employee scheduling details | Weekly reporting, Department scheduling, Employee detail integration |
| Daily Coverage Budget Report | Detailed daily budget report with unit-level breakdowns | Daily breakdowns, Unit-level analysis, Detailed budget metrics |
| Daily Coverage Budget Report V2 | Enhanced version with additional HPPD metrics | HPPD calculations, Enhanced metrics, Advanced analytics |
Common Report Components
All reports utilize data from the following tables:
- COVBUDGETS - Coverage and budget data
- WORKGROUP1 - Location information
- WORKGROUP2 - Department information
- WORKGROUP5 - Unit information
- SCHEDULES - Employee scheduling data (when applicable)
- EMPLOYEES - Employee information (when applicable)
- COVERAGETYPES - Coverage type definitions
Parameters
Most reports accept date parameters to specify the reporting period. Depending on the report, these parameters may be:
- A single reference date (for weekly reports)
- A date range with start and end dates (for daily or custom period reports)
- A location or work group ID to filter results