Ceridian Dayforce Lite Private Preview
Ceridian Dayforce is a workforce management platform.
Features
| 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. |
| 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 Ceridian Dayforce setup guide to connect Ceridian Dayforce with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
AVAILABILITYEMPLOYEE_BALANCE_TRANSACTIONEMPLOYEE_BALANCEEMPLOYEE_MANAGEREMPLOYEE_PAY_ADJUSTMENTEMPLOYEE_PAY_SUMMARYEMPLOYEE_PUNCHEMPLOYEE_RAW_PUNCHEMPLOYEE_SCHEDULEEMPLOYEE_TIME_AWAY_FROM_WORKEMPLOYEEPROJECT
We also re-import the EMPLOYEE_PAY_SUMMARY table once a week to capture updates and deletes.
Schema information
This schema applies to all Ceridian Dayforce connectors.
Explore Ceridian Dayforce schema ERD