AIS’s Employer Health Plan Database and Directories: 2012

Contents

Abridged Table of Contents – CD

Technical Information

Executive Summary.pdf

Directories Folder (PDF)

• Directory of Multi-Employer Plan Sponsors, Insured (126 pages) — Includes filings by multiemployer, multiple employer, direct filing entities, and collectively bargained health plans — with address, phone number, administrator name, total number of plan participants, number of employers, and collectively bargained indicator, plus list of their contracted insurance carriers with plan types, claims paid and premiums received
• Directory of Single Employer Plan Sponsors, Insured (1,171 pages) — Includes filings by single employer plans — with address, phone number, administrator name, total number of plan participants, plus list of their contracted insurance carriers with plan types, claims paid and premiums received
• Directory of Multi-Employer Plans, Self Insured (52 pages) — Includes filings by multiemployer, multiple employer, direct filing entities, and collectively bargained health plans—with address, phone number, administrator name, total number of plan participants, number of employers, and collectively bargained indicator, plus list of their contracted plan administrators and claims processing service providers
• Directory of Single Employer Plans, Self Insured (559 pages) — Includes filings by single employer plans—with address, phone number, administrator name, total number of plan participants, plus list of their contracted plan administrators and claims processing service providers
• Directory of Employers by State (2,568 pages) — Includes filings by all employers—with plan name, address, phone number, number of plan participants, industry, administrator name and applicable benefit funding arrangements, plus a list of health insurance carriers contracted to provide benefits for plan year 2010.
• Directory of Insurance Carriers, With Employer Clients (969 pages) — Includes health insurance carriers serving employers filing Form 5500 for 2010 plan year—with list of employers served, with location, phone number, number of participants for each employer. Does not include address/contact information; see AIS’s Directory of Health Plans: 2012
• Directory of Third Party Administrators (33 pages) — Includes third party administrators serving employers filing Form 5500 for 2010 plan year—with address, plus list of employers served, with total annual commissions and fees reported by each
• Directory of Insurance Brokers and Agents (2,106 pages) — Includes insurance brokers and agents serving employers filing Form 5500 for 2010 plan year—with address and phone number, plus list of employers served, with total annual commissions and fees reported by each
• Directory of Service Providers (6 pages) — Includes claims processors and plan administrators serving employers filing Form 5500 for 2010 plan year—with address, plus list of employers served

Spreadsheets Folder (Excel 2010)

• Executive Summary — Full spreadsheets of all tables and charts displayed in the Executive Summary
• Multiemployer Plans
• Multiemployer plans (4,291 raw records of multiemployer plans with contact information and various data)
• New plans (that began enrolling participants in 2010)
• Plans ranked by total number of active participants (end of year)
• Membership change (from beginning to end of year)
• Industry (multiemployer participants, from beginning to end of year)
• State (multiemployer participants by state, from beginning to end of year)
• Insured (3,712 raw records of multiemployer plans with links to carriers)
• Self-Insured (2,020 raw records of multiemployer plans with links to service providers)
• Single Employer Plans
• Single employer plans (42,520 raw records of single employer plans with contact data and various data)
• New plans (that began enrolling participants in 2010)
• Plans ranked by total number of active participants (end of year)
• Membership change (from beginning to end of year)
• Industry (multiemployer participants, from beginning to end of year)
• State (multiemployer plan participants by state, from beginning to end of year)
• Insured (35,808 raw records of multiemployer plans with links to carriers)
• Self-Insured (22,194 raw records of multiemployer plans with links to service providers)
• Health Insurance Carriers
• Insurance carriers (53,993 raw records of carriers linked to employer health plan clients), with number of members covered under contract, broker commissions/fees, premiums and claims
• Links to carriers as published in AIS’s Directory of Health Plans: 2012, with mailing address and MCO ID number (for linking to ERISA carrier records)
• Carriers with total number of plan participants and total number of employer group health clients
• Number of participants and clients by industry
• Number of participants by state, by carrier
• Carriers ranked by amount of claims paid in 2010
• Carriers ranked by amount of premiums received in 2010
• Third Party Administrators
• Vendors identified as TPAs by their employer clients
• TPAs linked to employer group health clients
• TPAs ranked by employer clients, participants in employer/client plans and commissions/fees
• Brokers
• 91,101 raw records of vendors identified as insurance brokers or agents by their employer clients
• Brokers linked to employer group health clients
• Insurance brokers and agents ranked by plan participants and commissions/fees
• Service Providers
• 1,009 raw records of vendors identified as claims processors or administrators by their employer clients
• Claims processors and administrators linked to employer group health clients
• Mailing Lists
  Includes mailing list data points in convenient format without extraneous data:
• All employers with company name, address, city, state, zip, phone and names of individuals signing the form submission as Administrator and/or as Sponsor
• Multiemployer and single employer insured and self-insured employers with company name, address, city, state, zip, phone and names of individuals signing the form submission as Administrator and/or as Sponsor
• Third party administrators with company name, address, city, state, zip
• Brokers and agents with company name, address, city, state, zip
• Claims processors with company name, address, city, state, zip

