Millennium Data Mapping - Employee Demographics

The Table below displays field mappings for data on the Employee Demographic 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 a match on SSN. If a match is not found, the HRIS will then check for a match on Employee ID. 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 >> Employee >> Demographic Info
Location of Data in Millennium Employeee Demographics Tab; Employee Miscellaneous Tab; Employee Status / Position Tab
Synchronization Direction Two-way

Field Mappings

HRIS Field Payroll Field Mapping Details
First Name First Name  
Middle Name Middle Name  
Last Name Last Name  
Street 1 Address 1  
Street 2 Address 2  
City City  
State State  
Zip Zip  
County County of Employee This is not a field contained within HRIS.
Country Country of Employee This field is not compatible with M3. M3 uses a text option and HRIS uses a drop down menu.
  Salutation of Employee This field does not exist within HRIS.
SSN SSN  
Gender Gender If value is set to "Undefined" in HRIS, the HRIS will set Gender to an empty value in Payroll since valid values in Payroll are only "Male" and "Female".If an empty value is not a valid option in Payroll, then "Undefined" will be mapped to "Male".
Marital Status Marital Status M3 contains a total of 6 options, the HRIS will sync the values of Single, Married & Undefined.
  Disability Description of Employee This is not a field contained within HRIS.
  Veteran Description of Employee This is not a field contained within HRIS.
Tobacco User Smoker / Tobacco use of Employee  
  Work Phone Extension of Employee This is not a field contained within HRIS.
Pay Group Pay Group of Employee  
Birth Date Birth Date  
Home Phone Home Phone  
Title Title  
Work Phone Work Phone  
Mobile Phone Cell Phone  
Email Email Address  
Hours Worked Default Hours  
Employee ID Employee ID If the HRIS Account is mapped to more than one Payroll Account, then the Employee ID of the "Master" Payroll Account will be used.
Employee Status Emp Status A (payroll) = Full Time (HRIS)A (payroll) = Part Time (HRIS) LOA (payroll) = LOA (HRIS) R (payroll) = Retired (HRIS) T (payroll) = Terminated (HRIS)A (payroll) = Undefined (HRIS)When loading from Payroll, Active will be mapped to Full Time. Note:The Employee Status field under the Employer Mapping tab controls the status in payroll. The Employee Status mapping under demographics is the HRIS status. These do not communicate except for when the employee is changed to "terminated" status under demographics.
Employee Type Empl Type The Employee Type Field within the HRIS must be configured with values equal to those configured in Payroll.
Pay Schedule Pay Freq When loading data from Payroll, the Utility will attempt to match the Pay Frequency Code from Payroll to the name of a Pay Schedule in the HRIS. If a match is not found, the employee will be assigned to the Default Pay Schedule configured within the HRIS.When loading data from the HRIS to Payroll, the pay schedule name in HRIS must match the Pay Schedule Code in Payroll exactly. If an employee is saved with a Pay Schedule Name that does not match an existing Pay Schedule Code in Payroll, the Pay Freq field will be set to an empty value.
Hire Date Hire Date  
Original Hire Date Rehire Date or Hire Date If a Rehire Date exists in Payroll, then this field will be used. Otherwise, Original Hire Date will be mapped to Hire Date.
Alt Service Date 1 Adj Seniority Date  
Termination Date Term Date  
Termination Reason Term Reason The Termination Field within the HRIS must be configured with values equal to those configured in Payroll.
  Workers Compensation Code of Employee This is not a field contained within HRIS.
Ethnicity Ethnicity The Ethnicity Field within the HRIS must be configured with values equal to those configured in Payroll.
Tax Form Tax Form  
  Clock of Employee This is not a field contained within HRIS.
  I9 Verified of Employee This is not a field contained within HRIS.
  I9 Reverify of Employee This is not a field contained within HRIS.
  Citizenship of Employee This is not a field contained within HRIS.
  Visa Type of Employee This is not a field required by M3.
  Visa Expiration of Employee This is not a field required by M3.
Cost Center 1 Organization / Department Level 1 See Cost Center Mapping options on Payroll - General Settings Help screen for more information.
Cost Center 2 Organization / Department Level 2 See Cost Center Mapping options on Payroll - General Settings Help screen for more information.
Cost Center 3 Organization / Department Level 3 See Cost Center Mapping options on Payroll - General Settings Help screen for more information.
Cost Center 4 Organization / Department Level 4 See Cost Center Mapping options on Payroll - General Settings Help screen for more information.
Cost Center 5 Organization / Department Level 5 See Cost Center Mapping options on Payroll - General Settings Help screen for more information.
OT Exempt OT Exempt  
Memo Memo  
Show in Pay Entry Show in Pay Entry  
Retirement Plan Retirement Plan  
Pay Group Pay Group Company Setup > Misc > Pay Groups When syncing from HRIS to payroll, the same Pay Group values must first exist in both systems.
Compensation Rate: AutoPay Auto Pay Employee > Payroll > Compensation If the current HRIS compensation record is Salary and AutoPay is true, then update Payroll with “Salary”.If the current HRIS compensation record is Hourly and the AutoPay is true, then update Payroll with “Hours”.If AutoPay is false on the current HRIS compensation record, then update Payroll with blank.
User Defined Lookup 1 MiscCheck1 User Defined Lookup 1 must be configured in Infinity with only a Yes and No value prior to Sync.
User Defined Lookup 2 MiscCheck2 User Defined Lookup 2 must be configured in Infinity with only a Yes and No value prior to Sync.
User Defined Lookup 3 MiscCheck3 User Defined Lookup 3 must be configured in Infinity with only a Yes and No value prior to Sync.
User Defined Lookup 4 MiscCheck4 User Defined Lookup 4 must be configured in Infinity with only a Yes and No value prior to Sync.
User Defined Lookup 5 MiscCheck5 User Defined Lookup 5 must be configured in Infinity with only a Yes and No value prior to Sync.
User Defined 1 Custom String Field 1  
User Defined 2 Custom String Field 2  
User Defined 3 Custom String Field 3  
User Defined 4 Custom String Field 4  
User Defined 5 Custom String Field 5  
TLM Manager Supervisors Employee>>MiscellaneousWill also populate field under company setup>>Miscellaneous>>Supervisors
Ext Ext. Employee>>Miscellaneous
EEO Class EEO Class Employee>>Status / Position*must be configured in Millennium under Company Setup>>Miscellaneous>>EEOC*
Payroll Pay Group Pay Group Employee>>Status / Position
Was this article helpful?
0 out of 0 found this helpful