OASIS Report - Maintain Data - Enrollment | PowerSchool ERP Compliance

Use the MO OASIS Report - Enrollment page to view, add, update, and maintain new employee enrollment information for Missouri OASIS (Online Automated Submission and Information System) retirement reporting. This page allows users to manage the initial enrollment data required when an employee first becomes a member of Missouri retirement systems (PSRS or PEERS), including personal demographics, contact information, and initial payroll details.

If errors are encountered during the Load data process, you can correct the source data on the Employee Information form of the MO OASIS Report - Enrollment page. After corrections, you must purge and reload the data.

PowerSchool recommends that you correct the report’s source data that is retrieved from the Core application.

You cannot add or delete records on the MO OASIS Report - Enrollment page.

On the MO OASIS Report - Enrollment page, filter records using the filter criteria. To enter filter criteria:
1. Select an option in the first field.
2. Select or enter a value.
3. Select Add if the button is enabled.
  Refer to Search for records for more information.
  - To edit a record, select the ellipsis in the Actions column and then select Edit. Refer to the Field descriptions, update the information, and select Save.
  - To download the information, select Download, then select Download PDF or Download as an Excel Document. The default file names are:
    - Excel: MO OASIS Report_<MMDDYYYY_hhmmss>.xlsx
    - PDF: MO OASIS Report_<MMDDYYYY_hhmmss>.pdf

Field descriptions

The Employee Information form of the MO OASIS Report page consists of the following:

General section

The following table describes the field in the General section on the Employee Information form of the MO OASIS Report - Enrollment page.

Field	Description	Load logic - Data source and Valid values
Employee	The employee’s name. This field is view-only.	Calculated during the data load process. The calculated value represents the employee's formatted full name for display purposes. The system constructs the employee name by combining the First Name, Last Name, Middle Name, and Suffix fields from the Employee Information page.

Field

Description

Load logic - Data source and Valid values

Employee

The employee’s name.

This field is view-only.

Calculated during the data load process.

The calculated value represents the employee's formatted full name for display purposes. The system constructs the employee name by combining the First Name, Last Name, Middle Name, and Suffix fields from the Employee Information page.

General tab

The following table describes the fields on the General tab on the Employee Information form of the MO OASIS Report - Enrollment page.

Field	Description	Load logic - Data source and Valid values
School Year	The school year for the OASIS enrollment submission in YYYY-YYYY format (e.g., 2025-2026).	Populated during the data load process. The field value is retrieved from the School Year field on the MO OASIS Report - Load page.
Report Month	The two-digit reporting month (01-12) for the OASIS enrollment submission.	Populated during the data load process. The field value is retrieved from the Report Month field on the MO OASIS Report - Load page.
Report Period	The reporting period for the OASIS submission.	Populated during the data load process. The field value is retrieved from the Report Period field on the MO OASIS Report - Load page.
Employee Number	The employee’s identification (ID) number. Select the Lookup icon to search for and select an employee number. This field is view-only and cannot be updated after saving the record.	Populated during the data load process. The field value is retrieved from the Employee Number field on the Employee Information page.
Social Security Number	The employee's Social Security number. This field is view-only.	Populated during the data load process. The field value is retrieved from the Social Security field on the Employee Information page.
Date of Birth	The employee's date of birth.	Populated during the data load process. The field value is retrieved from the Birthdate field on the Employee Information page. This field value overrides the Birthdate field value on the Employee Information page.
Gender	The employee's gender.	Valid values: M - Male F - Female The field value is retrieved from the Sex at Birth field on the Employee Information page. This field value overrides the Sex at Birth field value on the Employee Information page.
Marital Status	The employee's marital status code.	Valid values: M - Married S - Single U - Unknown Populated during the data load process. The field value is retrieved from the Marital Status field on the Payroll Information - State Required page.
Phone Number	The employee's home telephone number.	Populated during the data load process. The field value is retrieved from the Home Phone field on the Employment tab of the Employee Information page. If the phone number contains only formatting characters (dashes and spaces with no digits), the field is set to blank.
Email	The employee's email address.	Calculated during the data load process. The calculated value represents the employee's preferred email address. The system first checks the Personal Email field on the Employment tab of the Employee Information page. If populated, that value is used. If the Personal Email field is blank, the system retrieves the value from the Email field on the Employment tab of the Employee Information page.

Field

Description

Load logic - Data source and Valid values

School Year

The school year for the OASIS enrollment submission in YYYY-YYYY format (e.g., 2025-2026).

Populated during the data load process.

The field value is retrieved from the School Year field on the MO OASIS Report - Load page.

Report Month

The two-digit reporting month (01-12) for the OASIS enrollment submission.

