PATH: Human Resources > Reports > OTRS Reporting > Monthly Contribution

The OTRS Monthly Contribution Report extracts contribution and compensation data for all district employees who are participating OTRS members.

This report is only valid for districts that pay the entire employee portion; i.e., the Retirement Calculation Method is Employer Pays All of the Employee Portion.

OTRS Contribution Report Editor - Monthly Contributions

Monthly Contribution Report Logic

PATH: Human Resources > Reports > OTRS Reporting > Monthly Contribution

Only one record per reportable employee is allowed unless a prior period adjustment is being reported with a different Pay Period Month or Pay Period Year.
If an employee does not have retirement eligible wages/contributions for the month they are not reported.

Report Validations (2019/2020 Rates)

Member Before Tax plus Service Credit = 7% of Compensation amount
- Per OTRS a rounding difference of 10 to 15 cents is acceptable
Employer Contribution = 9.5% of Compensation amount (16.5% for retirees)
- Per OTRS a rounding difference of 10 to 15 cents is acceptable
Federal Match = 7.7% of Federal Compensation
- Per OTRS a rounding difference of up to $1.00 is acceptable

Report Options

PATH: Human Resources > Reports > OTRS Reporting > Monthly Contribution

Report options allow you to report on any combination of pay run data.

#	Option	Description
1	Pay Period Number(s)	Select the Pay Periods to include in the report. Beginning Pay Period Ending Pay Period
2	Generate for the selected Pay Period Number(s)	All Pay Types - When this option is selected, all Pay Types are included in the report. Specific Pay Types - When this option is selected, the Pay Type(s) dropdown list is enabled and allows you to select specific Pay Types.
3	Generate for the selected Pay Period Number(s) and Pay Type(s)	All Run Designators - When this option is selected, all Run Designators are included in the report. Specific Run Designators - When this option is selected, the Run Designator(s) dropdown list is enabled and allows you to select specific Run Designators.
4	Include Prior Period Adjustments	Yes No

Report Rules

PATH: Human Resources > Reports > OTRS Reporting > Monthly Contribution

Campus saves what you select so that you do not need to make new selections every time you generate the report.

Retirement Calculation Method

Field	Options
Retirement Calculation Method	The method by which retirement is calculated. Employer Pays All of Employee Portion The following options are available but not currently supported. Employer Pays Part of Employee Portion Employer Does Not Pay Employee Portion

Field

Options

Retirement Calculation Method

The method by which retirement is calculated.

Employer Pays All of Employee Portion

The following options are available but not currently supported.

Employer Pays Part of Employee Portion
Employer Does Not Pay Employee Portion

Contribution Fields

#	Field	Options
1	Select Member After Tax Benefit Code(s)	This dropdown list displays After Tax Benefit Codes.
2	Member Before Tax	2a. Select Contribution Benefit Code(s) 2b. Select Contributions on Fringe Benefit Code(s)
3	Select State Credit Benefit Code(s)	This dropdown list displays State Credit Benefit Codes.
4	Employer Contribution	4a. Select Non-Retiree Contribution Benefit Code(s) 4b. Select Non-Retiree Contributions on Fringe Benefit Code(s) 4c. Select Retiree Contribution Benefit Code(s) 4d. Select Retiree Contributions on Fringe Benefit Code(s)
5	Federal Match	5a. Select Contract Pay Benefit Code(s) 5b. Select Contributions on Fringe Benefit Code(s) 5c. Select Hourly Pay Benefit Code(s)

Compensation Factors

Regular Compensation amounts are derived from summing the Detailed Deduction Applies To amounts for each applicable Benefit Code chosen in 4) Employer Contribution in the Contribution Fields section.
Federal Compensation amounts are derived from summing the Detailed Deduction Applies To amounts for each applicable Benefit Code chosen in 5) Federal Match in the Contribution Fields section.
The Compensation Factors area allows you to identify any other amounts you want to add for reporting.

#	Field	Option
1	Select Employee Contribution Paid By Employer Benefit Code(s)	Benefit codes limited to OTRS codes
2	Select Non-Retiree Fringe Benefit Code(s)	Benefit codes excluding OTRS codes
3	Select Retiree Fringe Benefit Code(s)	Benefit codes excluding OTRS codes

Report Layout

Column	Description	Type, Format, and Length	Campus Location
County Code	The first 2 digits of the State District Number.	Numeric, 2 digits	Human Resources > Administration > District Master > State District Number
District Code	The last 4 characters of the State District Number.	Alphanumeric, 4 characters	Human Resources > Administration > District Master > State District Number
Vendor	Always reports as Infinite Campus.	N/A	N/A

Detail Record

