Skip Navigation Archive: U.S. Department of Health and Human Services U.S. Department of Health and Human Services
Archive: Agency for Healthcare Research Quality www.ahrq.gov
Archival print banner

This information is for reference purposes only. It was current when produced and may now be outdated. Archive material is no longer maintained, and some links may not work. Persons with disabilities having difficulty accessing this information should contact us at: https://info.ahrq.gov. Let us know the nature of the problem, the Web address of what you want, and your contact information.

Please go to www.ahrq.gov for current information.

Affordability of Insurance: Application of ACA Definitions in a Linked Employee-Employer Data Set

AHRQ's 2012 Annual Conference Slide Presentation

On September 10, 2012, G. Edward Miller, Thomas M. Selden, and Jessica Vistnes made this presentation at the 2012 Annual Conference.

Select to access the PowerPoint® presentation (1.4 MB).

Slide 1

Text Description is below the image.

Affordability of Insurance: Application of ACA Definitions in a Linked Employee-Employer Data Set

G. Edward Miller
Thomas M. Selden
Jessica P. Vistnes

AHRQ Conference September 10, 2012

Slide 2

Text Description is below the image.

Affordable Care Act (ACA)

  • The ACA will expand access to health insurance by:
    • Subsidizing Exchange coverage (139-400% FPL).
    • Expanding Medicaid (≤138% FPL).
  • Research has found a relationship between employers' insurance decisions and alternative forms of coverage for employees.
    • Spousal offers of ESI.
    • Public coverage.
  • The ACA will present employers with important new sources of insurance coverage to consider.

Slide 3

Text Description is below the image.

Important Information to Assess the ACA

  • Important categories of Modified Adjusted Gross Family Income (MAGI) in the ACA.
    • ≤138% FPL (Medicaid eligible).
    • 139-250% FPL (Large Exchange Subsidy).
    • 251-400% FPL (Small Exchange Subsidy).
    • >400% FPL (No Subsidy).
  • Important to know:
    • Within-employer distribution of workers' MAGI.
    • Alternative sources of coverage.
    • Premiums.
  • No nationally representative data set has all required data.

Slide 4

Text Description is below the image.

Employer-Sim Model

  • Synthetic workforces:
    • Use household data on workers to 'populate' establishment-level data on employers and their health insurance plans.
  • Medical Expenditure Panel Survey (MEPS) Insurance Component (IC):
    • 2010 data on private establishments.
    • Out-of-Pocket (OOP) premiums for all plans offered.
  • MEPS Household Component (HC):
    • 2005-2007: pooled data on workers and their families.
    • MAGI: constructed per ACA rules, CPI-adjusted to 2010 $s.

Slide 5

Text Description is below the image.

Linking Workers to Establishments

Variable CategoryLevel / Type of Information Used
LocationState, Census region / division
Industry2 Digit NAICS / collapsed codes
Multi-location firm?Y/N indicator
Establishment sizeNumber of employees in ranges
Establishment offers insurance?Y/N indicator

  • Draw a sample of 300+ workers that match each establishment on these characteristics.
  • Include 100+ low, medium and high wage workers.
  • Workers are sampled with replacement.

Slide 6

Text Description is below the image.

Raking Workers Weights

Variable CategoryLevel / Type of Information Used
Sex% Female
Age% Age 50 plus
Union% In union
Wage% Low, medium, high wage
Fulltime% Fulltime

  • 0/1 variables for MEPS HC workers.
  • Percent distributions in MEPS IC establishments.
  • Iteratively adjust MEPS HC sample weights until worker characteristics match estab. % distributions.

Slide 7

Text Description is below the image.

Synthetic Workforces

  • Synthetic workforces (in principle) can be used to examine any employee/family characteristic from the MEPS HC.
  • Quality depends on correlation between the HC characteristic and variables used in linking and raking.
    • We do not provide standard errors, which could be quite large given the multiple sources of data and imperfections in the synthetic match.
  • Modified adjusted gross incomes are strongly related to many of the variables available to construct synthetic workforces.

Slide 8

Text Description is below the image.

Goals

  • Estimate how many employers have a majority of workers who are income-eligible for ACA-related coverage.
  • Within predominantly subsidy-eligible firms, examine the degree of variation in workers' incomes.
  • Examine issues related to the affordability of insurance.

Slide 9

Text Description is below the image.

