What are the specifications for the EFW2 Format to import the Form 132?

Federal EFW2 Format

Click on "Browse" and select your file. The file must be in wagerpt format. These records should have a uniform 512 character length. There are two record types: RE contains employer information, RS contains employee information (state).

CODE RE - EMPLOYER RECORD LAYOUT

Length = 512

The fields required by the Oregon Employment Department are identified with an asterisk (*) and are underlined for your convenience. Fields that are in italics are preferred, but not required.

Location	Field	Length	Specifications
*1 - 2	Record Identifier	2	Constant "RE"
3 - 6	Tax Year	4	Not required.
7	Agent Indicator Code	1	Not required.
8 - 16	Employer/Agent	9	Not required.
17-25	Agent for EIN	9	Not required.
26	Terminating Business Indicator	1	Not required.
27-30	Establishment Number	4	Not required.
31-39	Other EIN	9	Not required.
40-96	Employer Name	57	Enter the employer's business name as registered with the Oregon Employment Department. Left justify and fill with blanks.
97-118	Physical Address	22	Not required.
119-140	Delivery Address	22	Enter the employer's delivery address (street or post office box). Left justify and fill with blanks.
141-162	City	22	Enter the employer's city. Left justify and fill with blanks.
163-164	State Abbreviation	2	Enter the employer's state. Use a postal abbreviation. For a foreign address, leave blank.
165-169	Zip Code	5	Enter a valid zip code. For a foreign address, leave blank.
170-173	Zip Code Extension	4	Enter the four-digit extension of the zip code. If not applicable, leave blank.
174-178	Blank	5	Not required.
179-201	Foreign State Province	23	Not required.
202-216	Foreign Postal Code	15	Not required.
217-218	Country Code	2	Not required.
219	Employment Code	1	Not required.
220	Tax Jurisdiction Code	1	Not required.
221-512	Blank	292	Spaces.

CODE RS - STATE RECORD LAYOUT

Length = 512

The fields required by the Oregon Employment Department are identified with an asterisk (*) and are underlined for your convenience. Fields that are in italics are not required.

Location	Field	Length	Specifications
*1 - 2	Record Identifier	2	Constant "RS"
*3 - 4	State Code	2	Enter the appropriate FIPS postal Numeric code. For Oregon, the code is "41".
5 - 9	Taxing Entity Code	5	Not required.
*10 - 18	Social Security Number (SSN)	9	Enter the employee's social security number. Enter only NUMERIC characters. If the SSN is not available, enter zeros (0) in locations 10-18. Omit hyphens, prefixes and suffixes. DO NOT USE 111111111, 333333333, OR 123456789.
*19-33	Employee First Name	15	Enter the first name of the employee exactly as shown on the social security card. Left justify and fill with blanks.
*34-48	Employee Middle Name or Initial	15	If applicable, enter the employee's middle name or initial exactly as shown on the social security card. Left justify and fill with blanks.
*49-68	Employee Last Name	20	Enter the last name of the employee exactly as shown on the social security card. Left justify and fill with blanks.
69-72	Suffix	4	Not required.
73-94	Location Address	22	Not required.
95-116	Employee Address	22	Enter the employee's address. Left justify and fill with blanks. Not required but preferred.
117-138	Employee City	22	Enter the employee's city. Left justify and fill with blanks. Not required but preferred.
139-140	State Abbreviation	2	Use the appropriate 2-letter state abbreviation. For a foreign address, leave blank. Not required but preferred.
141-145	Zip Code	5	Enter the appropriate valid zip code. For a foreign address, leave blank. Not required but preferred.
146-149	Zip Code Extension	4	Use this field for the four-digit extension of the Zip Code. If not applicable, leave blank. Not required but preferred.
150-154	Blank	5	Spaces.
155-177	Foreign State Province	23	Not Required.
178-192	Foreign Postal Code	15	Not Required.
193-194	Country Code	2	Not Required.
195-196	Optional Code	2	Not Required.
*197-202	Reporting Period	6	Enter the last month and 4 digit year in MMCCYY format for the calendar quarter for which this report applies; e.g., "032008" for January-March of 2008.
*203-213	State Quarterly Unemployment Insurance Total Wages	11	Right justify and zero fill. Do not include commas or decimals. Negative amounts are not allowed.
214-224	State Quarterly Unemployment Insurance Total Taxable Wages	11	Not Required.
225-226	Number of Weeks Worked	2	Not Required.
227-234	Date First Employed	8	Not Required.
235-242	Date of Separation	8	Not Required.
243-247	Blank	5	Not Required.
*248-254	State Employer Account Number	7	Business Identification Number. Do not include hyphen or check digit, e.g., if BIN is 0123456-7, enter 0123456.
255-267	Blank	13	Not Required.
268-273	Blank	6	Not Required.
274-275	State Code	2	Not Required.
276-286	State Taxable Wages	11	Not Required.
287-297	State Income Tax Withheld	11	Not Required.
298-307	Other State Data	10	Not Required.
308	Tax Type Code	1	Not Required.
309-319	Local Taxable Wages	11	Not Required.
320-330	Local Income Tax Withheld	11	Not Required.
331-337	State Control #	7	Not Required.
*338-340	Hours Worked	3	If hours worked is greater than 999, enter 999. Do not enter partial hours. Right justify and zero fill.
341-412	Supplemental Data	72	Not Required.
413-487	Supplemental Data	75	Not Required.
488-512	Blank	25	Not Required.