VRS Hybrid Report - File Layouts
The default file name for the VRS Hybrid report is VA VRS Hybrid Report_<MMDDYYYY>_<hhmmss>.rpt.
where
<MMDDYYYY>_<hhmmss> represents the report creation timestamp.
The VRS Hybrid report electronic file contains two record types:
D - Detail Record Type
The following table lists the D- Detail record type's position, field, data type, and description.
Position | Field | Data Type | Description |
---|---|---|---|
1 | Record Type | X(1) | Constant D |
2-10 | SSN | 9(9) | The employee's social security number. |
11-15 | VRS Agency Code | 9(5) | The five-digit agency code assigned in the VRS Navigator. |
16-50 | Last Name | X(35) | The employee's last name, including any suffix. |
51-70 | First Name | X20) | The employee's first name. |
71-90 | Middle Name | X(20) | The employee's middle name. |
91-99 | Filler | X(9) | filler |
100 | Marital Status | 9(1) | The employee's marital status. Valid values:
|
101-309 | Filler | X(209) | filler |
310-317 | Check Date | 9(8) | The payroll check date. The format is CCYYMMDD. |
318-323 | Payroll Period | 9(6) | The year and month for the payroll period used for reconciliation with VRS. The format is CCYYMM. |
324-353 | Filler | X(30) | filler |
354 | Employee Voluntary Contribution Sign | X(1) | Valid values:
|
355-361 | Employee Voluntary Contribution | 9(5)V99 | Employee Voluntary 457 Contribution |
362 | Employee Mandatory Contribution Sign | X(1) | Valid values:
|
363-369 | Employee Mandatory Contribution | 9(5)V99 | Employee Mandatory 401 Contribution |
370 | Employer Mandatory Contribution Sign | X(1) | Valid values:
|
371-377 | Employer Mandatory Contribution | 9(5)V99 | Employer Mandatory 401 Contribution |
378 | Employer Matching Contribution Sign | X(1) | Valid values:
|
379-385 | Employer Matching Contribution | 9(5)V99 | Employer Matching 401 Contribution |
386-500 | Filler | X(115) | filler |
T - Total Record Type
The following table lists the T- Total record type's position, field, data type, and description.
Position | Field | Data Type | Description |
---|---|---|---|
1 | Record Type | X(1) | Constant T |
2-9 | Report date | 9(8) | The report date. The format is CCYYMMDD. |
10-20 | Total Number of Detail Records | 9(11) | Total number of D - detail records. |
21 | Total Sign | X(1) | Valid values:
|
22-38 | Total Contributions | 9(17) | The sum of all detail record values for all the contribution amount type fields. |
39-500 | Filler | X(462) | filler |