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 the HRIS and Payroll Application.
When loading data from Payroll to HRIS, the HRIS will first look for an employee record match on SSN. If a match is not found, the HRIS will then check for a match on Employee ID. Once a matching employee record is found the HRIS 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 the HRIS.
When saving data from the HRIS to Payroll, the HRIS will match on SSN.
General Properties
| Property | Value |
|---|---|
| Location of Data in HRIS | Employee >> Payroll >> Taxes |
| Location of Data in Millennium | Employee Taxes Tab |
| Synchronization Direction | Two-way |
Field Mappings
| HRIS Field | Payroll Field | Mapping Details |
|---|---|---|
| Tax Code |
Tax Code | The Tax Code Field within the HRIS 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 |