OASIS Report - File Layout And Data Mapping - Employer Reporting - Payroll Details (Record Type 333)

The following table shows the positions, position names, descriptions, and data sources or valid values for the Payroll Details record (Type 333) in the Employer Reporting file.

Position	Position Name	Description	Data Source or Valid Values
1	Record Type	Identifies the record type.	The valid value is 333.
2	SSN	The employee's Social Security number.	Retrieved from the Social Security Number field on the Demographic Detail tab of the MO OASIS Report page.
3	Last Name	The employee's last name.	Retrieved from the Last Name field on the Demographic Detail tab of the MO OASIS Report page.
4	First Name	The employee’s first name.	Retrieved from the First Name field on the Demographic Detail tab of the MO OASIS Report page.
5	Middle Name	The employee's middle name.	Retrieved from the Middle Name field on the Demographic Detail tab of the MO OASIS Report page.
6	Name Suffix	The employee’s name suffix.	Retrieved from the Suffix field on the Demographic Detail tab of the MO OASIS Report page.
7	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 Detail tab of the MO OASIS Report page.
8	Gross Salary	The total gross earnings for the pay period.	Retrieved from the Gross Salary field on the Payroll Detail tab of the MO OASIS Report page.
9	Retirement Salary	The salary amount subject to PSRS/PEERS retirement contributions for the pay period.	Retrieved from the Retirement Salary field on the Payroll Detail tab of the MO OASIS Report page.
10	Employer Contribution	The employer's retirement contribution amount for the pay period.	Retrieved from the Employer Contribution field on the Payroll Detail tab of the MO OASIS Report page.
11	Employee Contribution	The employee's retirement contribution amount withheld for the pay period.	Retrieved from the Employee Contribution field on the Payroll Detail tab of the MO OASIS Report page.
12	Insurance Amount	The life insurance premium amount for the pay period.	Retrieved from the Insurance Amount field on the Payroll Detail tab of the MO OASIS Report page.
13	Annual Salary	The employee's total annual base salary for PSRS/PEERS reporting purposes.	Retrieved from the Annual Base Salary field on the Payroll Detail tab of the MO OASIS Report page.
14	Pay Period Start	The pay period beginning date for the retirement record.	Retrieved from the Pay Start Date field on the Payroll Detail tab of the MO OASIS Report page.
15	Pay Period End	The pay period ending date for the retirement record.	Retrieved from the Pay End Date field on the Payroll Detail tab of the MO OASIS Report page.
16	Position	The employee's job position classification for PSRS/PEERS reporting.	Retrieved from the Position Code field on the Payroll Detail tab of the MO OASIS Report page.
17	Pay Type	The pay frequency that specifies how often the employee is paid.	Valid values: W = Weekly B = Bi-weekly S = Semi-monthly M = Monthly O = Other Retrieved from the Pay Frequency field on the Payroll Detail tab of the MO OASIS Report page.
18	Employment Status	The employee's current employment status for PSRS/PEERS reporting purposes.	Retrieved from the Employment Status field on the Payroll Detail tab of the MO OASIS Report page.
19	Employment Status Date	The effective date of the employee's current employment status (e.g., termination date, leave start date).	Retrieved from the Status Date field on the Payroll Detail tab of the MO OASIS Report page.
20	Hours	The total hours the employee worked during the pay period.	Retrieved from the Hours Worked field on the Payroll Detail tab of the MO OASIS Report page.
21	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 Detail tab of the MO OASIS Report page. Left blank for wage types X, O, T, or R.
22	Career Ladder	Indicates whether the employee's earnings include career ladder compensation for teachers participating in Missouri's career ladder program.	Valid values: Y N Retrieved from the Career Ladder field on the Payroll Detail tab of the MO OASIS Report page.
23	Final Pay	Indicates whether this is the employee's final paycheck.	Valid values: Y N Retrieved from the Final Pay Employee field on the Payroll Detail tab of the MO OASIS Report page.
24	Part Time	Indicates whether the employee is a part-time employee for PSRS/PEERS reporting purposes.	Valid values: Y N Retrieved from the Part Time field on the Payroll Detail tab of the MO OASIS Report page.