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 a detailed technical specification for a Quarterly Reconciliation Report File Format, used by the Division of Retirement for tracking participant retirement contributions across multiple providers. The file format is designed to capture comprehensive contribution data for participants in various retirement plans, including Optional Retirement Plans (ORP) and Optional Accumulation Plans (OAP) from providers such as Voya, TIAA-CREF, Corebridge, Nationwide, Equitable, and Empower. Each record includes specific data fields with precise positioning and formatting requirements, including Social Security numbers, participant names, quarter dates, provider codes, and detailed contribution information for employee, employer, and mandatory contributions.
The file format uses a fixed-width structure with implied decimal points for monetary amounts, allowing for precise tracking of participant contribution data. Each record can capture both current quarter contributions and accumulated contribution amounts, with sign characters to indicate positive or negative values. The document specifies 2-character provider codes, 25-character provider names, and allows for tracking of various contribution types including employee, employer, and mandatory contributions. The technical specification ensures consistent data representation across different retirement plan providers, facilitating accurate financial reporting and reconciliation for the state's retirement system.
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 .