PATH: Human Resources > Reports > ERS Extract
This extract reports all ERS Retirement Members within the district who are assigned to ERS as their Retirement Organization. Staff demographics and Payroll information necessary for monthly reporting are included on the report and formatted for upload when run in the state reporting format. Additional formats are provided for data verification.
ERS Extract Editor
Report Logic
- To report, the employee must be assigned to the ERS: Employee Retirement System in the Retirement Organization field on the General Information tab on the Personnel Master.
Days of Service Calculation
| If the employee... | Then Campus... | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| has a time sheet record with hours indicated. |
|
|||||||||||||||||||||||||
| does NOT have a time sheet record with hours indicated | checks the Pay Periods in the Date selection and if they have the End of Year Cycle selected, 0 reports. (Human Resources > Payroll > Process > Tables > Payroll Types > Payroll Dates > Details of the Pay Period) If the Work Months on the Position Code on the Employee Work Assignment is set to 10 or 12, the following calculations are used.
Next, the Days per Year (Human Resources > Personnel > Personnel Master > Work Assignment) are divided by the calculation in the previous table. This determines the number of service days per pay period. The value is multiplied by the number of pay periods within the dates selected on the extract editor. All Work Assignments are summed and report as long as they are not greater than the following maximums.
|
Report Editor
| Field | Description |
|---|---|
| Start Date | The first day of the reporting range. |
| End Date | The last day of the reporting range. |
| Pay Type | The Pay Type on which you want to report. Pay Types are set up in Human Resources > Payroll > Process > Pay Cycle > Tables > Payroll Types. |
| Report Code | The Report Code is a code assigned by the retirement system. You must enter a number greater than 009 and less than 100. |
| # of Fiscal YE Payout Periods | Campus uses the number you enter here to determine the employee's days of service if the employee does not have a time sheet record with hours indicated on it. |
| Format |
|
Report Layout
| Field | Logic | Format and Length | Campus Database | Campus Location |
|---|---|---|---|---|
|
Loc Code
|
Code Assigned by the retirement system. | Numeric, 5 digits | HRDistrictRetirementInfo. organization |
Human Resources > Administration > District Master > District Master > Employer Retirement Number (for ERS) |
|
Report Code
|
Code Assigned by the retirement system. Must be greater than 009 and less than 100 |
Numeric, 3 digits | N/A | Human Resources > Reports > ERS Extract > Report Code |
|
Reported Date
|
The End Date from the report parameters. | Date field, 10 characters |
N/A | Human Resources > Reports > ERS Extract > End Date |
|
Reg #
|
The employee's registration number. | Numeric, 8 digits | HRRetirement. accountNumber |
Human Resources > Personnel > Personnel Master > HR General Information > Retirement Account Number |
|
SSN
|
The employee's Social Security Number. | Numeric, 9 digits | Identity.ssn | Human Resources > Personnel > Personnel Master > HR General Information > Social Security Number |
|
CI
|
First Letter of the employee's Last Name. | Alphanumeric, 1 character | Identity.lastName | Human Resources > Personnel > Personnel Master > HR General Information > Last Name |
| Last Name | The employee's last name and suffix. |
Alphanumeric, 20 characters | Identity.lastName | Human Resources > Personnel > Personnel Master > HR General Information > Last Name and Suffix |
|
First Name
|
The employee's first name. | Alphanumeric, 20 characters | Identity.firstName | Human Resources > Personnel > Personnel Master > HR General Information > First Name |
|
Days of Service
|
The number of days the employee worked. See the Days of Service Calculation for more information. | Numeric, 10 digits | N/A | N/A |
|
Salary
|
The Gross Salary for the month in the date report parameters. | Numeric, 10 digits | PayrollPaymentHistory. |
Human Resources > Payroll > Employee |
|
Contribs
|
The total amount of the employee's contributions. | Numeric, 10 digits | N/A | Human Resources > Payroll > Benefits > Benefit Codes Human Resources > Employee > Benefits Human Resources > Payroll > Process > Pay Cycle > Processes > Pay to Net |
| Loan | The total amount of staff loan payments. | Numeric, 10 digits | N/A | Human Resources > Payroll > Benefits > Benefit Codes Human Resources > Employee > Benefits Human Resources > Payroll > Process > Pay Cycle > Processes > Pay to Net |
|
Arrears
|
The total amount of staff arrears payments. This is the SUM of deductions with a Benefit Code of ERMA and ERVA. | Numeric, 10 digits | N/A | Human Resources > Payroll > Benefits > Benefit Codes Human Resources > Employee > Benefits Human Resources > Payroll > Process > Pay Cycle > Processes > Pay to Net |
| Item # | A 5-character number that identifies an employee. Campus uses the last 5 characters of their Primary Location Code. | Numeric, 5 digits | HREmploymentAssignment. primaryLocation |
Human Resources > Personnel > Personnel Master > HR General Information > Primary Location |
