URSA-PHARM-101: Oral Antidiabetic PDC

  • Published on Apr 10, 2026
  • 9 minute(s) read
Prev Next

Measure Description

Among patients with a continuous period of plan membership of 180 days or longer in the 12 months prior to a snapshot date, and with 2 or more antidiabetic medication fills during that membership period, the percentage of days between the first qualifying fill and the earlier of the snapshot date or membership period end date with positive supply of antidiabetic medication

Metadata

  • Measure Identifier: URSA-PHARM-101
  • Measure Type: Rate Measure
  • Temporal Structure: Entity
  • Component Class: Long-Form
  • Denominator Case Field: Patient ID
  • Target Direction: Up

Denominator Description

One per qualifying patient

Numerator Description

The antidiabetic medication PDC for the period from the first qualifying fill to the snapshot date or the end of the continuous membership period, whichever comes first

Published Fields

  • Data Model Keys

    • Patient ID -- The internal database identifier (used, e.g., for joins and primary keys) for the patient. This value is typically mastered, i.e., all records for the same patient, regardless of the source data system from which that record originated, should have the same Patient ID value. (Note that while the mastered Patient ID value might resemble a local identifier used in one of the upstream data sources, this does not indicate any special priority of that source system in determining the characteristics of the patient.) (See also [URSA-CORE] Patient)
    • Episode ID
    • Primary Payor ID -- The internal database identifier (used, e.g., for joins and primary keys) for the Primary Payor. (See also [URSA-CORE] Primary Payor)
    • Primary Plan ID -- The identifier for the health insurance plan product that is the first party responsible for payment.
    • First Fill Document ID
    • Second Fill Document ID
    • Primary Plan Attributee Provider ID
    • Empirical Attributee Primary Care Individual Provider ID
    • Empirical Attributee Primary Care Provider Group Provider ID

  • Date Fields

    • Reference Date
    • First Fill Filled Date
    • Second Fill Filled Date
    • PDC Numerator Period Start Date
    • PDC Numerator Period End Date
    • Truncated Continuous Membership Episode Start Date
    • Truncated Continuous Membership Episode End Date
    • First Fill Supply Exhausted Date
    • Segment Start Date -- The start date of the reporting segment. (See also [URSA-CORE] Reporting Segment)
    • Segment End Date -- The end date of the reporting segment. (See also [URSA-CORE] Reporting Segment)
    • Snapshot Date -- The date, evaluated at 00:00:00 AM, giving the moment the state of the world will be set to for the purposes of an analysis. The snapshot date does not represent the freshness of the data, or the date in real time at which an analysis was executed.

  • Episode Fields

    • Truncated Coverage Episode Length Days
    • Is Guaranteed PDC Below 80 Percent by Second Fill
    • Days from First Fill Supply Exhausted to Second Fill
    • PDC Denominator

  • Numerator Fields

    • PDC Numerator Contribution in Days
    • PDC Numerator Contribution Scaled
    • Numerator Supply Period Start Date
    • Numerator Supply Period End Date
    • Numerator Count Distinct Oral Antidiabetics

  • Medication Fields

    • First Fill Label Description
    • First Fill Calendar Date Aggregate Days Supply
    • Second Fill Label Description
    • Second Fill Calendar Date Aggregate Days Supply

  • Insurance Fields

    • Is Any Current Plan Membership
    • Original Membership Episode Start Date
    • Original Membership Episode End Date
    • Primary Payor Description
    • Primary Plan Description
    • Primary Plan Financial Class Description
    • Is Primary Plan Financial Class Commercial
    • Is Primary Plan Financial Class Medicare Advantage
    • Is Primary Plan Financial Class Medicaid
    • Is CMS ESRD Status -- Indicates the patient meets the Medicare ESRD eligibility criterion as of a particular date; can be derived from the CMS Medicare Beneficiary Status Code. (See also [URSA-CORE] CMS Medicare Beneficiary Status Code)
    • Is CMS Hospice Status -- Indicates the patient is considered to be Hospice status.
    • Is Dual Medicare-Medicaid Enrolled -- Indicates that the patient is concurrently enrolled in both Medicare and Medicaid programs. (Identifies the population often described as "dually eligible" or "duals".)

  • Patient Fields

    • Is Patient Alive
    • Patient Date of Birth -- The patient's date of birth. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the date of birth found on that particular type of record in the source data.
    • Patient Age Integer -- Patient age, expressed as an integer, as of a reference date or interval.
    • Is 3+ Hospital IP Admissions Last 12 Months
    • Is 3+ ED Visits Last 12 Months
    • Patient Sex Category
    • Is Patient Sex Female -- Indicates the patient's sex is female. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the patient sex documented on that particular type of record in the source data.
    • Is Patient Sex Male -- Indicates the patient's sex is male. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the patient sex documented on that particular type of record in the source data.
    • Patient Age Category Tier 1 -- Non-overlapping ranges of the patient age in years into three categories; [01] Pediatrics < 19, [02] Adults 19 - 64, and [03] Older Adults >= 65. Coarser grain to the Patient Age Category Tier 2. (See also [URSA-CORE] Patient Age Category Tier 2)
    • Patient Age Category Tier 2 -- Non-overlapping ranges of the patient age in years representing finer grain categories than the Patient Age Category Tier 1. This field incorporates findings from publications on defining meaningful age groups in the context of disease. These ranges closely, but not exactly, align with standard age ranges such as those defined by the Medical Subject Headings (MeSH). See results of K-Means simple clustering method at: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3825015/ (See also [URSA-CORE] Patient Age Category Tier 1)
    • PCP Attribution Category
    • Primary Care Engagement Category
    • Count Hospital Inpatient Admissions in Last 12 Months
    • Count ED Visits Without Inpatient Admissions in Last 12 Months

  • Metadata Fields

    • Is Any Current Data Coverage
    • Random Integer 1 to 1000
    • Is Medical Claim Data Coverage -- Indicates data coverage for medical claims (i.e., institutional and professional claims) from at least one data source for the patient and time period specified on the record. (See also [URSA-CORE] Data Coverage)
    • Is Pharmacy Claim Data Coverage -- Indicates data coverage for pharmacy claims from at least one data source for the patient and time period specified on the record. (See also [URSA-CORE] Data Coverage)

  • Diagnosis Fields

    • CCW Count Category
    • Count CCW Conditions -- The total of both Chronic Conditions and Potentially Disabling Events included in the CMS Chronic Condition Warehouse (CCW) library. (See also [URSA-CORE] CCW Comorbidity Category, [URSA-CORE] Count Potentially Disabling Events, [URSA-CORE] CMS Chronic Condition Warehouse (CCW), [URSA-CORE] Count Chronic Conditions)
    • CCW Systems Category
    • Count CCW Systems -- The count of distinct systems of the body with one or more active CCW Condition. CCW Systems are as a parent category to the individual CCW Conditions grouping them based primarily on the human body system they impact such as; Behavioral Health, Cancers, Cardiovascular, Cerebrovascular, Endocrine, Genitourinary, Musculoskeletal, and Pulmonary. (See also [URSA-CORE] CMS Chronic Condition Warehouse (CCW))
    • Is CCW System Behavioral Health -- Indicates the patient has one or more of the following CCW conditions; ADHD, Conduct Disorders, and Hyperkinetic Syndrome, Anxiety Disorders, Autism Spectrum Disorder, Bipolar Disorder, Depression, Depressive Disorders, Personality Disorders, PTSD, Schizophrenia, or Schizophrenia and Other Psychotic Disorders.
    • Is CCW System Cardiovascular -- Indicates the patient has one or more of the following CCW conditions; Acute Myocardial Infarction (AMI), Atrial Fibrillation, Heart Failure, Hypertension, Ischemic Heart Disease, or Peripheral Vascular Disease (PVD).
    • Is CCW System Congenital -- Indicates the patient has one or more of the following CCW conditions; Cerebral Palsy, Cystic Fibrosis and Other Metabolic Disorder, Intellectual Disability, Learning Disability, Muscular Dystrophy, or Other Developmental Delays.
    • Is CCW System Endocrine/Metabolic -- Indicates the patient has one or more of the following CCW conditions; Diabetes, Acquired Hypothyroidism, Hyperlipidemia, or Obesity.
    • Is CCW System Genitourinary -- Indicates the patient has one or more of the following CCW conditions; Benign Prostatic Hyperplasia or Chronic Kidney Disease (CKD).
    • Is CCW System Hematologic -- Indicates the patient has one or more of the following CCW conditions; Anemia.
    • Is CCW System Musculoskeletal -- Indicates the patient has one or more of the following CCW conditions; Hip or Pelvic Fracture, Rheumatoid Arthritis or Osteoarthritis, or Osteoporosis.
    • Is CCW System Neurological -- Indicates the patient has one or more of the following CCW conditions; Alzheimer's Disease, Alzheimer's Disease and Related Disorders or Senile Dementia, Stroke or Transient Ischemic Attack, Epilepsy, Migraine and Chronic Headache, Mobility Impairment, Multiple Sclerosis, or Deafness and Hearing Impairment.
    • Is CCW System Oncologic -- Indicates the patient has one or more of the following CCW conditions; Breast Cancer, Colorectal Cancer, Endometrial Cancer, Lung Cancer, Prostate Cancer, or Leukemia.
    • Is CCW System Ophthalmologic -- Indicates the patient has one or more of the following CCW conditions; Cataract, Glaucoma, or Blindness and Visual Impairment.
    • Is CCW System Pulmonary -- Indicates the patient has one or more of the following CCW conditions; Asthma, or Chronic Obstructive Pulmonary Disease (COPD) and Bronchiectasis.
    • Is CCW System Other -- Indicates the patient has one or more of the following CCW conditions; Fibromyalgia and Chronic Pain and Fatigue, Pressure or Chronic Ulcer.

  • Provider Fields

    • Count Primary Care Visits in Last 36 Months
    • Primary Plan Attributee Provider Description
    • Primary Plan Attributee Practice Address State Abbreviation
    • Primary Plan Attributee Practice Address ZIP Code 5-Digit
    • Empirical Attributee Primary Care Individual Provider Description
    • Empirical Attributee Primary Care Provider State
    • Empirical Attributee Primary Care Provider Zip

  • Location Fields

    • Patient State Abbreviation
    • Patient ZIP Code 5-Digit
    • UW HIP ADI Quintile Category -- The UW HIP Area Deprivation Index National Percentile grouped into 5 levels, each spanning 20 percentile points (ADI 1 is percentile scores from 1 to 20 while ADI 5 is scores from 81 to 100). Higher scores indicate more deprivation, so ADI 1 is the least deprived while ADI 5 is the most deprived. Quintiles are frequently used in health research. They give larger sample sizes per group and are easier to plot and interpret. Quintiles also carry less information and group more dissimilar patients. Quintiles are good for descriptive analyses while the original percentile measure is preferable for predictive modeling. (See also [URSA-CORE] UW HIP Area Deprivation Index National Percentile)
    • CDC SVI Overall Quintile Category -- The CDC SVI Overall National Percentile grouped into 5 levels, each spanning 20 percentile points (the first quintile is percentile scores from 1 to 20 while the fifth is scores from 81 to 100). Higher scores indicate more vulnerability, so the first quintile is the least vulnerable while the fifth is the most vulnerable. Quintiles are frequently used in health research. They give larger sample sizes per group and are easier to plot and interpret. Quintiles also carry less information and group more dissimilar patients. Quintiles are good for descriptive analyses while the original percentile measure is preferable for predictive modeling.

  • [No Field Group]

    • Ursa Serial ID

  • Measure Fields

    • Denominator