PA Quarterly Unemployment Report - File Layout and Data Mapping - Employer Tax Record: Code E

The Code E record identifies an employer whose employee wage and tax information is being reported, as well as the tax report data.

The following table shows the columns, column names, descriptions, and data sources or valid values for the Employer Tax (Code E) record type of the PA Quarterly Unemployment report.

Column	Column Name	Description	Data Source or Valid Values
A	Record Identifier	Identifies the record type.	The valid value is E.
B	Employer Account Number	The Pennsylvania unemployment compensation account number assigned by the Pennsylvania Department of Labor and Industry.	Retrieved from the PA U.I. Employer Account field on the PA Quarterly Unemployment Report - Load page.
C	Federal Employer Identification Number (FEIN)	The Employer Identification Number (EIN) assigned by the IRS.	Retrieved from the Employer Fed Tax ID field on the Federal/State Reporting tab of the Human Resources Profile - State page.
D	Filling Period	The quarter of the calendar year for the quarterly unemployment report.	Valid values: 1YYYY = Q1 of year YYYY 2YYYY = Q2 of year YYYY 3YYYY = Q3 of year YYYY 4YYYY = Q4 of year YYYY
E	Month 1 Employment for Employer	The number of covered employees who worked or received pay for the pay period, including the 12th day of the 1st month of the reporting period.	The valid value is the count of covered employees who worked or received pay for the pay period, including the 12th day of the 1st month of the reporting period.
F	Month 2 Employment for Employer	The number of covered employees who worked or received pay for the pay period, including the 12th day of the 2nd month of the reporting period.	The valid value is the count of covered employees who worked or received pay for the pay period, including the 12th day of the 2nd month of the reporting period.
G	Month 3 Employment for Employer	The number of covered employees who worked or received pay for the pay period, including the 12th day of the 3rd month of the reporting period.	The valid value is the count of covered employees who worked or received pay for the pay period, including the 12th day of the 3rd month of the reporting period.
H	Gross Wages	The total gross wages paid to all employees during the reporting quarter.	The valid value is the sum of all employees' gross compensation before any deductions.
I	Employee Withholding	The total unemployment insurance contributions withheld from all employees during the reporting quarter.	The valid value is the aggregate employee-side UI tax deducted from all employee paychecks.
J	Taxable Wages	The total taxable gross wages for all employees during the reporting quarter.	The valid value is the portion of wages subject to unemployment insurance tax after applying Pennsylvania's maximum taxable wage limit per employee.
K	Employer Contributions	The total employer-side unemployment insurance tax liability for the quarter.	The valid value is calculated by multiplying the total taxable wages by the employer's UI tax rate.