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 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 |