U.S. Employee Benefit Plan Sponsors
2023 Form 5500 and 5500-SF filings, with sponsor summaries, plan financials, insurance contracts, broker compensation and service-provider detail.
- Primary rows
- 828,670
- Primary fields
- 144
- Coverage
- US
- Source snapshot
- Aug 25, 2026
- Form year 2023
- Jan 1, 2023 – Dec 31, 2023
- Place reference
- Sep 23, 2026
Sample data
Download 100 rows as CSV with all 144 primary fields.
[] / {} Empty collection0 / false Recorded valuesDownload field definitions (CSV)
About this sample
Primary table only, all columns. Columns of type json contain JSON text within CSV cells.
Included data
- One sponsor row per EIN summarizes each plan's latest filing, participants, industry, plan features and available net assets. Participant totals count people separately in each plan.
- Schedules H and I supply plan financial totals; Schedule A supplies insurance carriers, contract premiums, benefit types and broker commissions and fees.
- Schedule C service-provider entries identify published services and compensation, with separate contract, broker and provider tables linked to filings.
- Sponsor records include separately dated place contacts and exact-EIN links to IRS exempt organizations and OSHA establishments.
What’s in the package
- sponsors.csv828,670 rows · 144 fields
One plan sponsor EIN from the captured form year; contact fields from its most recently received filing and plan aggregates from each plan's latest filing.
- plan_filings.csv995,756 rows · 247 fields
One Form 5500 or 5500-SF filing (ACK ID) from the DOL Latest tables; joins to sponsors.csv by sponsor_ein.
- insurance_contracts.csv339,696 rows · 99 fields
One Schedule A (insurance contract report) attached to a Form 5500 filing; joins to plan_filings.csv by ack_id and to sponsors.csv by sponsor_ein.
- insurance_broker_compensation.csv447,087 rows · 32 fields
One Schedule A line 3 agent, broker or other person paid commissions or fees; joins to insurance_contracts.csv by ack_id and schedule_a_number.
- service_providers.csv263,253 rows · 38 fields
One Schedule C Part I line 2 service provider entry of a Form 5500 filing; joins to plan_filings.csv by ack_id and to sponsors.csv by sponsor_ein.
Companion table fields
plan_filings.csv247 fields
| Field | Definition & format |
|---|---|
Form Type form_type | 5500 for a main Form 5500 filing or 5500-SF for a short form filing
|
ACK ID ack_id | EFAST2 acknowledgment ID; unique identifier of one filing submission
|
Plan Year Begin Date plan_year_begin_date | Plan (or DFE) year beginning date reported in Part I
|
Plan Year End Date plan_year_end_date | Plan (or DFE) year ending date reported in Part I
|
Plan Entity Code plan_entity_code | Form 5500 Part I line A plan/entity type code as published; the DOL layout does not label the numeric values
|
SF Plan Entity Code sf_plan_entity_code | 5500-SF Part I line A plan type code as published; numbered separately from the Form 5500 code and not labeled in the DOL layout
|
DFE Type Code dfe_type_code | Form 5500 Part I line A direct filing entity (DFE) code: M, C, P, E, G or D
|
Initial Filing Indicator initial_filing_indicator | Part I line B first return/report box; 1 = checked
|
Amended Indicator amended_indicator | Part I line B amended return/report box; 1 = checked
|
Final Filing Indicator final_filing_indicator | Part I line B final return/report box; 1 = checked
|
Short Plan Year Indicator short_plan_year_indicator | Part I line B short plan year (less than 12 months) box; 1 = checked
|
Collectively Bargained Indicator collectively_bargained_indicator | Collectively-bargained plan box; 1 = checked
|
Form 5558 Extension Indicator form_5558_extension_indicator | Filing under a Form 5558 extension; 1 = checked
|
Automatic Extension Indicator automatic_extension_indicator | Filing under an automatic extension; 1 = checked
|
DFVC Program Indicator dfvc_program_indicator | Filing under the Delinquent Filer Voluntary Compliance program; 1 = checked
|
Special Extension Indicator special_extension_indicator | Filing under a special extension; 1 = checked
|
Special Extension Text special_extension_text | Special extension description entered by the filer
|
SECURE Act Retroactive Adoption Indicator secure_act_retroactive_adoption_indicator | Part I line E retroactively adopted plan permitted by SECURE Act section 201; 1 = checked
|
Plan Name plan_name | Line 1a name of plan (or DFE)
|
Plan Number plan_number | Line 1b three-digit plan number (PN); with sponsor EIN identifies a plan
|
Plan Effective Date plan_effective_date | Line 1c effective date of plan
|
Sponsor Name sponsor_name | Line 2a plan sponsor's (employer's) or DFE sponsor's name
|
Sponsor DBA Name sponsor_dba_name | Line 2a sponsor doing-business-as name
|
Sponsor Mailing Address line 1 sponsor_mailing_address1 | Line 2a sponsor U.S. mailing address, first line
|
Sponsor Mailing Address line 2 sponsor_mailing_address2 | Line 2a sponsor U.S. mailing address, second line
|
Sponsor Mailing City sponsor_mailing_city | Line 2a sponsor U.S. mailing city
|
Sponsor Mailing State sponsor_mailing_state | Line 2a sponsor U.S. mailing state or territory code
|
Sponsor Mailing ZIP sponsor_mailing_zip | Line 2a sponsor U.S. mailing ZIP code or ZIP+4
|
Sponsor Mailing Foreign Address line 1 sponsor_mailing_foreign_address1 | Line 2a sponsor foreign mailing address, first line
|
Sponsor Mailing Foreign Address line 2 sponsor_mailing_foreign_address2 | Line 2a sponsor foreign mailing address, second line
|
Sponsor Mailing Foreign City sponsor_mailing_foreign_city | Line 2a sponsor foreign mailing city
|
Sponsor Mailing Foreign Province State sponsor_mailing_foreign_province_state | Line 2a sponsor foreign mailing province or state
|
Sponsor Mailing Foreign Country sponsor_mailing_foreign_country | Line 2a sponsor foreign mailing country code as published
|
Sponsor Mailing Foreign Postal Code sponsor_mailing_foreign_postal_code | Line 2a sponsor foreign mailing postal code as published
|
Sponsor Location Address line 1 sponsor_location_address1 | Line 2a sponsor U.S. location address (when different from mailing), first line
|
Sponsor Location Address line 2 sponsor_location_address2 | Line 2a sponsor U.S. location address, second line
|
Sponsor Location City sponsor_location_city | Line 2a sponsor U.S. location city
|
Sponsor Location State sponsor_location_state | Line 2a sponsor U.S. location state or territory code
|
Sponsor Location ZIP sponsor_location_zip | Line 2a sponsor U.S. location ZIP code or ZIP+4
|
Sponsor Location Foreign Address line 1 sponsor_location_foreign_address1 | Line 2a sponsor foreign location address, first line
|
Sponsor Location Foreign Address line 2 sponsor_location_foreign_address2 | Line 2a sponsor foreign location address, second line
|
Sponsor Location Foreign City sponsor_location_foreign_city | Line 2a sponsor foreign location city
|
Sponsor Location Foreign Province State sponsor_location_foreign_province_state | Line 2a sponsor foreign location province or state
|
Sponsor Location Foreign Country sponsor_location_foreign_country | Line 2a sponsor foreign location country code as published
|
Sponsor Location Foreign Postal Code sponsor_location_foreign_postal_code | Line 2a sponsor foreign location postal code as published
|
Sponsor EIN sponsor_ein | Line 2b sponsor Employer Identification Number (nine digits, leading zeros kept)
|
Sponsor Phone sponsor_phone | Line 2c/2d sponsor's U.S. telephone digits as published
|
Sponsor Phone Foreign sponsor_phone_foreign | Sponsor's foreign-format telephone number as published
|
Business Code business_code | Six-digit principal business activity code from the form instructions (NAICS-based)
|
Administrator Same As Sponsor Indicator administrator_same_as_sponsor_indicator | Line 3a administrator "same as plan sponsor" box; 1 = checked
|
Administrator Address Same As Sponsor Indicator administrator_address_same_as_sponsor_indicator | Administrator address same as sponsor indicator as published
|
Administrator Address line 1 administrator_address1 | Line 3a plan administrator U.S. address, first line
|
Administrator Address line 2 administrator_address2 | Line 3a plan administrator U.S. address, second line
|
Administrator City administrator_city | Line 3a plan administrator U.S. city
|
Administrator State administrator_state | Line 3a plan administrator U.S. state or territory code
|
Administrator ZIP administrator_zip | Line 3a plan administrator U.S. ZIP code or ZIP+4
|
Administrator Foreign Address line 1 administrator_foreign_address1 | Line 3a plan administrator foreign address, first line
|
Administrator Foreign Address line 2 administrator_foreign_address2 | Line 3a plan administrator foreign address, second line
|
Administrator Foreign City administrator_foreign_city | Line 3a plan administrator foreign city
|
Administrator Foreign Province State administrator_foreign_province_state | Line 3a plan administrator foreign province or state
|
Administrator Foreign Country administrator_foreign_country | Line 3a plan administrator foreign country code as published
|
Administrator Foreign Postal Code administrator_foreign_postal_code | Line 3a plan administrator foreign postal code as published
|
Administrator EIN administrator_ein | Line 3b plan administrator EIN (nine digits, leading zeros kept)
|
Administrator Phone administrator_phone | Line 3c plan administrator U.S. telephone digits as published
|
Administrator Phone Foreign administrator_phone_foreign | Plan administrator foreign-format telephone number as published
|
Last Report Sponsor Name last_report_sponsor_name | Line 4a sponsor name on the last return/report when the sponsor name, EIN or plan name changed
|
Last Report Sponsor EIN last_report_sponsor_ein | Line 4b sponsor EIN on the last return/report
|
Last Report Plan Name last_report_plan_name | Line 4c plan name on the last return/report
|
Last Report Plan Number last_report_plan_number | Line 4d plan number on the last return/report
|
Participants Beginning-of-Year participants_boy | Total number of participants at the beginning of the plan year (Form 5500 line 5; 5500-SF line 5a)
|
Active Participants Beginning-of-Year active_participants_boy | Total number of active participants at the beginning of the plan year (Form 5500 line 6a(1); 5500-SF line 5d(1))
|
Active Participants End-of-Year active_participants_eoy | Total number of active participants at the end of the plan year (Form 5500 line 6a(2); 5500-SF line 5d(2))
|
Retired Separated Receiving Benefits retired_separated_receiving_benefits | Form 5500 line 6b retired or separated participants receiving benefits
|
Retired Separated Future Benefits retired_separated_future_benefits | Form 5500 line 6c other retired or separated participants entitled to future benefits
|
Active Retired Separated Subtotal active_retired_separated_subtotal | Form 5500 line 6d subtotal of lines 6a(2), 6b and 6c
|
Deceased Participant Beneficiaries deceased_participant_beneficiaries | Form 5500 line 6e deceased participants whose beneficiaries receive or are entitled to benefits
|
Participants End-of-Year participants_eoy | Total number of participants at the end of the plan year (Form 5500 line 6f; 5500-SF line 5b)
|
Account Balance Participants Beginning-of-Year account_balance_participants_boy | Participants with account balances at the beginning of the plan year (defined contribution plans; Form 5500 line 6g(1); 5500-SF line 5c(1))
|
Account Balance Participants End-of-Year account_balance_participants_eoy | Participants with account balances at the end of the plan year (defined contribution plans; Form 5500 line 6g(2); 5500-SF line 5c(2))
|
Separated Partially Vested Participants separated_partially_vested_participants | Participants who terminated employment during the year with accrued benefits less than 100% vested (Form 5500 line 6h; 5500-SF line 5e)
|
Contributing Employers contributing_employers | Form 5500 line 7 employers obligated to contribute (multiemployer plans only)
|
Pension Feature Codes pension_feature_codes | Pension feature codes as published: concatenated two-character plan characteristics codes (Form 5500 line 8a; 5500-SF line 9a)
|
Welfare Feature Codes welfare_feature_codes | Welfare feature codes as published: concatenated two-character plan characteristics codes (Form 5500 line 8b; 5500-SF line 9b)
|
Funding Insurance Indicator funding_insurance_indicator | Form 5500 line 9a(1) funding arrangement: insurance; 1 = checked
|
Funding 412(e)(3) Contracts Indicator funding_412e3_contracts_indicator | Form 5500 line 9a(2) funding arrangement: Code section 412(e)(3) insurance contracts; 1 = checked
|
Funding Trust Indicator funding_trust_indicator | Form 5500 line 9a(3) funding arrangement: trust; 1 = checked
|
Funding General Assets Indicator funding_general_assets_indicator | Form 5500 line 9a(4) funding arrangement: general assets of the sponsor; 1 = checked
|
Benefit Insurance Indicator benefit_insurance_indicator | Form 5500 line 9b(1) benefit arrangement: insurance; 1 = checked
|
Benefit 412(e)(3) Contracts Indicator benefit_412e3_contracts_indicator | Form 5500 line 9b(2) benefit arrangement: Code section 412(e)(3) insurance contracts; 1 = checked
|
Benefit Trust Indicator benefit_trust_indicator | Form 5500 line 9b(3) benefit arrangement: trust; 1 = checked
|
Benefit General Assets Indicator benefit_general_assets_indicator | Form 5500 line 9b(4) benefit arrangement: general assets of the sponsor; 1 = checked
|
Schedule R Indicator schedule_r_indicator | Form 5500 line 10a Schedule R attached; 1 = attached
|
Schedule MB Indicator schedule_mb_indicator | Form 5500 line 10a Schedule MB attached; 1 = attached
|
Schedule SB Indicator schedule_sb_indicator | Form 5500 line 10a Schedule SB attached; 1 = attached
|
Schedule DCG Indicator schedule_dcg_indicator | Form 5500 line 10a Schedule DCG attached; 1 = attached
|
Schedule DCG Count schedule_dcg_count | Form 5500 line 10a number of Schedules DCG attached
|
Schedule MEP Indicator schedule_mep_indicator | Form 5500 line 10a Schedule MEP attached; 1 = attached
|
Schedule H Indicator schedule_h_indicator | Form 5500 line 10b Schedule H attached; 1 = attached
|
Schedule I Indicator schedule_i_indicator | Form 5500 line 10b Schedule I attached; 1 = attached
|
Schedule A Indicator schedule_a_indicator | Form 5500 line 10b Schedule A attached; 1 = attached
|
Schedule A Count schedule_a_count | Form 5500 line 10b number of Schedules A attached
|
Schedule C Indicator schedule_c_indicator | Form 5500 line 10b Schedule C attached; 1 = attached
|
Schedule D Indicator schedule_d_indicator | Form 5500 line 10b Schedule D attached; 1 = attached
|
Schedule G Indicator schedule_g_indicator | Form 5500 line 10b Schedule G attached; 1 = attached
|
Form M-1 Required Indicator form_m1_required_indicator | Form 5500 line 11a welfare plan subject to Form M-1 requirements; published response code
|
Form M-1 Compliance Indicator form_m1_compliance_indicator | Form 5500 line 11b plan currently in compliance with Form M-1 requirements; published response code
|
Form M-1 Receipt Confirmation Code form_m1_receipt_confirmation_code | Form 5500 line 11c Form M-1 receipt confirmation code as published
|
Eligible Assets Indicator eligible_assets_indicator | 5500-SF line 6a all plan assets invested in eligible assets; published response code
|
IQPA Waiver Indicator iqpa_waiver_indicator | 5500-SF line 6b claiming waiver of the independent qualified public accountant audit; published response code
|
PBGC Coverage Code pbgc_coverage_code | 5500-SF line 6c defined benefit plan covered under the PBGC insurance program; published response code
|
PBGC Premium Filing Confirmation Number pbgc_premium_filing_confirmation_number | 5500-SF line 6c PBGC My PAA premium filing confirmation number as published
|
Total Assets Beginning-of-Year USD total_assets_boy_usd | Total plan assets, beginning of year: 5500-SF line 7a(a), Schedule H line 1f(a) or Schedule I line 1a(a); U.S. dollars as published
|
Total Liabilities Beginning-of-Year USD total_liabilities_boy_usd | Total plan liabilities, beginning of year: 5500-SF line 7b(a), Schedule H line 1k(a) or Schedule I line 1b(a); U.S. dollars as published
|
Net Assets Beginning-of-Year USD net_assets_boy_usd | Net plan assets, beginning of year: 5500-SF line 7c(a), Schedule H line 1l(a) or Schedule I line 1c(a); U.S. dollars as published
|
Total Assets End-of-Year USD total_assets_eoy_usd | Total plan assets, end of year: 5500-SF line 7a(b), Schedule H line 1f(b) or Schedule I line 1a(b); U.S. dollars as published
|
Total Liabilities End-of-Year USD total_liabilities_eoy_usd | Total plan liabilities, end of year: 5500-SF line 7b(b), Schedule H line 1k(b) or Schedule I line 1b(b); U.S. dollars as published
|
Net Assets End-of-Year USD net_assets_eoy_usd | Net plan assets, end of year: 5500-SF line 7c(b), Schedule H line 1l(b) or Schedule I line 1c(b); U.S. dollars as published
|
Employer Contributions USD employer_contributions_usd | Contributions received or receivable from employers: 5500-SF line 8a(1), Schedule H line 2a(1)(A) or Schedule I line 2a(1); U.S. dollars as published
|
Participant Contributions USD participant_contributions_usd | Contributions received or receivable from participants: 5500-SF line 8a(2), Schedule H line 2a(1)(B) or Schedule I line 2a(2); U.S. dollars as published
|
Other Contributions USD other_contributions_usd | Contributions from others, including rollovers: 5500-SF line 8a(3), Schedule H line 2a(1)(C) or Schedule I line 2a(3); U.S. dollars as published
|
Other Income USD other_income_usd | Other income (loss): 5500-SF line 8b or Schedule I line 2c; Schedule H reports income by type instead; U.S. dollars as published
|
Total Income USD total_income_usd | Total income: 5500-SF line 8c, Schedule H line 2d or Schedule I line 2d; U.S. dollars as published
|
Benefits Paid USD benefits_paid_usd | Benefits paid, including direct rollovers and payments to insurance carriers to provide benefits: 5500-SF line 8d, Schedule H line 2e(4) or Schedule I line 2e; U.S. dollars as published
|
Corrective Deemed Distributions USD corrective_deemed_distributions_usd | 5500-SF line 8e certain deemed and/or corrective distributions; U.S. dollars as published
|
Administrative Service Provider Expenses USD administrative_service_provider_expenses_usd | Administrative service providers (salaries, fees, commissions): 5500-SF line 8f or Schedule I line 2h; Schedule H itemizes administrative expenses instead; U.S. dollars as published
|
Other Expenses USD other_expenses_usd | Other expenses: 5500-SF line 8g or Schedule I line 2i; U.S. dollars as published
|
Total Expenses USD total_expenses_usd | Total expenses: 5500-SF line 8h, Schedule H line 2j or Schedule I line 2j; U.S. dollars as published
|
Net Income USD net_income_usd | Net income (loss): 5500-SF line 8i, Schedule H line 2k or Schedule I line 2k; U.S. dollars as published
|
Plan Transfers USD plan_transfers_usd | Net transfers to (from) the plan: 5500-SF line 8j or Schedule I line 2l; Schedule H reports transfers to and from the plan separately; U.S. dollars as published
|
Late Participant Contributions Indicator late_participant_contributions_indicator | 5500-SF line 10a failure to transmit participant contributions timely; published response code
|
Late Participant Contributions USD late_participant_contributions_usd | 5500-SF line 10a failure to transmit participant contributions timely; amount in U.S. dollars as published
|
Nonexempt Party In Interest Transactions Indicator nonexempt_party_in_interest_transactions_indicator | 5500-SF line 10b nonexempt transactions with a party-in-interest; published response code
|
Nonexempt Party In Interest Transactions USD nonexempt_party_in_interest_transactions_usd | 5500-SF line 10b nonexempt transactions with a party-in-interest; amount in U.S. dollars as published
|
Fidelity Bond Indicator fidelity_bond_indicator | 5500-SF line 10c plan covered by a fidelity bond; published response code
|
Fidelity Bond USD fidelity_bond_usd | 5500-SF line 10c plan covered by a fidelity bond; amount in U.S. dollars as published
|
Fraud Or Dishonesty Loss Indicator fraud_or_dishonesty_loss_indicator | 5500-SF line 10d loss caused by fraud or dishonesty; published response code
|
Fraud Or Dishonesty Loss USD fraud_or_dishonesty_loss_usd | 5500-SF line 10d loss caused by fraud or dishonesty; amount in U.S. dollars as published
|
Insurance Broker Fees Indicator insurance_broker_fees_indicator | 5500-SF line 10e fees or commissions paid to brokers, agents or others by an insurance carrier or similar organization; published response code
|
Insurance Broker Fees USD insurance_broker_fees_usd | 5500-SF line 10e fees or commissions paid to brokers, agents or others by an insurance carrier or similar organization; amount in U.S. dollars as published
|
Benefits Not Paid When Due Indicator benefits_not_paid_when_due_indicator | 5500-SF line 10f failure to provide a benefit when due; published response code
|
Benefits Not Paid When Due USD benefits_not_paid_when_due_usd | 5500-SF line 10f failure to provide a benefit when due; amount in U.S. dollars as published
|
Participant Loans Indicator participant_loans_indicator | 5500-SF line 10g plan had participant loans; published response code
|
Participant Loans End-of-Year USD participant_loans_eoy_usd | Participant loans at year end: 5500-SF line 10g or Schedule H line 1c(8)(b); U.S. dollars as published
|
Blackout Period Indicator blackout_period_indicator | 5500-SF line 10h individual account plan had a blackout period; published response code
|
Blackout Notice Indicator blackout_notice_indicator | 5500-SF line 10i required blackout notice provided or an exception applied; published response code
|
DB Minimum Funding Indicator db_minimum_funding_indicator | 5500-SF line 11 defined benefit plan subject to minimum funding requirements; published response code
|
Unpaid Minimum Required Contributions USD unpaid_minimum_required_contributions_usd | 5500-SF line 11a unpaid minimum required contributions for all years; U.S. dollars as published
|
PBGC Missed Contribution Notice Code pbgc_missed_contribution_notice_code | 5500-SF line 11b PBGC missed contribution notification response code as published
|
PBGC Missed Contribution Notice Explanation pbgc_missed_contribution_notice_explanation | 5500-SF line 11b explanation entered by the filer for "No. Other"
|
DC Minimum Funding Indicator dc_minimum_funding_indicator | 5500-SF line 12 defined contribution plan subject to minimum funding requirements; published response code
|
Funding Waiver Ruling Letter Date funding_waiver_ruling_letter_date | 5500-SF line 12a date of the letter ruling granting a funding waiver
|
Minimum Required Contribution USD minimum_required_contribution_usd | 5500-SF line 12b minimum required contribution for the plan year; U.S. dollars as published
|
Employer Contribution Paid USD employer_contribution_paid_usd | 5500-SF line 12c amount contributed by the employer for the plan year; U.S. dollars as published
|
Funding Shortfall USD funding_shortfall_usd | 5500-SF line 12d line 12b minus line 12c; negative amounts as published
|
Funding Deadline Indicator funding_deadline_indicator | 5500-SF line 12e minimum funding amount will be met by the funding deadline; published response code
|
Termination Resolution Indicator termination_resolution_indicator | 5500-SF line 13a resolution to terminate the plan adopted in any plan year; published response code
|
Assets Reverted To Employer USD assets_reverted_to_employer_usd | 5500-SF line 13a plan assets reverted to the employer this year; U.S. dollars as published
|
All Assets Distributed Indicator all_assets_distributed_indicator | 5500-SF line 13b all plan assets distributed, transferred or brought under PBGC control; published response code
|
Trust Name trust_name | 5500-SF trust name field retained in the DOL layout
|
Trust EIN trust_ein | 5500-SF trust EIN field retained in the DOL layout
|
Trust Unrelated Business Income Indicator trust_unrelated_business_income_indicator | 5500-SF trust unrelated business taxable income indicator retained in the DOL layout
|
Trust Unrelated Business Income USD trust_unrelated_business_income_usd | 5500-SF trust unrelated business taxable income amount retained in the DOL layout; U.S. dollars
|
Coverage Tests Aggregation Indicator coverage_tests_aggregation_indicator | 5500-SF line 14a plan satisfies coverage and nondiscrimination tests by permissive aggregation with other plans; published response code
|
SF 401(k) Plan Indicator sf_401k_plan_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_401K_PLAN_IND); published code
|
SF 401(k) Satisfy Requirements Indicator sf_401k_satisfy_requirements_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_401K_SATISFY_RQMTS_IND); published code
|
SF ADP ACP Test Indicator sf_adp_acp_test_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_ADP_ACP_TEST_IND); published code
|
SF Method Used To Satisfy Requirements Indicator sf_method_used_to_satisfy_requirements_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_MTHD_USED_SATISFY_RQMTS_IND); published code
|
SF Plan Timely Amended Indicator sf_plan_timely_amended_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_PLAN_TIMELY_AMENDED_IND); published code
|
SF Last Plan Amendment Date sf_last_plan_amendment_date | 5500-SF IRS compliance field retained in the DOL layout (SF_LAST_PLAN_AMENDMENT_DATE)
|
SF Tax Code sf_tax_code | 5500-SF IRS compliance field retained in the DOL layout (SF_TAX_CODE); published code
|
SF Last Opinion Advisory Letter Date sf_last_opinion_advisory_letter_date | 5500-SF IRS compliance field retained in the DOL layout (SF_LAST_OPIN_ADVI_DATE)
|
SF Last Opinion Advisory Letter Serial Number sf_last_opinion_advisory_letter_serial_number | 5500-SF IRS compliance field retained in the DOL layout (SF_LAST_OPIN_ADVI_SERIAL_NUM)
|
SF Favorable Determination Letter Date sf_favorable_determination_letter_date | 5500-SF IRS compliance field retained in the DOL layout (SF_FAV_DETERM_LTR_DATE)
|
SF Plan Maintained In U.S. Territory Indicator sf_plan_maintained_in_us_territory_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_PLAN_MAINTAIN_US_TERRI_IND); published code
|
SF In Service Distribution Indicator sf_in_service_distribution_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_IN_SERVICE_DISTRIB_IND); published code
|
SF In Service Distribution USD sf_in_service_distribution_usd | 5500-SF IRS compliance field retained in the DOL layout (SF_IN_SERVICE_DISTRIB_AMT); U.S. dollars
|
SF Minimum Required Distribution Indicator sf_minimum_required_distribution_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_MIN_REQ_DISTRIB_IND); published code
|
SF 401(k) Design Based Safe Harbor Indicator sf_401k_design_based_safe_harbor_indicator | 5500-SF line 14b 401(k) nondiscrimination method: design-based safe harbor; 1 = checked
|
SF 401(k) Prior Year ADP Test Indicator sf_401k_prior_year_adp_test_indicator | 5500-SF line 14b 401(k) nondiscrimination method: "prior year" ADP test; 1 = checked
|
SF 401(k) Current Year ADP Test Indicator sf_401k_current_year_adp_test_indicator | 5500-SF line 14b 401(k) nondiscrimination method: "current year" ADP test; 1 = checked
|
SF 401(k) Not Applicable Indicator sf_401k_not_applicable_indicator | 5500-SF line 14b 401(k) nondiscrimination method: N/A; 1 = checked
|
SF Ratio Percentage Test Indicator sf_ratio_percentage_test_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_MTHD_RATIO_PRCNT_TEST_IND); published code
|
SF Average Benefit Test Indicator sf_average_benefit_test_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_MTHD_AVG_BNFT_TEST_IND); published code
|
SF Coverage Method Not Applicable Indicator sf_coverage_method_not_applicable_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_MTHD_NA_IND); published code
|
SF Distribution To Employee 62 Indicator sf_distribution_to_employee_62_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_DISTRIB_MADE_EMPLOYE_62_IND); published code
|
SF 401(k) Design Based Safe Harbor Alternate Indicator sf_401k_design_based_safe_harbor_alternate_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_401K_DESIGN_BASED_SAFE_HARBOR_IND); published code
|
SF 401(k) Prior Year ADP Test Alternate Indicator sf_401k_prior_year_adp_test_alternate_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_401K_PRIOR_YEAR_ADP_TEST_IND); published code
|
SF 401(k) Current Year ADP Test Alternate Indicator sf_401k_current_year_adp_test_alternate_indicator | 5500-SF IRS compliance field retained in the DOL layout (SF_401K_CURRENT_YEAR_ADP_TEST_IND); published code
|
Opinion Letter Date opinion_letter_date | 5500-SF line 14c date of the IRS Opinion Letter for an adopted pre-approved plan
|
Opinion Letter Serial Number opinion_letter_serial_number | 5500-SF line 14c IRS Opinion Letter serial number
|
Administrator Signed At administrator_signed_at | Electronic signature timestamp of the plan administrator as published (signer name withheld)
|
Administrator Manual Signed At administrator_manual_signed_at | Manual signature date/time of the plan administrator as published (signer name withheld)
|
Sponsor Signed At sponsor_signed_at | Electronic signature timestamp of the employer/plan sponsor as published (signer name withheld)
|
Sponsor Manual Signed At sponsor_manual_signed_at | Manual signature date/time of the employer/plan sponsor as published (signer name withheld)
|
DFE Signed At dfe_signed_at | Electronic signature timestamp for a DFE as published (signer name withheld)
|
DFE Manual Signed At dfe_manual_signed_at | Manual signature date/time for a DFE as published (signer name withheld)
|
Administrator Signature Status administrator_signature_status | System-generated administrator electronic signature status
|
Sponsor Signature Status sponsor_signature_status | System-generated sponsor electronic signature status
|
DFE Signature Status dfe_signature_status | System-generated DFE electronic signature status
|
Filing Status filing_status | System-generated EFAST2 filing status; the Latest datasets contain FILING_RECEIVED filings
|
Date Received date_received | System-generated date EFAST2 received the filing
|
Financial Statement Source financial_statement_source | 5500-SF for a short form filing; Schedule H or Schedule I for the financial schedule attached to a Form 5500 filing
|
Total Contributions USD total_contributions_usd | Total contributions: Schedule H line 2a(3); U.S. dollars as published
|
Noncash Contributions USD noncash_contributions_usd | Noncash contributions: Schedule H line 2a(2) or Schedule I line 2b; U.S. dollars as published
|
Benefits Paid Directly USD benefits_paid_directly_usd | Benefit payments directly to participants or beneficiaries, including direct rollovers: Schedule H line 2e(1); U.S. dollars as published
|
Benefits Paid To Insurance Carriers USD benefits_paid_to_insurance_carriers_usd | Payments to insurance carriers for the provision of benefits: Schedule H line 2e(2); U.S. dollars as published
|
Corrective Distributions USD corrective_distributions_usd | Corrective distributions: Schedule H line 2f or Schedule I line 2f; U.S. dollars as published
|
Deemed Participant Loan Distributions USD deemed_participant_loan_distributions_usd | Certain deemed distributions of participant loans: Schedule H line 2g or Schedule I line 2g; U.S. dollars as published
|
Salaries And Allowances USD salaries_and_allowances_usd | Administrative expenses, salaries and allowances: Schedule H line 2i(1); U.S. dollars as published
|
Contract Administrator Fees USD contract_administrator_fees_usd | Administrative expenses, contract administrator fees: Schedule H line 2i(2); U.S. dollars as published
|
Recordkeeping Fees USD recordkeeping_fees_usd | Administrative expenses, recordkeeping fees: Schedule H line 2i(3); U.S. dollars as published
|
IQPA Audit Fees USD iqpa_audit_fees_usd | Administrative expenses, IQPA audit fees: Schedule H line 2i(4); U.S. dollars as published
|
Investment Management Fees USD investment_management_fees_usd | Administrative expenses, investment advisory and investment management fees: Schedule H line 2i(5); U.S. dollars as published
|
Trustee Custodial Fees USD trustee_custodial_fees_usd | Administrative expenses, bank or trust company trustee/custodial fees: Schedule H line 2i(6); U.S. dollars as published
|
Actuarial Fees USD actuarial_fees_usd | Administrative expenses, actuarial fees: Schedule H line 2i(7); U.S. dollars as published
|
Legal Fees USD legal_fees_usd | Administrative expenses, legal fees: Schedule H line 2i(8); U.S. dollars as published
|
Valuation Appraisal Fees USD valuation_appraisal_fees_usd | Administrative expenses, valuation/appraisal fees: Schedule H line 2i(9); U.S. dollars as published
|
Other Trustee Fees USD other_trustee_fees_usd | Administrative expenses, other trustee fees and expenses: Schedule H line 2i(10); U.S. dollars as published
|
Other Administrative Expenses USD other_administrative_expenses_usd | Administrative expenses, other expenses: Schedule H line 2i(11); U.S. dollars as published
|
Total Administrative Expenses USD total_administrative_expenses_usd | Total administrative expenses: Schedule H line 2i(12); U.S. dollars as published
|
Transfers To Plan USD transfers_to_plan_usd | Transfers of assets to this plan: Schedule H line 2l(1); U.S. dollars as published
|
Transfers From Plan USD transfers_from_plan_usd | Transfers of assets from this plan: Schedule H line 2l(2); U.S. dollars as published
|
Insurance Contract Count insurance_contract_count | Rows in insurance_contracts.csv (Schedules A) for this filing
|
Service Provider Count service_provider_count | Rows in service_providers.csv (Schedule C Part I line 2 entries) for this filing
|
Is Initial Filing is_initial_filing | True when initial_filing_indicator is 1, false when 0
|
Is Amended Filing is_amended_filing | True when amended_indicator is 1, false when 0
|
Is Final Filing is_final_filing | True when final_filing_indicator is 1, false when 0
|
Is Short Plan Year is_short_plan_year | True when short_plan_year_indicator is 1, false when 0
|
DFE Type Label dfe_type_label | Form instructions label for dfe_type_code
|
Plan Category plan_category | pension, welfare, pension_and_welfare or no_recognized_codes from recognized plan characteristics codes
|
Has Defined Benefit Feature has_defined_benefit_feature | A defined benefit pension feature code (1A-1I) is reported
|
Has Defined Contribution Feature has_defined_contribution_feature | A defined contribution pension feature code (2A-2X) is reported
|
Has 401(k) Feature has_401k_feature | Code 2J (Code section 401(k) feature) is reported
|
Has Health Benefit has_health_benefit | Code 4A (health other than vision or dental) is reported
|
Has Dental Benefit has_dental_benefit | Code 4D (dental) is reported
|
Has Vision Benefit has_vision_benefit | Code 4E (vision) is reported
|
Has Life Insurance Benefit has_life_insurance_benefit | Code 4B (life insurance) is reported
|
Has Disability Benefit has_disability_benefit | Code 4F (temporary disability) or 4H (long-term disability) is reported
|
Pension Feature Codes JSON pension_feature_codes_json | Published pension feature codes in order, each with its form-instructions label (blank label when unrecognized)
|
Welfare Feature Codes JSON welfare_feature_codes_json | Published welfare feature codes in order, each with its form-instructions label (blank label when unrecognized)
|
Unrecognized Feature Codes unrecognized_feature_codes | Semicolon-separated published codes absent from the form-year code list
|
Is Latest Filing For Plan Year is_latest_filing_for_plan_year | The one filing per sponsor EIN, plan number and plan year begin date with the latest date received, then the highest ACK ID
|
Is Latest Filing For Plan is_latest_filing_for_plan | The one filing per sponsor EIN and plan number with the latest plan year begin date, then date received, then ACK ID; basis of sponsor plan aggregates
|
Form Year form_year | DOL form year of the captured Latest dataset
|
Source File source_file | CSV member of the captured DOL archive that holds this filing
|
Source Row Number source_row_number | One-based data-row ordinal in source_file, excluding the header; not a persistent ID
|
Source Snapshot source_snapshot | Immutable local raw snapshot ID
|
insurance_contracts.csv99 fields
| Field | Definition & format |
|---|---|
ACK ID ack_id | EFAST2 acknowledgment ID of the Form 5500 filing this Schedule A is attached to
|
Schedule A Number schedule_a_number | DOL sequence number of this Schedule A within its filing (FORM_ID); with ack_id identifies one contract report
|
Sponsor EIN sponsor_ein | Sponsor EIN of the Form 5500 filing (plan_filings.sponsor_ein); joins to sponsors.csv
|
Plan Number plan_number | Plan number of the Form 5500 filing (plan_filings.plan_number)
|
Is Latest Filing For Plan is_latest_filing_for_plan | Copied from plan_filings: the filing is its plan's latest; basis of sponsor summaries
|
Is Latest Filing For Plan Year is_latest_filing_for_plan_year | Copied from plan_filings: the filing is the latest for its plan year
|
Schedule Plan Year Begin Date schedule_plan_year_begin_date | Plan year beginning date entered on this Schedule A
|
Schedule Plan Year End Date schedule_plan_year_end_date | Plan year ending date entered on this Schedule A
|
Schedule Plan Number schedule_plan_number | Line B plan number entered on this Schedule A; plan_number comes from the filing
|
Schedule Sponsor EIN schedule_sponsor_ein | Line D sponsor EIN entered on this Schedule A; sponsor_ein comes from the filing
|
Carrier Name carrier_name | Line 1(a) name of the insurance carrier as published when recognized as an organization; see carrier_name_status
|
Carrier EIN carrier_ein | Line 1(b) insurance carrier EIN (nine digits, leading zeros kept)
|
Carrier NAIC Code carrier_naic_code | Line 1(c) NAIC company code as published; the instructions ask for zeros when none is assigned
|
Contract Number contract_number | Line 1(d) contract or identification number as published
|
Persons Covered End-of-Year persons_covered_eoy | Line 1(e) approximate number of persons covered at the end of the policy or contract year
|
Policy Year Begin Date policy_year_begin_date | Line 1(f) policy or contract year beginning date
|
Policy Year End Date policy_year_end_date | Line 1(g) policy or contract year ending date
|
Broker Commissions Total USD broker_commissions_total_usd | Line 2(a) total commissions paid to agents, brokers and other persons; U.S. dollars as published
|
Broker Fees Total USD broker_fees_total_usd | Line 2(b) total fees paid to agents, brokers and other persons; U.S. dollars as published
|
General Account Value End-of-Year USD general_account_value_eoy_usd | Part II line 4 current value of the plan interest in the general account at year end; U.S. dollars as published
|
Separate Account Value End-of-Year USD separate_account_value_eoy_usd | Part II line 5 current value of the plan interest in separate accounts at year end; U.S. dollars as published
|
Allocated Premium Rate Basis allocated_premium_rate_basis | Part II line 6a basis of premium rates for contracts with allocated funds, as entered
|
Allocated Premiums Paid USD allocated_premiums_paid_usd | Part II line 6b premiums paid to the carrier for contracts with allocated funds; U.S. dollars as published
|
Allocated Premiums Due Unpaid USD allocated_premiums_due_unpaid_usd | Part II line 6c premiums due but unpaid at the end of the year; U.S. dollars as published
|
Allocated Acquisition Costs USD allocated_acquisition_costs_usd | Part II line 6d specific acquisition or retention costs incurred by the carrier; U.S. dollars as published
|
Allocated Individual Policies allocated_individual_policies | Part II line 6e(1) allocated contract type: individual policies
|
Allocated Group Deferred Annuity allocated_group_deferred_annuity | Part II line 6e(2) allocated contract type: group deferred annuity
|
Allocated Other Contract allocated_other_contract | Part II line 6e(3) allocated contract type: other
|
Allocated Other Contract Description allocated_other_contract_description | Part II line 6e(3) other allocated contract type as entered
|
Purchased For Terminating Plan purchased_for_terminating_plan | Part II line 6f contract purchased to distribute benefits from a terminating plan
|
Unallocated Deposit Administration unallocated_deposit_administration | Part II line 7a(1) unallocated contract type: deposit administration
|
Unallocated Immediate Participation Guarantee unallocated_immediate_participation_guarantee | Part II line 7a(2) unallocated contract type: immediate participation guarantee
|
Unallocated Guaranteed Investment unallocated_guaranteed_investment | Part II line 7a(3) unallocated contract type: guaranteed investment
|
Unallocated Other Contract unallocated_other_contract | Part II line 7a(4) unallocated contract type: other
|
Unallocated Other Contract Description unallocated_other_contract_description | Part II line 7a(4) other unallocated contract type as entered
|
Unallocated Balance Prior Year End USD unallocated_balance_prior_year_end_usd | Part II line 7b balance at the end of the previous year; U.S. dollars as published
|
Unallocated Contributions Deposited USD unallocated_contributions_deposited_usd | Part II line 7c(1) contributions deposited during the year; U.S. dollars as published
|
Unallocated Dividends Credits USD unallocated_dividends_credits_usd | Part II line 7c(2) dividends and credits; U.S. dollars as published
|
Unallocated Interest Credited USD unallocated_interest_credited_usd | Part II line 7c(3) interest credited during the year; U.S. dollars as published
|
Unallocated Transferred From Separate Account USD unallocated_transferred_from_separate_account_usd | Part II line 7c(4) transferred from separate account; U.S. dollars as published
|
Unallocated Other Additions USD unallocated_other_additions_usd | Part II line 7c(5) other additions; U.S. dollars as published
|
Unallocated Total Additions USD unallocated_total_additions_usd | Part II line 7c(6) total additions; U.S. dollars as published
|
Unallocated Balance And Additions USD unallocated_balance_and_additions_usd | Part II line 7d total of balance and additions; U.S. dollars as published
|
Unallocated Benefits Disbursed USD unallocated_benefits_disbursed_usd | Part II line 7e(1) disbursed to pay benefits or purchase annuities; U.S. dollars as published
|
Unallocated Administration Charge USD unallocated_administration_charge_usd | Part II line 7e(2) administration charge made by the carrier; U.S. dollars as published
|
Unallocated Transferred To Separate Account USD unallocated_transferred_to_separate_account_usd | Part II line 7e(3) transferred to separate account; U.S. dollars as published
|
Unallocated Other Deductions USD unallocated_other_deductions_usd | Part II line 7e(4) other deductions; U.S. dollars as published
|
Unallocated Total Deductions USD unallocated_total_deductions_usd | Part II line 7e(5) total deductions; U.S. dollars as published
|
Unallocated Balance End-of-Year USD unallocated_balance_eoy_usd | Part II line 7f balance at the end of the current year; U.S. dollars as published
|
Benefit Health benefit_health | Part III line 8a benefit and contract type checked: Health (other than dental or vision)
|
Benefit Dental benefit_dental | Part III line 8b benefit and contract type checked: Dental
|
Benefit Vision benefit_vision | Part III line 8c benefit and contract type checked: Vision
|
Benefit Life Insurance benefit_life_insurance | Part III line 8d benefit and contract type checked: Life insurance
|
Benefit Temporary Disability benefit_temporary_disability | Part III line 8e benefit and contract type checked: Temporary disability (accident and sickness)
|
Benefit Long Term Disability benefit_long_term_disability | Part III line 8f benefit and contract type checked: Long-term disability
|
Benefit Supplemental Unemployment benefit_supplemental_unemployment | Part III line 8g benefit and contract type checked: Supplemental unemployment
|
Benefit Prescription Drug benefit_prescription_drug | Part III line 8h benefit and contract type checked: Prescription drug
|
Benefit Stop Loss benefit_stop_loss | Part III line 8i benefit and contract type checked: Stop loss (large deductible)
|
Benefit HMO benefit_hmo | Part III line 8j benefit and contract type checked: HMO contract
|
Benefit PPO benefit_ppo | Part III line 8k benefit and contract type checked: PPO contract
|
Benefit Indemnity benefit_indemnity | Part III line 8l benefit and contract type checked: Indemnity contract
|
Benefit Other benefit_other | Part III line 8m benefit and contract type checked: Other
|
Other Benefit Description other_benefit_description | Part III line 8m other benefit or contract type as entered
|
Experience Rated Premiums Received USD experience_rated_premiums_received_usd | Part III line 9a(1) experience-rated premiums: amount received; U.S. dollars as published
|
Experience Rated Premiums Due Unpaid Change USD experience_rated_premiums_due_unpaid_change_usd | Part III line 9a(2) increase (decrease) in amount due but unpaid; U.S. dollars as published
|
Experience Rated Unearned Premium Reserve Change USD experience_rated_unearned_premium_reserve_change_usd | Part III line 9a(3) increase (decrease) in unearned premium reserve; U.S. dollars as published
|
Experience Rated Premiums Earned USD experience_rated_premiums_earned_usd | Part III line 9a(4) premiums earned; U.S. dollars as published
|
Experience Rated Claims Paid USD experience_rated_claims_paid_usd | Part III line 9b(1) benefit charges: claims paid; U.S. dollars as published
|
Experience Rated Claim Reserves Change USD experience_rated_claim_reserves_change_usd | Part III line 9b(2) increase (decrease) in claim reserves; U.S. dollars as published
|
Experience Rated Incurred Claims USD experience_rated_incurred_claims_usd | Part III line 9b(3) incurred claims; U.S. dollars as published
|
Experience Rated Claims Charged USD experience_rated_claims_charged_usd | Part III line 9b(4) claims charged; U.S. dollars as published
|
Retention Commissions USD retention_commissions_usd | Part III line 9c(1)(A) retention charges: commissions; U.S. dollars as published
|
Retention Administrative Fees USD retention_administrative_fees_usd | Part III line 9c(1)(B) retention charges: administrative service or other fees; U.S. dollars as published
|
Retention Other Acquisition Costs USD retention_other_acquisition_costs_usd | Part III line 9c(1)(C) retention charges: other specific acquisition costs; U.S. dollars as published
|
Retention Other Expenses USD retention_other_expenses_usd | Part III line 9c(1)(D) retention charges: other expenses; U.S. dollars as published
|
Retention Taxes USD retention_taxes_usd | Part III line 9c(1)(E) retention charges: taxes; U.S. dollars as published
|
Retention Risk Charges USD retention_risk_charges_usd | Part III line 9c(1)(F) retention charges: charges for risks or other contingencies; U.S. dollars as published
|
Retention Other Charges USD retention_other_charges_usd | Part III line 9c(1)(G) other retention charges; U.S. dollars as published
|
Retention Total USD retention_total_usd | Part III line 9c(1)(H) total retention; U.S. dollars as published
|
Refunds Paid In Cash refunds_paid_in_cash | Part III line 9c(2) dividends or retroactive rate refunds were paid in cash
|
Refunds Credited refunds_credited | Part III line 9c(2) dividends or retroactive rate refunds were credited
|
Dividends Or Rate Refunds USD dividends_or_rate_refunds_usd | Part III line 9c(2) dividends or retroactive rate refunds; U.S. dollars as published
|
Reserves For Benefits After Retirement USD reserves_for_benefits_after_retirement_usd | Part III line 9d(1) policyholder reserves held to provide benefits after retirement; U.S. dollars as published
|
Claim Reserves End-of-Year USD claim_reserves_eoy_usd | Part III line 9d(2) claim reserves at year end; U.S. dollars as published
|
Other Reserves End-of-Year USD other_reserves_eoy_usd | Part III line 9d(3) other reserves at year end; U.S. dollars as published
|
Dividends Or Rate Refunds Due USD dividends_or_rate_refunds_due_usd | Part III line 9e dividends or retroactive rate refunds due; U.S. dollars as published
|
Nonexperience Rated Premiums Paid USD nonexperience_rated_premiums_paid_usd | Part III line 10a nonexperience-rated contracts: total premiums or subscription charges paid to the carrier; U.S. dollars as published
|
Nonexperience Rated Acquisition Costs USD nonexperience_rated_acquisition_costs_usd | Part III line 10b nonexperience-rated contracts: specific acquisition or retention costs; U.S. dollars as published
|
Information Not Provided Code information_not_provided_code | Part IV line 11 insurance company failed to provide information: published response code (1 = yes, 2 = no)
|
Carrier Name Status carrier_name_status | Why carrier_name is published or withheld: published_legal_form, published_organization_word, published_naic_code (carriers only), withheld_individual_service_code (service providers only), withheld_proxy_or_contact, withheld_person_segment (brokers and service providers), withheld_unrecognized or source_blank
|
Benefit Types benefit_types | Semicolon-separated keys of the Part III line 8 benefit and contract types checked, in form order
|
Total Premiums USD total_premiums_usd | Sum of the premium lines reported: Part II 6b, Part III 9a(1) and 10a; U.S. dollars
|
Premium Lines Reported premium_lines_reported | Number of premium lines (6b, 9a(1), 10a) reported; above 1 means total_premiums_usd adds several lines
|
Insurer Failed To Provide Information insurer_failed_to_provide_information | True when information_not_provided_code is 1, false when 2
|
Broker Line Count broker_line_count | Line 3 rows for this Schedule A in insurance_broker_compensation.csv
|
Form Year form_year | DOL form year of the captured Latest dataset
|
Source File source_file | CSV member of the captured DOL schedule archive that holds this row
|
Source Row Number source_row_number | One-based data-row ordinal in source_file, excluding the header; not a persistent ID
|
Source Snapshot source_snapshot | Immutable local raw snapshot ID
|
insurance_broker_compensation.csv32 fields
| Field | Definition & format |
|---|---|
ACK ID ack_id | EFAST2 acknowledgment ID of the Form 5500 filing
|
Schedule A Number schedule_a_number | DOL sequence number of the Schedule A within its filing; joins to insurance_contracts.csv with ack_id
|
Broker Row Number broker_row_number | DOL order of this line 3 entry within the Schedule A (ROW_ORDER); the instructions ask for descending amount paid
|
Sponsor EIN sponsor_ein | Sponsor EIN of the Form 5500 filing (plan_filings.sponsor_ein); joins to sponsors.csv
|
Plan Number plan_number | Plan number of the Form 5500 filing (plan_filings.plan_number)
|
Is Latest Filing For Plan is_latest_filing_for_plan | Copied from plan_filings: the filing is its plan's latest; basis of sponsor summaries
|
Is Latest Filing For Plan Year is_latest_filing_for_plan_year | Copied from plan_filings: the filing is the latest for its plan year
|
Carrier Name carrier_name | carrier_name of the linked Schedule A in insurance_contracts.csv, as delivered
|
Carrier EIN carrier_ein | carrier_ein of the linked Schedule A
|
Broker Name broker_name | Line 3(a) name of the agent, broker or other person as published when recognized as an organization; see broker_name_status
|
Broker U.S. Address Line 1 broker_us_address1 | Line 3(a) U.S. street line 1; withheld with the name
|
Broker U.S. Address Line 2 broker_us_address2 | Line 3(a) U.S. street line 2; withheld with the name
|
Broker U.S. City broker_us_city | Line 3(a) U.S. city
|
Broker U.S. State broker_us_state | Line 3(a) U.S. state or territory code
|
Broker U.S. ZIP broker_us_zip | Line 3(a) U.S. ZIP code or ZIP+4
|
Broker Foreign Address Line 1 broker_foreign_address1 | Line 3(a) foreign street line 1; withheld with the name
|
Broker Foreign Address Line 2 broker_foreign_address2 | Line 3(a) foreign street line 2; withheld with the name
|
Broker Foreign City broker_foreign_city | Line 3(a) foreign city
|
Broker Foreign Province State broker_foreign_province_state | Line 3(a) foreign province or state
|
Broker Foreign Country broker_foreign_country | Line 3(a) foreign country code as published
|
Broker Foreign Postal Code broker_foreign_postal_code | Line 3(a) foreign postal code as published
|
Commissions Paid USD commissions_paid_usd | Line 3(b) sales and base commissions paid; U.S. dollars as published
|
Fees Paid USD fees_paid_usd | Line 3(c) fees and other commissions paid; U.S. dollars as published
|
Fees Purpose fees_purpose | Line 3(d) purpose of the fees as entered; withheld with the name
|
Organization Code organization_code | Line 3(e) organization code as published; decoded in organization_type
|
Broker Name Status broker_name_status | Why broker_name is published or withheld: published_legal_form, published_organization_word, published_naic_code (carriers only), withheld_individual_service_code (service providers only), withheld_proxy_or_contact, withheld_person_segment (brokers and service providers), withheld_unrecognized or source_blank
|
Broker U.S. ZIP5 broker_us_zip5 | Five-digit ZIP key from broker_us_zip
|
Organization Type organization_type | Instructions label of organization_code
|
Form Year form_year | DOL form year of the captured Latest dataset
|
Source File source_file | CSV member of the captured DOL schedule archive that holds this row
|
Source Row Number source_row_number | One-based data-row ordinal in source_file, excluding the header; not a persistent ID
|
Source Snapshot source_snapshot | Immutable local raw snapshot ID
|
service_providers.csv38 fields
| Field | Definition & format |
|---|---|
ACK ID ack_id | EFAST2 acknowledgment ID of the Form 5500 filing this Schedule C is attached to
|
Provider Row Number provider_row_number | DOL order of this Part I line 2 entry within the Schedule C (ROW_ORDER); the instructions ask for descending compensation
|
Sponsor EIN sponsor_ein | Sponsor EIN of the Form 5500 filing (plan_filings.sponsor_ein); joins to sponsors.csv
|
Plan Number plan_number | Plan number of the Form 5500 filing (plan_filings.plan_number)
|
Is Latest Filing For Plan is_latest_filing_for_plan | Copied from plan_filings: the filing is its plan's latest; basis of sponsor summaries
|
Is Latest Filing For Plan Year is_latest_filing_for_plan_year | Copied from plan_filings: the filing is the latest for its plan year
|
Provider Name provider_name | Line 2(a) name of the service provider as published when recognized as an organization; see provider_name_status
|
Provider EIN provider_ein | Line 2(a) EIN (nine digits, leading zeros kept); for an individual the instructions allow the employer EIN
|
Provider U.S. Address Line 1 provider_us_address1 | Line 2(a) U.S. street line 1; withheld with the name
|
Provider U.S. Address Line 2 provider_us_address2 | Line 2(a) U.S. street line 2; withheld with the name
|
Provider U.S. City provider_us_city | Line 2(a) U.S. city
|
Provider U.S. State provider_us_state | Line 2(a) U.S. state or territory code
|
Provider U.S. ZIP provider_us_zip | Line 2(a) U.S. ZIP code or ZIP+4
|
Provider Foreign Address Line 1 provider_foreign_address1 | Line 2(a) foreign street line 1; withheld with the name
|
Provider Foreign Address Line 2 provider_foreign_address2 | Line 2(a) foreign street line 2; withheld with the name
|
Provider Foreign City provider_foreign_city | Line 2(a) foreign city
|
Provider Foreign Province State provider_foreign_province_state | Line 2(a) foreign province or state
|
Provider Foreign Country provider_foreign_country | Line 2(a) foreign country code as published
|
Provider Foreign Postal Code provider_foreign_postal_code | Line 2(a) foreign postal code as published
|
Relationship relationship | Line 2(c) relationship to the employer, employee organization or other party-in-interest as entered; withheld with the name
|
Direct Compensation USD direct_compensation_usd | Line 2(d) direct compensation paid by the plan; U.S. dollars as published
|
Indirect Compensation Code indirect_compensation_code | Line 2(e) received indirect compensation: published response code (1 = yes, 2 = no)
|
Eligible Indirect Compensation Code eligible_indirect_compensation_code | Line 2(f) indirect compensation included eligible indirect compensation with the required disclosures: published response code (1 = yes, 2 = no)
|
Indirect Compensation USD indirect_compensation_usd | Line 2(g) total indirect compensation other than eligible indirect compensation; U.S. dollars as published
|
Compensation Formula Code compensation_formula_code | Line 2(h) a formula was provided instead of an amount for some indirect compensation: published response code (1 = yes, 2 = no)
|
Provider Name Status provider_name_status | Why provider_name is published or withheld: published_legal_form, published_organization_word, published_naic_code (carriers only), withheld_individual_service_code (service providers only), withheld_proxy_or_contact, withheld_person_segment (brokers and service providers), withheld_unrecognized or source_blank
|
Provider U.S. ZIP5 provider_us_zip5 | Five-digit ZIP key from provider_us_zip
|
Service Codes service_codes | Line 2(b) service and compensation codes, semicolon-separated in published order
|
Service Codes JSON service_codes_json | Line 2(b) codes in published order, each with its instructions label (blank label when unrecognized)
|
Service Roles service_roles | Semicolon-separated service roles whose codes appear in service_codes (service_roles in schema.json)
|
Received Indirect Compensation received_indirect_compensation | True when indirect_compensation_code is 1, false when 2
|
Received Eligible Indirect Compensation received_eligible_indirect_compensation | True when eligible_indirect_compensation_code is 1, false when 2
|
Compensation Formula Provided compensation_formula_provided | True when compensation_formula_code is 1, false when 2
|
Reported Compensation USD reported_compensation_usd | direct_compensation_usd plus indirect_compensation_usd as reported; eligible indirect compensation has no line 2 amount
|
Form Year form_year | DOL form year of the captured Latest dataset
|
Source File source_file | CSV member of the captured DOL schedule archive that holds this row
|
Source Row Number source_row_number | One-based data-row ordinal in source_file, excluding the header; not a persistent ID
|
Source Snapshot source_snapshot | Immutable local raw snapshot ID
|
Field coverage
Data notes
Coverage counts describe the full tables. Blank cells and empty JSON collections are excluded; zero and false are populated values. Blank cells do not mean zero or no. A populated contact field does not establish that the contact is current or verified.
- The CY period label denotes the DOL form year (the year printed on the form), generally plan years beginning in that calendar year; filings reporting other plan years remain included.
- A form year is captured only after its extended filing deadlines have passed; late, delinquent-program and amended filings received after the DOL extract date are absent.
- Participant counts describe plans, not employee headcount; sponsor totals add each plan's latest filing, so a person in several plans is counted in each.
- Names, addresses and phones are filer-reported and not verified; one filing supplies each sponsor's contact block and variant counts show disagreement across filings.
- Signer, preparer, in-care-of, plan administrator and trustee names are withheld; administrator EIN, address and phone are kept as published. Carrier, broker and service provider names are delivered only when the name itself shows an organization (legal-form or organization word, or a carrier NAIC code) and, for brokers and providers, carries no separate personal-name segment; other names, their street lines, fee purposes and relationships are withheld while amounts, codes, EINs, city, state and ZIP remain. Business names can include an owner's name.
- Plan entity (line A) numeric codes are published without labels in the DOL layout, numbered separately on each form, and are not decoded.
- Business codes follow a NAICS-based form list; titles come from Census NAICS 2017, then 2022, and parent_prefix matches name the nearest published parent industry.
- Schedules A, C (Part I line 2), H and I are included; other schedules (D, G, MB, R, SB, DCG, MEP), Schedule C line 1 and 3 and Parts II and III, Schedule H/I line detail beyond the delivered totals and fees, attachments and filing images are not included.
- Schedule A attaches to Form 5500 filings with insurance contracts and Schedule C to large-plan and DFE filings; 5500-SF filers have neither, a Schedule C lists only providers paid $5,000 or more, and plans exempt from filing are absent.
- Schedule A total_premiums_usd adds the premium lines reported on one schedule; a filer entering the same premium on two lines is counted twice. Line 3 broker amounts do not always add up to the line 2 totals; both are kept as published.
- Sponsor plan net assets exclude DFE filings, whose assets belong to participating plans; sponsor name lists keep published spellings without merging variants.
- Place contacts describe the Overture release, not the form year. Matched does not mean manually verified; emails are limited to published shared business mailboxes, and sponsors filing from a third-party administrator or mailing address may link to that location or not at all.
- Nonprofit and OSHA values are exact-EIN joins from the captured sibling editions, not verified identity; OSHA figures cover only establishments that reported to OSHA, and Form 990 values describe the organization's own latest return.