PowerSchool ERP Missouri

OASIS Report - Load Data

Use the MO OASIS Report - Load page to load retirement information from payroll data into the Missouri OASIS (Online Automated Submission and Information System) reporting tables. This page allows users to specify the criteria for extracting payroll check data and populating OASIS retirement records for a specific school year and reporting month.

  1. On the MO OASIS Report page, select Load.

  2. Refer to the Field descriptions and enter or select the required load criteria.

  3. Select Load, and then Yes.

  4. If data for the selected criteria is loaded, select Yes to delete and reload the data.

  5. Save the Load Summary report file and select OK.

  6. If errors are encountered, save the Load Error log and select OK.

  7. Navigate to the file location.

  8. Inspect the files. Refer to Maintain data and update the data as necessary.

  9. Repeat these steps until no errors are encountered and all required data is loaded.

Field descriptions

The following table describes the fields on the MO OASIS Report - Load page.

Field

Description

School Year

The fiscal school year (e.g., 2023-2024) for which OASIS retirement data will be extracted. The current school year is the default.

Report Month

The month within the school year for which retirement data will be extracted. The month selection automatically updates the date range for check issue dates. An extra month (13) option is available for year-end processing.

Valid values:

  • 01

  • 02

  • 03

  • 04

  • 05

  • 06

  • 07

  • 08

  • 09

  • 10

  • 11

  • 12

  • 13

Report Period

The pay period within the selected month for which retirement data will be extracted.

Valid values:

  • Period 1

  • Period 2

  • Period 3

Check Issue Start Date

The beginning date range of the payroll check issue for which retirement data will be extracted.

Check Issue End Date

The ending date range of the payroll check issue for which retirement data will be extracted.

District Final Pay

Indicates that the current load represents the district's final payroll for the school year. When this option is selected, the system marks the extracted records as final pay records for PSRS/PEERS year-end processing.

Load Annual Salaries

Indicates whether annual salary information should be included in the OASIS data extraction. When this option is selected, the system retrieves and loads annual salary data from employee pay rate records.

Pay Runs to Exclude

The specific pay runs within the selected date range that should be excluded from the OASIS data extraction. The available pay runs are automatically updated based on the check issue date range entered.