PATH: Human Resources > Reports > PERA Extracts > PERA Contribution Report

The PERA Contribution Report collects data for the Public Employees Retirement Association of Minnesota.

PERA Contribution Extract Editor

Report Logic

A Header record generates for each Pay Period Number where at least one Deduction History record with a Pay Period Number has a Benefit Type of PERA on the Pay Period End Date entered.
A Summary record generates for each individual Retirement Information plan type where the employee has a PERA Deduction History record for the Pay Period in the header.
A Detail record generates for each Deduction History record where the Pay Period Paid is on the Pay Period End Date entered, the Benefit Type is PERA and the Plan Type matches the summary record plan type. Each detail record will report under the header and summary records with the corresponding Pay Period Number.
When the Allocated Pay Period is the same on multiple record for a single employee, the report combines the records and reports the sum of the amounts in the Member Amount (field 14) and PERA Eligible Earning (field16) fields.
All dollar amounts report with an implied decimal. For example, $345.67 will report as 34567.

Generating the Extract

Select PERA Contribution as the Extract Type.
Enter a Pay Period End Date in mmddyyyy format or by clicking the calendar icon and selecting a date.

Data will be reported for the paid date of the payroll.
Enter a Paid Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
Select the Overtime Paycodes to include in the report.
Select the Format in which the extract should generate. Use the State Format for submission to the state and CSV or HTML for data review and verification.
Click Generate Extract to view the report in the selected format.

Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. The generated extract is available in the Process Inbox. For more information about submitting a report to the batch queue, see the Batch Queue article.

PERA Contribution Extract - State Format (Fixed Width)

PERA Contribution Extract - CSV Format

PERA Contribution Extract - HTML Format

Header Layout

Element Name	Description	Type, Format, Length	Campus Database	Campus Location
Transaction Code	The transaction code for the plan summary record. Reports as 30.	Numeric, 2 digits	Not dynamically stored	Not dynamically stored
Employer Number	Reports the Employer Retirement Number when the Organization = PERA.	Numeric, 6 digits	HrDistirctRetirementInfo. employerRetirementNumber	Human Resources > Administration > District Master > Employer Retirement Number
Paid Date	The date the member's payroll was paid. Reports from the Paid Date selected on the extract editor.	Date field, 8 digits YYYYMMDD	N/A	N/A
Increase/Decrease	Indicates if the Contribution total is a positive or negative amount.	Alphanumeric + or -	Stored in the Campus Payroll database.	Human Resources > Payroll > Employee > Detailed Deductions > Deduction Amount, Cost Amounts
Contribution Total	The absolute value of all contributions being reported.	Numeric, 14 digits	Stored in the Campus Payroll database.	Human Resources > Payroll > Employee > Detailed Deductions > Deduct Amount, Cost Amounts
Number of Plan Summary Records	The number of plan summary records associated with the SDR records.	Numeric, 6 digits	Stored in the Campus Payroll database.	Calculated, not dynamically stored
Filler	N/A	N/A	N/A	N/A

Summary Layout

