Searching plans
Retirement and welfare search work the same way. Retirement search is at /retirement and welfare search is at /welfare. They share the search bar, filter layout, sort and URL format. Retirement filters cover size, fees and prospect flags. Welfare filters cover funding type, carriers, brokers and renewal premium.
The search bar
The search bar accepts a sponsor name, a plan name, or an EIN. Suggestions appear as you type.
- Nine digits or more matches as an EIN. Hyphens are stripped, so
910425694and91-0425694both work. - Shorter strings run a case-insensitive prefix match across sponsor and plan names.
boeifinds Boeing, Boeing Employee Association and any other name that starts with those characters. - Multiple words AND together.
acme 401only matches names containing both tokens.
With an empty search bar, the results show every plan that matches the filters. If a known sponsor does not show, check the filters. State and plan-size filters also narrow the suggestions.
Filter rail
The left rail groups every retirement filter into nine panels. Selections in one panel combine with OR. Filters in different panels combine with AND. An empty filter has no effect. The count next to each row shows how many active plans match if you turn it on.
| Panel | What it narrows |
|---|---|
| Size | Total assets and total participants. The buckets follow advisor segments, and a histogram slider gives finer ranges. |
| Location | State, city and ZIP code. All three match the sponsor's mailing address. |
| Plan type | Subtype (401(k), 403(b), DB, ESOP, ...), lifecycle (active, frozen, terminating, wind-down), sponsor structure (single-employer, MEP, PEP, ...), and tax class. |
| Plan features | Form 5500 plan-feature codes: auto-enrollment, QDIA, 404(c), participant-directed, controlled group, employer securities, PBGC. |
| Plan policy | Safe harbor, SECURE 2.0 mandate, Auto-IRA state, employer securities, top hat statement and auditor opinion type. |
| Industry | 20 two-digit NAICS sectors with a search box above the list. Sponsor industry comes from PDL where available. |
| Prospect flags | 17 flags and an 'any flag' option. Six flags come straight from DOL fields, six use fixed cutoffs, four use peer percentiles and one marks wind-down. |
| Performance | Admin fees as a percent of assets, year-over-year asset growth and participation rate. Each has buckets and a slider. |
| Providers | Type the name of any recordkeeper, advisor, TPA, auditor or legal-services provider. The results show plans where that provider is on Schedule C. |
Welfare search
Welfare search uses the same search bar, sliders and chip bar as retirement search, with welfare filters. The counts and bucket cutoffs fit welfare plan data.
| Panel | What it narrows |
|---|---|
| Size | Total premiums, persons covered and total broker compensation. Each has buckets and a slider. |
| Location | State, city and ZIP. The controls match retirement search. |
| Funding | Funding type (fully insured, self-funded, mixed, MEWA), sponsor structure and 'has stop-loss carrier'. |
| Coverage | Benefit lines on the main 5500 form: medical, dental, vision, life, disability and others. |
| Industry | 20 NAICS sectors from the same source as retirement search. |
| Performance | Year-over-year premium change, retention rate and broker pay as a percent of premium. |
| Prospect flags | 12 welfare prospect signals: premium spike, carrier or broker switch, high or under broker comp, concentration risk, premium-per-life outlier, no-broker, self-funded no-stop-loss, MEWA, recently terminated, funding transition. |
| Carriers and brokers | Type the name of the primary (largest-premium) carrier or broker on the filing. The filter uses carrier_key or broker_key. |
Sorting and pagination
The retirement results table sorts by total assets (largest first) by default. Click a column header to sort again. The sorts are:
- Total assets (descending, default)
- Total participants
- Active employees
- Sponsor name (A-Z)
- Asset growth percent (year over year)
- Admin expense percent of assets
- Plan-rank percentile
Welfare results sort by total premiums by default. You can also sort by persons covered, premium per life, broker pay or sponsor name.
Both searches show 25 rows per page. The pager is below the table. The limit and offset URL params change this for larger one-time pulls.
Saved searches and URL sharing
Every control writes its state into the URL, so the address bar is the saved search. If you copy, email or bookmark the link, it opens the same rows.
Example:
/retirement?state=NH,VT,ME &assets_min=10000000&assets_max=50000000 &naics2=52&features=2F,2H &flags=flag_fidelity_bond
That URL finds small and mid-market finance and insurance plans in northern New England. The plans have ERISA 404(c) and participant-directed investments, and the fidelity bond flag is on. The default sort (assets descending) does not show in the URL.
Signed-in users can save the current URL as a named view from the rail header. Saved views appear under Your saved views on the rail and on the account area.