Jordan | 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 Jordan report type’s RA record.

Data Item	Description	Length	Position
Record Identifier	Constant RA	2	1
Submitter’s EIN	Required	9	3
Variety	Optional	26	12
Submitter Name	Required	57	38
Location Address	Required	22	95
Delivery/Street Address	Required	22	117
City	Required	22	139
State Abbreviation	The postal abbreviation is required. For foreign addresses, fill the field with blanks.	2	161
ZIP Code	For foreign addresses, fill the field with blanks.	5	163
ZIP+4 Extension	For foreign addresses, fill the field with blanks.	4	168
Blank	Fill the field with blanks.	5	172
Foreign State/Province	If applicable, fill in this field. Otherwise, fill it with blanks. Left justify.	23	177
Foreign Postal Code	If applicable, fill in this field. Otherwise, fill it with blanks. Left justify.	15	200
Country Code	If applicable, fill in this field. Otherwise, fill it with blanks. Left justify.	2	215
Blank	Fill the field with blanks.	179	217
Contact Name	Required	27	396
Contact Phone Number	Required	15	423
Contact Phone Extension	Required	5	438
Blank	Fill the field with blanks.	3	443
Contact E-mail	Optional	40	446
Blank	Fill the field with blanks.	3	486
Contact Fax	Optional	10	489
Variety	Optional	14	499

RE Record

The following table lists the data item, description, length, and position of the Jordan 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
JTS Assigned Employer Account Number	Employer account number assigned by the Jordan Tax Service.	12	17
Variety	Optional	11	29
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 Indicator	Valid values: 0 = no change 1 = change to Name, Address, or Jurisdiction	1	174
Blank	Fill the field with blanks.	4	175
Foreign State/Province	If applicable, fill in this field. Otherwise, fill it with blanks. Left justify.	23	179
Foreign Postal Code	If applicable, fill in this field. Otherwise, fill it with blanks. Left justify.	15	202
Country Code	If applicable, fill in this field. Otherwise, fill it with blanks. Left justify.	2	217
Blank	Fill the field with blanks.	3	219
Employer PSD code	PSD code for this physical location, branch, or store.	6	222
Monthly filing indicator	Valid values: M = monthly filing Q = quarterly filing	1	228
Reporting Period Ending	Period ending year and month. The format is YYYYMM. It must be the quarter’s or month’s ending date if the Monthly filing indicator field value is M or Q.	11	229
Tax Type	Valid values: E = EIT L = LST W=W2	1	235
Employer total school District only payments	Required for LST reporting	6	236
Employer total number Of exemptions	Required for LST reporting	1	247
Blank	Fill the field with blanks.	6	254

RS Record

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

Data Item	Description	Length	Position
Record Identifier	Constant RS	2	1
Blank	Fill the field with blanks.	7	3
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
Blank	Fill the field with blanks.	5	150
Foreign State/Province	If applicable, fill in this field. Otherwise, fill it with blanks. Left justify.	23	155
Foreign Postal Code	If applicable, fill in this field. Otherwise, fill it with blanks. Left justify.	15	178
Country Code	If applicable, fill in this field. Otherwise, fill it with blanks. Left justify.	2	193
Blank	Fill the field with blanks.	1	195
Record change indicator	Valid values: 0 = no change 1 = change to Name, Address, or Jurisdiction	1	196
Reporting Period	The format is MMYYYY. It must be the quarter’s or month’s ending date if the Monthly filing indicator field value is M or Q. If reporting to multiple PSDs (for example, the employee has moved, this date reflects the actual period withheld for this PSD and may not coincide with month or quarter end dates.	6	197
Blank	Fill the field with blanks.	71	203
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	Fill the field with blanks.	10	298
Local Tax Type	Valid values: E = EIT L = LST W=W2	1	308
Local Taxable Wages	Enter Local Wages subject to EIT. It should be the same as PA Wages.	11	309
Local Income Tax Withheld	Enter Local Withholding. Required.	11	320
State Control Number	Fill the field with blanks.	7	331
Residence PSD Code	PSD code of employee residence list.	6	338
School District only Pmt	Required for LST reporting only.	11	344
Blank	Fill the field with blanks.	158	355

RT Record

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

Data Item	Description	Length	Position
Record Identifier	Constant RT	2	1
Number of Code RS Records	Required	7	3
Total Local Taxable Wages	Required	15	10
Total Local Tax Withheld	Required	15	25
Blank	Fill the field with blanks.	473	40

RF Record

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

Data Item	Description	Length	Position
Record Identifier	Constant RF	2	1
Blank	Fill the field with blanks.	5	3
Number of RS Records	Required	9	8
Total Local Taxable Wages	Required	15	17
Total Local Tax Withheld	Required	15	32
Blank	Fill the field with blanks.	466	47