Populated during the data load process.

The field value is retrieved from the Report Month field on the MO OASIS Report - Load page.

Report Period

The reporting period for the OASIS submission.

Populated during the data load process.

The field value is retrieved from the Report Period field on the MO OASIS Report - Load page.

Employee Number

The employee’s identification (ID) number.

Select the Lookup icon to search for and select an employee number.

This field is view-only and cannot be updated after saving the record.

Populated during the data load process.

The field value is retrieved from the Employee Number field on the Employee Information page.

Social Security Number

The employee's Social Security number.

This field is view-only.

Populated during the data load process.

The field value is retrieved from the Social Security field on the Employee Information page.

Date of Birth

The employee's date of birth.

Populated during the data load process.

The field value is retrieved from the Birthdate field on the Employee Information page.

This field value overrides the Birthdate field value on the Employee Information page.

Gender

The employee's gender.

Valid values:

M - Male
F - Female

The field value is retrieved from the Sex at Birth field on the Employee Information page.

This field value overrides the Sex at Birth field value on the Employee Information page.

Marital Status

The employee's marital status code.

Valid values:

M - Married
S - Single
U - Unknown

Populated during the data load process.

The field value is retrieved from the Marital Status field on the Payroll Information - State Required page.

Phone Number

The employee's home telephone number.

Populated during the data load process.

The field value is retrieved from the Home Phone field on the Employment tab of the Employee Information page. If the phone number contains only formatting characters (dashes and spaces with no digits), the field is set to blank.

The employee's email address.

Calculated during the data load process.

The calculated value represents the employee's preferred email address. The system first checks the Personal Email field on the Employment tab of the Employee Information page. If populated, that value is used. If the Personal Email field is blank, the system retrieves the value from the Email field on the Employment tab of the Employee Information page.

Demographic tab

The following table describes the fields on the Demographic tab on the Employee Information form of the MO OASIS Report - Enrollment page.

Field	Description	Load logic - Data source and Valid values
Last Name	The employee's last name. This field is view-only.	Populated during the data load process. The field value is retrieved from the Last Name field on the Employee Information page.
First Name	The employee’s first name. This field is view-only.	Populated during the data load process. The field value is retrieved from the First Name field on the Employee Information page.
Middle Name	The employee's middle name. This field is view-only.	Populated during the data load process. The field value is retrieved from the Middle Name field on the Employee Information page.
Suffix	The employee’s name suffix.	Populated during the data load process. The field value is retrieved from the Suffix field on the Employee Information page. Values of "JR" are automatically converted to "Jr." and values of "SR" are automatically converted to "Sr." during the load process. This field value overrides the Suffix field value on the Employee Information page. The values in the drop-down list are retrieved from the Suffix Table page.
Address 1	The first line of the employee's address.	Populated during the data load process. The field value is retrieved from the Address field on the Employment tab of the Employee Information page. This field value overrides the Address field value on the Employment tab of the Employee Information page.
Address 2	The second line of the employee's address.	Populated during the data load process. The field value is retrieved from the Address field on the Employment tab of the Employee Information page. This field value overrides the Address field value on the Employment tab of the Employee Information page.
Suite	The suite or apartment number of the employee's mailing address, if applicable.	Calculated during the data load process. The calculated value defaults to blank during the data load process. You can manually enter a suite or apartment number if needed.
City	The employee's city of residence.	Populated during the data load process. The field value is retrieved from the City field on the Employment tab of the Employee Information page. This field value overrides the City field value on the Employment tab of the Employee Information page.
State	The employee's state of residence.	Populated during the data load process. The field value is retrieved from the State field on the Employment tab of the Employee Information page. This field value overrides the State field value on the Employment tab of the Employee Information page.
Zip Code	The employee's zip code.	Populated during the data load process. The field value is retrieved from the Zip Code field on the Employment tab of the Employee Information page. If the zip code contains exactly six characters with a trailing hyphen (e.g., "12345-"), the system automatically trims it to five characters. This field value overrides the Zip Code field value on the Employment tab of the Employee Information page.

Field

Description

Load logic - Data source and Valid values

Last Name

The employee's last name.

This field is view-only.

Populated during the data load process.

The field value is retrieved from the Last Name field on the Employee Information page.

First Name

The employee’s first name.

This field is view-only.

Populated during the data load process.

The field value is retrieved from the First Name field on the Employee Information page.

Middle Name

The employee's middle name.

This field is view-only.

Populated during the data load process.

The field value is retrieved from the Middle Name field on the Employee Information page.

Suffix

The employee’s name suffix.

Populated during the data load process.

