Axiomatic Plan Intelligence — Form 5500 Schedule H / Schedule C / Schedule SB data. Covers ~1.5M defined-contribution and defined-benefit plan filings per year, with fund-level holdings extracted from ~50–60K plans/year whose Schedule of Assets PDF successfully parsed.
| Variable Name | Description | Field Type | Category |
|---|---|---|---|
| ack_id | EFAST2 acknowledgment ID — unique identifier for one Form 5500 filing (one plan-year). i.e. 20250826181243NAL0004599843001 | String | Plan Basics |
| company_ein | Employer Identification Number of the plan sponsor | String | Plan Basics |
| plan_name | Name of the employee benefit plan as reported on Form 5500 line 1a | String | Plan Basics |
| plan_number | 3-digit plan number assigned by the sponsor (distinguishes multiple plans filed under the same EIN) | String | Plan Basics |
| cl_company_legal_name | Full legal name of the plan sponsor company | String | Plan Basics |
| spons_dfe_mail_us_state | Two-letter US state of the plan sponsor's mailing address | String | Plan Basics |
| cl_industry_code | 6-digit NAICS industry code of the plan sponsor | String | Plan Basics |
| fiscal_year / fiscal_period | Plan year (e.g. 2024), and the DOL fiscal period label (e.g. 2024_2025). Latest complete plan year lags the calendar year by one, since forms for a given plan year are filed the following year | Integer / String | Plan Basics |
| tot_active_partcp_cnt | Total active participants in the plan | Integer | Plan Basics |
| avg_account_value | Average participant account value: net plan assets ÷ active participants for the plan-year | Decimal (USD) | Plan Basics |
| is_multiple_employer / is_pep | Whether the plan is a multiple-employer arrangement (MEP), and — a name-based heuristic — whether it's specifically a SECURE-Act Pooled Employer Plan (PEP) | Boolean | Plan Basics |
| has_self_directed_brokerage | Whether the plan offers a self-directed brokerage account option to participants (Form 5500 pension-benefit code 2R) | Boolean | Plan Basics |
| has_automatic_enrollment | Whether the plan features automatic enrollment with elective contributions deducted from payroll (Form 5500 pension-benefit code 2S) | Boolean | Plan Basics |
| filing_type | Which DOL form/schedule this filing used, and whether it can structurally carry a Schedule of Assets: sf_5500 (Form 5500-SF, never has one), full_5500_sch_h (the real Schedule-of-Assets candidate pool), full_5500_sch_h_no_assets (Schedule H filed, plan reported holding no assets), full_5500_sch_i (the full form's small-plan alternative to Schedule H) | String (enum) | Plan Basics |
| net_assets_eoy_amt | Total plan net assets at end of year (Schedule H line 1n) — the plan's overall size | Decimal (USD) | Plan Financials |
| tot_contrib_amt / emplr_contrib_amt / partcp_contrib_amt / other_contrib_rcvd_amt | Total, employer, participant, and other contributions received during the plan year (Schedule H Part II) | Decimal (USD) | Plan Financials |
| tot_distrib_benefit_amt | Total benefits paid to participants during the plan year | Decimal (USD) | Plan Financials |
| tot_admin_expenses_amt | Total administrative expenses charged to the plan (professional fees, contract administrator fees, investment management fees, other) | Decimal (USD) | Plan Financials |
| net_income_amt | Net change in plan assets for the year (income − expenses) | Decimal (USD) | Plan Financials |
| contribution_rate / benefit_distribution_rate / investment_return_rate / net_growth_rate | Derived annual rates: contributions ÷ assets, benefits paid ÷ assets, investment return on plan assets, and net asset growth | Decimal (%) | Plan Financials |
| mutual_funds_eoy_amt / common_trust_eoy_amt / pooled_sep_acct_eoy_amt / insurance_gen_acct_eoy_amt / govt_sec_eoy_amt / corp_debt_eoy_amt / common_stock_eoy_amt / employer_securities_eoy_amt / real_estate_eoy_amt / interest_bearing_cash_eoy_amt / participant_loans_eoy_amt | Plan-level balance-sheet asset-category totals at end of year (Schedule H Part I) — reported in aggregate on the form itself, not as individually-scheduled holdings | Decimal (USD) | Plan Financials |
| firm_name | Name of the asset-management firm (or issuing insurer, for insurance-wrapped vehicles) managing a given fund holding | String | Holdings — Asset Manager |
| vehicle_type | The investment vehicle type for a holding: Mutual Fund, Common Collective Trust, Pooled Separate Account, or Other | String (enum) | Holdings — Asset Manager |
| value_sum | Total AUM held in this firm's funds across all plans, for a fiscal year (and vehicle type) | Decimal (USD) | Holdings — Asset Manager |
| company_ein_cnt / ack_id_cnt | Number of distinct plan sponsors / plan filings holding this firm's (or fund's) products, for a fiscal year | Integer | Holdings — Asset Manager |
| composite_score / composite_rank | BrightScope-style multi-factor composite ranking (0–100) within the peer group for a fiscal year — a blend of scale, footprint/adoption, momentum, diversification/category standing, and (where SEC-matched) performance and cost, each expressed as a percentile | Decimal / Integer | Holdings — Asset Manager |
| fund_name | Name of the individual fund or investment product, as reported on the plan's Schedule of Assets | String | Holdings — Fund |
| avg_rank_in_plan / pct_plans_top10 | The fund's average rank by value within each plan's lineup, and the share of adopting plans where it ranks in the top 10 holdings — conviction signals distinct from raw adoption count | Decimal | Holdings — Fund |
| return_1yr / return_3yr / return_5yr | Trailing 1/3/5-year total return, chained from SEC N-PORT monthly filings (mutual funds only — collective trusts are not SEC-registered and have no return data of their own) | Decimal (%) | Fund Performance |
| net_expense_ratio | Fund's net annual expense ratio, from the SEC Mutual Fund Prospectus Risk/Return Summary data set | Decimal (%) | Fund Performance |
| category_rank_pct | The fund's trailing-1-year-return percentile rank within its canonical peer category (Target Date, Index, Stable Value, Bond/Fixed Income, International, Balanced/Mixed, US Equity Active) | Decimal (%) | Fund Performance |
| firm_names / fund_names | Semicolon-delimited list of every distinct asset-management firm / fund held by a plan in a given filing year — denormalized onto the plan-level rollup for full-text search | String | Holdings — Plan-level |
| has_mutual_fund / has_cct / has_psa / has_other | Whether the plan holds at least one holding of each vehicle type, for a filing year | Boolean | Holdings — Plan-level |
| has_holdings | Whether this plan's Schedule of Assets PDF was successfully extracted into fund-level holdings; false for plans searchable only via their reported financials | Boolean | Holdings — Plan-level |
| fund_count / firm_count | Number of distinct funds / asset-management firms held by the plan in this filing | Integer | Holdings — Plan-level |
| total_comp | Total Schedule C service-provider compensation reported by the plan (direct + indirect), across all named providers combined — not broken out per provider | Decimal (USD) | Service Providers & Fees |
| recordkeeper_names / advisor_names / tpa_names / broker_names / dominant_platform | Semicolon-delimited names of the plan's recordkeeper(s), investment advisor(s), third-party administrator(s), and broker(s), and the plan's dominant recordkeeping platform | String | Service Providers & Fees |
| direct_comp_total / indirect_comp_total | Direct compensation paid by the plan, and indirect compensation (e.g. revenue sharing) received by service providers — plan-level totals, not attributed to a single provider | Decimal (USD) | Service Providers & Fees |
| crd | The SEC/FINRA Central Registration Depository number identifying a registered investment adviser firm — the canonical key linking a Schedule C advisor name to its Form ADV profile | String | Advisor / RIA |
| regulatory_aum / discretionary_aum | The advisor firm's total assets under management across ALL of its clients (not just 401(k) plans on this platform), and the discretionary portion, per its Form ADV filing | Decimal (USD) | Advisor / RIA |
| plan_count_401k / plan_aum_401k_serviced | Number of 401(k) plans, and total plan AUM, where this advisor firm is named on Schedule C — derived from Form 5500 data, distinct from its regulatory AUM above | Integer / Decimal (USD) | Advisor / RIA |
| num_iars / num_offices / main_office_state | Number of advisory staff (Form ADV Item 5.B(1)) and offices, and the state of the firm's main office | Integer / String | Advisor / RIA |
| score_total | Plan Score — a peer-benchmarked 0–100 rating blending six components: Total Plan Cost, Company Generosity, Participation Rate, Salary Deferral, Account Balances, and Investment Menu Quality, each measured against a same-size peer group. An analytical benchmark, not investment advice | Decimal | Plan Score |
| score_cost / score_generosity / score_participation / score_deferral / score_balances | The five peer-benchmarked Plan Score sub-components (0–100 each), excluding the absolute (non-peer-percentile) Investment Menu Quality component | Decimal | Plan Score |
| peer_n | Number of similarly-sized plans (by AUM and participant count) used as the peer group for this plan's Plan Score percentiles | Integer | Plan Score |
| aftap_pct | Adjusted Funding Target Attainment Percentage — the key defined-benefit plan funding-health metric (Schedule SB), plan assets as a percentage of the funding target | Decimal (%) | DB Pension Funding |
| funding_target_amt / plan_assets_amt / funding_gap_amt | The plan's actuarial funding target, its actual asset value, and the gap (or surplus) between them | Decimal (USD) | DB Pension Funding |
| at_risk_flag / critical_status_flag | Whether the plan is classified "at-risk" or in "critical status" funding zones under ERISA/PPA rules | Boolean | DB Pension Funding |
| actuary_firm_name | Name of the plan's enrolled actuary firm, as reported on Schedule SB | String | DB Pension Funding |
| canonical_ein / canonical_pn | The most-recent EIN and plan number in a cross-EIN plan succession chain (e.g. a plan that changed sponsor EIN through M&A or re-registration) — lets the same underlying plan be recognized across its full filing history | String | Cross-Plan Lineage |
| Variable Name | Description | Field Type | Category |
|---|---|---|---|
| russell_name | Company name, will only have a value if ticker was in Russell 3000 index during specified datarun_date | String | Public company identifier |
| datarun_date | Date which data was generated as of | Date | Datarun Date |
| company_ein | Company EIN (Employer Identification Number) | String | Firmographic |
| cl_company_legal_name | Company name | String | Firmographic |
| cl_company_address_line1 | Address line 1 | String | Firmographic |
| cl_company_address_line2 | Address line 2 | String | Firmographic |
| cl_company_address_city | City | String | Firmographic |
| cl_company_address_state | State | String | Firmographic |
| cl_company_address_zip5 | Zip code | String | Firmographic |
| cl_industry_code | Form 5500 industry code (based on NAICS) | String | Firmographic (industry) |
| cl_industry_name | Industry name | String | Firmographic (industry) |
| cl_industry_sub_sector_code | Form 5500 industry sub-sector code (based on NAICS) | String | Firmographic (industry) |
| cl_industry_sub_sector_name | Industry sub-sector name | String | Firmographic (industry) |
| cl_industry_sector_code | Form 5500 industry sector code (based on NAICS) | String | Firmographic (industry) |
| cl_industry_sector_name | Industry sector name | String | Firmographic (industry) |
| cl_current_employees_cnt | Number of current employees in a pension or welfare plan | Numeric | Employee count |
| cl_pens_dfn_bnft_tot_active_partcp_cnt | Total active employees eligible for a defined benefit pension plan | Numeric | Employee count |
| cl_pens_dfn_contrib_tot_active_partcp_cnt | Total active employees eligible for a defined contribution pension plan | Numeric | Employee count |
| cl_act_pens_partcp_account_bal_cnt | Total active employees with a balance in a defined contribution pension plan | Numeric | Employee count |
| cl_welf_tot_active_partcp_cnt | Total active participants in a welfare plan | Numeric | Employee count |
| cl_growth_emp_1yr | Growth rate of current employees in a plan, 1 year | Numeric | Employee count |
| cl_growth_emp_3yr | Growth rate of current employees in a plan, 3 year | Numeric | Employee count |
| cl_pens_dfn_contrib_emplr_contrib_per_act_partcp | Company contributions to a defined contribution pension plan per active employee eligible for a defined contribution plan | Numeric | Salary Boost |
| cl_growth_pens_dfn_contrib_emplr_contrib_per_act_partcp_1yr | Growth rate of company contributions to a defined contribution pension plan per active employee eligible for a defined contribution plan, 1 yr | Numeric | Salary Boost |
| cl_growth_pens_dfn_contrib_emplr_contrib_per_act_partcp_3yr | Growth rate of company contributions to a defined contribution pension plan per active employee eligible for a defined contribution plan, 3 yr | Numeric | Salary Boost |
| cl_pens_dfn_contrib_emplr_contrib_per_act_partcp_bal | Company contributions to a defined contribution pension plan per active employee with a balance in a defined contribution plan | Numeric | Salary Boost |
| cl_growth_pens_dfn_contrib_emplr_contrib_per_act_partcp_bal_1yr | Growth rate of company contributions to a defined contribution pension plan per active employee with a balance in a defined contribution plan, 1 yr | Numeric | Salary Boost |
| cl_growth_pens_dfn_contrib_emplr_contrib_per_act_partcp_bal_3yr | Growth rate of company contributions to a defined contribution pension plan per active employee with a balance in a defined contribution plan, 3 yr | Numeric | Salary Boost |
| cl_pens_dfn_contrib_partcp_contrib_per_act_partcp | Participant contributions to a defined contribution pension plan per active employee eligible for a defined contribution plan | Numeric | Salary Deferral |
| cl_growth_pens_dfn_contrib_partcp_contrib_per_act_partcp_1yr | Growth rate of participant contributions to a defined contribution pension plan per active employee eligible for a defined contribution plan, 1 yr | Numeric | Salary Deferral |
| cl_growth_pens_dfn_contrib_partcp_contrib_per_act_partcp_3yr | Growth rate of participant contributions to a defined contribution pension plan per active employee eligible for a defined contribution plan, 3 yr | Numeric | Salary Deferral |
| cl_pens_dfn_contrib_partcp_contrib_per_act_partcp_bal | Participant contributions to a defined contribution pension plan per active employee with a balance | Numeric | Salary Deferral |
| cl_growth_pens_dfn_contrib_partcp_contrib_per_act_partcp_bal_1yr | Growth rate of participant contributions to a defined contribution pension plan per active employee with a balance, 1 yr | Numeric | Salary Deferral |
| cl_growth_pens_dfn_contrib_partcp_contrib_per_act_partcp_bal_3yr | Growth rate of participant contributions to a defined contribution pension plan per active employee with a balance, 3 yr | Numeric | Salary Deferral |
| cl_pens_dfn_contrib_contrib_amt_per_act_partcp | Total (Company + Participant) contributions to a defined contribution pension plan per active employee eligible for a defined contribution plan | Numeric | Salary Boost + Salary Deferral |
| cl_pens_dfn_contrib_contrib_amt_per_act_partcp_bal | Total (Company + Participant) contributions to a defined contribution pension plan per active employee with a balance in a defined contribution plan | Numeric | Salary Boost + Salary Deferral |
| cl_pens_dfn_contrib_emplr_contrib_perc | Company contributions as percentage of total contributions to a defined contribution pension plan | Numeric | Salary Boost Ratio |
| cl_pens_dfn_contrib_act_partcp_perc | Defined contribution pension plan participation rate (active employees only) | Numeric | Pension Plan Participation Rate |
| cl_pens_auto_enroll_pln_payroll_ded_ind | Company has a defined contribution pension plan with automatic enrollment feature | Boolean | Pension Plan Participation Rate |
| cl_pens_dfn_bnft_net_assets | Pension plan net assets in a defined benefit pension plan | Numeric | Pension plan net assets |
| cl_pens_dfn_contrib_net_assets | Pension plan net assets in a defined contribution pension plan | Numeric | Pension plan net assets |
| cl_growth_pens_dfn_contrib_net_assets_1yr | Growth rate of pension plan net assets in a defined contribution pension plan, 1 yr | Numeric | Pension plan net assets |
| cl_growth_pens_dfn_contrib_net_assets_3yr | Growth rate of pension plan net assets in a defined contribution pension plan, 3 yr | Numeric | Pension plan net assets |
| cl_pens_dfn_contrib_net_assets_per_partcp_bal | Pension plan net assets in a defined contribution plan per participant with a balance | Numeric | Pension plan net assets |
| cl_growth_pens_dfn_contrib_net_assets_per_partcp_bal_1yr | Growth rate of pension plan net assets in a defined contribution plan per participant with a balance, 1 yr | Numeric | Pension plan net assets |
| cl_growth_pens_dfn_contrib_net_assets_per_partcp_bal_3yr | Growth rate of pension plan net assets in a defined contribution plan per participant with a balance, 3 yr | Numeric | Pension plan net assets |
| cl_pens_plan_ind | Pension plan(s) indicator | Boolean | Pension plan offerings |
| cl_pens_defined_bnft_pens_ind | Defined benefit pension plan indicator | Boolean | Pension plan offerings |
| cl_pens_defined_contrib_pens_ind | Defined contribution pension plan indicator | Boolean | Pension plan offerings |
| cl_welf_plan_ind | Welfare plan(s) indicator | Boolean | Welfare benefit offerings |
| cl_welf_health_ins_ind | Health plan indicator | Boolean | Welfare benefit offerings |
| cl_welf_life_ins_ind | Life insurance plan indicator | Boolean | Welfare benefit offerings |
| cl_welf_supp_unemploy_ind | Supplemental unemployment insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_dental_ins_ind | Dental insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_vision_ins_ind | Vision insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_temp_dis_ins_ind | Temporary disability insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_prepaid_legal_ind | Prepaid legal insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_long_term_dis_ins_ind | Long term disability insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_sev_pay_ind | Severance pay indicator | Boolean | Welfare benefit offerings |
| cl_welf_scholarship_funded_ind | Scholarship (funded) indicator | Boolean | Welfare benefit offerings |
| cl_welf_death_benefits_ind | Death benefits indicator | Boolean | Welfare benefit offerings |
| cl_welf_taft_hartley_fin_assist_ind | Taft-Hartley financial assistance indicator | Boolean | Welfare benefit offerings |
| cl_welf_other_ben_ind | Other welfare benefit indicator | Boolean | Welfare benefit offerings |
| cl_fail_transmit_contrib_ind | Plan (pension or welfare) has failed to transmit contributions indicator | Boolean | Risk/Compliance related (Governance) |
| cl_fail_provide_benefit_due_ind | Plan (pension or welfare) has failed to provide benefit due indicator | Boolean | Risk/Compliance related (Governance) |
| cl_dfvc_program_ind | Plan in DFVC program (Delinquent Filer Voluntary Compliance program) indicator | Boolean | Risk/Compliance related (Governance) |
| cl_amended_ind | Amended plan indicator | Boolean | Risk/Compliance related (Governance) |
| Variable Name | Description | Field Type | Category |
|---|---|---|---|
| ticker | Company ticker | String | Public company identifier |
| datarun_date | Date which data was generated as of | Date | Public company identifier |
| russell_ticker | Company ticker, will only have a value if ticker was in Russell 3000 index during specified datarun_date | String | Public company identifier |
| russell_name | Company name, will only have a value if ticker was in Russell 3000 index during specified datarun_date | String | Public company identifier |
| company_ein | Company EIN (Employer Identification Number) | String | Firmographic |
| cl_company_legal_name | Company name | String | Firmographic |
| cl_industry_code | Form 5500 industry code (based on NAICS) | String | Firmographic (industry) |
| cl_industry_name | Form 5500 Industry name | String | Firmographic (industry) |
| cl_industry_sub_sector_code | Form 5500 industry sub-sector code (based on NAICS) | String | Firmographic (industry) |
| cl_industry_sub_sector_name | Form 5500 Industry sub-sector name | String | Firmographic (industry) |
| cl_industry_sector_code | Form 5500 industry sector code (based on NAICS) | String | Firmographic (industry) |
| cl_industry_sector_name | Form 5500 Industry sector name | String | Firmographic (industry) |
| cl_pens_age_old_plan | Age of oldest pension plan (in years) | Numeric | Firmographic |
| cl_welf_age_old_plan | Age of oldest welfare plan (in years) | Numeric | Firmographic |
| cl_age_old_plan | Age of oldest plan (in years) | Numeric | Firmographic |
| cl_last_filing_rcvd_date | Date most recent filing was received | Date | Date Stamp |
| cl_pens_last_filing_rcvd_date | Date most recent pension plan filing was received | Date | Date Stamp |
| cl_welf_last_filing_rcvd_date | Date most recent welfare plan filing was received | Date | Date Stamp |
| cl_mths_last_filing_rcvd | Months since most recent filing was received | Numeric | Other |
| cl_pens_mths_last_filing_rcvd | Months since most recent pension filing was received | Numeric | Other |
| cl_welf_mths_last_filing_rcvd | Months since most recent welfare filing was received | Numeric | Other |
| cl_last_filing_period_end_date | Date of most recent plan year end date | Date | Other |
| cl_pens_last_filing_period_end_date | Date of most recent plan year end date for a pension plan | Date | Other |
| cl_welf_last_filing_period_end_date | Date of most recent plan year end date for a welfare plan | Date | Other |
| cl_welf_plan_ind | Has welfare plan(s) | Boolean | Welfare benefit offerings |
| cl_welf_health_ins_ind | Health plan | Boolean | Welfare benefit offerings |
| cl_welf_life_ins_ind | Life insurance plan | Boolean | Welfare benefit offerings |
| cl_welf_supp_unemploy_ind | Supplemental unemployment insurance | Boolean | Welfare benefit offerings |
| cl_welf_dental_ins_ind | Dental insurance | Boolean | Welfare benefit offerings |
| cl_welf_vision_ins_ind | Vision insurance | Boolean | Welfare benefit offerings |
| cl_welf_temp_dis_ins_ind | Temporary disability insurance | Boolean | Welfare benefit offerings |
| cl_welf_prepaid_legal_ind | Prepaid legal insurance | Boolean | Welfare benefit offerings |
| cl_welf_long_term_dis_ins_ind | Long term disability insurance | Boolean | Welfare benefit offerings |
| cl_welf_sev_pay_ind | Severance pay | Boolean | Welfare benefit offerings |
| cl_welf_apprentice_training_ind | Apprenticeship and training | Boolean | Welfare benefit offerings |
| cl_welf_scholarship_funded_ind | Scholarship (funded) | Boolean | Welfare benefit offerings |
| cl_welf_death_benefits_ind | Death benefits | Boolean | Welfare benefit offerings |
| cl_welf_taft_hartley_fin_assist_ind | Taft-Hartley financial assistance | Boolean | Welfare benefit offerings |
| cl_welf_other_ben_ind | Other welfare benefit | Boolean | Welfare benefit offerings |
| cl_pens_plan_ind | Has pension plan(s) | Boolean | Pension plan offerings |
| cl_pens_defined_bnft_pens_ind | Defined benefit pension plan | Boolean | Pension plan offerings |
| cl_pens_defined_contrib_pens_ind | Defined contribution pension plan | Boolean | Pension plan offerings |
| cl_pens_benefits_pay_related_ind | Defined benefit pension plan- benefits are primarily pay related | Boolean | Pension plan characteristics |
| cl_pens_benefits_flat_dollar_ind | Defined benefit pension plan- benefits are primarily flat dollar | Boolean | Pension plan characteristics |
| cl_pens_cash_balance_plan_ind | Defined benefit pension plan- cash balance | Boolean | Pension plan characteristics |
| cl_pens_closed_by_pbgc_ind | Defined benefit pension plan- closed by PBGC | Boolean | Pension plan characteristics |
| cl_pens_plan_frozen_ind | Defined benefit pension plan- frozen plan | Boolean | Pension plan characteristics |
| cl_pens_age_service_wgt_plan_ind | Defined contribution pension plan-employer contributions based on age, service years, or compensation level of participants | Boolean | Pension plan characteristics |
| cl_pens_tgt_benefit_plan_ind | Defined contribution pension plan-target benefit plan | Boolean | Pension plan characteristics |
| cl_pens_money_purch_non_tgt_ben_ind | Defined contribution pension plan-money purchase plan | Boolean | Pension plan characteristics |
| cl_pens_offset_plan_ind | Defined contribution pension plan-Offset plan for which plan benefits are subject to offset for retirement benefits provided in another plan or arrangement of the employer | Boolean | Pension plan characteristics |
| cl_pens_prft_sharing_ind | Defined contribution pension plan- profit sharing | Boolean | Pension plan characteristics |
| cl_pens_tot_partic_direct_acct_ind | Defined contribution pension plan- total participant-directed account plan | Boolean | Pension plan characteristics |
| cl_pens_part_partic_direct_plan_ind | Defined contribution pension plan- partial participant-directed account plan | Boolean | Pension plan characteristics |
| cl_pens_stock_bonus_ind | Defined contribution pension plan-stock bonus | Boolean | Pension plan characteristics |
| cl_pens_cd_section_401k_ind | Defined contribution pension plan-401(k) feature | Boolean | Pension plan characteristics |
| cl_pens_cd_section_403b1_ind | Defined contribution pension plan-403(b)(1) arrangement | Boolean | Pension plan characteristics |
| cl_pens_cd_esop_non_leveraged_ind | Defined contribution pension plan-ESOP other than a leveraged ESOP | Boolean | Pension plan characteristics |
| cl_pens_leveraged_esop_ind | Defined contribution pension plan-leveraged ESOP | Boolean | Pension plan characteristics |
| cl_pens_partic_direct_brok_acct_opt_ind | Defined contribution pension plan-participant-directed brokerage accounts provided as an investment option under the plan | Boolean | Pension plan characteristics |
| cl_pens_auto_enroll_pln_payroll_ded_ind | Defined contribution pension plan-401(k) plan or 403(b) plan that provides for automatic enrollment in plan that has elective contributions deducted from payroll | Boolean | Pension plan characteristics |
| cl_pens_tot_part_partic_dir_acct_pln_ind | Defined contribution pension plan-total or partial participant-directed account plan | Boolean | Pension plan characteristics |
| cl_pens_plan_req_invest_empl_sec_ind | Pension plan-plan requires that all or part of employer contributions be invested and held, at least for a limited period, in employer securities | Boolean | Pension plan characteristics |
| cl_current_employees_cnt | Number of current employees in a pension or welfare plan | Numeric | Employee count |
| cl_pens_fail_transmit_contrib_ind | Pension plan has failed to transmit contributions | Boolean | Risk/Compliance related |
| cl_welf_fail_transmit_contrib_ind | Welfare plan has failed to transmit contributions | Boolean | Risk/Compliance related |
| cl_fail_transmit_contrib_ind | Plan (pension or welfare) has failed to transmit contributions | Boolean | Risk/Compliance related |
| cl_pens_fail_provide_benefit_due_ind | Pension plan has failed to provide benefit due | Boolean | Risk/Compliance related |
| cl_welf_fail_provide_benefit_due_ind | Welfare plan has failed to provide benefit due | Boolean | Risk/Compliance related |
| cl_fail_provide_benefit_due_ind | Plan (pension or welfare) has failed to provide benefit due | Boolean | Risk/Compliance related |
| cl_dfvc_program_ind | Plan in DFVC program (Delinquent Filer Voluntary Compliance program) | Boolean | Risk/Compliance related |
| cl_amended_ind | Amended plan | Boolean | Risk/Compliance related |
| cl_plan_ins_fdlty_bond_ind | Plan (pension or welfare) with fidelity bond | Boolean | Risk/Compliance related |
| cl_pens_prft_shar_no_emplr_contrib_ind | Pension plan with profit sharing indicator but no employer contribution | Boolean | Pension contributions |
| cl_pens_emplr_neg_contrib_ind | Pension plan with negative employer contributions | Boolean | Pension contributions |
| cl_pens_emplr_contrib_ind | Pension plan with employer contribution | Boolean | Pension contributions |
| cl_welf_only_ind | Company only has filings for welfare plans | Boolean | Welfare benefit offerings |
| cl_pens_only_ind | Company only has filings for pension plans | Boolean | Pension plan offerings |
| cl_welf_plans_ct | Count of welfare plan filings | Numeric | Welfare benefit offerings |
| cl_pens_plans_ct | Count of pension plan filings | Numeric | Pension plan offerings |
| cl_pens_net_assets | Pension plan net assets | Numeric | Pension net assets |
| cl_pens_dfn_bnft_net_assets | Pension plan net assets in a defined benefit pension plan | Numeric | Pension net assets |
| cl_pens_dfn_contrib_net_assets | Pension plan net assets in a defined contribution pension plan | Numeric | Pension net assets |
| cl_pens_emplr_contrib_amt | Pension plan company contributions | Numeric | Pension contributions |
| cl_pens_dfn_bnft_emplr_contrib_amt | Pension plan company contributions to a defined benefit pension plan | Numeric | Pension contributions |
| cl_pens_dfn_contrib_emplr_contrib_amt | Pension plan company contributions to a defined contribution pension plan | Numeric | Pension contributions |
| cl_pens_partcp_contrib_amt | Pension plan participant contributions | Numeric | Pension contributions |
| cl_pens_dfn_bnft_partcp_contrib_amt | Pension plan participant contributions to a defined benefit pension plan | Numeric | Pension contributions |
| cl_pens_dfn_contrib_partcp_contrib_amt | Pension plan participant contributions to a defined contribution pension plan | Numeric | Pension contributions |
| cl_pens_contrib_amt | Pension plan total (company + participant) contributions | Numeric | Pension contributions |
| cl_pens_dfn_bnft_contrib_amt | Pension plan total (company + participant) contributions to a defined benefit pension plan | Numeric | Pension contributions |
| cl_pens_dfn_contrib_contrib_amt | Pension plan total (company + participant) contributions to a defined contribution pension plan | Numeric | Pension contributions |
| cl_pens_tot_active_partcp_cnt | Total active employees eligible for a pension plan | Numeric | Employee count |
| cl_pens_dfn_bnft_tot_active_partcp_cnt | Total active employees eligible for a defined benefit pension plan | Numeric | Employee count |
| cl_pens_dfn_contrib_tot_active_partcp_cnt | Total active employees eligible for a defined contribution pension plan | Numeric | Employee count |
| cl_pens_tot_act_rtd_sep_benef_cnt | Total employees eligible for a pension plan | Numeric | Employee count |
| cl_pens_partcp_account_bal_cnt | Total employees with a balance in a defined contribution pension plan | Numeric | Employee count |
| cl_pens_dfn_contrib_net_assets_per_partcp_bal | Pension plan net assets in a defined contribution plan per participant | Numeric | Per employee statistics |
| cl_pens_pln_net_asset_per_partic | Pension plan net assets per employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_emplr_contrib_per_act_partcp | Company pension contributions per active employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_dfn_bnft_emplr_contrib_per_act_partcp | Company pension contributions to a defined benefit plan per active employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_partcp_contrib_per_act_partcp | Participant pension contributions per active employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_dfn_contrib_contrib_amt_per_act_partcp | Total (company+ participant) contributions to a defined contribution pension plan per active employee eligible for a defined contribution plan | Numeric | Per employee statistics |
| cl_pens_dfn_contrib_emplr_contrib_per_act_partcp | Company contributions to a defined pension plan per active employee eligible for a defined contribution plan | Numeric | Per employee statistics |
| cl_pens_emplr_contrib_per_partcp | Company pension contributions per employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_partcp_contrib_per_partcp | Participant pension contributions per employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_contrib_per_act_partcp | Total (company+ participant) pension contributions per active employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_contrib_per_partcp | Total (company + participant) pension contributions per employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_welf_tot_act_rtd_sep_benef_cnt | Total participants in a welfare plan | Numeric | Employee count |
| cl_welf_tot_active_partcp_cnt | Total active participants in a welfare plan | Numeric | Employee count |
| cl_thrive_score | Growth metrics encapsulating how companies have grown over the years | Numeric | Aggregated growth metrics |
| Variable Name | Description | Field Type | Category |
|---|---|---|---|
| company_ein | Company EIN (Employer Identification Number) | String | Firmographic |
| russell_ticker | Company ticker, will only have a value if ticker was in Russell 3000 index during the datarun_date | String | Firmographic |
| cl_company_legal_name | Company name | String | Firmographic |
| cl_industry_code | Form 5500 industry code (based on NAICS) | String | Firmographic (industry) |
| cl_industry_name | Industry name | String | Firmographic (industry) |
| cl_industry_sub_sector_code | Form 5500 industry sub-sector code (based on NAICS) | String | Firmographic (industry) |
| cl_industry_sub_sector_name | Industry sub-sector name | String | Firmographic (industry) |
| cl_industry_sector_code | Form 5500 industry sector code (based on NAICS) | String | Firmographic (industry) |
| cl_industry_sector_name | Industry sector name | String | Firmographic (industry) |
| cl_company_address_city | Address line 1 | String | Firmographic |
| cl_company_address_line1 | Address line 2 | String | Firmographic |
| cl_company_address_line2 | City | String | Firmographic |
| cl_company_address_state | State | String | Firmographic |
| cl_company_address_zip5 | Zipcode | String | Firmographic |
| cl_company_phone | Phone number | String | Firmographic |
| cl_age_old_plan | Age of oldest plan (in years) | Numeric | Firmographic |
| cl_year | Year of data (absolute year) | Date | Date Stamp |
| cl_yrn | Year of data (relative year) | Date | Date Stamp |
| cl_last_filing_rcvd_date | Date most recent filing was received | Date | Date Stamp |
| cl_welf_plan_ind | Welfare plan(s) indicator | Boolean | Welfare benefit offerings |
| cl_welf_health_ins_ind | Health plan indicator | Boolean | Welfare benefit offerings |
| cl_welf_life_ins_ind | Life insurance plan indicator | Boolean | Welfare benefit offerings |
| cl_welf_supp_unemploy_ind | Supplemental unemployment insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_dental_ins_ind | Dental insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_vision_ins_ind | Vision insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_temp_dis_ins_ind | Temporary disability insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_prepaid_legal_ind | Prepaid legal insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_long_term_dis_ins_ind | Long term disability insurance indicator | Boolean | Welfare benefit offerings |
| cl_welf_sev_pay_ind | Severance pay indicator | Boolean | Welfare benefit offerings |
| cl_welf_scholarship_funded_ind | Scholarship (funded) indicator | Boolean | Welfare benefit offerings |
| cl_welf_death_benefits_ind | Death benefits indicator | Boolean | Welfare benefit offerings |
| cl_welf_taft_hartley_fin_assist_ind | Taft-Hartley financial assistance indicator | Boolean | Welfare benefit offerings |
| cl_welf_other_ben_ind | Other welfare benefit indicator | Boolean | Welfare benefit offerings |
| cl_pens_plan_ind | Pension plan(s) indicator | Boolean | Pension plan offerings |
| cl_pens_defined_bnft_pens_ind | Defined benefit pension plan indicator | Boolean | Pension plan offerings |
| cl_pens_defined_contrib_pens_ind | Defined contribution pension plan indicator | Boolean | Pension plan offerings |
| cl_current_employees_cnt | Number of current employees in a pension or welfare plan | Numeric | Employee count |
| cl_fail_transmit_contrib_ind | Plan (pension or welfare) has failed to transmit contributions indicator | Boolean | Risk/Compliance related |
| cl_fail_provide_benefit_due_ind | Plan (pension or welfare) has failed to provide benefit due indicator | Boolean | Risk/Compliance related |
| cl_dfvc_program_ind | Plan in DFVC program (Delinquent Filer Voluntary Compliance program) indicator | Boolean | Risk/Compliance related |
| cl_amended_ind | Amended plan indicator | Boolean | Risk/Compliance related |
| cl_plan_ins_fdlty_bond_ind | Plan (pension or welfare) with fidelity bond indicator | Boolean | Risk/Compliance related |
| cl_pens_emplr_contrib_ind | Pension plan with employer contribution indicator | Boolean | Pension contributions |
| cl_pens_net_assets | Pension plan net assets | Numeric | Pension net assets |
| cl_pens_dfn_bnft_net_assets | Pension plan net assets in a defined benefit pension plan | Numeric | Pension net assets |
| cl_pens_dfn_contrib_net_assets | Pension plan net assets in a defined contribution pension plan | Numeric | Pension net assets |
| cl_pens_emplr_contrib_amt | Pension plan company contributions | Numeric | Pension contributions |
| cl_pens_dfn_bnft_emplr_contrib_amt | Pension plan company contributions to a defined benefit pension plan | Numeric | Pension contributions |
| cl_pens_dfn_contrib_emplr_contrib_amt | Pension plan company contributions to a defined contribution pension plan | Numeric | Pension contributions |
| cl_pens_partcp_contrib_amt | Pension plan participant contributions | Numeric | Pension contributions |
| cl_pens_dfn_bnft_partcp_contrib_amt | Pension plan participant contributions to a defined benefit pension plan | Numeric | Pension contributions |
| cl_pens_dfn_contrib_partcp_contrib_amt | Pension plan participant contributions to a defined contribution pension plan | Numeric | Pension contributions |
| cl_pens_contrib_amt | Pension plan total (company + participant) contributions | Numeric | Pension contributions |
| cl_pens_dfn_bnft_contrib_amt | Pension plan total (company + participant) contributions to a defined benefit pension plan | Numeric | Pension contributions |
| cl_pens_dfn_contrib_contrib_amt | Pension plan total (company + participant) contributions to a defined contribution pension plan | Numeric | Pension contributions |
| cl_pens_tot_active_partcp_cnt | Total active employees eligible for a pension plan | Numeric | Employee count |
| cl_pens_dfn_bnft_tot_active_partcp_cnt | Total active employees eligible for a defined benefit pension plan | Numeric | Employee count |
| cl_pens_dfn_contrib_tot_active_partcp_cnt | Total active employees eligible for a defined contribution pension plan | Numeric | Employee count |
| cl_pens_tot_act_rtd_sep_benef_cnt | Total employees eligible for a pension plan | Numeric | Employee count |
| cl_pens_partcp_account_bal_cnt | Total employees with a balance in a defined contribution pension plan | Numeric | Employee count |
| cl_pens_dfn_contrib_net_assets_per_partcp_bal | Pension plan net assets in a defined contribution plans per participant | Numeric | Per employee statistics |
| cl_pens_pln_net_asset_per_partic | Pension plan net assets per employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_emplr_contrib_per_act_partcp | Company pension contributions per active employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_dfn_bnft_emplr_contrib_per_act_partcp | Company pension contributions to a defined benefit plan per active employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_partcp_contrib_per_act_partcp | Participant pension contributions per active employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_dfn_contrib_contrib_amt_per_act_partcp | Total (company + participant) contributions to a defined pension plan per active employee eligible for a defined contribution plan | Numeric | Per employee statistics |
| cl_pens_dfn_contrib_emplr_contrib_per_act_partcp | Company contributions to a defined pension plan per active employee eligible for a defined contribution plan | Numeric | Per employee statistics |
| cl_pens_emplr_contrib_per_partcp | Company pension contributions per employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_partcp_contrib_per_partcp | Participant pension contributions per employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_contrib_per_act_partcp | Total (company + participant) pension contributions per active employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_contrib_per_partcp | Total (company + participant) pension contributions per employee eligible for a pension plan | Numeric | Per employee statistics |
| cl_pens_dfn_contrib_partcp_perc | Defined contribution pension plan participation rate | Numeric | Employee count |
| cl_welf_tot_act_rtd_sep_benef_cnt | Total participants in a welfare plan | Numeric | Employee count |
| cl_welf_tot_active_partcp_cnt | Total active participants in a welfare plan | Numeric | Employee count |
| cl_growth_emp_1yr | Growth rate of current employees in a plan, 1 year | Numeric | Growth |
| cl_growth_emp_3yr | Growth rate of current employees in a plan, 3 year | Numeric | Growth |
| cl_growth_pens_contrib_1yr | Growth rate of total (company + participant) pension contributions, 1 year | Numeric | Growth |
| cl_growth_pens_contrib_3yr | Growth rate of total (company + participant) pension contributions, 3 year | Numeric | Growth |
| cl_growth_pens_partcp_contrib_1yr | Growth rate of participant pension contributions, 1 year | Numeric | Growth |
| cl_growth_pens_partcp_contrib_3yr | Growth rate of participant pension contributions, 3 year | Numeric | Growth |
| cl_growth_pens_emplr_contrib_1yr | Growth rate of company pension contributions, 1 year | Numeric | Growth |
| cl_growth_pens_emplr_contrib_3yr | Growth rate of company pension contributions, 3 year | Numeric | Growth |
| cl_growth_pens_emplr_contrib_per_act_partcp_1yr | Growth rate of company pension contributions per active employee eligible for a pension plan, 1 year | Numeric | Growth |
| cl_growth_pens_emplr_contrib_per_act_partcp_3yr | Growth rate of company pension contributions per active employee eligible for a pension plan, 3 year | Numeric | Growth |
| cl_growth_pens_partcp_contrib_per_act_partcp_1yr | Growth rate of participant pension contributions per active employee eligible for a pension plan, 1 year | Numeric | Growth |
| cl_growth_pens_partcp_contrib_per_act_partcp_3yr | Growth rate of participant pension contributions per active employee eligible for a pension plan, 3 year | Numeric | Growth |