PowerSchool ERP Ohio

Quarterly Wage - Employer Quarterly (E) Record - File Layout and Data Mapping

The following table lists the positions, lengths, field names, descriptions, and data sources or valid values for the Employer Quarterly (E) Record of the Quarterly Wage report.

Position

Length

Field Name

Description

Data Source or Valid Values

1

1

Record ID

Identifies the record type.

The valid value is E.

2-5

4

Year

The reporting year for which quarterly wage data is being reported.

Retrieved from the Reporting Year field on the OH Quarterly Wage - Setup page.

6-14

9

Federal EIN

The nine-digit Federal Employer Identification Number assigned by the Internal Revenue Service (IRS).

Retrieved from the Federal Employer ID Number field on the OH Quarterly Wage - Setup page.

15-23

9

Filler

Leave blank

spaces

24-73

50

Employer Name

The organization’s name.

Retrieved from the Employer Name field on the Federal/State Reporting tab of the Human Resources Profile page.

74-113

40

Employer Address

The employer's street address.

Retrieved from the Address field on the OH Quarterly Wage - Setup page.

114-138

25

Employer City

The employer's city.

Retrieved from the City field on the OH Quarterly Wage - Setup page.

139-140

2

Employer State

The employer's state FIPS code.

Retrieved from the State field on the OH Quarterly Wage - Setup page. The system converts the state code to a FIPS code for the electronic file.

141-148

8

Filler

Leave blank

spaces

149-153

5

Zip Code

The employer's five-digit zip code.

Retrieved from the Zip Code field on the OH Quarterly Wage - Setup page.

154-158

5

Zip Extension

The employer's zip code extension (ZIP+4).

Retrieved from the Zip Extension field on the OH Quarterly Wage - Setup page.

159-166

8

Filler

Leave blank

spaces

167-170

4

System Code

Indicates Ohio unemployment tax reporting.

The valid value is UTAX.

Not retrieved from a user interface field.

171-172

2

State Code

Ohio's FIPS state code.

The valid value is 39.

Not retrieved from a user interface field.

173-187

15

State UI Account

The state identification code assigned by Ohio for unemployment insurance purposes.

Retrieved from the State ID Code field on the OH Quarterly Wage - Setup page.

188-189

2

Month

The last month of the quarter.

Valid values:

  • 03

  • 06

  • 09

  • 12

Calculated during the electronic file creation process.

The month value is derived from the Reporting Quarter field on the OH Quarterly Wage - Setup page using the following logic:

  • 1 = 03

  • 2 = 06

  • 3 = 09

  • 4 = 12

190

1

One

Not applicable

The valid value is 1.

Not retrieved from a user interface field.

191-275

85

Filler

Leave blank

spaces