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
This document is Attachment D - Weekly Distribution Report File Format for the Florida Department of Management Services (DMS) related to the State University System Optional Retirement Program (SUSORP) and Senior Management Service Optional Annuity Program (SMSOAP). The attachment details a specific file format for weekly distribution reporting, outlining precise data field requirements for recording participant distribution information. Each record includes detailed specifications such as report month, provider name, participant identifiers, Social Security number, distribution type, distribution date, amount, reason, and payee information. The format supports tracking various distribution types including contract exchanges, hardship withdrawals, loans, rollovers, separations, and required minimum distributions.
The document provides comprehensive technical specifications for financial providers like Voya, TIAA, Corebridge Financial, and others participating in the retirement programs. Each data field is assigned a specific position, length, and format, with examples demonstrating how information should be entered. The file format supports tracking distributions across multiple vendor sources, with unique identifiers for SUSORP and SMSOAP programs. The granular reporting requirements enable precise tracking of participant account activities, including distribution reasons (such as medical expenses, home purchase, or tuition), payee details, and financial transaction specifics, while maintaining a standardized reporting methodology across different retirement plan providers.
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 .