Deputy Lite
Deputy is a workforce management solution.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | AGREED_HOUR , AWARD_LIBRARY , NEWS_FEED , NOTIFICATION , and ROSTER 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:
ADDRESS
CATEGORY
COMMENT
COMPANY
COMPANY_PERIOD
CONTACT
EMPLOYEE
EMPLOYEE_AGREEMENT
EMPLOYEE_AGREEMENT_HISTORY
EMPLOYEE_AVAILABILITY
EMPLOYEE_HISTORY
EMPLOYEE_LEAVE
EMPLOYEE_ROLE
EMPLOYMENT_CONDITION
OPERATIONAL_UNIT
PAY_PERIOD
RESOURCE_TIMESHEET
STRESS_PROFILE
TIMESHEET_PAY_RETRUN
To capture updates and deletes, we re-import the following tables and their child tables:
AGREED_HOUR
AWARD_LIBRARY
NEWS_FEED
NOTIFICATION
ROSTER
Schema information
This schema applies to all Deputy connectors.
Explore Deputy schema ERD