PowerSchool ERP Ohio

New Hire Report - Employee 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 Employee 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

Employee SSN

The employee's Social Security number. 

Retrieved from the Social Security field on the Employee Information page.

11-26

16

Employee First Name

The employee’s first name.


Retrieved from the First Name field on the Employee Information page.

27-42

16

Employee Middle Initial

The employee's middle initial.

Retrieved from the Middle Name field on the Employee Information page.

43-71

29

Employee Last Name

The employee's last name.

Retrieved from the Last Name field on the Employee Information page.

72

1

Filler

Leave blank

spaces

73-112

40

Employee Address Line 1

The first line of the employee's address. 


Retrieved from the Address field on the Employment tab of the Employee Information page.

113-152

40

Employee Address Line 2

The second line of the employee's address. 


Retrieved from the Address field on the Employment tab of the Employee Information page.

153-192

40

Filler

Leave blank

spaces

193-217

25

Employee City

The employee's city of residence. 


Retrieved from the City field on the Employment tab of the Employee Information page.

218-219

2

Employee State

The employee's state of residence. 


Retrieved from the State field on the Employment tab of the Employee Information page.

220-224

5

Employee Zip Code

The employee's zip code. 


Retrieved from the Zip Code field on the Employment tab of the Employee Information page.

225-228

4

Employee Zip+4

The employee's zip code extension. 


Retrieved from the Zip Code field on the Employment tab of the Employee 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 employee's date of birth. 

Retrieved from the Birthdate field on the Employee Information page.

279-286

8

Hire Date

The employee's date of hire. 

Retrieved from the Hire Date field on the Employment tab of the Employee Information page.

287-288

2

State of Hire

The employee's state of hire. 


Retrieved from the State field on the Employment tab of the Employee Information page.

289

1

Employee Gender

The employee's gender. 



Valid values:

  • M = Male

  • F = Female

Retrieved from the Sex at Birth field on the Employee Information 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

Employer 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 N.

755-815

61

Filler

Leave blank

spaces