PowerSchool ERP Ohio

New Hire Report - Vendor or Independent Contractor Information (Record Type 2) - File Layout and Data Mapping

The following table lists the positions, lengths, field names, descriptions, and data sources or valid values for the Vendor or Independent Contractor Information (Record Type 2) of the New Hire report.

Position

Length

Field Name

Description

Data Source or Valid Values

1

1

Record Type

Identifies the record type.

The valid value is 2.

2-10

9

Contractor SSN

The independent contractor’s Social Security number.

Retrieved from the Soc. Security field on the Defined Page 10 - Ohio Independent Contractor page.

11-26

16

Contractor First Name

The legal first name of the independent contractor.

Retrieved from the First Name field on the Defined Page 10 - Ohio Independent Contractor page.

27-42

16

Contractor Middle Initial

The independent contractor's middle initial.

Retrieved from the Middle Name field on the Defined Page 10 - Ohio Independent Contractor page.

43-71

29

Contractor Last Name

The legal last name of the independent contractor.

Retrieved from the Last Name field on the Defined Page 10 - Ohio Independent Contractor page.

72

1

Filler

Leave blank

spaces

73-112

40

Contractor Address Line 1

The first line of the contractor's address. 


Retrieved from the Address 1 field in the Purchasing section of the Vendor Information page.

113-152

40

Contractor Address Line 2

The second line of the contractor's address. 


Retrieved from the Address 2 field in the Purchasing section of the Vendor Information page.

153-192

40

Filler

Leave blank

spaces

193-217

25

Contractor City

The contractor's city of residence. 


Retrieved from the City field in the Purchasing section of the Vendor Information page.

218-219

2

Contractor State

The contractor's state of residence. 


Retrieved from the State field in the Purchasing section of the Vendor Information page.

220-224

5

Contractor Zip Code

The contractor's zip code. 


Retrieved from the first 5 characters of the Zip Code field in the Purchasing section of the Vendor Information page.

225-228

4

Contractor Zip+4

The contractor's zip code extension. 


Retrieved from the last 4 characters of the Zip Code field in the Purchasing section of the Vendor Information page (if the zip code includes the extension in format 99999-9999).

229-270

42

Filler

Leave blank

spaces

271-278

8

Birth Date

The date of birth of the independent contractor.

Retrieved from the Birthdate field on the Defined Page 10 - Ohio Independent Contractor page.

279-286

8

Hire/Contract Date

The contract start date or hire date for the independent contractor.

Retrieved from the Start Date field on the Defined Page 10 - Ohio Independent Contractor page.

287-288

2

State of Hire

The contractor's state of hire. 


Retrieved from the State field on the Federal/State Reporting tab of the Human Resources Profile page.

289

1

Contractor Gender

The gender of the independent contractor.

Valid values:

  • M = Male

  • F = Female

Retrieved from the Gender field on the Defined Page 10 - Ohio Independent Contractor page.

290

1

Filler

Leave blank

spaces

291-299

9

Employer FEIN

The nine-digit Federal Employer Identification Number assigned by the Internal Revenue Service (IRS).

Retrieved from the Federal Identification Number (EIN) field on the OH New Hire Report - Setup - Employer page.

300

1

Filler

Leave blank

spaces

301-312

12

Contractor Account Number

The Ohio state employer account number.

Retrieved from the State Employer Account Number field on the Human Resources Profile - State page.

313-357

45

Employer Name

The official legal name of the employer or organization.

Retrieved from the Name field on the OH New Hire Report - Setup - Employer page.

358-397

40

Employer Address Line 1

The primary street address of the employer's location.

Retrieved from the Street Address 1 field on the OH New Hire Report - Setup - Employer page.

398-437

40

Filler

Leave blank

spaces

438-477

40

Filler

Leave blank

spaces

478-502

25

Employer City

The city where the employer is located.

Retrieved from the City field on the OH New Hire Report - Setup - Employer page.

503-504

2

Employer State

The two-character state code for the employer's address.

Retrieved from the State field on the OH New Hire Report - Setup - Employer page.

505-509

5

Employer Zip Code

The five-digit postal zip code for the employer's address.

Retrieved from the Zip field on the OH New Hire Report - Setup - Employer page.

510-513

4

Employer Zip+4

The four-digit zip code extension (ZIP+4).

Retrieved from the Zip Ext field on the OH New Hire Report - Setup - Employer page.

514-753

240

Filler

Leave blank

spaces

754

1

Independent Contractor

Indicates whether the person being reported is an independent contractor (vendor).

The valid value is Y.

Retrieved from the Independent field on the OH New Hire Report - Setup - Employer page.

755-762

8

First Pay Date

The date of the first payment made to the independent contractor.

Retrieved from the First Pay Date field on the Defined Page 10 - Ohio Independent Contractor page.

763-764

2

Months of Service

The number of months of service for the independent contractor.

Retrieved from the Months Service field on the Defined Page 10 - Ohio Independent Contractor page.

765-815

51

Filler

Leave blank

spaces