Issue

When running a Core HR to CMiC data sync, you may encounter the following error:

"EMH_EFFECTIVE_DATE - Effective Date can not be less than Hire Date"

This error occurs when the system attempts to update an employee record in CMiC with an effective date earlier than the employee’s hire date.

In CMiC, all effective dates must be on or after the hire date for an employee.

Cause

• The hire date in Core HR or CMiC is incorrect, or
• An effective-dated update is entered with a date before the hire date or rehire date. 

Resolution

Follow these steps to resolve the error:

1. Verify the Hire Date in Core HR and CMiC
   • Check that the employee’s hire date is correct in both systems.
2. If Hire Date is Incorrect in CMiC:
   • Manually update the hire date in CMiC.
   • Hire dates cannot be updated via the sync from Core HR to CMiC (this is a CMiC API limitation).
3. Check All Effective-Dated Records
   • Ensure any updates (e.g., tax changes, pay changes, etc) are dated on or after the employee’s hire or rehire date.
4. Re-run the Data Sync
   • Once dates are corrected, the sync should be completed successfully, and the error should be cleared. 

Key Points to Remember

• CMiC enforces chronological order: an employee must be hired before effective-dated changes can be applied.
• Hire date corrections in CMiC must be done manually.
• Always verify both hire dates and effective dates before re-running the sync.