Edit on GitHub
Ceridian Dayforce Lite Private Previewlink
Ceridian Dayforce is a workforce management platform.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | ANALYST_REPORT , CONTACT_INFORMATION_TYPE , DEPARTMENT , EMPLOYEE_PAY_SUMMARY , EMPLOYMENT_STATUS_REASON , EMPLOYMENT_STATUS , JOB_ASSIGNMENT , JOB , LOCATION_ADDRESS , ORGANIZATION_UNIT , PAY_CLASS , PAY_GROUP_CALENDAR , PAY_TYPE , PAYEE , PROJECT , and WORK_LOCATION 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 Ceridian Dayforce setup guide to connect Ceridian Dayforce with your destination using Fivetran connectors.
Sync overviewlink
To capture new records, we incrementally sync the following tables and their child tables:
AVAILABILITY
EMPLOYEE_BALANCE_TRANSACTION
EMPLOYEE_BALANCE
EMPLOYEE_MANAGER
EMPLOYEE_PAY_ADJUSTMENT
EMPLOYEE_PAY_SUMMARY
EMPLOYEE_PUNCH
EMPLOYEE_RAW_PUNCH
EMPLOYEE_SCHEDULE
EMPLOYEE_TIME_AWAY_FROM_WORK
EMPLOYEE
PROJECT
We also re-import the EMPLOYEE_PAY_SUMMARY
table once a week to capture updates and deletes.
Schema informationlink
This schema applies to all Ceridian Dayforce connectors.
To zoom, open the ERD in a new window.