When I Work Lite
When I Work is a cloud-based employee scheduling solution.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ACCOUNT, ANNOTATION, AUTO_SCHEDULED_SHIFT, EVENT, LOCATION, OPEN_SHIFT_REQUEST``POSITION, SHIFT, SHIFT_BREAK, SHIFT_BREAK_AUDIT, SHIFT_REQUEST_MESSAGES, SHIFT_REQUEST_SWAP, SHIFT_TEMPLATE_BLOCK, SITE, TIME, TIME_OFF_REQUEST, TIME_OFF_REQUEST_MESSAGE, TIME_OFF_REQUEST_TYPE, and USERS tables. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step When I Work setup guide to connect When I Work with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
ANNOTATIONAUTO_SCHEDULED_SHIFTEVENTOPEN_SHIFT_REQUESTPAYROLLSCHEDULED_SHIFT_BREAKSHIFTSHIFT_BREAKSHIFT_BREAK_AUDITSHIFT_REQUEST_MESSAGESSHIFT_REQUEST_SWAPTIMETIME_OFF_REQUESTTIME_OFF_REQUEST_MESSAGE
To capture updates and deletes, we also re-import the following tables and their child tables weekly:
ANNOTATIONAUTO_SCHEDULED_SHIFTEVENTOPEN_SHIFT_REQUESTSHIFTSHIFT_BREAKSHIFT_BREAK_AUDITSHIFT_REQUEST_MESSAGESSHIFT_REQUEST_SWAPTIMETIME_OFF_REQUESTTIME_OFF_REQUEST_MESSAGE
Schema information
This schema applies to all When I Work connectors.
Explore When I Work schema ERD