New Hire Report - File Layout and Data Mapping

Record Identifier

X(17)

1-17

VA Newhire Record

Format Version Number

X(4)

18-21

1.00

Employee First Name

X(16)

22-37

employee.fname

Employee Middle Name

X(16)

38-53

employee.mname

Employee Last Name

X(30)

54-83

employee.lname

Employee SSN#

9(9)

84-92

employee.ssn

Employee Address Line 1

X(40)

93-132

employee.addr1

Employee Address Line 2

X(40)

133-172

employee.addr2

Employee Address Line 3

X(40)

173-212

spaces

Employee City

X(25)

213-237

employee.city

Employee State

X(2)

238-239

employee.state

Employee Postal Code

X(20)

240-259

employee.zip

Employee Zip+4

9(4)

260-263

employee.zip

Employee Country Code

X(2)

264-265

spaces

Required for foreign addresses only.

Employee Date of Birth

9(8)

266-273

employee.birth_date

Employee Date of Hire

9(8)

274-281

employee.hire_date

Employee State of Hire

X(2)

282-283

VA

Is Medical Insurance Available to Employee?

X(1)

284-284

Valid values:

• Y

• N

filler

X(1)

285-285

space

Employer FEIN

9(9)

286-294

Retrieved from the Federal Identification Number (EIN) field on the VA New Hire Report - Setup - Employer page.

Employer State EIN

X(12)

295-306

Retrieved from the State ID field on the VA New Hire Report page.

Employer Name

X(45)

307-351

Retrieved from the Name field on the VA New Hire Report - Setup - Employer page.

Employer Address Line 1

X(40)

352-391

Retrieved from the Street Address 1 field on the VA New Hire Report - Setup - Employer page.

Employer Address Line 2

X(40)

392-431

Retrieved from the Street Address 2 field on the VA New Hire Report - Setup - Employer page.

Employer Address Line 3

X(40)

432-471

spaces

Employer City

X(25)

472-496

Retrieved from the City field on the VA New Hire Report - Setup - Employer page.

Employer State

X(2)

497-498

Retrieved from the State field on the VA New Hire Report - Setup - Employer page.

Employer Postal Code

X(20)

499-518

Retrieved from the Zip field on the VA New Hire Report - Setup - Employer page.

Employer Zip+4

9(4)

519-522

Retrieved from the Zip Ext field on the VA New Hire Report - Setup - Employer page.

Employer Country Code

X(2)

523-524

spaces

Required for foreign addresses only.

Employer Phone Number

9(10)

525-534

Retrieved from the Employer Contact Number field on the VA New Hire Report - Setup - Employer page.

Employer Phone Extension

9(6)

535-540

Retrieved from the Employer Phone Ext field on the VA New Hire Report - Setup - Employer page.

Employer Contact

X(20)

541-560

Retrieved from the Employer Contact field on the VA New Hire Report - Setup - Employer page.