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
Attachment D details 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 document specifies a comprehensive data reporting template for distribution transactions, requiring providers to submit detailed records for each participant distribution, including fields such as report month, provider name, participant social security number, distribution type, distribution date, distribution amount, distribution reason, and distribution payee. The file format supports 13 different distribution types, ranging from contract exchanges to rollover source distributions, and includes specific coding for various distribution reasons like medical expenses, home purchase, and disability.
The reporting format accommodates multiple investment providers, including Brighthouse, TIAA, Corebridge Financial, Nationwide, Voya, Equitable, and Empower, with unique company identification numbers for each. The detailed record structure allows for precise tracking of participant account distributions, with fields for sign character, exact distribution amounts, and specific payee information. Each distribution record must be formatted according to strict positional requirements, with predetermined field lengths and positions to ensure consistent and accurate reporting across different retirement program vendors. The document serves as a technical specification for standardizing distribution reporting across these state 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 .