Contributions Supported File Formats - Unemployment Insurance

Supported Wage and Contribution Formats

Federal (mmref-1) Wage Format
Maryland (34-character) Wage Format
Maryland (80-character) Wage Format
ICESA Wage Format
Contributions (Tax) Format

Federal (mmref-1) Wage Format

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 is taken from the SSA Publication MMREF-1 dated July 2000. Maryland requires data as described above and will ignore other locations.

Maryland (34-character) Wage Format
(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

Maryland (80-character) Wage Format
(must be readable by IBM compatible PCs running Windows operating system 1995 or later)

(THIS FORMAT IS NOT VALID FOR FTP FILING)

Record Length – 80

LOCATION	FIELD	LENGTH	DESCRIPTION
1	Blank	1	Must Be Blank
2 - 11	State Employer Account Number	10	Enter the 10-digit employer account number assigned by the State of Maryland. 1st two digits are 0’s. Omit hyphens, spaces.
12 - 14	Reporting Period (YYQ)	2	Enter the last two digits of the year and the calendar quarter (e.g., 153)
18 - 26	Employee's SSN	9	Enter the employee’s SSN. If unknown, enter all 1’s. Numeric only. Omit hyphens and spaces.
27	Employee's First Initial	1	Enter the 1st character of first name.
29 - 31	Employee's Last Name	3	Enter the 1st three characters of last name. Omit hyphens and apostrophes.
33 - 40	State Quarterly UI Total	8	Enter the employee’s wages. Right-Justify and zero-fill. Numeric only. Do not include decimals or commas. (e.g., $8,009.49, enter 00800949)
67 - 70	Constant	4	Enter 9999
71 - 80	Blanks	10
81	End of Line	0	Enter a carriage return (Enter Key)

FTP 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 the Maryland Department of Labor	55	Must be filled with spaces.

Contribution (Tax) Reporting (Employer contribution return) – Employee Format

Record Length – 155

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)	S9(5)
47 - 51	5	Employment 2nd Month (for zero employment, use "00000)	S9(5)
52 - 56	5	Employment 3rd Month (for zero employment, use "00000)	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)