Critical information
- Release: Week of 1/12/26
- Status: General Availability (GA) - Fully released and available to all eligible customers.
Availability
- Plans: Essentials/Advanced, Essentials Plus, Professional/Premium
- Rollout schedule: Immediate
Requirements
- Permissions: ActivConnect API (Add-on) subscription
- Other: HRIS Integration enabled (required for time off data to populate; accounts without this integration will see null values)
Feature description
ActivConnect Time Off Data introduces new columns across multiple ActivConnect views that provide access to employees' approved time off information, enabling customers to analyze workforce availability, calculate accurate active day counts, and create custom reports that account for scheduled absences. This enhancement helps operations managers, workforce analysts, and HR administrators make more informed decisions about capacity planning and productivity metrics.
Key capabilities
- Time off duration tracking: Access the total duration of approved time off in seconds for any user on a given day
- Time off type visibility: View the type of leave approved for each user (e.g., vacation, sick leave)
- Time off day count: Identify days with approved time off, regardless of whether it's a full or partial day
- Accurate active day calculation: Active day count automatically adjusts to 0 on days with approved time off
-
Multi-view integration: Time off data available across
daily_user_summary,daily_application_summary, anddaily_group_benchmarkviews
Use cases
Operations managers can analyze workforce availability patterns by incorporating time off data into capacity planning reports. Workforce analysts can create custom reports that accurately reflect productive time by excluding days with approved time off from average calculations. HR administrators can reconcile time off records across systems and validate PTO usage trends.
How to access
Direct access: The data will automatically be accessible via the ActivConnect API
Navigation path: Access through your existing ActivConnect integration
What's new
- Enhanced daily user summary view
The existing daily_user_summary view has been enhanced with new columns to track time off data:
| Column Name | Data Type | Description |
|---|---|---|
| time_off_duration_seconds | INT64 | Total approved time off in seconds for a user on a given day. |
| time_off_type | STRING | Type of approved time off for a user on a given day (e.g., vacation, sick leave). |
| time_off_day_count | INT64 | Shows 1 if a partial day or full day of time off was approved for a user on a given day |
- Enhanced daily application summary view
The existing daily_application_summary view has been enhanced with time off day count:
| Column Name | Data Type | Description |
|---|---|---|
| time_off_day_count | INT64 | Shows 1 if a partial day or full day of time off was approved for a user on a given day |
- Enhanced daily group benchmark view
The existing daily_group_benchmark view has been enhanced with time off day count:
| Column Name | Data Type | Description |
|---|---|---|
| time_off_day_count | INT64 | Shows 1 if a partial day or full day of time off was approved for a user on a given day |
- Impact on Active Days
When a user has approved time off (time_off_day_count = 1) on a given day, the active_day_count will automatically be set to 0 in all applicable ActivConnect views (daily_user_summary, daily_group_benchmarks, daily_application_summary). This ensures that productivity averages and metrics accurately reflect the number of actual working days.
Known limitations
- Currently only available to customers with the ActivConnect API (Add-on)
- Accounts without the HRIS integration enabled will see null values for all time off columns
Support
For questions or assistance with this feature:
- Documentation: ActivConnect Data Glossary
- Contact support: https://www.activtrak.com/support/
- Customer success: Reach out to your Customer Success team