Edit on GitHub
When I Work Lite link
Updated November 1, 2023
When I Work is a cloud-based employee scheduling solution.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | All tables |
| Custom data | ||
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step When I Work setup guide to connect When I Work with your destination using Fivetran connectors.
Sync overviewlink
To capture new records, we incrementally sync the following tables and their child tables:
- ANNOTATION
- AUTO_SCHEDULED_SHIFT
- EVENT
- OPEN_SHIFT_REQUEST
- PAYROLL
- SCHEDULED_SHIFT_BREAK
- SHIFT
- SHIFT_BREAK
- SHIFT_BREAK_AUDIT
- SHIFT_REQUEST_MESSAGES
- SHIFT_REQUEST_SWAP
- TIME
- TIME_OFF_REQUEST
- TIME_OFF_REQUEST_MESSAGE
We also re-import these tables once a week to capture updates and deletes.
Schema informationlink
This schema applies to all When I Work connectors.
To zoom, open the ERD in a new window.