PowerSchool ERP Ohio

Federal 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 Federal 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 federal 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 federal tax settings in the Federal section of the Employee Tax Information page.

D

Tax Paid

The total federal tax withheld for the employee.

Retrieved from a calculated value during payroll processing.

The system automatically calculates federal tax withholding based on the federal withholding settings in the Federal 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.