Description: CMS provides ACOs with monthly claims data for members, including their medical visits and ACO program eligibility. This data can be divided into Membership and Claims tables through the ETL process. However, when calculating PMPY at specific levels of detail using these tables, issues arise due to unrelated dimensions, leading to inaccurate and understated results. This article presents a solution to this problem by utilizing Tableau's data blending capabilities.

Description: This 1950 Report on Group Life Insurance death and disability benefits adds experience by number of lives of 1949 to the previous report. This report covers the period between 1946 -1949.

Description: The COVID-19 pandemic has had an impact on all aspects of daily life and its impact extends to how disability incidence may play out in the future. Product profitability will be shaped by how morbidity patterns, interest rate levels and other key drivers will play out into the future. In this session, our panel will discuss COVID’s impact on IDI morbidity experience as observed over the past 18 months, offer comparisons and insights in light of other insurance lines of business, and share emerging information on the on-going effects of Long COVID. Highlights will also include how regional differences and implications for insurers as the industry moves further into the COVID vaccine era.

Description: sources of Health Care data Issue No. 37.

Description: The Society of Actuaries Individual Disability Experience Committee has completed their study of incidence experience for the period 2006-2014 comparing trends to the 2013 IDI Valuation Table (2013 IDIVT) base incidence rates. Included is the report and pivot table.

Description: Documentation Sheet for Database in relation to the 1991-92 Group Medical Insurance Large Claims Database experience study.

Description: This report describes two methods, an observation-based analysis and an actual to model analysis, to analyze long-term care insurance experience to determine if calendar year trends exist.

Description: The Society of Actuaries Individual Disability Experience Committee has completed their study of incidence experience for the period 2006-2014 comparing trends to the 2013 IDI Valuation Table (2013 IDIVT) base incidence rates. Included is the report and pivot table.

Description: Documentation Sheet for Database in relation to the 1991-92 Group Medical Insurance Large Claims Database experience study.

Description: The Group Life Insurance Experience Committee of the Society of Actuaries has completed the 2005 Group Term Life Waiver Reserve Table Report. There were several compelling reasons to develop a new experience study and table, not the least of which was that 35 years is a long interval for any study. This is the excel Calculation Spreadsheet for Reserve Factors for Group Term Waiver of Premium [NAIC version]. Please see the SOA website for the Report of the Group Life Experience Committee for March 2006.