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.

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 /

2

State /

3

Address Line 1

20

Address Line 1

28

Address Line 2

20

Address Line 2

28

ZIP / Code

9

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

9

Social Security 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.

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