Employee Pay Summary - manually changed records
2min
There are situations where a person has issues punching a clock and the time recorded in Ceridian needs to be manually adjusted. It's possible these adjustments are made by a manager in Ceridian several days later.
By default, a Sync Bridge replicates the last 30 days worth of Employee Pay Summary records.
When this situation occurs, Ceridian does not provide a field in their API to indicate that a punch has changed and provides the updated record as a new record in the API. To account for this situation a Transformation needs to be created in DataLakeHouse.io in order to mark the __DLH_IS_DELETED flag to TRUE.
Create a Transformation
-
A Pre SQL is created to
UPDATE DATALAKEHOUSE_DB.PRODDB_CERIDIAN_DAYFORCE.EMPLOYEE_PAY_SUMMARY
SET __dlh_is_active = false, __dlh_is_deleted = true
WHERE EMPLOYEE_XREF IN (
SELECT DISTINCT(EMPLOYEE_XREF) FROM
DATALAKEHOUSE_DB._TMP_PRODDB_CERIDIAN_DAYFORCE.EMPLOYEE_PAY_SUMMARY
)
;
Updated 11 May 2023
Did this page help you?
Yes
No