Element Name	Description	Type, Format and Length	Campus Database	Campus Location
Transaction Code	The transaction code for the plan summary record. Reports as 31.	Numeric, 2 digits	Not dynamically stored	Not dynamically stored
Employer Number	Reports the Employer Retirement Number when the Organization = PERA.	Numeric, 6 digits	HrDistirctRetirementInfo. employerRetirementNumber	Human Resources > Administration > District Master > Employer Retirement Number
Plan ID	The unique identifier for the plan. Reports the plan type reported for this Plan Summary record.	Numeric, 2 digits	HrRetirement. accountNumber	Human Resources > Personnel > Personnel Master > HR General Information > Retirement Information > PERA
Increase/Decrease	Indicates if the plan total is a positive or negative amount.	Alphanumeric + or -	Stored in the Campus Payroll database.	Human Resources > Payroll > Employee > Detailed Deductions > Deduct Amount, Cost Amounts
Plan Total	The sum of all Member Total, Employer Total, and Additional Total values being reported.	Numeric, 12 digits	Stored in the Campus Payroll database.	Human Resources > Payroll > Employee > Detailed Deductions > Deduct Amount, Cost Amounts
Increase/Decrease	Indicates if the member total is a positive or negative amount.	Alphanumeric + or -	Stored in the Campus Payroll database.	Human Resources > Payroll > Employee > Detailed Deductions > Deduct Amount
Member Total	The sum of all Member Amount values being reported.	Numeric, 12 digits	Stored in the Campus Payroll database.	Human Resources > Payroll > Employee > Detailed Deductions > Deduct Amount
Increase/Decrease	Indicates whether the employer total is a positive or negative amount.	Alphanumeric + or -	Stored in the Campus Payroll database.	Calculated, not dynamically stored
Employer Total	The sum of all employer contribution values from the Employer Amount calculation MINUS the Additional Total.	Numeric, 12 digits	Stored in the Campus Payroll database.	Calculated, not dynamically stored
Increase/Decrease	Indicates whether the additional total is a positive or negative amount.	Alphanumeric + or -	Stored in the Campus Payroll database.	Calculated, not dynamically stored
Additional Total	The sum of all PERA eligible earnings.	Numeric, 12 digits	Stored in the Campus Payroll database.	Calculated, not dynamically stored
Number of Detail Records	The total number of detail records associated with this summary record.	Numeric, 6 digits	Stored in the Campus Payroll database.	Calculated, not dynamically stored
Filler	N/A	N/A	N/A	N/A

Detail Layout

