PA Quarterly Unemployment Report

Report Year

This field will default to the current year as defined in the HRM profile.

Report Quarter

Choose the number representing the actual quarter for which the report is being run. For the second quarter, choose 2, meaning April-June.

PA U.I. Employer Account

Enter your PA unemployment compensation account number, in the format xxyyyyy or xxyyyyyR or xxyyyyyM. Note: Do NOT include dashes or spaces. This field will default to the account number entered the last time the report was run.

Maximum Weeks

This field is required for all report types. Choose the maximum number of credit weeks for the quarter being reported. This number will default to whatever was entered the last time the report was run.

Deduction Code

This field is optional. You may enter the deduction code representing the unemployment compensation payroll deduction. If you enter a deduction code, the salary information in the report will be taken from the deduct table. If you leave this field blank, the report’s salary information will be taken from the payroll table.

Employer Maximum Taxable

Enter the maximum annual salary taxable for PA unemployment compensation. For all clients, it will default to whatever was entered the last time the report was run. However, after the user enters the PA U.I. Employer Account number, if the account number has an “M” or an “R” in the ninth position, this maximum taxable is then set to zero.

Employer U.I. Tax Rate

Enter the PA unemployment compensation tax rate, in decimal format. For example, if the rate is 2.5%, you would enter 0.025.

Pay Run – Month n

Enter the pay run that contains the 12th of the first, second, or third month in the quarter being reported.

Report Year

The year for which the report is being run. This field cannot be changed in update mode.

Report Quarter

The number representing the actual quarter for which the report is being run. For the second quarter, choose 2, meaning April-June. This field cannot be changed in update mode.

Employee Number

When adding a record and the employee number is entered, the social security number, first name, middle name, last name and suffix will be defaulted in from the employee database. This field cannot be changed in update mode.

employee.empl_no

Social Security

This field cannot be changed on the screen. Any changes must be made to the employee database.

employee.ssn

First Name

The employee’s first name.

employee.f_name

Middle Name

The employee’s middle name.

employee.m_name

Last Name

The employee’s last name.

employee.l_name

Suffix

The employee’s name suffix.

employee.name_suffix

Department

This field prints only on the hard copy report. It does not get reported to PA USMC.

employee.home_orgn

Prior Gross Wages

This amount is the difference between the employee’s yearly gross and their quarterly gross

Withholding

The employee’s withholding amount.

deduct.taken_q

or

zero

Gross Wages

The employee’s quarterly gross wages.

deduct.sal_q

or

payroll.tearn_q

Taxable Wages

The portion of the employee’s gross wages that is subject to employer unemployment taxes. This portion is subject to the limit (Employer Maximum Taxable) entered during the load process.

Credit Weeks

This comes from the Employee Information - State Required Screen.

empuser.ftext4

Include In Month 1,2,3

Check each box if the employee was paid during the pay run which included the 12th of that month.

Amended

Check if this is an amended record.

Amended Withholding

If this is an amended record, enter the corrected withholding amount.

Amended Gross Wages

If this is an amended record, enter the corrected gross wages.

Amended Taxable Wages

If this is an amended record, enter the corrected taxable wages.

Amended Credit Weeks

If this is an amended record, enter the corrected credit weeks.

A RECORD – IDENTIFICATION RECORD

Record Identifier

Constant ‘A’

Char(1)

1

Report Type

Constant ‘O’ for Original report, ‘A’ for an Amended Report

Char(1)

2

Not Used

Blank

Char(1)

3

Not Used

Blank

Char(1)

4

Not Used

Blank

Char(1)

5

Not Used

Blank

Char(1)

6

Not Used

Blank

Char(1)

7

Not Used

Blank

Char(1)

8

Not Used

Blank

Char(1)

9

Not Used

Blank

Char(1)

10

Not Used

Blank

Char(1)

11

E RECORD – EMPLOYER RECORD

Record

Identifier

Constant “E”

Char(1)

1

Account

Number

Enter the Employer Account Number without spaces or hyphens. Left-justify and right=fill with spaces.

Char(9)

2

Check Digit

Enter blank.

Char(1)

3

Filing Period

Enter “1” for the first quarter (Jan. – March), “2” for the second quarter (April – June), “3” for the third quarter (July – Sept.), or “4” for the fourth quarter (Oct. – Dec.), and the appropriate 4-digit year.

Numeric(5)

4

Number of Employees 1st Month

Enter 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. Right-justify and zero-fill.

Numeric(5)

5

Number of Employees

2nd Month

Enter 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. Right-justify and zero-fill.

Numeric(5)

6

Number of Employees

3rd Month

Enter 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. Right-justify and zero-fill.

Numeric(5)

7

Gross Wages

Enter the total quarterly gross wages subject to state UC tax. Include all tip income. Right-justify and zero-fill.

Numeric(13)

8

Employee Withholding

Enter employee withholding due (gross wages multiplied by the employee withholding rate). Right-justify and zero-fill.

Numeric(13)

9

Taxable Wages

Enter the employee’s quarterly taxable wages subject to unemployment taxes. Right-justify and zero-fill.

Numeric(13)

10

Employer Contributions

Enter employer contributions due (taxable wages multiplied by employer PA contribution rate). Right-justify and zero-fill.

Numeric(13)

11

S RECORD – EMPLOYEE RECORD

Record

Identifier

Constant “S”

Char(1)

1

Account

Number

Enter the Employer Account Number without spaces or hyphens. Left-justify and right=fill with spaces.

Char(9)

2

Soc. Security Number

Enter the employee's Social Security number with no spaces or hyphens. If not known, enter blank.

Numeric(9)

3

employee.ssn

Employee Last Name

Enter the employee's last name. If the last name includes a suffix, enter the last name, space, and suffix.

Char(25)

4

employee. l_name

Employee First Name

Enter the employee’s first name.

Char(15)

5

employee. f_name

Employee Middle Name

Enter the employee’s middle name or initial. If not known, enter blank.

Char(15)

6

employee. m_name

Employee Gross Wages

Enter the employee’s quarterly gross wages paid. Include all tip income. Right-justify and zero-fill.

Numeric(11)

7

deduct.sal_q
or
payroll.tearn_q

Employee Taxable Wages

Enter zeroes.

Numeric(11)

8

Employee Credit Weeks

Enter the number of weeks in the reporting period in which $50 or more was earned, regardless of when paid. Right-justify and zero-fill. Valid values are 0 through 14.

Numeric(2)

9

empuser.ftext4

Not Used

Blanks

Char(1)

10

Not Used

Blanks

Char(1)

11