Column	Description	Type, Format, and Length	Campus Location
Pay Period Year	The calendar year of the report data being submitted. The reported year should be the calendar year in which the work was completed. If multiple pay periods are selected on the editor and they span multiple calendar years, separate records report for each calendar year. Multiple calendar years may be included on the same report as long as they fall within the same employment year.	Numeric, 4 digits YYYY	Human Resources > Payroll > Process > Pay Cycle > Tables > Payroll Types > (Pay Type) > Payroll Dates > (Pay Period) > Payroll Date Years > Calendar Year (CAL)
Pay Period Month	The calendar month of the report data being submitted. The reported month should be the calendar month in which the work was completed. If multiple pay periods are selected on the editor and they span multiple months, separate records report for each month. Multiple calendar months may be included on the same report as long as they fall within the same employment year.	Numeric, 2 digits NN	Human Resources > Payroll > Process > Pay Cycle > Tables > Payroll Types >(Pay Type) > Payroll Dates > (Pay Period) > Details > Date End
Employment Year	The fiscal year of the report data being submitted. Multiple Employment Years cannot be reported on the same report.	Numeric, 4 digits YYYY	Human Resources > Payroll > Process > Pay Cycle > Tables > Payroll Types > (Pay Type) > Payroll Dates > (Pay Period) > Payroll Date Years > Fiscal Year (FSC)
Tax Number	The employee's tax number.	Alphanumeric, 9 characters	Human Resources > Personnel > Personnel Master > HR General Information > Social Security Number
Tax Number Type	S Social Security Number F Federal Taxpayer Identification Number If the value in Social Security Number begins with 9 and the fourth and fifth digits are in the following ranges, then F reports: 70-88, 90-92, 94-99	Alphanumeric, 1 character	Human Resources > Personnel > Personnel Master > HR General Information > Social Security Number
First Name	The employee's first name.	Alphanumeric, 100 characters	Human Resources > Personnel > Personnel Master > HR General Information > First Name
Middle Name	The employee's middle name.	Alphanumeric, 100 characters	Human Resources > Personnel > Personnel Master > HR General Information > Middle Name
Last Name	The employee's last name.	Alphanumeric, 100 characters	Human Resources > Personnel > Personnel Master > HR General Information > Last Name
Suffix	The generational assignment the employee uses as part of their name; e.g., Jr, III.	Alphanumeric, 10 characters	Human Resources > Personnel > Personnel Master > HR General Information > Suffix
Birth Date	The employee's date of birth.	Date YYYY-MM-DD	Human Resources > Personnel > Personnel Master > HR General Information > Birth Date
Gender	The employee's gender.	Alphanumeric, 1 character M or F	Human Resources > Personnel > Personnel Master > HR General Information > Gender
Address 1	The first line of the employee's address. The Payroll Residence checkbox must be marked on the address for any address fields to report.	Alphanumeric, 100 characters	Human Resources > Personnel > Personnel Master > HR General Information > Contact Information > Address 1
Address 2	The second line of the employee's address.	Alphanumeric, 100 characters	Human Resources > Personnel > Personnel Master > HR General Information > Contact Information > Address 2
City	The city on the employee's address.	Alphanumeric, 50 characters	Human Resources > Personnel > Personnel Master > HR General Information > Contact Information > City
State	The state on the employee's address.	Alphanumeric, 2 characters	Human Resources > Personnel > Personnel Master > HR General Information > Contact Information >State
Zip Code	The zip code on the employee's address.	Numeric, 10 digits	Human Resources > Personnel > Personnel Master > HR General Information > Contact Information > Zip Code
SDE Experience	Years of experience as reported by the State Department of Education. This field reports based on the Contribution Fields > 3. Select State Credit Benefit Codes selected on the extract editor. This field reports from the most current Benefit Code even if the benefit code was not processed within the selected pay period(s)/pay type(s)/run designator(s) combination. 0 reports If the employee's benefit records do not include a benefit code. Support staff report 0.	Numeric, 2 digits	Human Resources > Payroll > Employee > Manage Employees > (employee) > Benefits > Benefits > Benefit Level > Numeric Value
Compensation	The monthly portion of an employee's regular annual compensation as defined by statute. Compensation is calculated as follows: Eligible Wages + Fringe Benefits + Employer Retirement Amount Paid	Numeric, 12 digits NNNNNNNNNN.NN	Human Resources > Payroll > Employee > Manage Employees > (employee) > Payroll > Detailed Deductions > Details > Applies to Payroll > Manage > Employees > pick an employee > Payroll > Detailed Deductions > (pay date and benefit/deduction code) > Details
Federal Compensation	The monthly portion of an employee's federally funded compensation. Federal Compensation is calculated as follows: Eligible Wages + Fringe Benefits + Employer Retirement Amount Paid	Numeric, 12 digits NNNNNNNNNN.NN	Human Resources > Payroll > Employee > Manage Employees > (employee) > Payroll > Detailed Deductions > Details > Applies to Payroll > Manage > Employees > pick an employee > Payroll > Detailed Deductions > (pay date and benefit/deduction code) > Details
Member After Tax	The employee's additional voluntary after-tax contributions to retirement.	Numeric, 12 digits NNNNNNNNNN.NN	Payroll > Manage > Employees > (employee) > Payroll > Detailed Deductions > (pay date and benefit/deduction code) > Details
Member Before Tax	The employee's before-tax contributions to retirement. This amount could be employer or employee paid.	Numeric, 12 digits NNNNNNNNNN.NN	Payroll > Manage > Employees > (employee) > Payroll > Detailed Deductions > (pay date and benefit/deduction code) > Details
State Credit	The state credit paid to the employee.	Numeric, 12 digits NNNNNNNNNN.NN	Payroll > Manage > Employees > (employee) > Payroll > Detailed Deductions > (pay date and benefit/deduction code) > Details
Employer Contribution	The employer contributions to retirement.	Numeric, 12 digits NNNNNNNNNN.NN	Payroll > Manage > Employees > (employee) > Payroll > Detailed Deductions > (pay date and benefit/deduction code) > Details
Federal Match	The employer's fee based on Federal Compensation for the pay period.	Numeric, 12 digits NNNNNNNNNN.NN	Payroll > Manage > Employees > (employee) > Payroll > Detailed Deductions > (pay date and benefit/deduction code) > Details

Monthly Contribution (OTRS Reporting) (Oklahoma)