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.
|
| 2 | Generate for the selected Pay Period Number(s) |
|
| 3 | Generate for the selected Pay Period Number(s) and Pay Type(s) |
|
| 4 | Include Prior Period Adjustments |
|
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.
The following options are available but not currently supported.
|
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
Header
| 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.
|
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.
|
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 |
|
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.
|
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 |
