SmartFusion Modules > Payroll > Deductions > Retirement File/Report > Louisiana 

Recent Changes:  
6.111 - Replaced Parochial Employees retirement system with the new file format for Municipal Employees retirement system (MERS). 
6.108 - Updated report to UX standards for MPERS; Added hazardous duty, supplemental retirement wages, overtime retirement wages and retirement agency number
6.107 - Updated export file format for MPERS

Introduction

This process allows for the reporting and exporting of retirement deduction information for Louisiana.

Selection Criteria

Include employer cost - If checked, the employer cost will display on the report
Employer name for export - Is visible only for 'Municipal Employees' Retirement System' file format. This has a maximum of 14 characters and defaults to the first 14 characters of the organization name. Select process - Create File (only creates the file), Print (only prints the report) or Print & Create File (default)
File format - Specify the retirement file format to create. This option is only available when choosing Print & Create File or Create File process. Available file formats are Municipal Employees' Retirement System and Municipal Police Employees' Retirement System.
Report sequence - Determines the order of the data
Output option - The options are Detail (displays the amounts for each individual employee) and Totals only
Include employees - Options are Retired, Non-Retired, and Both (default)
Include dates on report and file - When checked, the employee begin and end dates will be displayed
Enter period to report - Current period (default), Current Quarter, Fiscal Year, Month, Quarter 1, Quarter 2, Quarter 3, Quarter 4 or Year
Enter filename - the complete file path where the file will be exported
Deductions - This will filter the results based on the deductions selected

Export File Format for Municipal Employees' Retirement System

  • File name will be "MERS.rpt" unless designated in Payroll System File Page 4
  • Data pull is from stored procedure csi_RetirementReportByPayTypeLouisiana
  • Export file format is a Crystal report pr-RetirementExportMersLA.rpt

Detail

Field Length Start End Format SF Field
D 1 1 1 Hardcoded
Social Security Number 10 2 11 10 digits - zero fill 1st pos hr180.cssn
Employee Name 24 12 35 hr180.clastname, hr180.cfirstname hr180.cmi hr180.csuffix
Earnings Type 4 36 39 B-Base/C- Court Salary/ CS-Courts' Supplemental pr166.LouisianaEarningsType
MB- Marshals' Salary/ MF- Marshals' Fees/ MS- Marshals' Supplemental
Employee Salary 9 40 48 000000000 implied decimal pr161.yretwage split by pay type based on pr166.LouisianaEarningsType
Employee Contributions 9 49 57 000000000 implied decimal pr162.ydedamt split by pay type based on pr166.LouisianaEarningsType
Employer Contributions 9 58 66 000000000 implied decimal pr162.yempcost split by pay type based on pr166.LouisianaEarningsType
Employer Name 14 67 80 User entered ( will default to first 14 characters of organization name)

Total

Field Length Start End Format SF Field
T 1 1 1 Hardcoded
Blank Spaces 31 2 33 not used
Payroll Date 6 34 39 MMYYYY Month to report
Total Salary 9 40 48 000000000 implied decimal(sum of Employee Salary in detail record)
Total Employee Contributions 9 49 57 000000000 implied decimal(sum of Employee contributions in detail record)
Total Employer Contributions 9 58 66 000000000 implied decimal(sum of Employer contributions in detail record)
Employer Name 14 67 80 User entered(will default to first 14 characters of organization name)

NOTE: Employee contribution by earnings type is calculated as follows: Total employee contribution (pr162.ydedamt) per check * ( Total retirement wage per check per earnings type/ Total Retirement wage per check)

Employer contribution by earnings type is calculated as follows: Total employer cost (pr162.yempcost) per check * ( Total retirement wage per check per earnings type/ Total Retirement wage per check)

Export File Format for Municipal Police Employees' Retirement System

  • File name will be "PERS.rpt" unless designated in Payroll System File Page 4
  • Data pull is from stored procedure csi_RetirementReportLouisiana
  • Export file format is a Crystal report pr-RetirementExportMpersLA.rpt

Header

Field Length Start End Format SF Field
Employer Number 3 1 3 000 Retirement Agency Number in PR System Page 2
Reporting Month & Year 6 4 9 MMYYYY user entry
Total MPERS Salary 9 10 18 000000000 implied decimal SUM(pr161.yretwage)
Total State Supplemental Pay 9 19 27 000000000 implied decimal SUM(pr161.yretwage) for pr166.isSupplement
Total Overtime Pay 9 28 36 000000000 implied decimal SUM(pr161.yretwage) for pr166.lovertime
Total Employee Contributions 9 37 45 000000000 implied decimal SUM(pr162.ydedamt)
Total Employer Contributions 9 46 54 000000000 implied decimal SUM(pr162.yempcost)

Detail

Field Length Start End Format SF Field
National ID 9 1 9 hr180.cssn
Contribution Classification 1 10 10 H or N hr180.IsHazardousDuty
MPERS Salary 9 11 19 000000000 implied decimal pr161.yretwage
State Supplemental Pay 9 20 28 000000000 implied decimal pr161.yretwage for pr166.isSupplement
Overtime Pay 9 29 37 000000000 implied decimal pr161.yretwage for pr166.lovertime
Employee Contributions 9 38 46 000000000 implied decimal pr162.ydedamt
Employer Contributions 9 47 55 000000000 implied decimal pr162.yempcost

References

Louisiana Retirement File Export Prior to 1 Jul 2020