{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.SmartFusion Modules > Payroll > Deductions > Retirement File/Report > South Carolina
Recent Changes:
6.192 - Added a check to see if the organization name is over 40 characters for customers in South Carolina. If the name is over 40 characters, it will cause the retirement report export to generate an error and not allow the export to complete.
Introduction
This process allows for the reporting and exporting of retirement deduction information for South Carolina.
The Organization Id Code must be populated for at least one deduction code with Deduction Type "R" and Retirement Type 1, 3 or 4.
Selection Criteria
Select process - Create File, Print or Print & Create File (default)
Report sequence - Class, Department, Location, Name (default) or SSN
Output option - Detail or Totals Only
Include employees - Retired, Non-Retired or Both (default)
Include in file - Department, Location (default) or none
Include dates on report and file
Include ORP (Optional Retirement Program)
Enter period to report - Only Current Quarter is allowed for SC
Enter filename - This option determines where the file is saved to and is enabled when create file is selected; A default path can be set in the payroll system file (Page 4)
Furlough Percentages (a furlough data table is created using csi_PRRetFurlough stored procedure)
- Employee cost
- Employer cost
- ORP (Optional Retirement Program)
- PORS (Police Officers Retirement System)
Export File
- A default path can be set in the payroll system file (Page 4)
- Data pull is from stored procedure CSI_RETIREMENTREPORT
- Export file format is a Crystal report pr162r12.rpt
https://www.peba.sc.gov/forms > Form 1221
Header
Field | Length | Start | End | Format | SF Field |
---|---|---|---|---|---|
Record type | 3 | 1 | 3 | HCO | n/a |
Agency Number | 5 | 4 | 8 | alpha | pr163.corgid (1st one) |
Organization Name | 40 | 9 | 48 | alpha | ConfigurationItem.Organization.Name |
Period Type | 1 | 49 | 49 | Q | n/a |
Period Beginning | 8 | 50 | 57 | yyyyMMdd | user entry |
Period Ending | 8 | 58 | 65 | yyyyMMdd | user entry |
???? | 1 | 66 | 66 | D | n/a |
Record Count | 6 | 67 | 72 | numeric | Count(hr180.cssn) |
Total Contributions | 11 | 73 | 83 | numeric | Sum(formula ydedamt1) |
Blank | 11 | 84 | 94 | ||
Current Date | 8 | 95 | 102 | yyyyMMdd | |
Blank | 18 | 103 | 120 |
Detail
Field | Length | Start | End | Format | SF Field |
---|---|---|---|---|---|
Record type | 3 | 1 | 3 | DCO | n/a |
Agency Number | 5 | 4 | 8 | alpha | pr163.corgid (1st one) |
Dept or Location | 5 | 9 | 13 | numeric | csi25.cdept or csi24.cloc |
SSN | 9 | 14 | 22 | hr180.cssn | |
Employee Name | 33 | 23 | 55 | hr180.clastname, hr180.cfirstname | |
hr180.cmi, hr180.csuffix | |||||
Hire Date Within | 8 | 56 | 63 | yyyyMMdd | Activity Date for Active in Personnel |
Ending Date Within | 8 | 64 | 71 | yyyyMMdd | Activity Date for Inactivated In Payroll |
???? | 1 | 72 | 72 | 1 | n/a |
Employee Status | 1 | 73 | 73 | R or blank | pr158.cempstatus |
Salary | 9 | 74 | 82 | 000000000 | pr161.ypostamt |
Employee Contribution | 9 | 83 | 91 | 000000000 | formula ydedamt1 |
Blank | 9 | 92 | 100 | ||
Contract Length | 2 | 101 | 102 | 00 | pr165.icontractlen |
Retirement Credit | 2 | 103 | 104 | 00 | calculation based on pr158.cempstatus |
03 for all 3 months; else 01 or 02 | |||||
Blank | 16 | 105 | 120 |