PowerSchool ERP Missouri

OASIS Report - File Layout And Data Mapping - Employer Reporting - Enrollment Details (Record Type 111)

The following table shows the positions, position names, descriptions, and data sources or valid values for the Employer Reporting file’s Enrollment Details record (Type 111).

Position

Position Name

Description

Data Source or Valid Values

1

Record Type

Identifies the record type.

The valid value is 111.

2

SSN

The employee's Social Security number.

Retrieved from the Social Security Number field on the General tab of the MO OASIS Report - Enrollment page.

3

Last Name

The employee's last name.

Retrieved from the Last Name field on the Demographic tab of the MO OASIS Report - Enrollment page.

4

First Name

The employee’s first name.

Retrieved from the First Name field on the Demographic tab of the MO OASIS Report - Enrollment page.

5

Middle Name

The employee's middle name.

Retrieved from the Middle Name field on the Demographic tab of the MO OASIS Report - Enrollment page.

6

Name Suffix

The employee’s name suffix.

Retrieved from the Suffix field on the Demographic tab of the MO OASIS Report - Enrollment page.

7

Address Line 1

The first line of the employee's address. 

Retrieved from the Address 1 field on the Demographic tab of the MO OASIS Report - Enrollment page.

8

Address Line 2

The second line of the employee's address. 

Retrieved from the Address 2 field on the Demographic tab of the MO OASIS Report - Enrollment page.

9

Suite

The suite or apartment number of the employee's mailing address, if applicable.

Retrieved from the Suite field on the Demographic tab of the MO OASIS Report - Enrollment page.

10

City

The employee's city of residence. 

Retrieved from the City field on the Demographic tab of the MO OASIS Report - Enrollment page.

11

State

The employee's state of residence. 

Retrieved from the State field on the Demographic tab of the MO OASIS Report - Enrollment page.

12

Zip Code (5)

The employee's zip code. 

Retrieved from positions 1-5 of the Zip Code field on the Demographic tab of the MO OASIS Report - Enrollment page.

13

Zip+4

The employee's zip code extension. 

Retrieved from positions 7-10 of the Zip Code field on the Demographic tab of the MO OASIS Report - Enrollment page.

14

Birth Date

The employee's date of birth. 

Retrieved from the Date of Birth field on the General tab of the MO OASIS Report - Enrollment page.

15

Gender

The employee's gender. 

Retrieved from the Gender field on the General tab of the MO OASIS Report - Enrollment page.

16

Marital Status

The employee's marital status code.

Retrieved from the Marital Status field on the General tab of the MO OASIS Report - Enrollment page.

17

Hire Date

The employee's date of hire. 

Retrieved from the Hire Date field on the Payroll tab of the MO OASIS Report - Enrollment page.

18

Phone

The employee's home telephone number.

Retrieved from the Phone Number field on the General tab of the MO OASIS Report - Enrollment page.

19

Part Time

Indicates whether the employee is a part-time employee for PSRS/PEERS reporting purposes.

Retrieved from the Part Time field on the Payroll tab of the MO OASIS Report - Enrollment page.

20

Weekly

Indicates whether the pay frequency is weekly.

Valid values:

  • Y

  • N

Calculated during the file generation process. Set to Y if the Pay Frequency field value on the Payroll tab of the MO OASIS Report - Enrollment page is W (Weekly), otherwise N.

21

Bi-Weekly

Indicates whether the pay frequency is bi-weekly.

Valid values:

  • Y

  • N

Calculated during the file generation process. Set to Y if the Pay Frequency field value on the Payroll tab of the MO OASIS Report - Enrollment page is B (Bi-weekly), otherwise N.

22

Semi-Monthly

Indicates whether the pay frequency is semi-monthly.

Valid values:

  • Y

  • N

Calculated during the file generation process. Set to Y if the Pay Frequency field value on the Payroll tab of the MO OASIS Report - Enrollment page is S (Semi-monthly), otherwise N.

23

Monthly

Indicates whether the pay frequency is monthly.

Valid values:

  • Y

  • N

Calculated during the file generation process. Set to Y if the Pay Frequency field value on the Payroll tab of the MO OASIS Report - Enrollment page is M (Monthly), otherwise N.

24

Other

Indicates whether another pay frequency is followed.

Valid values:

  • Y

  • N

Calculated during the file generation process. Set to Y if the Pay Frequency field value on the Payroll tab of the MO OASIS Report - Enrollment page is O (Other), otherwise N.

25

Annual Salary

The employee's total annual base salary for PSRS/PEERS reporting purposes.

Retrieved from the Annual Base Salary field on the Payroll tab of the MO OASIS Report - Enrollment page.

26

Position

The employee's job position classification for PSRS/PEERS reporting.

Valid values:

  • 000 = Non-Member

  • 001 = Superintendent/CEO

  • 005 = Asst. Superintendent/P

  • 010 = Principals/Asst. Principal

  • 020 = Office Administration

  • 025 = School/Home Coordinator

  • 030 = Teachers

  • 040 = Instructional Aides/Paraprofessionals

  • 045 = Coach

  • 050 = Nurses/Health Services

  • 055 = Speech/Language Pathologist

  • 060 = Transportation

  • 070 = Food Services

  • 080 = Maintenance

  • 090 = Other

  • 095 = Qualified Public Safety Personnel

  • 100 = Secondary Position

Retrieved from the Position Code field on the Payroll tab of the MO OASIS Report - Enrollment page.

27

Wage Type

The retirement system classification.

Valid values:

  • P = PSRS Regular

  • S = PSRS Social Security

  • C = PSRS Critical Shortage

  • N = PEERS Regular

  • W = PEERS Critical Shortage

  • R = Non-Member Retiree

  • O = Non-Member PSRS as Non-Certificated

  • T = Non-Member Substitute Teaching WAR Waiver

  • X = Non-Member

Retrieved from the Wage Type field on the Payroll tab of the MO OASIS Report - Enrollment page.

28

Position Term

The number of months in the employee's work year.

Valid values:

  • blank

  • 09

  • 10

  • 11

  • 12

Retrieved from the Term of Position field on the Payroll tab of the MO OASIS Report - Enrollment page.

29

Email Address

The employee's email address.

Retrieved from the Email field on the General tab of the MO OASIS Report - Enrollment page.