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