The field value is retrieved from the Suffix field on the Employee Information page. Values of "JR" are automatically converted to "Jr." and values of "SR" are automatically converted to "Sr." during the load process.

This field value overrides the Suffix field value on the Employee Information page.

The values in the drop-down list are retrieved from the Suffix Table page.

Address 1

The first line of the employee's address.

Populated during the data load process.

The field value is retrieved from the Address field on the Employment tab of the Employee Information page.

This field value overrides the Address field value on the Employment tab of the Employee Information page.

Address 2

The second line of the employee's address.

Populated during the data load process.

The field value is retrieved from the Address field on the Employment tab of the Employee Information page.

This field value overrides the Address field value on the Employment tab of the Employee Information page.

Suite

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

Calculated during the data load process.

The calculated value defaults to blank during the data load process. You can manually enter a suite or apartment number if needed.

City

The employee's city of residence.

Populated during the data load process.

The field value is retrieved from the City field on the Employment tab of the Employee Information page.

This field value overrides the City field value on the Employment tab of the Employee Information page.

State

The employee's state of residence.

Populated during the data load process.

The field value is retrieved from the State field on the Employment tab of the Employee Information page.

This field value overrides the State field value on the Employment tab of the Employee Information page.

Zip Code

The employee's zip code.

Populated during the data load process.

The field value is retrieved from the Zip Code field on the Employment tab of the Employee Information page. If the zip code contains exactly six characters with a trailing hyphen (e.g., "12345-"), the system automatically trims it to five characters.

This field value overrides the Zip Code field value on the Employment tab of the Employee Information page.

Payroll tab

The following table describes the fields on the Payroll tab on the Employee Information form of the MO OASIS Report - Enrollment page.

Field	Description	Load logic - Data source and Valid values
Pay Frequency	The frequency at which the employee is paid.	Valid values: W - Weekly B - Bi-weekly S - Semi-monthly M - Monthly O - Other Populated during the data load process. The field value is retrieved from the Pay Frequency field on the Payroll tab of the Employee Information page.
Hire Date	The employee's date of hire.	Populated during the data load process. The field value is retrieved from the Hire Date field on the Employment tab of the Employee Information page. This field value overrides the Hire Date field value on the Employment tab of the Employee Information page.
Position Code	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 Populated during the data load process. The field value is retrieved from the O Wage Pos Cd field on the Payroll Information - State Required page. The source field varies by wage type: For wage type X, the value is 000. For wage type R, the value is retrieved from the R Wage Pos Cd field on the Payroll Information - State Required page. For wage type T, the value is 030. For wage type O, the value is retrieved from the O Wage Pos Cd field on the Payroll Information - State Required page. For other wage types, the value is retrieved from the O Wage Pos Cd field on the Payroll Information - State Required page.
Term of Position	The number of months in the employee's work year.	Valid values: blank 09 10 11 12 Populated during the data load process. For wage types P, S, or C, the value is retrieved from the Months(PSRS) field on the Payroll Information - State Required page. For wage types N or W, the value is retrieved from the Mnths(PEERS) field on the Payroll Information - State Required page. For part-time employees, the value is retrieved from the Months(PT) field on the Payroll Information - State Required page. For wage types X, O, R, or T, this field is set to NULL.
Part Time	Indicates whether the employee is a part-time employee for PSRS/PEERS reporting purposes.	Calculated during the data load process. The calculated value represents the employee's part-time status. If the Part Time field on the Payroll Information - State Required page contains a value, that value is used. Otherwise, the system checks the Part Time Status field on the Personnel tab of the Employee Information page. If set to P, this option is selected. Otherwise, it is cleared. For wage types X, O, R, T, C, N, or W, this option is cleared.
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 Calculated during the data load process. The calculated value corresponds to the retirement wage type based on the deduction codes in the Check History. The system looks up the Retirement System field on the MO Retirement Deductions page for each retirement deduction code. If no retirement deduction is found, the system checks if the employee has a retirement date or an active retirement deduction. Retirees default to R, and non-members default to X.
Annual Base Salary	The employee's total annual base salary for PSRS/PEERS reporting purposes.	Calculated during the data load process. The calculated value represents the employee's full annual salary. If the Annual Salary field on the Payroll Information - State Required page contains a value, that value is used. Otherwise, the system calculates the annual salary from active pay rates using salary schedule tables, with different calculations based on pay method (Hourly, Daily, Per Check, Range/Step, or Salary). For wage types X (Non-Member) or O (Non-Member PSRS as Non-Certificated), the annual base salary is set to 0.00. FLSA overtime is typically not included in annual base salary calculations, as annual salary is derived from pay rate records, not check history.