Attachment I - Quarterly Reconciliation Report File Format.pdf
PDF 117 KB Posted
- Attached to
- DMS-2425-199, (SUSORP and SMSOAP)
- Solicitation number
- ITN-12499
- Issued by
- Alachua County, Graceville City, Florida
About this file
This document is an Attachment I detailing the Quarterly Reconciliation Report File Format for the Florida Department of Management Services (DMS), Division of Retirement, specifically for the State University System Optional Retirement Program (SUSORP) and Senior Management Service Optional Annuity Program (SMSOAP). The file provides a comprehensive technical specification for a data file format used to report quarterly retirement contribution information, with precise instructions for recording participant details, including Social Security numbers, names, contribution amounts, and provider codes. The document specifies a detailed 133-character record format with specific field lengths and positions for capturing employee and employer contribution data, including sign characters and zero-filled monetary amounts with implied decimal points.
The file format supports multiple retirement providers, including Voya ORP, TIAA-CREF, Corebridge, Nationwide, Equitable, and Empower, with specific two-letter provider codes. Each record captures multiple contribution types: participant employee contributions, employer contributions, mandatory employee contributions, and their respective accumulated amounts. The format uses a zero-fill method for monetary amounts and includes sign characters to denote positive or negative values, allowing for precise financial tracking across different retirement programs. While this document is a technical specification for data reporting, it is part of a broader procurement process for comprehensive retirement program services involving approximately 18,000 SUSORP members and 95 SMSOAP members across Florida's state universities.
View the file
Other files
Show 40 more
50 files listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
DMS-24/25-199
SUSORP/SMSOAP Page 1 of 3
ATTACHMENT I – QUARTERLY RECONCILIATION REPORT FILE FORMAT
Header Record
Data Field Length Definition
No Header Record
Detail Record
Data Field Example Data/Notes Field Length
Position Definition
SSN 023456789
No spaces or hyphens
9 1-9
Participant Social Security number
Participant Name Smith, John 35 10-44 Participant Name (Last, Suffix, First, MI)
Quarter Date 20240101 8 45-52 Reporting date for this file (Format:
CCYYMMDD)
Provider Code OF 2 53-54 Assigned by Division of Retirement:
OA = Brighthouse ORP(Inactive)
OB = TIAA-CREF ORP
OC = Corebridge ORP OD = Nationwide ORP (Inactive) OF = Voya ORP OG = Equitable ORP PA = Empower OAP (Inactive) PB = Voya OAP PC = Corebridge OAP PD = Equitable OAP (2 spaces) = TIAA-CREF OAP
Provider Name Voya ORP 25 55-79 Provider Company Name
Participant Employee Contribution (Sign character)
Space or + or – or 0 1 80 Sign character (space, +, or 0 for positive amounts, - for negative amounts)
Participant Employee
Amount
Zero Fill 0001234
7 81-87 Participant Employee Contribution Amount Amount fields have an implied decimal point so $12.34 would be 0001234
Participant Employer
Space or + or - 1 88 Sign character (space or + for
Employee
0001234
7 89-95 Participant Employer Contribution Amount Amount fields have an implied decimal point so $12.34 would be 0001234
Participant Accumulated Employee Contribution (Sign character)
Space or + or - 1 96 Sign character (space or + for
SUSORP/SMSOAP Page 2 of 3
Data Field Example Data/Notes Field Length
Position Definition
Accumulated Employee
000001234
9 97-105 Participant Accumulated Employee Contribution Amount Amount fields have an implied decimal point so $12.34 would be 000001234
Participant Accumulated Employer
Space or + or - 1 106 Sign character (space or + for
Employer
9 107-115 Participant Accumulated Employer Contribution Amount Amount fields have an implied decimal point so $12.34 would be 000001234
Participant Mandatory Employee
Space or + or - 1 116 Sign character (“space” or “+” for positive amounts, “-“ for negative
Mandatory Employee
7 117-123 Participant Mandatory Employee Contribution Amount Amount fields have an implied decimal point so $12.34 would be 0001234
Participant Accumulated Mandatory Employee
Space or + or - 1 124 Sign character (“space” or “+” for positive amounts, “-“ for negative
Mandatory Employee
9 125-133 Participant Accumulated Employee Contribution Amount Amount fields have an implied decimal point so $12.34 would be 000001234
Trailer Record
Data Field Logical Length
Definition
No Trailer Record
SUSORP/SMSOAP Page 3 of 3
REMAINDER OF PAGE INTENTIONALLY LEFT BLANK
| ATTACHMENT I – QUARTERLY RECONCILIATION REPORT FILE FORMAT |
| Header Record |
| Trailer Record |
File details come from the government source that posted it. Updated .