---
title: Pharmacy Care Gaps - Latest Action Statistics
slug: onedash/pharmacy-care-gaps-latest-action-statistics
docTags: 
createdAt: 2025-07-23T19:06:44.503Z
---

## Report Columns

| Column                                     | Description                                                                                                       |
| ------------------------------------------ | ----------------------------------------------------------------------------------------------------------------- |
| LOB                                        | Grouped line of business (PDP, MAPD/EGWP, DSNP)                                                                   |
| Measure                                    | The MedicareStars measure (e.g., DM, RAS, Statin)                                                                 |
| Action                                     | The outreach channel (e.g., Fax, Text, EHR)                                                                       |
| Successful\_Gaps\_with\_Action\_ANYTIME    | Number of successful gaps where this action type was used at any point                                            |
| Total\_Gap\_Count\_with\_Action\_ANYTIME   | Total successful gaps (for this LOB + measure combination); used as denominator for the below Percent calculation |
| Percent\_with\_Action\_ANYTIME             | % of gaps that had this action at any time                                                                        |
| Successful\_Gaps\_with\_Action\_as\_LATEST | Number of gaps where this was the most recent (latest) action                                                     |
| Total\_Gaps\_with\_Action\_as\_LATEST      | Total successful gaps (for this LOB + measure combination); used as denominator for the below Percent calculation |
| Percent\_with\_Action\_as\_LATEST          | % of gaps where this action was the latest recorded                                                               |

## Overview

This report summarizes the most recent successful outreach actions taken on pharmacy-related care gaps across Medicare Stars adherence measures. It evaluates both the **presence of the action per care gap** and whether that action type is **the latest action overall**.

The goal is to understand how different communication types (e.g., fax, text, EHR) are used in closing care gaps, and how that varies by line of business (LOB) and Stars measure.

## Use Case

This report is intended to:

- Quantify what proportion of closed care gaps had a specific outreach method performed
- Identify the most common action types associated with successful gaps
- Compare action performance across LOBs and measures
- Track how often a given action was the **most recent outreach** compared to other actions

## Definitions

| Term               | Description                                                     |
| ------------------ | --------------------------------------------------------------- |
| **Successful Gap** | A care gap with an outcome of `success-auto` or `successful`    |
| **Action Type**    | Channel or mode of outreach (e.g., Text, Fax, EHR, Manual Call) |
| **LOB Grouped**    | Normalized line of business (`PDP`, `MAPD/EGWP`, or `DSNP`)     |
| **Latest Action**  | The most recent outreach action attempted for the intervention  |

## Filtering Criteria

- **Date Range**: The care gap creation date is between January 1 of the current year and current date.
- **Departments/Teams**: Includes only gaps assigned to Pharmacy teams or associated Pharmacy caseworkers.
- **LOBs**: Restricted to `DSNP`, `MAPD`, `EGWP`, and `ND51` (converted to `PDP`).
- **Measures**: Includes the following MedicareStars measures:
  - MedicareStarsDM
  - MedicareStarsRAS
  - MedicareStarsStatin
  - MedicareStarsSUPD
  - MedicareStarsSPC
  - MedicareStarsCOB
  - MedicareStarsPolyACH

## Logic Summary

1. **Identify Pharmacy Interventions**: Filters gaps by team or assignee and ensures the outcome is successful.
2. **Select Most Relevant Actions**: Includes only "sent" actions and filters out unsuccessful manual calls (Left Voicemail, Failed Calls).
3. **Group and Count**: Tallies the number of care gaps that had each action type, both ever and as the latest.
4. **Aggregate by LOB and Measure**: Groups results to enable direct comparisons across business lines and measures.

## Notes

- Manual call types such as "Left Voicemail" and "Failed Call" are excluded from the latest action results.
- The denominator for percentage calculations varies by whether you're counting the action occurring at any point in the care gap life cycle or action occurring last.
- Counts are based only on interventions with a successful outcome and valid action history.