QW and UI

National Directionary of New Hires

02 NDNH Output Record Specs 8-30-06

QW and UI

OMB: 0970-0166

Document [doc]
Download: doc | pdf

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-11 February 28, 2003


File Typeapplication/msword
File TitleNDNH W-4 Output Record Layouts
AuthorYoram Mohr
Last Modified ByUSER
File Modified2006-11-14
File Created2006-11-14

© 2024 OMB.report | Privacy Policy