Deputy Lite
Deputy is a workforce management solution.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | AWARD_LIBRARY, NEWS_FEED, and NOTIFICATION 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 Deputy setup guide to connect Deputy with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
ADDRESSCATEGORYCOMMENTCOMPANYCOMPANY_PERIODCONTACTEMPLOYEEEMPLOYEE_AGREEMENTEMPLOYEE_AGREEMENT_HISTORYEMPLOYEE_AVAILABILITYEMPLOYEE_HISTORYEMPLOYEE_LEAVEEMPLOYEE_ROLEEMPLOYMENT_CONDITIONOPERATIONAL_UNITPAY_PERIODRESOURCE_TIMESHEETROSTERSTRESS_PROFILETIMESHEET_PAY_RETRUN
To capture updates and deletes, we re-import the following tables and their child tables:
AWARD_LIBRARYNEWS_FEEDNOTIFICATION
Schema information
This schema applies to all Deputy connections.
Explore Deputy schema ERD