PowerSchool ERP Ohio

State Tax Report - Report by Employee w/Current Address (A) - File Layout and Data Mapping

The following table shows the columns, column names, descriptions, and data sources or valid values for the State Tax Report - Report by Employee w/Current Address (A).

Column

Column Name

Description

Data Source or Valid Values

A

Employee Number

The employee’s identification (ID) number.

Retrieved from the Employee Number field on the Employee Information page.

B

Name

The employee's full name.

Retrieved from the Last Name and First Name fields on the Employee Information page.

C

Taxable Wages

The total wages subject to state tax for the employee.

Retrieved from a calculated value during payroll processing.

The system automatically calculates the taxable gross wages based on the employee's state tax settings in the State section of the Employee Tax Information page.

D

Tax Paid

The total state tax withheld for the employee.

Retrieved from a calculated value during payroll processing.

The system automatically calculates state tax withholding based on the state withholding settings in the State section of the Employee Tax Information page.

E

Address Line 1

The first line of the employee's address. 


Retrieved from the Address field on the Employment tab of the Employee Information page.

F

Address Line 2

The second line of the employee's address. 


Retrieved from the Address field on the Employment tab of the Employee Information page.

G

City

The employee's city of residence. 


Retrieved from the City field on the Employment tab of the Employee Information page.

H

State

The employee's state of residence. 


Retrieved from the State field on the Employment tab of the Employee Information page.

I

Zip

The employee's zip code. 


Retrieved from the Zip Code field on the Employment tab of the Employee Information page.