Unemployment Insurance and New Hire Reporting

MMREF FORMAT RE Record (RE/RS/RT) Specifications

File Content:This file format allows the submission of multiple employer quarterly reports for both contributory and reimbursable employers. However it does not allow the mix of quarter and year. All data files must be in ASCII format. A web upload is the preferred method for filing. Other filing media include CD ROM, DVD, and USB flash drive. We cannot accept Email.
Each record within the wage data file must be delimited by (end with) a CR/LF (Carriage Return / Line Feed) (HEX CODE - ODOA)

DWS Tax Report “Form 33H” calculation via the web upload. Total Wages will be the sum of all RS Records after each employee’s wage (location: RS Record 214-224) has been truncated at the decimal point. For this reason, the Form 33H total wages, subject wages, and tax calculations may not match your payroll report.

WAGE REPORTING
MMREF Format RE Specifications
RE
Position:
Field Name: Length: Type: Specifications:
1-2 Record Identifier 2 A Constant   "RE"
3-6 Tax Year 4 N Enter the tax year for this report (e.g. 2009)
7 Blank 1 A Fill with Blanks.
8-16 Federal Employer Identification Number (FEIN) 9 N Enter the Federal Employer Identification Number. FEIN #12-3456789=123456789.
17-39 Blank 23 A Fill with Blanks.
40-96 Employer Name 57 A Enter the Employer name. Left justify and fill with blanks.
97-118 Location Address (1st Address Line) 22 A Enter the employer's location address (Attention, Suite, Room Number, etc.). Left justify and fill with blanks.
119-140 Delivery Address (2nd Address Line) 22 A Enter the employer's delivery address (Street or Post Office Box) Left justify and fill with blanks.
141-162 City 22 A Enter the employer's city. Left justify and fill with blanks.
163-164 State Abbreviation 2 A Enter the company's State or commonwealth/territory. Use a postal abbreviation. For a foreign address, fill with blanks.
165-169 Zip Code 5 N Enter the company's ZIP Code. For a foreign address, fill with blanks.
170-173 Zip Code Extension 4 N Enter the company's four-digit extension of the ZIP Code. If not applicable, fill with blanks.
174-221 Blank 48 A Fill with Blanks.
222-223 Reporting Quarter 2 N Last month of the reporting quarter; i.e.:03,06,09,12.
224-233 DWS UT UI Registration Number 10 A DWS Employer UT UI Registration Number (e.g.,"C01234567" OR "01234567" "R01234567" OR "01234567")
234-512 Blank 279 A Fill with blanks.

WAGE REPORTING

MMREF Format RS Specifications

RS
Position:
Field Name: Length: Type: Specifications:
1-2 Record Identifier 2 A Constant   "RS"
3-4 State Code 2 A Enter the appropriate postal NUMERIC code. Numeric Code for Utah, the code is 49.
5-9 Blank 5 A Defined by State/local agency.
10-18 Social Security Number (SSN) 9 N Enter the employee's SSN as shown on the original/replacement SSN card issued by SSA. (e.g. 123-45-6789 = 123456789) If no SSN is available, enter zeros.
19-33 Employee First Name 15 A Enter the employee's first name as shown on the SSN card. Punctuation is not allowed Left justify and fill with blanks.
34-48 Employee Middle Name or initial 15 A If applicable, enter the employee's middle name or initial as shown on the SSN card. Punctuation is not allowed Left justify and fill with blanks. Otherwise, fill with blanks
49-68 Employee Last Name 20 A Enter the employee's last name as shown on the SSN card. Punctuation is not allowed Left justify and fill with blanks
69-196 Blank 128 A Fill with blanks.
197-202 Reporting Period 6 N Enter the last month and four digit year for the calendar quarter for which this report applies; e.g., 1st Qtr "032002" for January-March of 2002     2nd Qtr "062002" for April-June of 2002     3rd Qtr "092002" for July-September of 2002     4th Qtr "122002" for October-December of 2002
203-213 State Quarterly Unemployment Insurance Total Wages (Wages, Tips and Other Compensation) 11 N DWS Total Wages e.g. $15,933.87 = 00001593387 Right justify and zero fill.
214-224 State Quarterly Unemployment Insurance Total Taxable Wages 11 N DWS Total Wages e.g. $14,822.87 = 00001482287 Right justify and zero fill.
225-247 Blank 23 A Fill with blanks.
248-257 DWS Employer Account Number 10 A DWS Employer Registration Number (e.g. "C01234567" or "01234567"       "R01234567" or "01234567")
258-268 Blank 11 N Fill with blanks. Reserved for DWS use
269-512 Blank 244 A Fill with blanks.

WAGE REPORTING

MMREF Format RT Specifications

RT
Position:
Field Name: Length: Type: Specifications:
1-2 Record Identifier 2 A Constant   "RT"
3-9 Number of RS Records 7 N Enter the total number of State Employee Records (Code RS) Right justify and zero fill.
10-24 DWS Total Quarterly Wages (Wages, Tips and Other Compensation 15 N Enter the total wages for all Employee Records (Code RS) Total Wages (both dollars and cents), Right justified Zero fill. e.g., e.g. $15,933.87 = 00001593387
25-399 Blank 375 A Fill with blanks. Reserved for DWS use.
400-414 DWS Total Excess Wages 15 N Wages in excess of Utah taxable wage base. Total Wages (both dollars and cents), Right justified Zero fill. e.g., e.g. $1,111.00 = 00000111100
415-429 DWS Total Taxable Wages 15 N Total wages less excess wages. Total Wages (both dollars and cents), Right justified Zero fill. e.g., e.g. $14,822.87 = 00001482287
430-434 DWS Tax Rate 5 N Enter the DWS Tax Rate. e.g. 1.3% = 00013
435-443 DWS Tax Due 9 N Enter the DWS Tax due. e.g. $14,822.87 = 00001482287
444-448 Month 1 Employee Count 5 N Employees Count during month 1
449-453 Month 2 Employee Count 5 N Employees Count during month 2
454-458 Month 3 Employee Count 5 N Employee Count during month 3
459-512 Blank 54 A Fill with blanks. Resrved for DWS use.