Agencies | Online Services | Policies
Arkansas Department Of Workforce Services
Skip Navigation
Text-Only Page














 

Magnetic Media for UI Wage Reporting - Diskette

Personal Computer Program for UI Wage Reporting


Diskette Specifications
Codes 1E & 2E Employer Records
Code 1S/2S – Supplemental Records Quarterly SUI Diskette
Code 2S – Supplemental Record

http://www.bls.gov/cew/forms/mwr_ar.pdf

(Multiple Worksite Instructions)

Download DWS.EXE to your PC by clicking on the link below.

DOWNLOAD DWSQDRS- Windows Disk Version

Download the file DWS.EXE to your desktop. Double click on the file and follow the instructions to install the program. After you have finished, there should be a red or yellow icon with DWS on it on your desktop. Clicking on this icon will start the Department of Workforce Services Quarterly Diskette Reporting System. If this icon is not on the desktop, go to the yellow "INSTALL" folder on the c drive and double click on the SETUP.EXE file to finish the installation.

Download ARESD.EXE to your PC by clicking on the link below.

DOWNLOAD DOS VERSION 3.0

When the download is complete, go to the DOS prompt and make a subdirectory "C:\ESD", and move the file ARESD.EXE to this subdirectory. By then entering ARESD.EXE, this self-extracting file will produce ten files. Keying ESD_RPT.EXE will start The Department of Workforce Services Quarterly Diskette Reporting System. This program is menu driven. Complete operating instructions may be obtained by printing out the file SHOW.ME.)

Return to Top


MAGNETIC DISKETTE SPECIFICATIONS

DISKETTE SPECIFICATIONS - Diskette must be sent with the original Quarterly Contribution and Wage Report except when the report is filed via the Internet.

Specifications for diskette reporting furnished by the Social Security Administration have been modified to meet the reporting requirements of the Department of Workforce Services. Care has been taken to preserve the records defined by the Social Security Administration, although many of the items are not required for Department of Workforce Service reporting. Only those items indicated by an asterisk (*) are mandatory; all other items may be left blank. Specific questions regarding Department of Workforce Service quarterly reporting may be directed to:

Telephone: 501-682-1190
U.S. Postal Address:
Department of Workforce Services
Attn: Technical & Wage Services
Post Office Box 8007
Little Rock, Arkansas 72203-8007
Physical Address:
Department of Workforce Services
Attn: Technical & Wage Services
#2 Capitol Mall, Rm 323
Little Rock, Arkansas 72201

Items marked with two asterisks (**) need only be completed in the case of multiple worksites. Specific questions regarding Department of Workforce Services quarterly reporting of multiple worksite data on diskettes may be directed to:

ES-202 Section
Department of Workforce Services
Post Office Box 2981
Little Rock, Arkansas 72203-2981
Attn: Research & Analyst
Telephone 501-682-3190

Technical Specifications

Data must be written in sequential file structure on 3 1/2" disk in ASCII format using the MSDOS or Windows operating system. Only the code 1E, 2E, 1S, and 2S records are needed. The records must terminate with a carriage return and a line feed. The file should be named AR209B.TXT.

Special Instructions

Failure to provide quarterly wage detail by Magnetic Media may result in penalties being assessed as provided by
A.C.A. § 11-10-717

Seasonal employers should refer to instructions furnished with approval notice (Form DWS-Ark-291) for reporting wages paid within effective dates.

Adjustments to prior/current quarterly reports must not be included on magnetic diskette reporting. An adjustment form (DWS-Ark 223) is on our web page at www.dws.arkansas.gov under Employer Services, "UI Employer Forms". A letter including the following can also be submitted:

  1. Dws Account number
  2. Quarter to Adjust
  3. Employee Name
  4. Employee ssn
  5. Wages as originally reported
  6. Wages as should be reported (you will receive an underpayment notice for additional tax due)

If this information was not included with your disk, you may fax it to:

Attn: Technical & Wage Services
(501) 683-2379


Return to Top

DISKETTE

Diskette Quarterly Specification:
Date: January 2007
Record Name: Codes 1E & 2E Employer Records

Code 1E – Employer Length = 128

