New Hire Report - File Layout and Data Mapping
The default file name for the New Hire report is VIRG<MMDD>.tpe
where
MMDD represents the report creation date.
The following table describes the New Hire report's fields, format, position, and data source or valid value.
Field | Format | Position | Data source or Valid value |
---|---|---|---|
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:
|
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. |