Millennium Data Mapping - Employee Taxes

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
Was this article helpful?
0 out of 0 found this helpful