Location
Field
Length
Description & Remarks
*1-2
Record Identifier
2
Constant "1E"
*3-6
Payment Year
4
Enter the year for which the report is being prepared. Enter numeric characters only. e.g. 2007 is listed as ‘2007’.
*7-15
Federal ID Number
9
Enter only numeric characters. Enter your federal id (EIN) Do NOT list "Applied For". The DWS nine digit account number is entered in the 2S record 3-14.
16-24
State/Local 69 Number
9
If not applicable, enter blanks. See SSA Glossary for further explanation.
*25-74
Employer Name
50
Left justify and fill with blanks.
*75-114
Street Address
40
Left justify and fill with blanks.
115
Foreign Address
1
If the information shown in positions 75-114 of the Code 1E record and in positions 3-47 of the Code 2E record is for a foreign address (i.e. ' outside of the U.S. and U.S. territories and possessions, and not APO or FF enter the letter 'X' in this field. Otherwise, enter a blank.
116-128
Blank
13
Enter blanks. Reserved for SSA use

Return to Top


Code 2E - Employer Record Length=128

Location
Field
Length

Description & Remarks

*1-2
Record Identifier
2
Constant "'2E".
*3-27
City
25
Left justly and fill with blanks. If this is a foreign address, also include the name of the foreign 'state', province, etc., e.g., Ontario.
*28-37
State
10
USE standard USPS postal alphabetical abbreviation (Appendix B). If this is a foreign address, include the two-character country code, e.g., CN for Canada. Left justify and fill with blanks.
38-42
ZIP Code Extension
5
Use this field as necessary for the four-digit extension of the ZIP Code, being sure to include the hyphen in position 38. If this is a foreign address, use this field as necessary for overflow for a foreign postal code begun in positions 43-47; left justify and fill with blanks. If this field is not applicable, enter blanks.
*43-47
ZIP Code or Foreign Postal Code
5
Enter a valid ZIP Code. For a foreign address, however, use this field for the Foreign Postal Code, if applicable; left justify and fill with blanks; if necessary, continue the Foreign Postal Code in positions 38-42 above.


Qtrly SUI- DISKETTE

Location
Field
Length
Description & Remarks
48
Name Code
1
Enter "S" if the surname appears first in the employee name field (positions 12-38) of the following employee Code 1W records. Enter "F" if the first name appears first in the employee name field of the following employee Code 1 W records. This code may vary with each employer (Code 1E/2E) as long as the name format on the associated employee Code 1W records remains consistent with the name code.
49
Type of Employment
1

Enter the appropriate code:
A-Agriculture
X-Household
M-Military
Q-Medicare Qualified Government Employment (MQGE)
X-Railroad
R-Regular (All others)

NOTE: This code must correspond to the rate of withholding for social security tax in the associated Code 1W/2W records.

50-51
Blank
2
Enter blanks. Reserved for SSA use.
52-55
Establishment Number OR Coverage Group (CG)/Payroll Record unit (PRU)
4
Enter either the Establishment Number or the Coverage Group/Payroll Record Unit number, whichever is applicable. See SSA Glossary for further explanation. Otherwise, enter blanks.
56
Limitation of Liability (L) Indicator
1
For Section 218 State/local entities only: If applicable, enter the letter "L". Otherwise, enter a blank. Refer to SSA Glossary.
57-128
Blank
72
Enter blanks. Reserved for SSA use.

Return to Top

* CODE 1S/2S – SUPPLEMENTAL RECORDS DISKETTE

Diskette Quarterly Specifications
Date: January 2007
Record Name Codes 1S & 2S - Supplemental Records
Code 1S - Supplemental Record Length =128

Location
Field
Length
Description & Remarks
*1-2
Record Identifier
2
Constant '1S'.
3-128
Supplemental Data
126
To be defined by user

FOR QUARTERLY REPORTING

Location
Field
Length
Description & Remarks
*1-2
Record Identifier
2
Constant '1S'.
*3-11
Social Security Number
9
Enter the employee's social security number.
*12-38
Employee Name
27
Enter employee’s name. First name, middle initial, last name
39-78
Street Address
40
Left justify and fill with blanks.
79-103
City
25
Left justify and fill with blanks. If this is a foreign address, also include the name of the foreign 'state', province, etc., e.g., Ontario.
104-113
State
10
Enter the standard USPS postal alphabetical abbreviation (Appendix B). Left justify and fill with blanks. If this is a foreign address, enter the two-character county code, e.g., CN for Canada.
114-118
ZIP Code Extension
5
Use this field as necessary for the four-digit extension of the ZIP Code, being sure to include the hyphen in position 114. If this is a foreign address, use this field as necessary for overflow for a foreign postal code begun in positions 119-123; left justify and fill with blanks. If this field is not applicable, enter blanks.
119-123
ZIP Code or Foreign Postal Code
5
Enter a valid ZIP Code. For a foreign address, however, use this field for the Foreign Postal Code, if applicable; left justify and fill with blanks; if necessary, continue the Foreign Postal Code in positions114-118 above.
124
Blank
1
Enter a blank.
*125-126
State Code
2
Enter 05 (Arkansas).
*127-128
Optical Code
2
Seasonal designation (assigned by DWS). If not seasonal, do not fill- enter blanks.

Return to Top

Quarterly SUI- DISKETTE

Code 2S – Supplemental Record

Location
Field
Length
Description & Remarks
1-2
Record Identifier
2
Constant "2S".
3-128
Supplemental Data
126 To be defined by user.

FOR QUARTERLY REPORTING

Location
Field
Length
Description & Remarks
*1-2
Record Identifier
2
Constant "2S".
*3-14
State DWS Account Number
12
Left justify alignment, enter the nine digit DWS account number (Example: 000123456 ) and leave last three spaces blank.
*15-18
Reporting Period
4
Enter the last month and year for the calendar quarter for which this report applies; e.g., '0306" for January-March of 2006; '0607" for April- June of 2007.
*19-27
State Quarterly
Unemployment Insurance
Total Wages
9
Right justify and zero fill. More than 7 figures will require breakdown-each set of numbers totaling the full amount Must be different numbers e.g. 500,000.00 would be listed as 99999.99, 99999.98, 99999.97, 99999.96, 99999.95,&.15.
28-36
State Quarterly Unemployment Insurance Taxable Wages
9
Right justify and zero fill.
37-38
Number of Weeks Worked
2
To be defined by user.
39-42
Date First Employed
4
Enter the month and year, e.g., "0189."
43-46
Date Of Separation
4
Enter the month and year, e.g., "0599 or 0500."
47-51
Taxing Entity Code
5
To be defined by user.
52-53
State Code
2
Enter the appropriate FIPS Postal NUMERIC code. (Appendix B).
54-62
State Taxable Wages
9
Right justify and zero fill.
63-70
State Income Tax Withheld
8
Right Justify and zero fill.
71-80
Other State Data
10
To be defined by individual taxing agencies.
81
Tax Type Code
1
Enter the appropriate code for entries in positions 87-95 and 96-102
C-City Income Tax
D-County Income Tax
E-School District Income Tax
F-Other Income Tax
82-86
Taxing Entity Code
5
To be defined by individual taxing agencies.
87-95
Local Taxable Wages
9
To be defined by individual taxing agencies.
96-102
Local Income Tax Withheld
7
To be defined by individual taxing agencies.
103-109
State Control Number
7
Optional.
**110-128
Blank
19
Enter blanks OR for employer use. (See note below)
**Note: Employers with multiple worksite locations may use the following fields in lieu of Submitting the Multiple Worksite Report.
110-118
Establishment
9
See Page 2 of Multiple Worksite Report instructions. Click on link at top of the page. (Right Justify)
119-121
County
3
See Page 2 of Multiple Worksite Report instructions. Click on link at top of the page. (Right Justify)
122-125
Industry
4
See Page 2 of Multiple Worksite Report instructions. Click on link at top of the page. (Right Justify)
126
Month 1 Employment
1
Enter "1" if worked during or received pay for pay period including the 12th of the month; or Enter "O" if did not work and received no pay for pay period including the 12th of the month.
127
Month 2 Employment
1
See month 1 instructions.
128
Month 3 Employment
1
See month 1 instructions.
Return To Top