{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.SmartFusion Modules > Payroll > Deductions > Retirement File/Report > Mississippi
Recent Changes:
6.111 - Initial creationSelection Criteria
Include employer cost
Include summary page
Select process - Create File, Print & Create File (default), Print Only
Create file path
Output option - Detail (default), Totals Only
Enter period to report - Current period (default), Current Quarter, Fiscal Year, Month, Quarter 1, Quarter 2, Quarter 3, Quarter 4 or Year
Export File Format
| Field | Length | Start | End | Format | SF Field |
|---|---|---|---|---|---|
| Agency Number | 7 | 1 | 7 | pr163.corgid | |
| blank | 1 | 8 | 8 | ||
| SSN | 9 | 9 | 17 | hr180.cssn | |
| Last Name | 20 | 18 | 37 | hr180.clastname | |
| First Name | 15 | 38 | 52 | hr180.cfirstname | |
| Middle Name | 1 | 53 | 53 | hr180.cmi | |
| Suffix | 3 | 54 | 56 | hr180.csuffix | |
| WageCode | 2 | 57 | 58 | pr166.cmswage | |
| PostAmount | 8 | 59 | 66 | SUM(Pr161.reportwage) | |
| for wage codes 15, 16, 17 | |||||
| else SUM(Pr161.ypostamt) | |||||
| MonthYear | 6 | 67 | 72 | MMYYYY | user selection |
| DeductionAmount | 8 | 73 | 80 | SUM(pr162.ydedamt) | |
| for pr163.cretiretype IN ('1', '3', '4') | |||||
| EmployerCost | 8 | 81 | 88 | SUM(pr162.yempcost) | |
| for pr163.cretiretype IN ('1', '3', '4') | |||||
| Credit Flag | 2 | 89 | 90 | 01 for > 80 hrs; else 00 | |
| EmployeeStatus | 2 | 91 | 92 | hr180.cempstatus | |
| StatusDate | 8 | 93 | 100 | mmddyyyy | HR180Activity.ActivityDate |
| Job Class Identifier | 5 | 101 | 105 | csi26.crsdclass | |
| SalaryAmount | 8 | 106 | 113 | SUM(pr161.ypostamt) | |
| for wage codes 15, 16, 17 | |||||
| else 0 | |||||
| SalaryCode | 2 | 114 | 115 | 00 for zero Salary Amount else 01 | |
| Gender | 1 | 116 | 116 | hr180.csex | |
| Date of Birth | 8 | 117 | 124 | mmddyyyy | hr180.dob |
| Address Line1 | 30 | 125 | 154 | hr180.caddress1 | |
| Address Line2 | 30 | 155 | 184 | hr180.caddress2 | |
| Address 3 and 4 | 60 | 185 | 244 | blank | |
| City | 28 | 245 | 272 | hr180.ccity | |
| State | 4 | 273 | 276 | hr180.cstate | |
| Zip Code | 5 | 277 | 281 | hr180.czip |