The Table below displays field mappings for data on the Employee Accruals screen. If a field is not included in the Table below, then it will not be mapped between Core HR and Payroll Application.
When loading data from Payroll to Core HR, Core HR will first look for an employee record match on SSN. If a match is not found, Core HR will then check for a match on Employee ID. Once a matching employee record is found, Core HR will then check to see if Core HR contains a PTO Type that matches the Millennium Accrual Code. If a match is found and the current balance in Core HR differs from the current Available time in Payroll, then a new Time Off Transaction record will be added to Core HR under Employee >> Time and Labor Mgmt >> Time Off for the difference between Core HR and Payroll. The added Accrual Transaction record will bring the Core HR Time Balance equal to the Millennium Available Time.
When loading data from Core HR to Payroll, Core HR will first process accruals up to the end of the Pay Period. Then, Core HR will first look for an employee record match on SSN. If a match is not found, Core HR will then check for a match on Employee ID. Once a matching employee record is found, Core HR will then check to see if Payroll contains a Millennium Accrual Code that matches the HR PTO Type. If a match is found and the current Available Balance or Used Amount in Payroll differs between Core HR and Payroll, then the Millennium Accrual will be updated with the new Available and/or Used time. If an Accrual record does not exist in Millennium for the employee, but an Accrual Code matches the Time Off Type in Infinity, then a new Accrual will be created in Millennium for the Employee.
General Properties
| Property | Value |
|---|---|
| Location of Data in Core HR | Employee >> Time and Labor Mgmt >> Time Off |
| Location of Data in Millennium | Employee Accruals Tab |
| Synchronization Direction | Two-way |
Field Mappings
| Core HR Field | Payroll Field | Primary Key | Mapping Notes |
|---|---|---|---|
| PTO Type | Accrual Type | Yes | |
| Balance | Available | When loading Accruals from HR, the balance loads as of the current date. When loading Accruals to Millennium from HR, the balance is loaded as of the end date of the Pay Period. |
|
| Taken | Used | Used time only syncs from Millennium to Core HR. Taken is Granted Time + Taken Time. |