Hyper Query
Advanced query definitions for automated data processing and analysis within the Attendance on Demand system.
Hyper Query files contain specialized query definitions that can be used for automated data extraction, report generation, and system integrations. These queries are typically used for complex data filtering and processing tasks.
Available Hyper Queries
| Query Name | Description | Key Features |
|---|---|---|
| Comp Greater Than | Compensation Balance Filter | Window function for latest benefit record, Balance threshold filtering |
| Leave Request Within 7 Days | Leave Request Analysis | Identifies leave requests near scheduled days off, Conflict detection |
| PA Agency Employees Weekly | Perfect Attendance - Agency | Weekly agency employee processing, Attendance tracking |
| PA Employees Weekly | Perfect Attendance - All | Weekly employee processing, Performance metrics |