Stratify Analysis by Firm-Size

  • Large firms (50+ full-time workers):
    • Subject to fines if at least one full-time employee gets subsidized Exchange coverage.
  • Small firms (<50 full-time workers):
    • No penalties for employees accessing Exchange coverage.
    • Tax credits for some firms with <25 workers (started in 2010).

Slide 10

Text Description is below the image.

Distribution of establishments, by workers' family income, 2010

Distribution
of Establishments
Small FirmsLarge Firms
Offering ESINot OfferingOffering ESI
Total estabs (millions)1.92.41.5
Majority of workers withPercent of Establishments
MAGI >400% FPL52.823.440.5
MAGI <400% FPL47.276.659.5
MAGI 139 to 400% FPL37.960.447.8

Source: Authors' calculations using data from the Employer-Sim Model. Estimates are weighted by MEPS-IC establishment weights. We did not estimate standard errors for point estimates from our simulation model.

Slide 11

Text Description is below the image.

Distribution of incomes for full-time, eligible workers in establishments that offer ESI, 2010

Distribution of IncomesPercent of workers within-establishment by income
(MAGI as percentage of FPL)
≤138%139-150%251-400%>400%
Majority of workers withSmall Firms
MAGI >400% FPL1.910.320.567.3
MAGI <400% FPL7.225.832.035.0
MAGI 139 to 400% FPL6.921.733.432.6
Majority of workers withLarge Firms
MAGI >400% FPL2.010.821.765.5
MAGI <400% FPL9.128.328.933.7
MAGI 139 to 400% FPL8.829.929.931.4

Source: Authors' calculations using data from the Employer-Sim Model. Estimates are weighted by MEPS-IC establishment weights. We did not estimate standard errors for point estimates from our simulation model.

Slide 12

Text Description is below the image.

Affordability of Insurance

  • ACA definition of affordability:
    • OOP premium for single coverage <9.5% of MAGI.
  • Our definition of affordable dependent coverage:
    • Dependent coverage if offered.
    • OOP premium for dependent coverage <9.5% of MAGI.
  • Use the Employer-Sim Model to examine affordability.
    • Re-weight the data to produce worker-level estimates.
    • Focus on workers with MAGI between 139-400% FPL.
      • Potentially eligible for subsidized Exchange coverage.

Slide 13

Text Description is below the image.

Affordability (continued)

  • For full-time workers with MAGI 139-400% FPL, who are offered insurance, we examine the percent of workers with:
    • Affordable single coverage (legal ACA definition).
    • 'Affordable' dependent coverage from own employer.
  • Examine options for workers with "unaffordable" dependent coverage:
    • Spousal offer of ESI.
    • Children eligible for public coverage with premium.

Slide 14

Text Description is below the image.

Affordability of Dependent Coverage

  • Determine needed coverage for each family member:
    • Assume persons ≤138% FPL, children with free public coverage, and persons with Medicare or Tricare do not need ESI.
    • Others are assumed to need ESI provided by the worker.
  • Count the number of persons in workers' health insurance eligibility unit (HIEU) who need ESI:
    • Caveat: MEPS HIEU definition does not account for new ACA rules for dependents up to age 26.
  • Calculate OOP premium, from own employer, to cover all who need ESI.
  • Determine whether OOP premium <9.5% of MAGI.

Slide 15

Text Description is below the image.

Distribution of OOP Premiums: Workers with MAGI 139%-400% FPL, 2010

Firm SizeFull-time, eligible workers with dependents
MeanPercentile of the OOP premium distribution
10th25th50th75th90th95th
Single coverage
Small firms98400600150025005900
Large firms8040300700110016003500
Dependent coverage**
Small firms38330031006200910011,200
Large firms332280017002800430065008200

 Source: Authors' calculations using data from the Employer-Sim Model. Estimates are weighted by MEPS-IC worker-level weights. We did not estimate standard errors for point estimates from our simulation model.
**Premiums for dependent coverage are conditional on an offer of dependent coverage.

Slide 16

Text Description is below the image.

Affordability of Single ESI: Workers with MAGI 139%-400% FPL, 2010

Worker CharacteristicsFull-time, eligible workers with dependents
Percentile of the OOP premium distribution
All estabsMajority
139-400%
All estabsMajority
139-400%
Small firmsLarge firms
Total workers (millions)2.71.510.45.2
Average family income30,99830,18230,42728,744
Lowest OOP single premium10021095815858
% lacking affordable single coverage8.810.73.03.9

