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 an 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 file details a comprehensive weekly distribution reporting template that providers must use to document participant distributions, including specific data fields such as report month, provider name, participant information, distribution type, date, amount, reason, and payee. The report format requires precise data entry across 295 character positions, with specific length and position requirements for each data element, covering distribution types like loans, rollovers, hardship withdrawals, and required minimum distributions.
The document includes a detailed breakdown of FRS Company Numbers for various vendors like TIAA, Voya, Corebridge Financial, and Equitable, which are part of the retirement program service providers. The reporting template is designed to capture granular transaction details, including distribution reasons (medical, home purchase, disability), sign characters for amounts, and unique identifiers for each transaction. The standardized format ensures consistent reporting across different providers and enables precise tracking of retirement plan distributions for approximately 18,000 SUSORP members and 95 SMSOAP members, with each distribution meticulously documented to support financial and administrative oversight of these optional retirement programs.
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 .