DLLR's Division of Unemployment Insurance

 

Supported Formats - E-Wage Reporting - Unemployment Insurance Contributions

 

Formats supported by E-Wage

  1. Federal (mmref-1) (512 characters)
  2. Maryland Diskette Format (34 characters)
  3. ICESA format (275 characters)
 

EWAGE Maryland Federal Format – Employee Record

Record Length – 512

LOCATION FIELD LENGTH DESCRIPTION
1 - 2 Record Identifier 2 Enter "RS"
3 – 4 State Code 2 Enter "24" to indicate a Maryland Wage; otherwise, the record will be ignored.
10 – 18 Employee’s SSN 9 Enter the employee’s SSN. If unknown, enter all 1s. Numeric only. Omit hyphens, and spaces.
19 – 33 Employee’s First Name 15 Enter the employee’s first name. Left justify; fill with spaces.
34 Employee’s Middle Initial 1 Enter the employee’s middle initial. If no middle initial, leave blank.
49 – 68 Employee’s Last Name 20 Enter the employee’s last name. Left justify; fill with spaces.
197 – 202 Reporting Period (MMCCYY) 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. (E.G. $17,077.74, enter 00001707774).
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 CDs and diskettes is taken from the SSA Publication MMREF-1 dated July 2000. Maryland requires data as described above and will ignore other locations.

 

EWAGE Maryland Diskette
(must be readable by IBM compatible PCs running Windows operating system 1995 or later)

Record Length – 34

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
 

EWAGE Maryland ICESA Format S Record – Employee Format

Record Length – 275

LOCATION FIELD LENGTH DESCRIPTION
1 Record Identifier 1 Enter "S"
2 – 10 Social Security Number 9 Enter the employee’s SSN. If unknown, enter all 1s. Numeric only. Omit hyphens, and spaces.
11 – 30 Employee’s Last Name 20 Enter the employee’s last name. Left justify; fill with spaces.
31 – 42 Employee’s First Name 12 Enter the employee’s first name. Left justify; fill with spaces.
43 Employee’s Middle Initial 1 Enter the employee’s middle initial. If no middle initial, leave blank.
44 – 45 State Code 2 Enter "24" to indicate a Maryland Wage; otherwise, the record will be ignored.
64 – 77 State Quarterly UI Total 14 Enter the employee’s wage. Right justify and zero fill. Numeric only. Do not include commas. (E.G. $38,994.17, enter 00000003899417).
147 – 156 State Employer Account Number 10 Enter the 10-digit employer account number assigned by State of Maryland. 1st two digits are 0s. Omit hyphens, spaces.
215 – 220 Reporting Month 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 Jan – Mar 1999. Format is MMYYYY.
221-275 Data Fields Not Used by DLLR 55 Must be filled with spaces.