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 Attachment I - Quarterly Reconciliation Report File Format for the Florida Department of Management Services (DMS), Division of Retirement, related to the State University System Optional Retirement Program (SUSORP) and Senior Management Service Optional Annuity Program (SMSOAP). The attachment specifies a detailed file format for quarterly reconciliation reports, outlining precise data field requirements for reporting participant retirement contributions. The document provides comprehensive instructions for formatting data fields including Social Security numbers, participant names, quarter dates, provider codes, contribution amounts, and sign characters, with specific length and position guidelines for each data element.
The file format supports tracking contributions from multiple retirement providers including Voya, TIAA-CREF, Corebridge, Nationwide, Equitable, and Empower across Optional Retirement Program (ORP) and Optional Annuity Program (OAP) platforms. Each record includes fields for participant employee and employer contributions, accumulated contributions, and mandatory contributions, with an implied decimal point system for monetary amounts. The document uses zero-fill formatting and specific sign characters to denote positive or negative contribution amounts, enabling precise financial reconciliation for approximately 18,000 SUSORP members and 95 SMSOAP members across twelve 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 .