Millennium Data Mapping - Employee Compensation Transactions

The Table below displays field mappings for data on the Compensation Transactions 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 record exists by checking for an existing record with the same Employer Code, Pay Code, Rate 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 >> Compensation >> Compensation Transactions Tab
Location of Data in Millennium Employee Fringe Tab
Synchronization Direction Two-way

Field Mappings

HRIS Field Payroll Field Mapping Details
Start Date Start Date  
End Date End Date  
Amount Rate Per If the Rate Per = “Hour” in Payroll then the record will be set to “Hourly” in the HRIS. Otherwise, it will be set to “Salary”
Type    
Category    
Pay Code Code  
Rate Code Rate Code The Rate Code Field within the HRIS must be configured with values equal to those configured in Payroll.
Employer Code Account Code  
Agency Agency  
Notes    
Frequency Frequency  
Calc Code Calc Code  
Last Taken Last Taken  
Units Units  
Rates Rates  
Goal Goal  
Paid Paid  
Minimum Minimum  
Maximum Maximum  
YTD Maximum YTD Maximum  
Was this article helpful?
0 out of 0 found this helpful