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.