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 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 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 Core HR.
When saving data from Core HR to Payroll, Core HR 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 Core HR | Employee >> Payroll >> Direct Deposits |
| Location of Data in Millennium | Employee Dir Dep Tab |
| Synchronization Direction | Two-way |
Field Mappings
| Core HR 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 Core HR. Otherwise, the Amount will imported as a Flat Amount. |
| Priority | Priority | |
| Override Pre-Note | Pre-Note Date | The date that Core HR populates in the Pre-Note date field in payroll is equal to the start date of the direct deposit record minus 30 days. |