Source: Authors' calculations using data from the Employer-Sim Model. Estimates are weighted by MEPS-IC worker-level weights. We did not estimate standard errors for point estimates from our simulation model.

Slide 17

Text Description is below the image.

Affordability of Single ESI: Workers with MAGI 139%-400% FPL, 2010

Worker CharacteristicsFull-time, eligible workers with dependents
Within-establishment distribution of family income
All workersMajority
139-400%
All workersMajority
139-400%
Small firmsLarge firms
Total workers (millions)3.21.512.15.5
Average family income52,97151,00252,79850,564
Lowest OOP single premium9841111804853
% lacking affordable single coverage2.53.00.70.9

Source: Authors' calculations using data from the Employer-Sim Model. Estimates are weighted by MEPS-IC worker-level weights. We did not estimate standard errors for point estimates from our simulation model.

Slide 18

Text Description is below the image.

Affordability of Dependent ESI: Workers with MAGI 139%-400% FPL, 2010

Affordability of Dependent ESIFull-time, eligible workers with dependents
Within-establishment distribution of family income
All workersMajority
139-400%
All workersMajority
139-400%
Small firmsLarge firms
Percent of workers
Lacking affordable dependent coverage41.442.016.619.4
   Not offered dependent coverage7.88.20.40.7
   Offered but not affordable33.633.816.218.7

Source: Authors' calculations using data from the Employer-Sim Model. Estimates are weighted by MEPS-IC worker-level weights. We did not estimate standard errors for point estimates from our simulation model.

Slide 19

Text Description is below the image.

Alternative sources of dependent coverage: Workers with MAGI 139%-400% FPL, 2010

Alternative sourcesFull-time, eligible workers in small firms with dependents who lack affordable dependent coverage
Within-establishment distribution of family income
All workersMajority
139-400%
All workersMajority
139-400%
Dependent Cov. OfferedDependent Cov. Not Offered
Percent of workers
Spouse offer***31.433.335.038.3
Children eligible32.233.925.6260.7
No spouse offer or eligible children46.639.645.041.17

  Source: Authors' calculations using data from the Employer-Sim Model. Estimates are weighted by MEPS-IC worker-level weights. We did not estimate standard errors for point estimates from our simulation model.
***Workers may have both a spousal offer and eligible children, so percentages do not sum to 100%.

Slide 20

Text Description is below the image.

Limitations

  • We do not calculate standard errors (SEs).
  • Appropriate SEs must account for multiple sources of variance:
    • Matching of MEPS-HC workers to MEPS-IC establishments.
    • Using samples of MEPS-HC workers to estimate summary statistics for each establishment.
    • Sampling variation in the MEPS-IC.
  • Relative standard errors (RSEs) for our point estimates are likely to be large.
  • Additional sources of error are attributable to the HC-IC linkage process.

Slide 21

Text Description is below the image.

Summary

  • ACA-related incentives raise important considerations for private employers regarding the provision of ESI.
    • Many establishments have a majority of workers who are income-eligible for Medicaid or Exchange coverage.
  • Within-firm heterogeneity in workers' incomes complicates employers' decisions.
  • Most workers with MAGI 139-400% FPL have access to affordable single coverage.
    • We estimate that about 750,000 workers lacked affordable single coverage in 2010.
  • For those with lack of access to 'affordable' dependent coverage.
  • Nearly half lacked an alternative source of dependent coverage.

Slide 22

Text Description is below the image.

Further Work

  • Evaluate the affordability of dependent coverage using all available sources:
    • Worker's ESI.
    • Spouse's ESI.
    • Children's eligibility for public insurance.
  • Evaluate workers' net benefits of Exchange coverage by comparing costs of moving to the Exchange with the costs of the most affordable alternative.
  • Examine the within-establishment concentration of workers who would benefit from Exchange coverage.
Page last reviewed December 2012
Internet Citation: Affordability of Insurance: Application of ACA Definitions in a Linked Employee-Employer Data Set: AHRQ's 2012 Annual Conference Slide Presentation. December 2012. Agency for Healthcare Research and Quality, Rockville, MD. https://archive.ahrq.gov/news/events/conference/2012/track_f/01_miller_vistnes/miller.html

 

The information on this page is archived and provided for reference purposes only.

 

AHRQ Advancing Excellence in Health Care