Millennium Data Mapping - Employee Direct Deposits

The Table below displays field mappings for data on the Direct Deposit 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 Direct Deposit record exists by checking for an existing record with the same Account Number, Transit Number 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. Additionally, Deductions will only be saved to the "Master" Account if the Employee is mapped to more than one Account in Payroll.

General Properties

Property Value
Location of Data in HRIS Employee >> Payroll >> Direct Deposits
Location of Data in Millennium Employee Dir Dep Tab
Synchronization Direction Two-way

Field Mappings

HRIS Field Payroll Field Mapping Details
Start Date Start Date  
End Date End Date  
Account Number Account Num  
Routing Number Transit  
Checking Checking  
Percent or Flat Amount Amount If AmountCode in Payroll = "%" then the Amount will be imported as a percent value in the HRIS. Otherwise, the Amount will imported as a Flat Amount.
Priority Priority  
Override Pre-Note Pre-Note Date The date that the HRIS populates in the Pre-Note date field in payroll is equal to the start date of the direct deposit record minus 30 days.
Was this article helpful?
0 out of 0 found this helpful