PowerSchool ERP Missouri

OASIS Report - Create File

Use the MO OASIS Report - Report page to generate retirement reports and interface files for submission to Missouri OASIS (Online Automated Submission and Information System). This page allows users to select the report type, format, and criteria for producing OASIS retirement reports or creating electronic interface files for upload to the Missouri retirement systems.

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

  2. Select the School Year, Report Month, and Report Period.

  3. Create a hard copy of the report to verify data before you create the electronic file:

    1. Select Hard Copy.

    2. Select PDF or Excel.

    3. Select Create, and then Yes.

  4. Save the file and select OK.

  5. Navigate to the folder containing the report file.

  6. Inspect the file. Refer to Maintain data and update it if necessary.

  7. Repeat these steps until all the required data is included.

  8. Create the interface file:

    1. Select Interface File.

    2. Select the Report Format:

      • Employer Reporting: The standard interface file format that includes all retirement data elements for submission to MOSERS. This is the default selection and is used for regular monthly retirement reporting.

      • Annual Base Salary Only: A specialized interface file format used for reporting annual base salary updates only. This format is used when districts need to submit salary-only updates to the retirement system, such as for enrollment records or salary corrections, without affecting previously reported wage and contribution data.

      • Gross Salary Only: A specialized interface file format used for reporting gross salary data only. This format is used when districts need to submit wage-only updates to the retirement system, typically for reporting additional compensation or wage corrections without affecting the employee's annual base salary on file.

    3. Select Create, and then Yes.

    4. Save the file and select OK.

The default file names are:

  • Employer Reporting: EmployeReporting_<Report Month>_<ending School Year>.csv

  • Annual Base Salary Only: EmployeReportingAnnBas_<Report Month>_<ending School Year>.csv

  • Gross Salary Only: EmployeReportingGrossBas_<Report Month>_<ending School Year>.csv

For detailed information about the report’s file layout, refer to OASIS Report - File Layouts And Data Mapping.

Follow the state's submission procedures.