Field lengths in Sage HRMS and ADP

Sage HRMS contains several fields that are longer than the corresponding fields in ADP. During export and import, if Sage HRMS Link passes these fields to ADP at their full Sage HRMS length, they are truncated. When working in Sage HRMS, only enter the amount of characters ADP can accept. The following table lists the fields and their lengths in Sage HRMS and ADP.

Field information

 

ADP Field

ADP Length

Sage HRMS Field

Sage HRMS Length

File Number

6

Employee ID

9

Deduction Code

2

Benefit Code

10

Deduction Amount

7

Benefit Contribution

9

EEO Occupational Category

1

EEO Classification

6

City

17

City

20

State / Province

2

State / Province

3

Address Line 1

20

Address Line 1

28

Address Line 2

20

Address Line 2

28

ZIP /Postal Code

9

ZIP /Postal Code

10

Home Phone Area Code

3

Home Phone

13

Home Phone Number

7

Home Phone

13

Nickname

10

Nickname

14

Standard Hours

5

Standard Hours

11

Social Security Number/Social Insurance Number

9

Social Security Number / Social Insurance Number

11

Citizen

6

Citizen

12

Employee E-mail

6

Employee E-mail

254

Rate 1 (Salary)

7

Salary

16

 

The following table describes the fields in ADP that are longer than the corresponding fields in Sage HRMS.

Field information

 

ADP Field

ADP Length

Sage HRMS Field

Sage HRMS Length

Employee Number

10

Social Security Number

9

Business Phone

17

Business Phone

13

Employee First Name

30

First Name

14

Employee Last Name

30

Last Name

25