Skip to content  

Division of Unemployment Insurance (DUI)

Use of Magnetic Media for Wage Reporting and Contributions Returns

E-wage filing of quarterly unemployment wages

 

Revised September 2008

TABLE OF CONTENTS

I.  MAGNETIC MEDIA REPORTING
        General Information

II.  TAPE REPORTING
        A.  General Tape Requirements
        B.  Maryland Tape Requirements
        C.  Federal Tape Specifications
        D.  ICESA Tape Specifications
        E.  Contribution (Tax) Tape Specifications

III.  DISKETTE REPORTING
        General Diskette Requirements

IV.  MAGNETIC MEDIA MAILING

V.  MAGNETIC MEDIA QUESTIONS

VI.  RECORD FORMATS
         A.  General Information
         B.  TAPE or 3480 CARTRIDGE, DISKETTE, CD-ROM (must be readable by IBM compatible PC's running Windows operating system 1995 or later)  (MARYLAND FORMAT) (Exhibit A)
         C. 
TAPE or 3480 CARTRIDGE, DISKETTE, CD-ROM (must be readable by IBM compatible PC's running Windows operating system 1995 or later) (FEDERAL FORMATS) (Exhibit B)
        D. 
TAPE or 3480 CARTRIDGE, DISKETTE, CD-ROM (must be readable by IBM compatible PC's running Windows operating system 1995 or later)  (ICESA FORMAT) (Exhibit C)
        E.  CONTRIBUTION (Tax) Tape Specifications (Exhibit D)
        F.  DISKETTE (MARYLAND) (Exhibit E)

VII.  MISCELLANEOUS
        Glossary of Key Terms
        Magnetic Media Transmittal Form (Exhibit F)

Maryland Department of Labor, 
Licensing & Regulation
Division of Unemployment Insurance
1100 North Eutaw Street
Baltimore, MD  21201
May, 2004

I.  MAGNETIC MEDIA REPORTING

    A.  MARYLAND REQUIRES ALL EMPLOYERS WITH MORE THAN 100 EMPLOYEES WORKING IN THE STATE OF MARYLAND TO REPORT QUARTERLY WAGES ON MAGNETIC MEDIA. THE STATE HAS ATTEMPTED TO MAKE THE REPORTING AS CONVENIENT AS POSSIBLE BY PROVIDING MULTIPLE MEDIA AND FORMATS. YOU MAY CHOOSE EITHER OF THESE MEDIAS OR FORMATS.

    B.  TAX PREPARERS , PAYROLL COMPANIES, COST CONTROL COMPANIES IN THE STATE OF MARYLAND FILING ON BEHALF OF 100 OR MORE EMPLOYERS ARE REQUIRED TO FILE THEIR QUARTERLY CONTRIBUTIONS , (TAXES NOT WAGES) RETURNS FOR UNEMPLOYMENT INSURANCE ON MAGNETIC MEDIA.

    C.  OTHERWISE, THE CONTRIBUTION/WAGE REPORT, FORM DUI 15/16 IS STILL REPORTED ON PAPER UNLESS YOU ARE REPORTING FOR 100 OR MORE EMPLOYERS AS STATED IN PARAGRAPH B. ABOVE.

General Information and Requirements for Magnetic Media Reporting

* This document contains information on the media and formats accepted by the State of Maryland for the processing of Wage Reports and Contribution Returns. A glossary of key terms, acceptable record layouts and the required Magnetic Media Transmittal form are included.

* Maryland accepts Wage reporting data on magnetic reel tape (State, Federal and ICESA formats), 3480 cartridge tape non compressed (State, Federal and ICESA formats), 3 ½" diskette and CD-ROM (must be readable by IBM compatible PC's running Windows operating system 1995 or later). No other medias or formats are accepted at this time.

* Maryland accepts Contribution (tax) reporting data on magnetic reel tape, 3480 cartridge and 3 ½" diskettes (State format only). This pertains to Cost Control and Payroll companies or Tax Preparers who are required to report for 100 or more employers.

* Wage Reports and Contribution Returns must be submitted by the end of the month following the completion of the calendar quarter to be considered timely, i.e., reports for the quarter ending September 30 must be submitted no later than October 31, reports for the quarter ending December 31 must be submitted no later than January 30, reports for the quarter ending March 31 must be submitted no later than April 30, and reports for the quarter ending June 30 must be submitted no later than July 31.

* Magnetic media must be accompanied by a Magnetic Media Transmittal Form (EXHIBIT F). This transmittal must be reproduced and used in subsequent submissions. CAUTION, THE CONTRIBUTION AND WAGE REPORT, FORM DUI 15/16 AND THE APPROPRIATE CHECK SHOULD BE FORWARDED SEPARATELY IN THE ENVELOPE PROVIDED WITH YOUR TAX PACKAGE TO P.O. BOX 17291, BALTIMORE, MARYLAND 21297-0365. The reverse side, The Wage Report, Form DUI 16 must be annotated as: "Wages reported on magnetic media."

* Magnetic media must have an external label which contains all the information on the Transmittal form in the event the form is separated from the media. If more than one tape or diskette is required for the submittal, a volume number should be included on the external label (e.g. diskette 1 of 3, 2 of 3, or tape 3 of 3, etc).

* Tapes will be returned to the Employer to the address shown on the transmittal form after processing; diskettes will not be returned. Tapes cannot be returned to Post Office Boxes according to Postal Regulations. 2/01

* For initial, first time submitters; both the magnetic media and paper forms or printouts should be prepared; however only the magnetic media should be submitted. The paper form/printout will be requested if you cannot correct any errors on the magnetic media in a timely manner.

* All tapes, reels, cartridges and diskettes should be labeled. Labels should have employer name, account number, contact person, address and telephone number. A transmittal sheet must be submitted with the magnetic media in the event the two are separated from each other.

________________________________________________________________

II. TAPE REPORTING

    A.  General Requirements

    *  Files should be written on ½" magnetic tape, in the unpacked mode using only 9-track tapes or 3480 cartridges.

    *  Only magnetic tape recorded in EBCDIC (Extended Binary Coded Decimal Interchange Code) is acceptable.

    *  Reel tapes must be recorded at 1600 or 6250 bpi. Only 3480 cartridge tapes in the standard style and format will be accepted.

    *  Compressed files cannot be accepted.

    *  Files with signed fields cannot be processed.

    *  Tapes may have standard internal labels or be unlabeled.

    B.  Maryland Format Tape Specifications (Wages)

    *  Each record must be fixed length of 80 characters.

    *  The largest acceptable block size is 8,000 (100 X 80).

    C.  Federal Format Tape Specifications (Wages)

    This record layout used the Code RE (Employer Record) and the Code RS (Supplemental/Employer Record) as prescribed for state reporting by the Social Security Administration (SSA). Refer to the SSA Publication MMREF-1 dated July, 2000, or later, for valid entries and/or records if you are submitting the entire federal layout or for multi-state reporting.

    *  Each record must be a fixed length of 512 characters.

    *  The only  acceptable block size is 23,040 (512 X 45).

    *  A Code RE record must exist for each employer on the tape and be followed by the Code RS record(s). If data for an employer is contained on more than one tape, a Code RE Record MUST appear on each tape.

    *  Records containing any state code other than 24, Maryland will be ignored.

    D.  ICESA Format Tape Specifications (Wages)

    For this format, Maryland uses only the S Record (employee) ignoring all other record types, as prescribed for state wage reporting by the Interstate Conference of Employment Security Agencies (ICESA). Maryland will read only those fields in the record as indicated under the ICESA format section of this reference guide. Refer to the ICESA publication. "ICESA Format" for the complete ICESA record layout.

    *  Each record must be a fixed length of 275 characters.

    *  The largest acceptable block size is 27,500 (275 X 100); however, the preferred block size is 6,875 (275 X 25).

    *  Records containing any state code other than 24, Maryland, or record types other than S are ignored.

    E.  Contribution (Tax) Maryland Tape and Diskette Specifications

    (Only For Cost Control and Payroll Companies and Tax Preparers Who Report For 100 or More Employers, Refer to Section I.B.)

    *  Preparers submitting contribution data on magnetic media for the first time are required to submit a test tape or diskette. Call 410-767-2885 for information on mailing the test media. Preparers are also required to submit a hard copy printout of the data contained on the quarterly tape. The printout must include the total amount of tax paid for all employers, the employer account number, employer name, employment, total wages, excess wages, taxable wages, rate and tax paid for each employer on the tape.

    *  Formats and Label Requirements are given in Exhibit D.

    *  Questions in regard to detail information for tax preparers preparing magnetic media for contributions should be directed to Monica Douglass at 410-767-2667. A booklet to address questions is available.

________________________________________________________________

III. DISKETTE REPORTING (WAGES)

    A.  The diskette format is a non-delimited ASCII text file with carriage return and line feed characters at the end of each record and a standard end-of-file marker which has been generated on a MS-DOS or PC-DOS machine (i.e, an IBM or IBM compatible personal computer). Only  3 ½" diskettes are acceptable.

    B.  Maryland Diskette Specifications

    *  The file or dataset name must be UIWAGE.TXT and must be the only file or dataset on the diskette.

    *  All records must be a fixed length of 34 characters followed by carriage return and line feed characters.

    C.  Diskette labels should include the employer’s name, Maryland employer account number, quarter and year being reported, contact person’s name and telephone number.

    D.  NOTE:  Employers submitting diskettes or CD-ROM's in the Federal or ICESA formats must be submitted in the acceptable fixed width formats (see exhibits A, B and C).

________________________________________________________________

IV. MAGNETIC MEDIA MAILING

    A. Wage Record tapes and diskettes without the computer hard copy/printout must be mailed to:

Department of Labor, Licensing & Regulation
Office of Information Technology
1100 North Eutaw Street, Room 305
Baltimore, Maryland 21201

    B.  Contribution (Tax) tapes and diskettes must be mailed with the printout and payment to the address below:

Department of Labor, Licensing & Regulation
Division of Unemployment Insurance
P.O. Box 17291
Baltimore, MD 21297-0365

The Contribution and Wage Report, Form DUI 15/16 and the appropriate check should be mailed to the P.O. Box shown in paragraph B above and as shown in the General Information and Requirements for Magnetic Media Reporting Section.

________________________________________________________________

V.  MAGNETIC MEDIA QUESTIONS

    A.  Wage Records

        1.  Questions regarding the programming of quarterly wage data on magnetic media should be directed to :

Tape/Cartridge Only: 

Department of Labor, Licensing & Regulation
Office of Information Technology
1100 North Eutaw Street, Room 305
Baltimore, MD 21201
Attention: Ms. Pat Slater
Telephone: (410) 767-2860
Fax: (410) 333-5304

Diskette/CD-ROM Only:

Department of Labor, Licensing & Regulation
Office of Information Technology
1100 North Eutaw Street, Room 305
Baltimore, MD 21201
Attention: Mr. Walter Krysiak
Telephone: (410) 767-4380
Fax: (410) 333-5142

    2.  Questions regarding the submittal of quarterly wage data on magnetic media should be directed to:

Tape/Cartridge/Diskette/CD-ROM: 

Department of Labor, Licensing & Regulation
Division of Unemployment Insurance
1100 North Eutaw Street, Room 208
Baltimore, MD 21201
Attention: Mr. Walter Krysiak
Telephone: (410) 767-4380
Fax: (410) 333-5142

    B.  Contributions (Tax)

    Questions regarding the preparation of your contribution magnetic media should be directed to:

Department of Labor, Licensing & Regulation
Division of Unemployment Insurance
1100 North Eutaw Street
Baltimore, MD 21201

General Contact: Mr. James McVicker
Telephone: (410) 767-2492
Diane Markowski
Telephone: (410) 767-2670

________________________________________________________________

VI.  RECORD FORMATS

The following exhibits contain the record layouts for the Maryland, Federal, and ICESA formats.

    1.  The Federal record layout for tapes is taken directly from the Social Security Publication MMREF-1. Only those records and fields required by Maryland are included in this publication. Refer to the MMREF-1 for valid entries for other fields and records if you are submitting the complete Federal format; otherwise, all other locations in the Code E and S records for tapes are ignored.

    2.  The ICESA record layout may be used for tapes only. The ICESA tape record layout is taken directly from the ICESA publication "ICESA Format". Only those records and fields required by Maryland are included in this publication. Refer to the "ICESA Format" for valid entries for other fields and records if you are submitting the complete ICESA format; otherwise, all other fields locations and record types are ignored.

________________________________________________________________

Exhibit A
TAPE or 3480 CARTRIDGE, DISKETTE, CD-ROM (must be readable by IBM compatible PC's running Windows operating system 1995 or later) 
(MARYLAND FORMAT)
Record Length - 80
Block Size - 8,000 (100 X 80)

 

LOCATION

FIELD

LENGTH

DESCRIPTION

1

Reserved

1

Must Be Blank

2 - 11

Employer Account Number

10

Enter the employer’s account number assigned by the State of Maryland. Numerics only; omit hyphens and spaces.

12 - 13

Reporting Year

2

Enter the 2 digit year (decade) for which this report applies. Numerics only. E.G. "1999 = 99

14

Reporting Quarter

1

Enter the quarter for which this report applies. Numerics only. E.G. "2" for April - June.

18 - 26

Employee Social Security Number

9

Enter the employee’s Social Security number. If unknown, enter all zeroes. Numerics only; omit hyphens, and spaces.

27

Employee Initials

1

First name initial.

29 - 31

Employee Last Name

3

First 3 positions of last name, omit hyphens, and apostrophes.

33 - 40

Employee Wages

8

Enter the employee’s total wages paid during the quarter. Numerics only. Do not include decimals or commas. Zero fill, right justify.

67 - 70

Constant

4

Always 9999.

71 80

Blanks

10

Reserved.

All positions not indicated should be blank.
________________________________________________________________

Exhibit B
TAPE OR 3480 CARTRIDGE
, DISKETTE, CD-ROM (must be readable by IBM compatible PC's running Windows operating system 1995 or later) (FEDERAL FORMAT)
(CODE RE - EMPLOYER RECORD)

 

LOCATION

FIELD

LENGTH

DESCRIPTION

1-2

Record Identifier

2

Constant "RE"

40-96

Employer Name

57*

Enter employer name. Left justify; fill with spaces.

97-118

Location Address

22*

Enter the employer’s location address (Attention, Suite, Room Number)

119-140

Delivery Address

22*

Enter the employer’s delivery address

141-162

City

22*

Enter the city of the employer’s mailing address. Left justify; fill with spaces.

163-164

State Abbreviation

2

Enter the standard FIPS alphabetic postal abbreviation. (Maryland = MD).

165-169

Zip Code

5*

Enter the employer’s zip code.

170-173

Zip Code (Extension)

4*

Enter the employer’s 4 digit extension of the zip code.

The Revised Federal Format for tapes is taken from the SSA Publication MMREF-1 dated July, 2000.

Maryland requires data as described above and will ignore other locations.

*Fields ignored by Maryland.
________________________________________________________________

Exhibit B
TAPE OR 3480 CARTRIDGE
, DISKETTE, CD-ROM (must be readable by IBM compatible PC's running Windows operating system 1995 or later) (FEDERAL FORMAT)
(CODE RS - EMPLOYEE RECORD)
Record Length - 512
 Block Size - 23,040 (512 X 45)

 

LOCATION

FIELD

LENGTH

DESCRIPTION

1-2

Record Identifier

2

Constant "RS"

3-4

State Code

2

Enter the appropriate FIPS postal numeric code: the code for Maryland is 24.

10-18

Social Security Number

9

Enter the employee’s Social Security number. If unknown, enter all zeros. Numerics only; omit hyphens and spaces.

19-33

Employee First Name

15

Enter employee’s first name. Left Justify; fill with spaces.

34

Employee Middle Initial

1

Enter the employee’s middle initial. If no middle initial, leave blank.

49-68

Employee Last Name

20

Enter the employee’s last name. Left justify; fill with spaces.

197-202

Reporting Period

6

Enter the last month and year for the calendar quarter for which this report applied: E.G. "032000" for Jan-Mar 2000.

203-213

State Quarterly UI Total

11

Enter employee wages; right justify and zero fill. Numerics only. Do not include decimals or commas.

248-267

State Employer Account Number

20

Enter your Maryland Unemployment Insurance Account Number. The first 10 positions must be entered as zeros. Starting with position 258 enter your 10 digit Maryland Unemployment Insurance Account Number. All Maryland Unemployment Account Numbers start with 2 zeros. For example: if your Maryland Unemployment Account Number is 0012345678 it must be entered in positions 248 to 267 as 00000000000012345678. Omit hyphens, spaces, right justify.

The Revised Federal Format for Tapes is taken from the SSA Publication MMREF-1 dated July, 2000.

Maryland requires data as described above and will ignore other locations. Also all records for state codes (positions 3-4) other than Maryland’s code 24 are ignored.
________________________________________________________________

Exhibit C
TAPE OR 3480 CARTRIDGE, DISKETTE, CD-ROM (must be readable by IBM compatible PC's running Windows operating system 1995 or later)
(ICESA FORMAT)
(S RECORD - EMPLOYEE FORMAT)
Record Length - 275
Block Size - 6875 (275 X 100) or 27,500 (275 X 100)

 

LOCATION

FIELD

LENGTH

DESCRIPTION

1

Record Identifier

1

Constant "S"

2 - 10

Social Security Number

9

Enter the employee’s social security number. If unknown, enter all zeroes. Numerics only; omit hyphen and spaces.

11 - 30

Employee Last Name

20

Enter the employee’s last name. Left justify; fill with spaces.

31 - 42

Employee First Name

12

Enter the employee’s first name. Left justify; fill with spaces.

43

Employee Middle Initial

1

Enter the employee’s middle initial. If no middle initial, leave blank.

44 - 45

State Code

2

Enter the state FIPS Postal Numeric Code for the state to which wages are reportable; the code for Maryland is 24.

64 - 77

State Qtr Unemployment Insurance Total Wages

14

Enter the gross total wages earned for the quarter. Include all tip income. Right justify and zero fill. Numerics only. DO NOT include decimals and commas.

147 - 156

State Unemployment Insurance Account Number

10

The state ID/Account number assigned for UI reporting purposes.

Enter the 10 digit employer account number assigned by State of Maryland in positions 147-156. Numerics only; omit hyphens, spaces. Left justify, blank fill. (First 2 positions are zeroes).

215-220 Reporting Quarter and Year 6 Enter the 2 digit month and 4 digit year for the calendar quarter for which the report applies, e.g., "031999" for January - March 1999 "061999" for April - June 1999, "091999" July - September 1999, "121999" for October - December 1999. Format is MMYYYY.

The ICESA Format is taken from the ICESA Publication "ICESA FORMAT." Maryland requires data as described above, will ignore other field/locations, and record types, as well as records for State codes other than Maryland (24 in positions 44 and 45).
________________________________________________________________

Exhibit D
CONTRIBUTION (TAX) REPORTING - TAPE AND DISKETTE
(EMPLOYER CONTRIBUTION RETURN FORMAT)

 

LOCATION

LENGTH

DESCRIPTION

PICTURE

1 - 14

14

BLANKS

X(14)

15

1

Remit Type - constant "1"

9(1)

16 - 24

9

Remit Amount.

9(7)V99

25 -34

10

MD U.I. Employer Number.

9(10)

35 - 37

3

Year Quarter (YYQ)

9(3)

38 - 41

4

Rate (format 2.5% - 0250).

99V99

42 - 46

5

Employment 1st Month (for zero employment use "00000" for employment not reported use "00001-", sign in low order position.

S9(5)

47 - 51

5

Employment 2nd Month (for zero employment use "00000", for employment not reported use "00001-", sign in low order position.

S9(5)

52 - 56

5

Employment 3rd Month (for zero employment use "00000", for employment not reported use "00001-", sign in low order position.

S9(5)

57 - 67

11

Total Wages Paid by Employer

9(9)V99

68 - 78

11

Excess Wages (wage base = $7,000 through 12/31/92; $8,500 as of 1/1/93).

9(9)V99

79 - 89

11

Taxable Wages (Total Wages less excess wages).

9(9)V99

90 - 98

9

Computed Tax (Taxable wages times rate).

9(7)V99

99

1

Wage report code (constant 0).

X(1)

100 - 155

56

BLANKS

X(56)

Tapes MUST be clearly marked: "Labeled" or Unlabeled".

External Label Requirements:

1.  Tape Creation Date
2.  Quarter/Year of Wage Data
3.  Name, Address and Telephone Number of Preparer
4.  Number of Reels or Cassettes
5.  Total Record Count
6.  Return address for tape

Internal Label Requirements

1.  Internal Label: IBM Standard label; If not IBM Standard Label, tape should be non-labeled
2.  9 Track
3.  Character Set: EBCDIC
4.  Blocking Factor = 26
5.  Data set name left to vendor’s discretion

________________________________________________________________

 

Exhibit E (Effective October 1, 2004)
DISKETTE, CD-ROM (must be readable by IBM compatible PC's running Windows operating system 1995 or later)

(STATE FORMAT)

DISKETTE FILE MUST BE NAMED UIWAGE.TXT

 

LOCATION

FIELD

LENGTH

DESCRIPTION

1 – 10

Employer Account Number

10

As assigned by State Of Maryland. THIS NUMBER IS NOT YOUR FEDERAL ID#, OR YOUR CENTRAL REGISTRATION NUMBER.

11 - 13

Reporting Period YYQ

3

Enter the last 2 digits of the year and the quarter number i.e. 041

14 - 22

Employee Social Security Number

9

All numeric 111111111, if unknown.

23

Employee Initial

1

First letter of the first name.

24 - 26

Employee’s Last Name

3

Only the first 3 letters of the last name (omit hyphens, apostrophes or special characters)

27

Blank

1

Blank

28 - 34

Employee’s Wages

7

Total wages paid for the quarter in question (zero fill). Cents of 49 or less, round down to the lowest whole dollar. Cents of 50 or more, round up to the next whole dollar. Example of wages, $255,429.50 report as 0255430

 
________________________________________________________________

VII. MISCELLANEOUS

Glossary of Terms

Employer - An employing unit determined to be liable for unemployment insurance taxes in Maryland.

Employer Account Number - The 10 digit number assigned by Maryland to a liable employer’s Unemployment Insurance tax account. Quarterly wage data is reported under this account number (first 2 digits are zeroes, and the last [10th] position is a modulus 11 check digit.

Maryland Format - The record layout created by Maryland for quarterly tax and wage reporting by tape and diskette exclusively for Maryland.

Federal Format - A record layout provided by the Social Security Administration (SSA) for state wage reporting; detailed information provided in that Agency’s publication TIB-4.

DLLR/DUI 15-16, Employer Contribution and Employment Report - A two part form which contains summary tax and wage detail information. These forms MUST be submitted quarterly for each employer account number.

Hard Copy - Quarterly wage detailed on paper (e.g. computer printout) that is submitted only when the magnetic media cannot be corrected in a timely manner.

ICESA Format - The uniform record layout created by the Interstate Conference of Employment Security Agencies (ICESA) to standardize and simplify wage reporting, especially for multi-state employers.

Magnetic Media - Computer tapes, cartridges, diskettes and CD-ROM's (must be readable by IBM compatible PC's running Windows operating system 1995 or later) 

Yr./Qtr. - The year and calendar quarter for which data are being submitted e.g., 992 represents the period April 1, 1999, through June 30, 1999.

________________________________________________________________

 

Return to the E-Wage Reporting home page
Return to the Unemployment Insurance home page

Please direct any questions about E-Wage reporting to ewage@dllr.state.md.us.
Please direct any questions about Unemployment Insurance to ui@dllr.state.md.us.
Questions or comments regarding the DLLR website may be directed to webmaster@dllr.state.md.us.

Updated June 9, 2009