Philadelphia | PowerSchool ERP Compliance

This format requires comma-separated fields.

The following are the records included:

There is one header and total record in the file.

Header Record

The following table lists the data item, description, and position of the Philadelphia report type’s header record.

Data Item	Description	Position
SOCIAL SEC NUMBER	Constant value	1
LAST NAME	Constant value	2
FIRST	Constant value	3
MIDDLE	Constant value	4
EMPLOYEE ADDRESS	Constant value	5
CITY	Constant value	6
STATE	Constant value	7
ZIP	Constant value	8
TAX YEAR	Constant value	9
TAX MONTH	Constant value	10
LOCAL TAXABLE EARNINGS FOR MONTH	Constant value	11
AMT	Constant value	12
PSD CODE	Constant value	13

The following table lists the data item, description, and position of the Philadelphia report type’s detail records.

Data Item	Description	Position
Employee SSN#	9 numeric digits only, no dashes	1
Employee Last Name	No commas, quotes or any other punctuation	2
Employee First Name	No commas, quotes or any other punctuation	3
Employee Middle Name	No commas, quotes or any other punctuation	4
Employee Address	No commas, quotes or any other punctuation	5
Employee City	No commas, quotes or any other punctuation	6
Employee State	Two letter US Postal abbreviation	7
Employee Zip	Must be 5 numeric digits or ZIP + 4	8
Tax Year	The 4 digit of the tax year YYYY	9
Tax Month	The month the payment is for.	10
Local Taxable Earnings for the Month	The total earnings for the month being reported	11
Withholding Amount	The total withholding amount for the month	12
PSD Code	6 digit code	13

The following table lists the data item, description, and position of the Philadelphia report type’s total record.

Data Item	Description	Position
Blank		1,2,3,4,5,6,7,8,9,10
Total Earnings for the Month	Total of the detail records	11
Total Withholding Amount for the Month	Total of the detail records	12
Blank		13