Click here for a detailed listing of the data on the CD (5-page PDF file). Files on the CD are in .xlsx, .pdf and.docx formats.

Table of Contents – Executive Summary

Highlights

Employer Health Plan Sponsors

• Multiemployer Plans
• Top 100 Multiemployer Health Plan Sponsors With Insured Plans, by Number of Active Participants, 2010
• Top 100 Multiemployer Health Plan Sponsors With Self-Insured Plans, Ranked by Number of Active Participants, 2010
• Top 50 Multiemployer Health Plan Sponsors by Change in Number of Participants Beginning of Year to End of Year
• New Multiemployer Health Plans That Began Reporting Membership During Plan Year 2010
• Single Employer Plans
• Top 100 Single Employer Health Plan Sponsors With Insured Plans, by Number of Active Participants, 2010
• Top 100 Single Employer Health Plan Sponsors With Self-Insured Plans, Ranked by Number of Active Participants, 2010
• Top 50 Single Employer Health Plan Sponsors by Change in Number of Participants Beginning of Year to End of Year
• Top 25 New Single Employer Health Plans That Began Reporting Membership During Plan Year 2010
• Employer Health Plan Data by Industry
• Number of Multiemployer Plan Participants and Sponsors by Industry
• Number of Single Employer Plan Participants and Sponsors by Industry
• Percentage of Plan Participants by Industry—Multiemployer Plans, End of Year 2010
• Percentage of Plan Participants by Industry—Single Employer Plans, End of Year 2010
• Change in Number of Plan Participants During 2010 by Industry—Multiemployer Plans
• Change in Number of Plan Participants During 2010 by Industry—Single Employer Plans
• Employer Health Plan Data by Geographic Location
• Number of Multiemployer Plan Participants by State, Beginning of Year/End of Year
• Number of Multiemployer Health Plan Sponsors by State
• Number of Single Employer Plan Participants by State, Beginning of Year/End of Year
• Number of Single Employer Health Plan Sponsors by State

Health Insurance Carriers Serving Employer-Sponsored Plans

• Top 50 Insurance Carriers by Employer Clients' Total Number of Plan Participants
• Top 50 Insurance Carriers Ranked by Number of Employer Clients Reporting
• Sample: Selected Major Insurance Carriers With Rankings of Industries Served by
• Number of Plan Participants
• Sample: Selected Major Insurance Carriers With Ranking of States Served by
• Number of Plan Participants
• Top 25 Insurance Carriers by Amount of Claims Paid for Plan Year 2010, as Reported by
• Employer Clients
• Top 25 Insurance Carriers by Amount of Premiums Received for Plan Year 2010, as
• Reported by Employer Clients

Third Party Administrators Serving Employer-Sponsored Plans

• Top 50 TPAs by Number of Participants in Employer/Client Plans
• Top 25 TPAs Ranked by Number of Employer Clients
• Top 50 TPAs by Amount of Commissions and Fees Reported for Plan Year 2010

Insurance Brokers Serving Employer-Sponsored Plans

• Top 50 Insurance Brokers by Clients' Total Number of Plan Participants
• Top 50 Insurance Brokers by Total Commissions and Fees Reported by Clients

Appendix A: Background on ERISA Law and Data Collection Process

Appendix B: How to Use AIS’s Employer Health Plan Databases and Directories: 2012

Appendix C: Methodology and Disclaimers

Appendix D: Sample Pages from All Eight Directories Provided on CD

Data Fields

• Employer Data—Company Name, Contact Data, Industry, Employer ID Number, Names of individuals identified as Administrator Signed Name and Sponsor Signed Name, Type of Plan/Filing Entity, etc.
• Contact Data—Specific Mailing Lists with Company Name, Individual Name, Local Address/City/State/Zip, Telephone—for Employer-Sponsored Health Benefits and for Third-Party Administrators, Brokers and other Vendors that served them in providing benefit for the 2010 plan year.
• Plan Structure Data—Identifying whether plans are Collectively Bargained, Number of Contributing Employers, Funding and Benefit Types (insured/self-funded)
• Enrollment Data—Number of Active Participants (employees, dependents and retirees) at the Beginning and End of the 2010 plan year, for employers offering health benefits
• Insurance Carrier Data Per Employer Plan Sponsor—Number of Covered Members, Policy Start/End Dates, Plan Types-HMO/PPO/Indemnity. PLUS Financial Details for the Contract, for the applicable plan year—Premiums Received ($), Earned Premium Amount ($), Claims Paid ($), Claims Charged Amount ($)
• Vendor Compensation Data—Commissions and Fees paid to TPAs and Brokers by each Employer Plan Sponsor.
• Links from Employer Plan Sponsors to Contracted Carriers, TPAs and other Vendors—Direct links listing contracted carriers, TPAs, Brokers, etc. for each Employer-Sponsored Plan. Links to Insurance Carriers coordinated with ID field from AIS’s Directory of Health Plans database (sold separately).

Methodology

This product is based on U.S. Dept. of Labor data sets showing results from Form 5500, Form 5500-SF, Schedule A and Schedule C, filed by employers as of March 15, 2012, applicable to plan year 2010.

