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 detailing the Weekly Distribution Report File Format for the State University System Optional Retirement Program (SUSORP) and State Money Purchase Optional Assistance Program (SMSOAP). The file specifies a precise 295-character record format for reporting participant distribution transactions, with detailed requirements for each data field including report month, provider name, participant identification, social security number, distribution type, distribution date, amount, reason, and payee information. The document provides comprehensive instructions for financial providers to standardize reporting across different vendors like Voya, TIAA, Brighthouse, Nationwide, and others.
The file format supports tracking various distribution types such as loans, hardship withdrawals, rollover distributions, required minimum distributions, and separations from service, with specific two-character codes for each transaction type. Financial providers must record precise details including distribution amounts (with implied decimal placement), reasons for distribution (medical, home purchase, disability, etc.), and unique transaction identifiers. The document includes specific company number assignments for different financial service providers participating in SUSORP and SMSOAP, enabling consistent and standardized reporting across multiple investment vendors within 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 .