Attachment D - Weekly Distribution Report File Format.pdf
PDF 119 KB Posted
- Attached to
- DMS-2425-199, (SUSORP and SMSOAP)
- Solicitation number
- ITN-12499
- Issued by
- Alachua County, Graceville City, Florida
About this file
The document is an Attachment D detailing the Weekly Distribution Report File Format for the Florida Department of Management Services' State University System Optional Retirement Program (SUSORP) and Senior Management Service Optional Annuity Program (SMSOAP). The file specifies a precise 295-character data reporting structure for tracking retirement plan distributions, including detailed fields for report month, provider name, participant information, distribution type, date, amount, reason, and payee. The format supports tracking distributions across multiple vendors including TIAA, Voya, Corebridge Financial, Equitable, and others, with specific codes for distribution types ranging from loan and rollover to hardship withdrawal and required minimum distributions.
The reporting format allows granular tracking of participant-level financial transactions, with each record containing specific positional data for social security number, name, account numbers, distribution amounts, and transaction reasons. The document provides comprehensive guidance for vendors to standardize reporting, including sign characters for amounts, specific two-character codes for distribution reasons (such as medical, home purchase, funeral), and unique identifiers for each transaction. The file is part of a larger procurement effort for retirement program services covering approximately 18,000 SUSORP members and 95 SMSOAP members, with vendors required to maintain precise electronic reporting standards and integrate seamlessly with existing infrastructure.
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 D – WEEKLY DISTRIBUTION REPORT FILE FORMAT
Header Record
Data Field Length Definition
No Header Record
Detail Record
Data Field Example Data/Notes Field Length
Position Definition
Report Month Date
20240101 8 1-8 Reporting date for this file (Format:
CCYYMMDD).
Provider Name Voya ORP 25 9-33 Provider Company Name.
Aggregator Plan
ID
20 34-53 The identif ier used by the Aggregator (if any) to identify the Plan.
Employer Plan ID FLASUSORP or
FLASMSOAP
20 54-73 Plan ID used by the Employer to uniquely identify the Plan. May be the same as the Aggregator Plan
ID.
Vendor Plan ID 20 74-93 The Plan ID used by the vendor to identify the Plan.
SSN 023456789
No spaces or hyphens
9 94-102
Participant Social Security number.
First Name John 35 103-137 Participant First Name.
Last Name Smith 35 138-172 Participant Last Name.
Participant Account Numbers
To be specified by Investment Provider Company
25 173-197 Participant specific account/contract number(s) with the provider. Participants may have more than one account or contract with the provider.
Provider Transaction Number
20 198-217 Unique identif ier of this distribution transaction at the provider’s discretion.
Distribution Type
04 or 09 2 218-219 Type of distribution processed:
01 – Contract Exchange 02 – Hardship withdrawal (including HEART withdrawals) 03 – In-service withdrawal 04 – Loan 05 – Rollover (out of the plan) 06 – Separation from service distribution 07 – Death 08 – Disability 09 – Required Minimum Distribution (RMD) 10 – Qualif ied Domestic Relations Order (QDRO) 11 – Other 12 – Refund of Voluntary Contributions Only 13 – Rollover Source Distribution
SUSORP/SMSOAP Page 2 of 3
Data Field Example Data/Notes Field Length
Position Definition
14 – Repayment of Unauthorized or Invalid Distribution
Distribution Date
20240101 8 220-227 Date of the distribution (YYYYMMDD format).
Distribution Amount (Sign character)
+ or - 1 Sign character (“space”, “+”, or “0” for positive amounts, “-“ for negative amounts).
Distribution Amount
Zero Fill 0000123456; which means $1,234.56
10 228-238 Amount of the distribution (Eight numeric characters followed by two decimal places. The decimal point is implied).
Reason
M or PF (single character data can be left or right justif ied)
2 239-240 Reason for this distribution:
C – Casualty Loss D – Disability F – Funeral HP – Home Purchase M – Medical PF – Prevent Foreclosure T – Tuition O – Other U – Unknown; if a specific distribution is not know and the Distribution Type = ‘02’ (Hardship) submit as ‘U’ – otherwise submit as two spaces (null value) V - Voluntary Contributions Only R – Rollover Source Contributions RP - Repayment
Payee
Smith, John or First Mortgage Company
35 241-275 Payee who received the distribution (name or entity).
Empty Field Zero Fill or Space Fill 16 276-291 Filler (Unused).
FRS Company Number/Vendor Source
0002 or 0051 4 292-295 FRS Company Number:
SUSORP
0001 – Brighthouse (MetLife)
0002 – TIAA
0003 – Corebridge Financial
(AIG/VALIC)
0004 – Nationwide (Jefferson National) 0008 – Voya (ING) 0009 – Equitable (AXA)
SMSOAP
0050 – Empower (Great West) 0051 – Voya (ING) 0053 – Corebridge Financial
(AIG/VALIC)
0055 – Equitable (AXA)
0057 – TIAA
SUSORP/SMSOAP Page 3 of 3
Trailer Record
Data Field Logical Length
Definition
No Trailer Record
REMAINDER OF PAGE INTENTIONALLY LEFT BLANK
| ATTACHMENT D – WEEKLY DISTRIBUTION REPORT FILE FORMAT |
| Header Record |
| Trailer Record |
File details come from the government source that posted it. Updated .