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, 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 detailed data reporting format, including precise instructions for formatting contribution and participant information across multiple data fields. Each data field is meticulously defined with specific character positions, lengths, and formatting requirements, such as using zero-filled amounts with implied decimal points and specific sign characters to denote positive or negative financial entries.
The document supports retirement program data reporting for multiple providers including Voya ORP, TIAA-CREF, Corebridge, Nationwide, Equitable, and Empower, with specific two-letter codes assigned to each. The reporting format captures detailed participant information including Social Security numbers, names, quarterly reporting dates, employee and employer contributions, accumulated contributions, and mandatory contribution details. Notably, the file format allows for precise financial tracking with strict formatting rules, enabling accurate reconciliation of retirement program contributions across different providers and participant categories.
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 .