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 |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
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 connections.
Explore When I Work schema ERD