CWCI Interactive Applications Updated Through AY 2021
Updates to the CWCI Claims Monitoring, Prescription Drug, MTUS Formulary, and Regional Scorecard interactive applications, featuring IRIS data on California workers’ compensation claims through AY 2021 are posted under the Research tab on our website. The applications listed below offer detailed data that can be used to examine and compare industry data on key metrics and are available exclusively to CWCI members who use their registered email and password to log on to www.cwci.org.
The Claims Monitoring App: This application allows users to access data on average paid indemnity and medical losses on claims from AY 2009 through AY 2021 at nine levels of development, ranging from 3 to 72 months, with payments valued through December 2021. The tool provides results for indemnity claims or for all claims, allows data to be viewed for specific industries and regions, and categorizes medical payment data into medical treatment, pharmacy, medical-legal services, medical cost containment and other medical. Heat maps and graphics automatically adjust to display the results as users toggle through the specific options from the drop-down menus to change their global selections.
The Prescription Drug App: This application can be used to identify trends and compare industrywide data on prescription drugs dispensed to injured workers between January 2007 and December 2021. Claim level data allows users to examine prescription drug utilization by accident year at six levels of development, and service-level data allows users to look at prescription drugs dispensed during calendar years 2007 to 2021. Dashboards allow users to build custom views of statewide or regional pharmaceutical data for all claims or indemnity claims, and the global selection settings and drop down menus allow users to see results at different levels of development; for open and/or closed claims; for specific drug groups; for generic and/or brand drugs; by opioid drug name; by industry; and for specific accident years or service years. As users choose specific metrics to view, the accompanying tables and charts automatically display the results, with regional data provided in color-coded heat maps.
The MTUS Formulary App: This application displays the medications within each version of the MTUS Prescription Drug Formulary grouped by their formulary category: Exempt, Non-Exempt, Not Listed; Special Fill, and Perioperative. Users can identify which drugs were added to or dropped from the formulary and when; easily find where approximately 100 therapeutic drug groups and hundreds of specific drugs have been categorized; track changes in prescription and payment distributions among the formulary categories beginning with pre-formulary years (CY 2016 and 2017) and extending into the post-formulary years beginning with CY 2018; find the average wholesale price (AWP) and average amount paid for specific drugs (by drug ingredient) over time; and view lists of the top 20 drugs by formulary category, broken out either by calendar year or by formulary version.
The Regional Scorecard App: This application features IRIS data on 19 key metrics derived from AY 2009 through AY 2021 claims, with statewide and regional results available for comparison. The app includes data on average medical, indemnity and other payments (including breakdowns showing average paid TD and PD, allocated loss adjustment expense, and data on demographics, claim status, and claim volume). Users may also drill down to view results for specific injury years and industries.
Accessing the Apps: CWCI member company employees may log on to www.cwci.org with their user name and password (those who don’t have an account may select “Your Account” at the top of the home page, click “Add Me as a Member User” from the pull-down menu, complete the form, then use that info to log in). Once logged in, users can go to the drop-down menu under the Research tab, click Interactive Research Tools and open the app they want. As new data becomes available, CWCI will update the apps.