Field Name

Required

Data Type

Max

Description

EmployeeID

Yes

String

15

Stores the unique identifier of a specific employee

EmployeeAddressID

Yes

String

15

Unique ID for the employee address; if more than one address for an employee, this ID distinguishes between multiple addresses

AddressOne

Yes

String

61

Physical location - address line 1

AddressTwo

String

61

Physical location - address line 2

AddressThree

String

61

Physical location - address line 3

City

String

35

Physical location - city

State

String

2

Physical location - two-letter state abbreviation

ZipCode

String

11

Physical location - five- or nine-digit ZIP code

County

String

61

Physical location - county

Country

String

61

Country name from IRS options

PhoneOne

String

30

Primary Phone Number

PhoneTwo

String

30

Secondary Phone Number

PhoneThree

String

30

Tertiary Phone Number

Fax

String

21

Fax Number

Email

String

201

Employee’s corporate email address

ForeignAddress

Bool

Indicate whether it is a foreign address or not

ForeignState

String

State when address is non-U.S. (e.g. a Canadian province)

ForeignPostalCode

String

Postal code when address is non-U.S. (e.g. a Canadian postal code)

CountryCode

String

Country name from IRS options