The Table below displays field mappings for data on the Federal Tax 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 an existing Tax record exists by checking for an existing record with the same Employer Code, Tax Code and Start Date. If no match is found, then a new record will be added to Core HR.
When saving data from Core HR to Payroll, Core HR will match on SSN.
General Properties
| Property | Value |
|---|---|
| Location of Data in Core HR | Employee >> Payroll >> Taxes |
| Location of Data in Millennium | Employee Taxes Tab |
| Synchronization Direction | Two-way |
Field Mappings
| Core HR Field | Payroll Field | Mapping Details |
|---|---|---|
| Tax Code |
Tax Code | The Tax Code Field within Core HR must be configured with values equal to those configured in Payroll. |
| Start Date | Start Date | |
| End Date | End Date | |
| Filling Status | Filing Status | |
| Exemptions |
Exemptions | |
| Extra Tax Calculation |
See Extra Tax Amount | |
| Extra Tax Amount | Additional Amount Additional Percentage |
When loading from Payroll: Case 1 Additional Amount = 0 and Additional Percentage <> 0 Result 1 Extra Tax Amt= Additional PercentageExtra Tax Calc = Percentage Case 2 Additional Amount <> 0 and Additional Percentage = 0 Result 1 Extra Tax Amt = Additional Amount Extra Tax Calc = Dollar Amount Case 3 All other scenarios Result 3 Extra Tax Amt = Additional Amount Extra Tax Calc = Dollar Amount |