AIS has extracted just the data specific to health insurance benefits, and we have applied our expertise to understanding and analyzing this data in ways that we hope will be useful to our health insurance audience—including health plans, third-party administrators, consultants and vendors serving the health insurance industry.

Data in AIS’s Employer Health Plan Database and Directories are filed and submitted electronically to the Dept. of Labor by employer health plan sponsors with varying degrees of understanding of the questions asked on the forms. AIS obtains the data in its raw form and has observed myriad data integrity issues due to data entry errors, incomplete records, and occasionally flagrant disregard for accuracy on the part of employer plan sponsors. Records with insufficient or incompatible data in any given field may not be picked up by any analyses that are dependent on that field. When, in the course of analyzing and outputting the data, AIS analysts observe obviously inaccurate or conflicting data, that data is deleted from the data set so as not mislead users or skew totals. Nevertheless, AIS cannot guarantee the accuracy or veracity of any of the data displayed in this product, nor of the results obtained from analysis of this data.

Due to data integrity issues noted above, some employer health plans may be excluded from the directories or charts that are applicable to their plan type, and some employer health plans may be inadvertently included in directories or charts that are not relevant to their plan type. Likewise, carriers, third party administrators, brokers and other service providers may be misidentified by their employer clients with incorrect or incomplete names, EIN numbers, service type or contact information, resulting in these companies being excluded from appropriate directories or charts, or inadvertently included in directories or charts that are not relevant to the service they provide.

Definitions

• Multiemployer plans are those that have filed a Form 5500 and are designated in the Labor Dept. data as multiemployer groups, Direct Filing Entities (DFEs) or multiple-employer groups that are collectively bargained. Actual funding and benefit arrangements may vary.
• Single employer plans are employers that have filed either a Form 5500 or a Form 5500-SF and are designated in the Labor Dept. data sets as a single employer plan, or a multiple-employer plan that is not collectively bargained. Actual funding and benefit arrangements may vary. These plans are not collectively bargained.
• Insured plans are those that have indicated an insured benefit arrangement on their Form 5500 (line 9b). In applications where plans are linked to carriers, these links are identified via accompanying Schedule A filings listing detail on the health insurance carriers that contracted with the plan during the plan year, for plans flagged via “health benefits,” “HMO” or “PPO,” or “indemnity” indicators. Includes trusts.
• Self-insured plans are those that indicated a self-funded benefit arrangement on their Form 5500. In applications where plans are linked to TPAs, brokers or other service providers, these links are identified via accompanying Schedule C listing detail on vendors that have been flagged by the employer as claims processors or plan administrators.
• Total Active Participants may include employees that are participating in employee benefits that are not specifically the health insurance benefit, for instance they may participate in a plan that includes health insurance and other benefits, but not be signed up to the health insurance plan specifically.

Written By

AIS’s Employer Health Plan Database and Directories was designed and assembled by Susan Namovicz-Peat, who has been managing AIS’s Directory of Health Plans for more than 10 years and is one of the nation’s foremost health business database researchers. It is produced by Atlantic Information Services, Inc., which has been serving health care business leaders for more than 25 years with timely business and regulatory news, specialized data and strategic information.

Written For

• Health plans and market consultants seeking competitive intelligence and leads in their markets … to identify targets by size, industry, geography, funding arrangement or premiums paid.
• Employer HR departments seeking competitive intelligence on health benefits to use in planning benefit offerings, negotiating with carriers, shopping for vendors or benchmarking their plan participation and costs.
• Health insurance market analysts and benefit consultants who need to track trends in coverage by industry, plan membership size, funding arrangement, premiums paid or geography.
• Policymakers, media and researchers trying to understand the number of people who are insured under commercial employer-based health plans … by industry, region or plan size.
• IT companies and other vendors that market their products and services to employer HR departments, health insurers, third party administrators or brokers. (Mailing lists, provided in convenient Excel spreadsheets, list addresses and phone numbers for all entities, and the name of Plan Administrators for employer entities.)

AIS Guarantee

Order AIS’s Employer Health Plan Database and Directories for a 30-day risk-free inspection and test for yourself the value of this highly practical resource. If within 30 days you're not interested in keeping it, just return it to AIS and we will send you a prompt, full refund or credit. Refunds will not be made once the seal on the CD package has been broken. Please review your copy of the printed Executive Summary prior to breaking the seal.

Shipping Information

This item is shipped via UPS. Please give us your street address when you order (UPS does not deliver to PO boxes.) You should receive your order within 5-7 business days. Shipping and handling cost is $12 per item.

Rush orders: Please call us at 800-521-4323 to place a rush order. We will overnight your order for an additional charge of $45, or you can give us your FedEx or UPS account number and we will charge the shipping to your account. Rush orders placed after 3:00pm EST will not be shipped out until the next business day.

View Sample (PDF)

• Sample spreadsheet – multiemployer data
• Sample spreadsheet – single employer
• Sample directory page – Third Party Administrators
• Detailed list of CD contents