Capital | PowerSchool ERP Compliance

All records are mandatory and must be 512 bytes in length. If there is no local data, leave the relevant fields blank.

The following are the records included:

RA Record

The following table lists the data item, description, length, and position of the Capital report type’s RA record.

Data Item	Description	Length	Position
Record Identifier	Constant RA	2	1
Submitter’s EIN	Required	9	3
Variety	Optional	12	12
Year-End Reconciliation Indicator	Optional Valid values: 1 - Year-End Reconciliation 0 - Monthly or Quarterly file	1	24
Variety	Optional	192	25
Submitter Name	Required	57	217
Location Address	Required	22	274
Delivery Address	Required	22	296
City	Required	22	318
State Abbreviation	Use Postal Abbreviation	2	340
ZIP Code	Required	5	342
ZIP Code Extension	Required	4	347
Variety	Optional	45	351
Contact Name	Required	27	396
Contact Phone Number	Required	15	423
Contact Phone Extension	Required	5	438
Blank	Fill with blanks	3	443
Contact E-mail	Optional	40	446
Blank	Fill with blanks	3	486
Contact Fax	Optional	10	489
Variety	Optional	14	499

The following table lists the data item, description, length, and position of the Capital report type’s RE record.

Data Item	Description	Length	Position
Record Identifier	Constant RE	2	1
Tax Year	Required	4	3
Agent Indicator	Optional	1	7
Employer EIN	Required	9	8
Variety	Optional	23	17
Type of Tax	Valid values: E = EIT L = LST W = W2	1	29
Variety	Optional	10	30
Employer Name	Required	57	40
Location Address	Required	22	97
Delivery Address	Required	22	119
City	Required	22	141
State Abbreviation	Required	2	163
Zip Code	Required	5	165
Zip Code Extension	Required	4	170
Record Change Notice	Optional Valid values: 0 = No change 1 = Changed	1	174
Variety	Optional	46	175
Period Type	Optional: M for Monthly, Q for Quarterly, Y for Yearend Reconciliation	1	221
Period	Optional: 1-12 for Monthly, 1-4 for Quarterly, 5 or 13 for Yearend Reconciliation	2	222
Local Account Number	Optional Local Account #, required for employers with multiple accounts for a single EIN	30	224
Blank	Fill with blanks	281	254
PA eight-digit Account Number (as displayed on each payment coupon)	Required by PA, but not for local	8	505

The following table lists the data item, description, length, and position of the Capital report type’s RS record.

Data Item	Description	Length	Position
Record Identifier	Constant RS	2	1
State Code	Must be 42 for PA State Wages and Withholding	2	3
Taxing Entity Code	Optional	5	5
Social Security Number	Required	9	10
Employee First Name	Required	15	19
Employee Middle Name/Initial	Required	15	34
Employee Last Name	Required	20	49
Suffix	Required	4	69
Location Address	Required	22	73
Delivery Address	Required	22	95
City	Required	22	117
State Abbreviation	Required	2	139
Zip Code	Required	5	141
Zip Code Abbreviation	Required	4	146
Variety	Optional	118	150
Record Change Notice	Optional Valid values: 0 = No change 1 = Changed	1	196
Variety	Optional	71	197
Blank	Leave blank	6	268
State Code	Optional	2	274
State Taxable Wages	Enter PA Wages as applicable	11	276
State Income Tax Withheld	Enter PA Withholding as applicable	11	287
Blank	Leave blank	11	298
Local Taxable Wages	Enter Local Wages subject to EIT(should be the same as PA Wages)	11	309
Local Income Tax Withheld	Enter Local Withholding. Required.	11	320
State Control Number	Leave blank	7	331
Residence PSD Code	PSD code of employees residence list	6	338
Work PSD Code	PSD code of work location	6	344
Local Tax Type	EIT, ENR or LST depending on type of local tax being reported	3	350
Variety	Optional	135	353
Blank	Leave blank	25	488

The following table lists the data item, description, length, and position of the Capital report type’s RT record.

Data Item	Description	Length	Position
Record Identifier	Constant RT	2	1
Variety	Optional	337	3
Blank	Leave blank	136	340
Number of Code RS Records	Required	7	476
Total Local Taxable Wages	Required	15	483
Total Local Tax Withheld	Required	15	498

The following table lists the data item, description, length, and position of the Capital report type’s RF record.

Data Item	Description	Length	Position
Record Identifier	Constant RF	2	1
Blank	Leave blank	5	3
Variety	Optional	468	8
Number of RS Records	Required	7	476
Total Local Taxable Wages	Required	15	483
Total Local Tax Withheld	Required	15	498