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:
- Dws Account number
- Quarter to Adjust
- Employee Name
- Employee ssn
- Wages as originally reported
- 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 employees 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. |