Sage 100 Payroll Link automatically-mapped employee fields

When you first set up Sage 100 Payroll Link, you add employees to Sage HRMS from Sage 100. After setup, you enter new employees in Sage HRMS and transfer updates between the programs.

The system automatically maps the following employee fields from each program.

Demographic fields

Mapped fields
Sage HRMS Fields	Sage 100 Payroll Fields	Notes
Address (Street 1, Street 2, City, State, Zip) on the Address and Phone tab of the Demographics page	Address, City, State, ZIP Code on the Main tab of the Employee Maintenance window
Phones (Home, Business, Cellular) on the Address and Phone tab of the Demographics page	One or both Telephone fields with types of Home, Work, or Cell on the Main tab of the Employee Maintenance window	Transferring to Sage 100 Payroll exceptions: The HRMS Pager and Fax numbers are not transferred. If the employee only has a Home, Business, or Cellular number in HRMS, it is transferred and selected as Primary in Sage 100 Payroll. If the employee has a Home, Business, and Cellular numbers, Home and Cellular are transferred and Home is selected as Primary. If the employee has a Home number and either a Business or Cellular number, they are both transferred and Home is selected as Primary. If the employee does not have a Home number but has a Cellular number, it is transferred and Cell is selected as Primary. If the employee does not have a Home or Cellular number but has a Business number, it is transferred and Work is selected as Primary. If the employee does not have any phone numbers in HRMS, any phone numbers in Sage 100 Payroll are cleared. Transferring to HRMS exceptions: The Sage 100 Payroll phones with type Other are not transferred.
Names (First, Middle, Last) on the Personal tab of the Demographics page	First Name, Middle Name, and Last Name on the Main tab of the Employee Maintenance window
E-mail on the Address and Phone tab of the Demographics page	E-mail on the Main tab of the Employee Maintenance window
SSN (Social Security Number) on the Personal tab of the Demographics page	Soc. Sec. No. on the Main tab of the Employee Maintenance window
Birth Date on the Personal tab of the Demographics page	Birth Date on the Main tab of the Employee Maintenance window
Marital Status on the Personal tab of the Demographics page	Marital Status on the Main tab of the Employee Maintenance window	Transferring to Sage 100 Payroll exceptions: HRMS values of Domestic Partnership and Other transfer as Single. Transferring to HRMS exceptions: Sage 100 Payroll value of Separated will transfer to HRMS as Single.
Gender on the Personal tab of the Demographics page	Sex on the Main tab of the Employee Maintenance window
Ethnic Origin on the Personal tab of the Demographics page	Race Code on the Main tab of the Employee Maintenance window	Transferring to Sage 100 Payroll exceptions: HRMS value of Two or More Races transfers as Other. Transferring to HRMS exceptions: Sage 100 values of Other or Not Reported transfer to HRMS as blank.

Employment fields

Mapped fields
Sage HRMS Fields	Sage 100 Payroll Fields	Notes
Sage 100 Payroll Employee Number on the Sage 100 Payroll Setup page	Employee Number on the Main tab of the Employee Maintenance window
Employee Status on the Job tab of the Current Job page	Employee Status on the Main tab of the Employee Maintenance window	Transferring to Sage 100 Payroll exceptions: HRMS status LOA or Not Employee becomes Inactive. HRMS status Dependent becomes Active. Transferring to HRMS exceptions: Payroll status Inactive becomes Not Employee. Payroll status Terminated stays Terminated. All other statuses become Active.
Employee Type on the Job tab of the Current Job page	Full / Part Time on the Main tab of the Employee Maintenance window	Transferring to Sage 100 Payroll exceptions: HRMS type of Regular Full Time becomes Full. All other HRMS types become Part. Transferring to HRMS exceptions: Payroll type Full becomes Regular Full Time. Payroll type Part becomes Regular Part Time.
Original Hire Date on the Seniority tab of the HR Status page	Hire Date on the Main tab of the Employee Maintenance window
Last Hire Date on the Seniority tab of the HR Status page	Rehire Date on the Main tab of the Employee Maintenance window
Adjusted Seniority Date on the Seniority tab of the HR Status page	Hire Date on the Main tab of the Employee Maintenance window
Job Start Date on the Job tab of the Current Job page	Hire Date on the Main tab of the Employee Maintenance window
Termination Date on the Termination Data tab of the Termination page	Termination Date on the Main tab of the Employee Maintenance window	When transferring to Sage 100 Payroll, the Termination Date only transfers if the employee has a status in HRMS of Terminated.

Contacts fields

