PowerSchool ERP Missouri

OASIS Report - File Layouts And Data Mapping - Gross Salary Only - Payroll Header (Record Type 003)

The following table shows the positions, position names, descriptions, and data sources or valid values for the Payroll Header record (Type 003) in the Gross Salary file.

Position

Position Name

Description

Data Source or Valid Values

1

Record Type

Identifies the record type.

The valid value is 003.

2

Payroll Count

Total number of payroll detail records to follow.

Calculated during the file generation process.

The system counts the total number of records in the MO OASIS staging table for the selected school year and report month. This count represents the number of Payroll Detail records (Type 333) that will follow in the file.