#	Element Name	Description	Type, Format and Length	Campus Database	Campus Location
1	Transaction Code	The transaction code for the plan summary record. Reports as 38.	Numeric, 2 digits	Not dynamically stored	Not dynamically stored
2	Employer Number	Reports the Employer Retirement Number when the Organization = PERA.	Numeric, 6 digits	HrDistirctRetirementInfo. employerRetirementNumber	Human Resources > Administration > District Master > Employer Retirement Number
3	Plan ID	The unique identifier for the plan. Reports the plan type for the employee on the Date Pay Period Paid.	Numeric, 2 digits	HrRetirement. accountNumber	Human Resources > Personnel > Personnel Master > HR General Information > Retirement Information > PERA, Account Number
4	Social Security Number	The Social Security Number of the employee from the active personnel record of the individual being reported.	Numeric, 9 digits	Person.staffStateID	Human Resources > Personnel > Personnel Master > HR General Information > Social Security Number
5	Last Name	The last name from the active personnel record.	Alphanumeric, 30 characters	Identity.lastName	Human Resources > Personnel > Personnel Master > HR General Information > Last Name
6	First Name	The first name from the active personnel record.	Alphanumeric, 30 characters	Identity.firstName	Human Resources > Personnel > Personnel Master > HR General Information > First Name
7	Middle Initial	The middle initial from the active personnel record.	Alphanumeric, 1 character	Identity.middleName	Human Resources > Personnel > Personnel Master > HR General Information > Middle Name
8	Title After Name	Any suffix following the individual's name.	Alphanumeric, 4 characters	Identity.suffix	Human Resources > Personnel > Personnel Master > HR General Information > Suffix
9	Coverage Start Date	The beginning date of the reported pay period. The report finds the pay period to which the PERA deduction was allocated (Human Resources > Payroll > Employee > Employees > Payroll > Detailed Deductions > PERA > Allocated Pay Period) and reports the beginning date for that pay period.	Date field, 8 digits YYYYMMDD	Stored in the Campus Payroll database.	Human Resources > Payroll > Process > Pay Cycle > Tables > Payroll Types > Payroll Dates > Payroll Date Details > Date Start
10	Coverage End Date	The end date of the reported pay period. The report finds the pay period to which the PERA deduction was allocated (Human Resources > Payroll > Employee > Employees > Payroll > Detailed Deductions > PERA > Allocated Pay Period) and reports the end date for that pay period.	Date field, 8 digits YYYYMMDD	Stored in the Campus Payroll database.	Human Resources > Payroll > Process > Pay Cycle > Tables > Payroll Types > Payroll Dates > Details > Date End
11	Pay Type	The type of pay the contribution is based on. Reports the Pension Payment Type. Options are: 01: Regular service activity 02: Lump sum payments of unused, accrued compensatory time 04: Grievance pay 05: Lump sum payments that have retroactive earnings period 06: Omitted Deduction from earnings of a member	Numeric, 2 digits	Stored in the Campus Payroll database.	Stored in the Campus Payroll database.
12	Adjustment Indicator	Indicates that the transaction is an adjustment to a previously submitted transaction. Reports as A if the Pension Transaction Type is marked as an adjustment. Otherwise reports as O.	Alphanumeric, 1 character	Stored in the Campus Payroll database.	Stored in the Campus Payroll database.
13	Increase/Decrease	Indicates whether the Member Amount is a positive or negative amount.	Alphanumeric + or -	Stored in the Campus Payroll database.	Human Resources > Payroll > Employee > Detailed Deductions > PERA > Deduct Amount
14	Member Amount	Reports the Member Contribution amount equal to the PERA eligible earnings multiplied by the Plan Rate.	Numeric, 10 digits	Stored in the Campus Payroll database.	Humanr Resources > Payroll > Employee > Detailed Deductions > PERA > Deduct Amount
15	Increase/Decrease	Indicates whether the PERA Eligible Earnings is a positive or negative number.	Alphanumeric + or -	Stored in the Campus Payroll database.	Calculated, not dynamically stored.
16	PERA Eligible Earning	Reports the member's eligible earnings for the reported pay period.	Numeric, 10 digits	Stored in the Campus Payroll database.	Stored in the Campus Payroll database.
17	Increase/Decrease	Indicates whether the DCP Employer Amount is positive or negative.	Alphanumeric + or -	Stored in the Campus Payroll database.	Stored in the Campus Payroll database.
18	Employer Amount	Reports the sum of all Employer Cost fields for the employee AND plan type.	Numeric, 10 digits	Stored in the Campus Payroll database.	Stored in the Campus Payroll database.
19	School Fiscal Year	The school year during which the reported earnings were accrued. If the Pay Type is 01: Regular service activity AND the Coverage Start Date and Coverage End Date are in June, July or August, then the report finds the pay period to which the deduction was allocated and reports the fiscal year for that pay period. All other scenarios report blank.	Numeric, 4 digits	Stored in the Campus Payroll database.	Human Resources > Payroll > Process > Pay Cycle > Tables > Payroll Types > Payroll Dates > Details > Payroll Date Years > FSC
20	Reference	Reports additional transaction details. Currently reports as blank.	N/A	N/A	N/A
21	Increase/Decrease	Indicates whether the Compensated Hours is a positive or negative value. Currently reports as blank.	N/A	N/A	N/A
22	Compensated Hours	Reports the number of hours for which the employee receives compensation during the reported pay cycle. Currently reports as blank.	N/A	N/A	N/A
23	Increase/Decrease Overtime Pay	Indicates whether the compensated hours are a positive or negative amount.	Alphanumeric + or -	Stored in the Campus Payroll database.	Calculated, not dynamically stored.
24	Overtime Pay	The total amount of overtime pay for the employee. The sum of all pay tied to all pay codes entered into the Overtime Paycodes field on the extract editor reports.	Numeric, 10 digits	Stored in the Campus Payroll database.	Calculated, not dynamically stored.
25	Filler	N/A	N/A	N/A	N/A

PERA Contribution Report (Human Resources) (Minnesota)

Report Logic

Generating the Extract

Header Layout

Summary Layout

Detail Layout

Related Articles