Mapped fields
Sage HRMS Fields	Sage 100 Payroll Fields	Notes
Name on the First Contact and Second Contact tabs of the Contacts page	Emergency Contact on the Additional tab of the Employee Maintenance window
Relation on tabs of the Contacts page	Relationship on the Additional tab of the Employee Maintenance window
Home, Business, or Cellular on tabs of the Contacts page	Telephone on the Additional tab of the Employee Maintenance window	Transferring to Sage 100 Payroll: In Sage 100, the default phone type is Home. If you want to transfer a contact phone number other than Home, you must set the phone type in Sage 100 before the transfer. Transferring to HRMS: The phone field that gets transferred depends on the phone type in Sage 100 Payroll.
Extension on tabs of the Contacts page	phone extension on the Additional tab of the Employee Maintenance window

Pay fields

Mapped fields
Sage HRMS Fields	Sage 100 Payroll Fields	Notes
Pay Effective (Date) on the Current Pay tab of the Current Pay page	Date Changed (for Pay Rate 1) on the Pay Defaults tab of the Employee Maintenance window
Unit Pay Rate or Pay Period Salary on the Current Pay tab of the Current Pay page	Pay Rate 1 on the Pay Defaults tab of the Employee Maintenance window	Transferring to HRMS: If the employee is hourly, Pay Rate 1 transfers to Unit Pay Rate. If the employee is salaried, Pay Rate 1 transfers to Pay Period Salary.
Annual Pay on the Current Pay tab of the Current Pay page	calculated	In Sage 100 Payroll, the annual salary is calculated using Autopay Hours, Pay Rate 1, Pay Method, and Pay Cycle.
Pay Effective (Rate) on the Job tab of the Current Job page	Date Changed (for Pay Rate 1) on the Pay Defaults tab of the Employee Maintenance window
Autopay Employee on the Sage 100 Payroll Setup page	Autopay Hours on the Pay Defaults tab of the Employee Maintenance window	Transferring to Sage 100 Payroll: If Autopay Employee is set to Yes, Hours/Units from the HRMS Current Pay page are transferred to the Autopay Hours field. Transferring to HRMS: If the Autopay Hours are greater than 0.00 (in Sage 100) and the Autopay Employee indicator is set to Yes (in HRMS), the Autopay Hours are transferred to the Hours/Units field on the HRMS Job and Pay > Current Pay detail page. If the Autopay Hours equal 0.00, the Autopay Employee indicator is set to No, the Hours / Units on the Current Pay page uses calculated hours from the Pay Cycle field in Sage 100 as follows: Weekly is transferred as 40.00 Biweekly is transferred as 80.00 Semimonthly is transferred as 86.67 Monthly is transferred as 173.33
Direct Deposit on the Sage 100 Payroll Setup page	Direct Deposit on the Direct Deposit tab of the Employee Maintenance window
Overtime Exempt on the Sage 100 Payroll Setup page	Overtime Exempt on the Pay Defaults tab of the Employee Maintenance window	In HRMS, Overtime Exempt is a read-only field that uses values from the Exempt Status field on the Current Job page.
Pension / Profit Sharing on the Sage 100 Payroll Setup page	Profit Sharing on the Benefits tab of the Employee Maintenance window
Pay Cycle on the Sage 100 Payroll Setup page	Pay Cycle on the Pay Defaults tab of the Employee Maintenance window	Transferring to Sage 100 Payroll: If the Pay Cycle in HRMS is monthly and the Pay Cycle in Sage 100 Payroll is Daily, Quarterly or Annually, the transfer process does not change the value in Sage 100 Payroll. Transferring to HRMS: In Sage 100 Payroll, Pay Cycle is a read-only field which uses the pay frequency from the Pay Cycle field. If the Pay Cycle is Daily, Quarterly, or Annually, the Pay Frequency in HRMS is set to Monthly.
Pay Method on the Sage 100 Payroll Setup page	Pay Method on the Pay Defaults tab of the Employee Maintenance window	In HRMS, Pay Method is a read-only field that uses information from the Salaried/Hourly field on the Current Job page.
Seasonal on the Sage 100 Payroll Setup page	Seasonal Employee on the Main tab of the Employee Maintenance window

VETS fields

Mapped fields
Sage HRMS Fields	Sage 100 Payroll Fields	Notes
Active Duty Discharge date on the Military tab of the HR Status page	Military Service Separation Date on the Additional tab of the Employee Maintenance window
Protected Veteran on the Military tab of the HR Status page	Veteran on the Additional tab of the Employee Maintenance window	This is a check box in both Sage HRMS and Sage 100.

Other fields

Mapped fields
Sage HRMS Fields	Sage 100 Payroll Fields	Notes
Medical Coverage on the Sage 100 Payroll Setup page	Medical Coverage on the Benefits tab of the Employee Maintenance window	This is a check box in both Sage HRMS and Sage 100.
Medical Coverage Effective Date on the Sage 100 Payroll Setup page	Effective Date on the Benefits tab of the Employee Maintenance window