Sage 100 Payroll Mapped Fields

Mapped fields
Sage HRMS Field	Location in Sage HRMS	Sage 100 Payroll Field	Location in Sage 100 Payroll
Address, City, State, ZIP Code	Demographics window (Address and Phone tab) Phone numbers must be entered in the following format in order to transfer correctly: (999)999-9999	Address, City, State, ZIP Code	Employee Maintenance screen (Main tab)
Home (phone)	Phone No.
Name	Demographics window (Personal tab)	Name When transferring an employee from Sage HRMS to Sage 100 Payroll, the system does not transfer data entered in the Middle name field on the employee’s Demographics window. If you want to add a middle name or middle initial to an employee, enter that information in the First name field.
SSN	Soc. Sec. No.
Birth Date	Birth Date
Marital Status	Marital Status When transferring an employee from SSage HRMS to Sage 100 Payroll, if the status is other than M (Married) or S (Single) in Sage HRMS, the status is set to S (Single) in Sage 100 Payroll.
Gender	Sex
Ethnic Origin	Race Code Only the first character of the race code is transferred.
Employee Status (When transferring an employee from Sage 100 Payroll to Sage HRMS, if the employee status is Inactive in Sage 100 Payroll, the status is set to Not Employee in Sage HRMS.)	Current Job window	Employee Status (When transferring an employee from Sage HRMS to Sage 100 Payroll, if the employee status is LOA or Not Employee in Sage HRMS, the status is set to Inactive in Sage 100 Payroll.)
Job Start Date	Current Job window	Hire Date
Emergency Contact	Emergency Contacts window (Only the first contact is transferred.)	Emergency Contact
Emergency Phone	Emergency Phone
Termination Date	Termination window	Termination Date (When transferring an employee from Sage HRMS to Sage 100 Payroll, the Termination Date only transfers if the employee has a current status of Terminated in Sage HRMS.)
Sage 100 Employee Number	Sage 100 Payroll Setup window (Payroll Status tab) (For more information, see Use the Sage 100 Payroll Setup window.)
Direct Deposit	Sage 100 Payroll Setup window (Payroll Status tab)	Direct Deposit
Pension Plan	Sage 100 PayrollSetup window (Payroll Status tab)	Pension/Profit Sharing
Autopay Employee Note: When transferring an employee from Sage 100 Payroll to Sage HRMS, if the Sage 100 PayrollAutopay Hours are greater than 0.00 the Autopay Employee indicator is set to Yes and the Autopay hours are transferred to the Hours / Units field on the Sage HRMS Current Pay Detail window. If the Sage 100 PayrollAutopay Hours equal 0.00, the Autopay Employee indicator is set to No and the Hours / Units field on the Sage HRMS Current Pay Detail window is populated from the Pay Cycle field in Sage 100 Payroll 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	Sage 100 Payroll Setup window (Payroll Status tab)	Autopay Hours Note: When transferring an employee from Sage HRMS to Sage 100 Payroll, if the Autopay Employee indicator is set to Yes, Hours / Units from the Sage HRMS Current Pay Detail window are transferred to the Autopay Hours field. If the Autopay Employee indicator is set to No, 0.00 is transferred to the Autopay Hours field.	Employee Maintenance screen (Wages tab)
Pay Cycle (Pay Cycle is a read-only field which is populated with the Pay Frequency from the Sage HRMS Current Pay Detail window. The Pay Frequency field is populated from the Pay Cycle field in Sage 100 Payroll. There is one exception: If the Sage 100 Payroll Pay Cycle is Daily, Quarterly or Annually, the Sage HRMS Pay Frequency is set to Monthly.)	Sage 100 Payroll Setup window (Payroll Status tab)	Pay Cycle (When transferring an employee from Sage HRMS to Sage 100 Payroll, if the Pay Cycle in Sage HRMS is monthly and the Pay Cycle in Sage 100 Payroll is Daily, Quarterly or Annually, the transfer process does not change the value of Daily, Quarterly or Annually.)
Pay Method (Pay Method is a read-only field which is populated with values from the Salaried/Hourly field on the Sage HRMS Current Job Detail window. The Salaried/Hourly field is populated from the Pay Method field in Sage 100 Payroll.)	Sage 100 Payroll Setup window (Payroll Status tab)	Pay Method
Overtime Exempt (Overtime Exempt is a read-only field which is populated with values from the Exempt Status field on the Sage HRMS Current Job Detail window.)	Sage 100 Payroll Setup window (Payroll Status tab)	Overtime Exempt
Benefit Code	Sage 100 PayrollSetup window (Payroll Status tab)	Benefit Code
Pay Rate / Salary (Pay Rate / Salary is a read-only field which is populated with values from either the Unit Pay Rate or the Pay Period Salary fields from the Sage HRMS Current Pay Detail window. If the employee is hourly, the Sage 100 Payroll Pay Rate 1 populates the Unit Pay Rate field on the Sage HRMS Current Pay Detail window. - If the employee is salaried, the Sage 100 Pay Rate 1 populates the Period Salary field on the Sage HRMS Current Pay Detail window.	Sage 100 Payroll Setup window (Payroll Status tab)	Pay Rate 1

Address, City, State, ZIP Code

Demographics window (Address and Phone tab)

Phone numbers must be entered in the following format in order to transfer correctly: (999)999-9999

Address, City, State, ZIP Code

Employee Maintenance screen (Main tab)

Home (phone)

Phone No.

Name

Demographics window (Personal tab)

Name

When transferring an employee from Sage HRMS to Sage 100 Payroll, the system does not transfer data entered in the Middle name field on the employee’s Demographics window. If you want to add a middle name or middle initial to an employee, enter that information in the First name field.

SSN

Soc. Sec. No.

Birth Date

Marital Status

When transferring an employee from SSage HRMS to Sage 100 Payroll, if the status is other than M (Married) or S (Single) in Sage HRMS, the status is set to S (Single) in Sage 100 Payroll.

Gender

Sex

Ethnic Origin

Race Code

Only the first character of the race code is transferred.

Employee Status

(When transferring an employee from Sage 100 Payroll to Sage HRMS, if the employee status is Inactive in Sage 100 Payroll, the status is set to Not Employee in Sage HRMS.)

Current Job window

Employee Status

(When transferring an employee from Sage HRMS to Sage 100 Payroll, if the employee status is LOA or Not Employee in Sage HRMS, the status is set to Inactive in Sage 100 Payroll.)

Job Start Date

Current Job window

Hire Date

Emergency Contact

Emergency Contacts window

(Only the first contact is transferred.)

Emergency Contact

Emergency Phone

Termination Date

Termination window

Termination Date

(When transferring an employee from Sage HRMS to Sage 100 Payroll, the Termination Date only transfers if the employee has a current status of Terminated in Sage HRMS.)

Sage 100 Employee Number

Sage 100 Payroll Setup window (Payroll Status tab)

(For more information, see Use the Sage 100 Payroll Setup window.)

Direct Deposit

Sage 100 Payroll Setup window (Payroll Status tab)

Direct Deposit

Pension Plan

Sage 100 PayrollSetup window (Payroll Status tab)

Pension/Profit Sharing

Autopay Employee

Note: When transferring an employee from Sage 100 Payroll to Sage HRMS, if the Sage 100 PayrollAutopay Hours are greater than 0.00 the Autopay Employee indicator is set to Yes and the Autopay hours are transferred to the Hours / Units field on the Sage HRMS Current Pay Detail window.

If the Sage 100 PayrollAutopay Hours equal 0.00, the Autopay Employee indicator is set to No and the Hours / Units field on the Sage HRMS Current Pay Detail window is populated from the Pay Cycle field in Sage 100 Payroll 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

Sage 100 Payroll Setup window (Payroll Status tab)

Autopay Hours

Note: When transferring an employee from Sage HRMS to Sage 100 Payroll, if the Autopay Employee indicator is set to Yes, Hours / Units from the Sage HRMS Current Pay Detail window are transferred to the Autopay Hours field.

If the Autopay Employee indicator is set to No, 0.00 is transferred to the Autopay Hours field.

Employee Maintenance screen (Wages tab)

Pay Cycle

(Pay Cycle is a read-only field which is populated with the Pay Frequency from the Sage HRMS Current Pay Detail window. The Pay Frequency field is populated from the Pay Cycle field in Sage 100 Payroll. There is one exception: If the Sage 100 Payroll Pay Cycle is Daily, Quarterly or Annually, the Sage HRMS Pay Frequency is set to Monthly.)

Sage 100 Payroll Setup window (Payroll Status tab)

Pay Cycle

(When transferring an employee from Sage HRMS to Sage 100 Payroll, if the Pay Cycle in Sage HRMS is monthly and the Pay Cycle in Sage 100 Payroll is Daily, Quarterly or Annually, the transfer process does not change the value of Daily, Quarterly or Annually.)

Pay Method

(Pay Method is a read-only field which is populated with values from the Salaried/Hourly field on the Sage HRMS Current Job Detail window. The Salaried/Hourly field is populated from the Pay Method field in Sage 100 Payroll.)

Sage 100 Payroll Setup window (Payroll Status tab)

Pay Method

Overtime Exempt

(Overtime Exempt is a read-only field which is populated with values from the Exempt Status field on the Sage HRMS Current Job Detail window.)

Sage 100 Payroll Setup window (Payroll Status tab)

Overtime Exempt

Benefit Code

Sage 100 PayrollSetup window (Payroll Status tab)

Benefit Code

Pay Rate / Salary

(Pay Rate / Salary is a read-only field which is populated with values from either the Unit Pay Rate or the Pay Period Salary fields from the Sage HRMS Current Pay Detail window.

If the employee is hourly, the Sage 100 Payroll Pay Rate 1 populates the Unit Pay Rate field on the Sage HRMS Current Pay Detail window.
- If the employee is salaried, the Sage 100 Pay Rate 1 populates the Period Salary field on the Sage HRMS Current Pay Detail window.

Sage 100 Payroll Setup window (Payroll Status tab)

Pay Rate 1