Expanded Federal Parent Locator Service OMB Control No: 0970-0166
National Directory of New Hires Expiration Date: XX/XX/200X
NDNH W-4 Output Record Layouts
CHART H-1: NDNH W-4 OUTPUT RECORD LAYOUTS AND FIELD DESCRIPTIONS |
||||
Field Name |
Location |
Length |
A/N |
Comments |
W-4 TRANSMISSION CONTROL RECORD |
||||
Record Identifier |
1-2 |
2 |
A/N |
This field is equal to the characters ‘R4’, identifying the record as the header record containing returning W-4 data. |
Transmitter State Code |
3-4 |
2 |
N |
This field contains the information that was submitted on the input record. |
Transmitter Agency Code |
5-13 |
9 |
A/N |
This field contains the information that was submitted on the input record. |
Transmission Type |
14-15 |
2 |
A/N |
‘W4’ |
Department of Defense Code |
16 |
1 |
A/N |
This field contains the information that was submitted on the input record. |
Version Control Number |
17-18 |
2 |
A/N |
‘01’ |
Date Stamp |
19-26 |
8 |
N |
This field contains the information that was submitted on the input record. |
Batch Number |
27-32 |
6 |
N |
This field contains the information that was submitted on the input record. |
Records Received |
33-43 |
11 |
N |
This is the total number of records received in the transmission, including the header and trailer records. |
Records Rejected |
44-54 |
11 |
N |
This is the total number of records rejected in the transmission. |
Error Records Returned |
55-65 |
11 |
N |
This is the total number of W-4 records with errors returned in the transmission. |
Records Posted to NDNH |
66-76 |
11 |
N |
This is the total number of W-4 records in the transmission that were posted to the NDNH W-4 File. |
Records Posted to Unverified |
77-87 |
11 |
N |
This is the total number of W-4 records in the transmission that were posted to the NDNH W-4 Unverified File. |
Batch Error Code 1 |
88-91 |
4 |
A/N |
Refer to the Chart E-1, “NDNH W-4 Error and Warning Codes”, in this document for the error and warning codes and their explanation. |
Batch Error Code 2 |
92-95 |
4 |
A/N |
|
Batch Error Code 3 |
96-99 |
4 |
A/N |
|
Batch Error Code 4 |
100-103 |
4 |
A/N |
|
Batch Error Code 5 |
104-107 |
4 |
A/N |
|
Filler |
108-157 |
50 |
A/N |
This field is all spaces. |
Records Processed |
158-168 |
11 |
N |
This is the total number of W-4 data records in the transmission minus the rejected records. |
Filler |
169-831 |
663 |
A/N |
This field is all spaces. |
W-4 DATA RECORD |
||||
Record Identifier |
1-2 |
2 |
A/N |
‘WO’ |
Employee SSN |
3-11 |
9 |
N |
This field contains the information that was submitted on the input record. |
Employee Name First Name Middle Name Last Name |
12-27 28-43 44-73 |
16 16 30 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Employee Street Address Line 1 Line 2 Line 3 |
74-113 114-153 154-193 |
40 40 40 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Employee City |
194-218 |
25 |
A/N |
This field contains the information that was submitted on the input record. |
Employee State |
219-220 |
2 |
A/N |
This field contains the information that was submitted on the input record. |
Employee Zip Code Zip Code 1 Zip Code 2 |
221-225 226-229 |
5 4 |
N A/N |
This field contains the information that was submitted on the input record. |
Employee Foreign Address Foreign Country Code Foreign Country Name Foreign Zip Code |
230-231 232-256 257-271 |
2 25 15 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Employee Date of Birth |
272-279 |
8 |
A/N |
This field contains the information that was submitted on the input record. |
Employee Date of Hire |
280-287 |
8 |
A/N |
This field contains the information that was submitted on the input record. |
Employee State of Hire |
288-289 |
2 |
A/N |
This field contains the information that was submitted on the input record. |
Federal EIN |
290-298 |
9 |
N |
This field contains the information that was submitted on the input record. |
State EIN |
299-310 |
12 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Name |
311-355 |
45 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Street Address Line 1 Line 2 Line 3 |
356-395 396-435 436-475 |
40 40 40 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Employer City |
476-500 |
25 |
A/N |
This field contains the information that was submitted on the input record. |
Employer State |
501-502 |
2 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Zip Code Zip Code 1 Zip Code 2 |
503-507 508-511 |
5 4 |
N A/N |
This field contains the information that was submitted on the input record. |
Employer Foreign Address Foreign Country Code Foreign Country Name Foreign Zip Code |
512-513 514-538 539-553 |
2 25 15 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Employer Optional Street Address Line 1 Line 2 Line 3 |
554-593 594-633 634-673 |
40 40 40 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Employer Optional City |
674-698 |
25 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Optional State |
699-700 |
2 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Optional Zip Code Zip Code 1 Zip Code 2 |
701-705 706-709 |
5 4 |
A/N A/N |
This field contains the information that was submitted on the input record. |
Employer Optional Foreign Address Foreign Country Code Foreign Country Name Foreign Zip Code |
710-711 712-736 737-751 |
2 25 15 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Filler |
752-801 |
50 |
A/N |
This field is all spaces. |
Error Code 1 |
802-805 |
4 |
A/N |
Refer to the “Chart E-1: NDNH W-4 Error and Warning Codes”, in this document for the error and warning codes and their explanation. |
Error Code 2 |
806-809 |
4 |
A/N |
|
Error Code 3 |
810-813 |
4 |
A/N |
|
Error Code 4 |
814-817 |
4 |
A/N |
|
Error Code 5 |
818-821 |
4 |
A/N |
|
SSN Verification Indicator |
822 |
1 |
A/N |
The value of this field is equal to ‘C’ if an SSN has been corrected, and spaces, if the record does not contain a corrected SSN. |
SSN 1 |
823-831 |
9 |
A/N |
This is the corrected SSN if an SSN has been corrected. |
NDNH QW Output Record Layouts
CHART H-2: NDNH QW OUTPUT RECORD LAYOUTS AND FIELD DESCRIPTIONS |
||||
Field Name |
Position |
Length |
Alpha/ Numeric |
Description/Remarks |
QUATERLY WAGE TRANSMISSION CONTROL RECORD |
||||
Record Identifier |
1-2 |
2 |
A/N |
This field is equal to the characters ‘RQ’, identifying the record as the header record containing returning QW data. |
Transmitter State Code |
3-4 |
2 |
N |
This field is required for States and territories. |
Transmitter Agency Code |
5-13 |
9 |
A/N |
This field is required for Federal Agencies. |
Transmission Type |
14-15 |
2 |
A/N |
This field must contain the characters ‘QW’. |
Department of Defense Code |
16 |
1 |
A/N |
This field is required for DoD only. |
Version Control Number |
17-18 |
2 |
A/N |
This field must contain the numbers ‘01’. |
Date Stamp |
19-26 |
8 |
N |
This field must contain the transmission date of the QW data to the NDNH. |
Batch Number |
27-32 |
6 |
N |
Transmitting Federal agency or state generates this field. |
Records Received |
33-43 |
11 |
N |
This is the total number of records received in the transmission, including the header and trailer records. |
Records Rejected |
44-54 |
11 |
N |
This is the total number of records rejected in the transmission. |
Error Records Returned |
55-65 |
11 |
N |
This is the total number of QW data records with errors in the transmission that is returned. |
Records Posted to NDNH |
66-76 |
11 |
N |
This is the total number of QW data records in the transmission that were posted to the NDNH QW File. |
Records Posted to Unverified |
77-87 |
11 |
A/N |
This is the total number of QW data records in the transmission that were posted to the Unverified QW File. |
Error Code 1 |
88-91 |
4 |
A/N |
Refer to the “Chart E-2: NDNH QW Error and Warning Codes”, in this document for the error and warning codes and their explanation. |
Error Code 2 |
92-95 |
4 |
A/N |
|
Error Code 3 |
96-99 |
4 |
A/N |
|
Error Code 4 |
100-103 |
4 |
A/N |
|
Error Code 5 |
104-107 |
4 |
A/N |
|
Filler |
108-157 |
50 |
A/N |
This field is all spaces. |
Records Processed |
158-168 |
11 |
N |
This is the total number of QW data records in the transmission minus the rejected records. |
Filler |
169-631 |
463 |
A/N |
This field is all spaces. |
QUARTERLY WAGE DATA RECORD |
||||
Record Identifier |
1-2 |
2 |
A/N |
This field is equal to the characters ‘QO’, identifying the record as containing returning QW employee and employer data. |
Employee SSN |
3-11 |
9 |
N |
This field contains the information that was submitted on the input record. |
Employee Name First Name Middle Name Last Name |
12-27 28-43 44-73 |
16 16 30 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Employee Wage Amount |
74-84 |
11 |
N |
This field contains the information that was submitted on the input record. |
Reporting Period |
85-89 |
5 |
N |
This field contains the information that was submitted on the input record. |
Federal EIN |
90-98 |
9 |
N |
This field contains the information that was submitted on the input record. |
State EIN |
99-110 |
12 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Name |
111-155 |
45 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Street Address Line 1 Line 2 Line 3 |
156-195 196-235 236-275 |
40 40 40 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Employer City |
276-300 |
25 |
A/N |
This field contains the information that was submitted on the input record. |
Employer State |
301-302 |
2 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Zip Code Zip Code 1 Zip Code 2 |
303-307 308-311 |
5 4 |
N N |
This field contains the information that was submitted on the input record. |
Employer Foreign Address Foreign Country Code Foreign Country Name Foreign Zip Code |
312-313 314-338 339-353 |
2 25 15 |
A/N A/N A/N
|
This field contains the information that was submitted on the input record. |
Employer Optional Street Address Line 1 Line 2 Line 3 |
354-393 394-433 434-473 |
40 40 40 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Employer Optional City |
474-498 |
25 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Optional State |
499-500 |
2 |
A/N |
This field contains the information that was submitted on the input record. |
Employer Optional Zip Code Zip Code 1 Zip Code 2 |
501-505 506-509 |
5 4 |
N N |
This field contains the information that was submitted on the input record. |
Employer Optional Foreign Address Foreign Country Code Foreign Country Name Foreign Zip Code |
510-511 512-536 537-551 |
2 25 15 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Filler |
552-601 |
50 |
A/N |
This field is all spaces. |
Error Code 1 |
602-605 |
4 |
A/N |
Refer to the “Chart E-2: NDNH QW Error and Warning Codes”, in this document for the error and warning codes and their explanation. |
Error Code 2 |
606-609 |
4 |
A/N |
|
Error Code 3 |
610-613 |
4 |
A/N |
|
Error Code 4 |
614-617 |
4 |
A/N |
|
Error Code 5 |
618-621 |
4 |
A/N |
|
Filler |
622-631 |
10 |
A/N |
This field, which is for the corrected SSN, is spaces; it is not being used for QW at the present time. |
NDNH UI Output Record Layouts
CHART H-3: NDNH UI OUTPUT RECORD LAYOUTS AND FIELD DESCRIPTIONS |
||||
Field Name |
Position |
Length |
Alpha/ Numeric |
Description/Remarks |
UI TRANSMISSION CONTROL RECORD |
||||
Record Identifier |
1-2 |
2 |
A/N |
This is the character ‘RU’ identifying the record as the header record containing returning UI data. |
Transmitter State Code |
3-4 |
2 |
A/N |
This field contains the information that was submitted on the input record. |
Filler |
5-13 |
9 |
A/N |
This field contains the information that was submitted on the input record. |
Transmission Type |
14-15 |
2 |
A/N |
‘UI’ |
Filler |
16 |
1 |
A/N |
This field contains the information that was submitted on the input record. |
Version Control Number |
17-18 |
2 |
A/N |
‘01’ |
Date Stamp |
19-26 |
8 |
N |
This field contains the information that was submitted on the input record. |
Batch Number |
27-32 |
6 |
N |
This field contains the information that was submitted on the input record. |
Records Received |
33-43 |
11 |
N |
This is the total number of records received in the transmission, including the Header and Trailer records. |
Records Rejected |
44-54 |
11 |
N |
This is the total number of records rejected in the transmission. |
Error Records Returned |
55-65 |
11 |
N |
This is the total number of UI data records with errors returned in the transmission. |
Records Posted to NDNH |
66-76 |
11 |
N |
This is the total number of UI data records in the transmission that were accepted and posted to the NDNH UI File. |
Filler |
77-87 |
11 |
A/N |
This field is all spaces. |
Error Code 1 |
88-91 |
4 |
A/N |
Refer to the “Chart E-3: NDNH UI Error and Warning Codes”, in this document for the error and warning codes and their explanation. |
Error Code 2 |
92-95 |
4 |
A/N |
|
Error Code 3 |
96-99 |
4 |
A/N |
|
Error Code 4 |
100-103 |
4 |
A/N |
|
Error Code 5 |
104-107 |
4 |
A/N |
|
Filler |
108-325 |
298 |
A/N |
This field is all spaces. |
UI DATA RECORD |
||||
Record Identifier |
1-2 |
2 |
A/N |
This field is equal to the characters ‘UO’, identifying the record as containing returning UI claimant and employer data. |
Claimant SSN |
3-11 |
9 |
N |
This field contains the information that was submitted on the input record. |
Claimant Name First Name Middle Name Last Name |
12-27 28-43 44-73 |
16 16 30 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Claimant Street Address Line 1 Line 2 Line 3 |
74-113 114-153 154-193 |
40 40 40 |
A/N A/N A/N |
This field contains the information that was submitted on the input record. |
Claimant City |
194-218 |
25 |
A/N |
This field contains the information that was submitted on the input record. |
Claimant State |
219-220 |
2 |
A/N |
This field contains the information that was submitted on the input record. |
Claimant Zip Code Zip Code 1 Zip Code 2 |
221-225 226-229 |
5 4 |
N A/N |
This field contains the information that was submitted on the input record. |
Claimant Benefit Amount |
230-240 |
11 |
N |
This field contains the information that was submitted on the input record. |
Reporting Period |
241-245 |
5 |
N |
This field contains the information that was submitted on the input record. |
Filler |
246-295 |
50 |
A/N |
This field is all spaces. |
Error Code 1 |
296-299 |
4 |
A/N |
Refer to the “Chart E-3: NDNH UI Error and Warning Codes”, in this document for the error and warning codes and their explanation. |
Error Code 2 |
300-303 |
4 |
A/N |
|
Error Code 3 |
304-307 |
4 |
A/N |
|
Error Code 4 |
308-311 |
4 |
A/N |
|
Error Code 5 |
312-315 |
4 |
A/N |
|
Filler |
316-325 |
10 |
A/N |
This field is spaces because it is not being used at the present time. |
THE PAPERWORK REDUCTION ACT OF 1995
Public reporting burden for this collection of information is estimated to average 266.7 hours per month for processing input and output files, including the time for reviewing instructions, gathering and maintaining the data needed, and reviewing the collection of information. An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number.
H-
File Type | application/msword |
File Title | NDNH W-4 Output Record Layouts |
Author | Yoram Mohr |
Last Modified By | USER |
File Modified | 2006-11-14 |
File Created | 2006-11-14 |