--- title: "URSA-CKD-116: Distinct Refill Dates for CKD Pts on 2+ CKD Meds" slug: "ursa-ckd-116-distinct-refill-dates-for-ckd-pts-on-2-ckd-meds" updated: 2026-10-08T03:13:08Z published: 2026-10-08T03:13:08Z canonical: "docs.ursahealth.com/ursa-ckd-116-distinct-refill-dates-for-ckd-pts-on-2-ckd-meds" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.ursahealth.com/llms.txt > Use this file to discover all available pages before exploring further. # URSA-CKD-116: Distinct Refill Dates for CKD Pts on 2+ CKD Meds ## Measure Description Among patients actively taking two or more chronic medications, the count of distinct upcoming refill dates for those chronic medications ## Metadata - **Measure Identifier**: URSA-CKD-116 - **Measure Type**: Rate Measure - **Temporal Structure**: Entity - **Component Class**: Long-Form - **Denominator Case Field**: Patient ID - **Denominator Observation Fields**: Patient ID, Snapshot Date [, snapshot_date] - **Target Direction**: Down ## Denominator Description One per patient with 2+ chronic medications with remaining supply from their most recent fill, as of the snapshot date ## Numerator Description One per distinct calendar day associated with either the supply exhausted date or the actual refill date (for fills in the past), whichever comes first. ## Published Fields - **Data Model Keys** - Document ID -- The internal database identifier (used, e.g., for joins and primary keys) for the document. (See also [URSA-CORE] Document) - 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) - Filling Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the filling provider. - Prescribing Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the prescribing provider. (See also [URSA-CORE] Prescribing Provider) - Lifetime Medication Treatment Episode ID -- The internal database identifier (used, e.g., for joins and primary keys) for the Lifetime Medication Treatment Episode. (See also [URSA-PHARM] Lifetime Medication Treatment Episode) - Primary Plan ID -- The identifier for the health insurance plan product that is the first party responsible for payment. - 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 Attributee Provider ID - Empirical Attributee Individual Nephrology Provider ID - Empirical Attributee Nephrology Group Provider ID - Empirical Attributee Primary Care Individual Provider ID - Empirical Attributee Primary Care Provider Group Provider ID - **Operations Support Fields** - Prescription Number -- The unique, user-facing (“real-world”) identifier used by operational systems or staff to identify the medication order. (See also [URSA-CORE] Medication Order) - **Patient Fields** - Is Patient Alive - Patient Age Integer -- Patient age, expressed as an integer, as of a reference date or interval. - 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) - Patient Sex Category - Count Hospital Inpatient Admissions in Last 12 Months - Count ED Visits Without Inpatient Admissions in Last 12 Months - Is CKD Stage 4 or 5 - Patient Age Category Tier 3 - Patient Sex - **Date Fields** - Filled Date -- The date a prescription or medication order was filled, with medications dispensed. - Next Medication Synchronization Opportunity Date -- Given a Lifetime Medication Treatment Episode as of a particular moment in time this is the earliest of the (1) next fill date for a medication in that episode; or (2) the date the supply from the most recent prior fill for a medication in that episode will be exhausted. That is, either the next fill date or the next supply exhausted date for a particular chronic medication. Because this is the next time the patient may be at the pharmacy to resupply, this represents the next opportunity to align this medication with the patient's other medications (e.g., by dispensing a one-time, smaller-then-usual amount designed to synchronize with the supply of the patient's other chronic medications, eventually resulting in a single date in which all the patient's medications are exhausted simultaneously). (See also [URSA-PHARM] Lifetime Medication Treatment Episode) - Current Continuous Primary Payor Membership Episode Start Date -- The start date of the Continuous Primary Payor Membership Episode in effect as of the (potentially historical) period covered by the record. (See also [URSA-CORE] Continuous Primary Payor Membership Episode) - Current Continuous Primary Payor Membership Episode End Date -- The end date of the Continuous Primary Payor Membership Episode in effect as of the (potentially historical) period covered by the record. Values follow the standard exclusive convention for Period End Dates. (See also [URSA-CORE] Continuous Primary Payor Membership Episode, [URSA-CORE] Period End Date) - Current Dialysis Episode Start Date - Current Dialysis Episode End Date - Last Continuous Primary Payor Membership Episode End Date -- The end date of the most recent prior completed Continuous Primary Payor Membership Episode as of the (potentially historical) period covered by the record. Values follow the standard exclusive convention for Period End Dates. (See also [URSA-CORE] Continuous Primary Payor Membership Episode, [URSA-CORE] Period End Date) - Last Continuous Primary Payor Membership Episode Start Date -- The start date of the most recent prior completed Continuous Primary Payor Membership Episode as of the (potentially historical) period covered by the record. (See also [URSA-CORE] Continuous Primary Payor Membership Episode) - Current Continuous Medical Claim Data Coverage Episode End Date -- The end date of the Continuous Medical Claim Data Coverage Episode in effect as of the (potentially historical) period covered by the record. Values follow the standard exclusive convention for Period End Dates. (See also [URSA-CORE] Continuous Medical Claim Data Coverage Episode, [URSA-CORE] Period End Date) - Current Continuous Medical Claim Data Coverage Episode Start Date -- The start date of the Continuous Medical Claim Data Coverage Episode in effect as of the (potentially historical) period covered by the record. (See also [URSA-CORE] Continuous Medical Claim Data Coverage Episode) - Current CKD Stage Start Date - Current CKD Stage End Date - uACR Date - Earliest ACE/ARB Fill in Last 12 Months - Earliest Ace Inhibitor Fill in Last 12 Months - Earliest ARB Fill in Last 12 Months - Earliest SGLT2 Fill in Last 12 Months - Earliest nsMRA Fill in Last 12 Months - Earliest Statin Fill in Last 12 Months - 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 Date of Death - 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. - **Provider Fields** - Is Prescribing Provider Empirically Attributed PCP - Prescribing Provider NPI -- The 10-digit National Provider Identifier for the prescribing provider. (See also [URSA-CORE] Prescribing Provider) - Prescribing Provider Description -- The natural language description of the prescribing provider. (See also [URSA-CORE] Prescribing Provider) - Prescribing Practice Address State Abbreviation - Prescribing Practice Address ZIP Code 5-Digit - Filling Provider NPI -- The 10-digit National Provider Identifier for the filling provider. (See also [URSA-CORE] Filling Provider) - Filling Provider Description -- The natural language description of the filling provider. (See also [URSA-CORE] Filling Provider) - Is Filling Provider Mail Order Pharmacy -- Indicates the filling provider is a mail-order pharmacy. (See also [URSA-CORE] Filling Provider) - Is Filling Provider Specialty Pharmacy -- A pharmacy that dispenses generally low volume and high cost medicinal preparations to patients who are undergoing intensive therapies for illnesses that are generally chronic, complex and potentially life threatening. Often these therapies require specialized delivery and administration. - Provider Fill Volume Percentile Rank - Provider Fill Volume Quintile Category - Is Filling Provider Major Chain - Filling Provider Major Chain Description - Filling Provider State Abbreviation - Filling Provider ZIP Code 5-Digit - Filling Provider Primary NUCC Provider Taxonomy Code -- The primary NUCC Provider Taxonomy code for the filling provider. (See also [URSA-CORE] Filling Provider, [URSA-CORE] Primary NUCC Provider Taxonomy Code) - Filling Provider Primary NUCC Provider Taxonomy Description -- The primary NUCC Provider Taxonomy description for the filling provider. (See also [URSA-CORE] Filling Provider, [URSA-CORE] Primary NUCC Provider Taxonomy Description) - Count Primary Care Visits in Last 36 Months - Plan Attributee Provider Description - Count Nephrology Provider Visits in Last 12 Months - Empirical Attributee Individual Nephrology Provider Description - Empirical Attributee Nephrology Group Provider Description - Count Primary Care Visits for CKD in Last 12 Months - Primary Care Engagement Category - Empirical Attributee Primary Care Provider Group Description - Empirical Attributee Individual Primary Care Provider Description - Count Nephrology Provider Visits in Last 6 Months - Count of Visits to Vascular Surgeon or Interventional Radiologist in Last 24 Months - Count Visits with Attributee Individual Primary Care Provider in Last 36 Months - Count Visits with Attributee Primary Care Provider Group in Last 36 Months - Empirical Attributee Individual Nephrology Provider Practice Zip Code - Practice Address ZIP Code 5-Digit - **Location Fields** - Patient State Abbreviation - Patient ZIP Code 5-Digit - Patient County Description - 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) - UW HIP ADI Decile Category - 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. - CDC SVI Socioeconomic Quintile Category -- The CDC SVI Socioeconomic Theme 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. (See also [URSA-CORE] CDC SVI Socioeconomic Theme National Percentile ) - CDC SVI Household / Disability Quintile Category -- The CDC SVI Household/Disability Theme 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. (See also [URSA-CORE] CDC SVI Household / Disability Theme National Percentile ) - CDC SVI Minority / Language Quintile Category -- The CDC SVI Minority/Language Theme 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. (See also [URSA-CORE] CDC SVI Minority / Language Theme National Percentile) - CDC SVI Housing / Transportation Quintile Category -- The CDC SVI Housing/Transportation Theme 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. (See also [URSA-CORE] CDC SVI Housing / Transportation Theme National Percentile) - **Insurance Fields** - Is Any Current Plan Membership - Primary Plan Description - 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) - Primary Plan Financial Class Description - **Clinical Services Fields** - Is Hospice in Last 12 Months -- Evidence of CMS hospice status or evidence of hospice services in the last 12 months. Typically used as a denominator exclusion. - Is Last Dialysis Modality Hemodialysis - Is Last Dialysis Modality Peritoneal Dialysis - **Medication Fields** - Count of Active Chronic Medications - NDC Code 11-Digit -- The standard 11-digit National Drug Code; e.g., 00045012400 = Tylenol 500 mg. - Label Description -- Supplies the name given to the product by the manufacturer. - Is OTC -- Indicates that the medication is an over-the-counter (OTC) drug that does not require a prescription. - Days Supply -- The number of calendar days, including the date the medication was dispensed, the dispensed medication will last at the patient's intended dosage as defined in their prescription. - Calendar Date-LMTE Aggregate Days Supply - Red Book Generic Cross Reference Code -- A unique 6-digit code assigned to all products that contain the same set of active ingredients. By extracting all records containing this code, users can identify comparable products regardless of trade or generic name. (See also [URSA-CORE] Red Book Generic Formulation Code) - Primary Agent Description -- The primary active ingredient in the medication. In medications with multiple active ingredients, this identifies by name only the primary agent. - Red Book Generic Formulation Code -- A unique 6-digit code identifying drugs with common active ingredients, master dosage form, strength, and route of administration. The GFC is not manufacturer or package size specific, and can therefore be used in preparation of drug utilization reports and analysis of generic alternatives for substitution and formulary development. The GFC may also be used within pharmacy and claims administration systems as an efficient means of linking NDC numbers to clinical screening functions. (See also [URSA-CORE] Red Book Generic Cross Reference Code) - Active Ingredients Description -- A natural language description of the medication's biologically active ingredient(s). For medications with multiple active ingredients, the active ingredients should be listed in alphabetical order. - Form Description -- The natural language description of the medication's form. (See also [URSA-CORE] Medication Form) - Route of Administration Description -- The natural language description of the medication's route of administration. - AHFS Therapeutic Class Code 6-Digit -- The standard 6-digit AHFS Pharmacologic-Therapeutic Class Code, representing the first 3 tiers of the AHFS Pharmacologic-Therapeutic Classification system. The code is expressed as 6 numbers, without special characters delimiting the tiers, with leading and trailing zeros as needed. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System) - AHFS Therapeutic Class Tier 1 Description -- The natural language description of the first-tier category within the AHFS Therapeutic Classification System that the medication is assigned to. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System) - AHFS Therapeutic Class Tier 2 Description -- The natural language description of the second-tier category within the AHFS Therapeutic Classification System that the medication is assigned to. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System) - AHFS Therapeutic Class Tier 3 Description -- The natural language description of the third-tier category within the AHFS Therapeutic Classification System that the medication is assigned to. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System) - NCPDP Dispense as Written Code -- The standard 1-digit Dispense as Written (DAW) code developed and maintained by the National Council for Prescription Drug Programs (NCPDP), identifying the types of substitutions, if any, the pharmacy can make when filling the prescription; e.g., 1 = Substitution not allowed by prescriber. - Is CKD ACE/ARB In-Supply Period - Is CKD Ace Inhibitors In-Supply Period - Is CKD ARB In-Supply Period - Is CKD SGLT2 In-Supply Period - Is CKD nsMRA In-Supply Period - Is CKD Statin In-Supply Period - Is CKD ACE/ARB Active Therapy Period - Is CKD SGLT2 Active Therapy Period - Is CKD nsMRA Active Therapy Period - Is CKD Statin Active Therapy Period - **Diagnosis Fields** - 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) - 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 Genitourinary -- Indicates the patient has one or more of the following CCW conditions; Benign Prostatic Hyperplasia or Chronic Kidney Disease (CKD). - 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 Pulmonary -- Indicates the patient has one or more of the following CCW conditions; Asthma, or Chronic Obstructive Pulmonary Disease (COPD) and Bronchiectasis. - Is CCW Acquired Hypothyroidism -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Acute Myocardial Infarction -- At least 1 inpatient claim with one or more of the DX codes from the corresponding CCW value set as the first or second diagnosis position in the prior 1 year. - Is CCW Alzheimers Disease -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 3 years. - Is CCW Anemia -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Anxiety Disorders -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years. - Is CCW Asthma -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Atrial Fibrillation -- At least 1 inpatient OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set as the first or second diagnosis position in the prior 1 year. - Is CCW Benign Prostatic Hyperplasia -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. Exclusion: If any of the qualifying claims also have an ICD-10 DX of D29.1, then it is excluded. - Is CCW Bipolar Disorder -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years. - Is CCW Breast Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in prior 1 year. - Is CCW Cataract -- At least 1 HOP or Carrier claim with one or more of the DX codes from the corresponding CCW value set as the principal diagnosis position in the prior 1 year. - Is CCW CKD -- Indicates that the patient meets the CMS Chronic Condition Warehouse criteria for chronic kidney disease; i.e., 2 or more qualifying outpatient or professional ICD codes in the prior 2 years, or 1 or more non-outpatient institutional claim ICD codes in the prior 2 years. - Is CCW COPD and Bronchiectasis -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Colorectal Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Depression -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Depressive Disorders -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years. - Is CCW Diabetes -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years. - Is CCW Endometrial Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Glaucoma -- At least 1 Carrier claim with one or more of the DX codes from the corresponding CCW value set as the principal diagnosis position in the prior 1 year. - Is CCW Heart Failure -- At least 1 inpatient, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 2 years. - Is CCW Ischemic Heart Disease -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 2 years. - Is CCW Hip or Pelvic Fracture -- At least 1 inpatient or SNF claim with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Hyperlipidemia -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Hypertension -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Lung Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Osteoporosis -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Prostate Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. - Is CCW Rheumatoid Arthritis or Osteoarthritis -- At least 2 inpatient, SNF, HHA, HOP, or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years. - Is CCW Stroke or Transient Ischemic Attack -- At least 1 inpatient OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. EXCLUSIONS: If any of the qualifying claims have : 800 <= DX Code <= 804.9, 850 <= DX Code <= 854.1 in any DX position OR DX V57xx as the principal DX Code, then the claim is excluded. - Is CCW Schizophrenia or Other Psychotic Disorders -- At least 1 inpatient OR 2 other nondrug claims of any service type with one ore more of the DX codes from the corresponding CCW value set in the prior 2 years. - Is First Period with Stage 3b Identified - CCW Count Category - Is CCW Alzheimers Disease and Related Disorders or Senile Dementia -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 3 years. - Is CCW Obesity -- At least 1 inpatient OR 2 non-inpatient claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years. - Is CCW PVD -- At least 1 inpatient OR 2 non-inpatient claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years. - 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 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 Hematologic -- Indicates the patient has one or more of the following CCW conditions; Anemia. - 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 Other -- Indicates the patient has one or more of the following CCW conditions; Fibromyalgia and Chronic Pain and Fatigue, Pressure or Chronic Ulcer. - **Denominator Fields** - Has Patient had at least one eGFR in the Last 12 Months - Has Patient had at least one uACR in the Last 12 Months - **Metadata Fields** - 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) - Random Integer 1 to 1000 - **Validation Only Fields** - Count of Original Fill Records - Supply Exhausted Date - LMTE Medication Next Filled Date - **Measure Fields** - Denominator - Numerator - **Patient Observation Fields** - Last GFR Result Date - Last Race-Adjusted GFR Result Numeric - Is Last Race-Adjusted GFR in CKD Stage 1 Range - Is Last Race-Adjusted GFR in CKD Stage 2 Range - Is Last Race-Adjusted GFR in CKD Stage 3 Range - Is Last Race-Adjusted GFR in CKD Stage 3a Range - Is Last Race-Adjusted GFR in CKD Stage 3b Range - Is Last Race-Adjusted GFR in CKD Stage 4 Range - Is Last Race-Adjusted GFR in CKD Stage 5 Range - uACR Value - **Module Fields** - Count of Active CKD Medications - Is Chronic Medication -- A medication meeting at least one of the following: (1) 3 or more fills over the history of the patient for this or other medications in the same AHFS Therapeutic Class ; (2) 90 or more days supply over the history of the patient for this or other medications in the same AHFS Therapeutic Class - Ingredients Hash -- A coded value used to identify all medication fills sharing active ingredients based on the best available data. The Ingredients Hash is primarily based on mapping the NDC to the Red Book Generic Cross Reference Code but, if not found, takes the first non-missing value from (1) the active ingredients listed in the source data, (2) the label description, (3) the NDC code. (See also [URSA-PHARM] Lifetime Medication Treatment Episode ID, [URSA-CORE] Red Book Generic Cross Reference Code) - Is CKD ACE/ARB - Is CKD Ace Inhibitor - Is CKD ARB - Is CKD SGLT2 - Is CKD nsMRA - Is CKD Statin - Is CKD Medication - CKD Stage Category -- The stage of a patient’s chronic kidney disease (CKD), for stage 1 through stage 5 and ESRD. Stage is only calculated for patients already meeting the criteria for CKD. Stage is determined by a combination of the following: (1) ICD-10-CM codes specific to a particular stage; (2) eGFR lab results within certain bands associated with a stage (see below); (3) identification of the patient in a CMS Monthly Membership Report as an ESRD beneficiary; (4) documentation of a prior kidney transplantation surgery; and/or (5) status as a chronic dialysis patient. The patient’s CKD stage can change over time, so a patient timeline data structure is appropriate. The following eGFR bands are used: GFR >= 90: Stage 1; 60 <= GFR < 90: Stage 2; 30 <= GFR < 60: Stage 3; 15 <= GFR < 30: Stage 4; GFR < 15: Stage 5. The appropriate race-specific eGFR lab is used when the patient's race is known. (See also [URSA-CKD] Is Chronic Dialysis Patient, [URSA-CKD] Kidney Transplantation Surgery Encounter) - Is CKD Stage 1 -- The stage of a patient’s chronic kidney disease (CKD), for stage 1 through stage 5 and ESRD. Stage is only calculated for patients already meeting the criteria for CKD. Stage is determined by a combination of the following: (1) ICD-10-CM codes specific to a particular stage; (2) eGFR lab results within certain bands associated with a stage (see below); (3) identification of the patient in a CMS Monthly Membership Report as an ESRD beneficiary; (4) documentation of a prior kidney transplantation surgery; and/or (5) status as a chronic dialysis patient. The patient’s CKD stage can change over time, so a patient timeline data structure is appropriate. The following eGFR bands are used: GFR >= 90: Stage 1; 60 <= GFR < 90: Stage 2; 30 <= GFR < 60: Stage 3; 15 <= GFR < 30: Stage 4; GFR < 15: Stage 5. The appropriate race-specific eGFR lab is used when the patient's race is known. (See also [URSA-CKD] Is Chronic Dialysis Patient, [URSA-CKD] Kidney Transplantation Surgery Encounter) - Is CKD Stage 2 -- The stage of a patient’s chronic kidney disease (CKD), for stage 1 through stage 5 and ESRD. Stage is only calculated for patients already meeting the criteria for CKD. Stage is determined by a combination of the following: (1) ICD-10-CM codes specific to a particular stage; (2) eGFR lab results within certain bands associated with a stage (see below); (3) identification of the patient in a CMS Monthly Membership Report as an ESRD beneficiary; (4) documentation of a prior kidney transplantation surgery; and/or (5) status as a chronic dialysis patient. The patient’s CKD stage can change over time, so a patient timeline data structure is appropriate. The following eGFR bands are used: GFR >= 90: Stage 1; 60 <= GFR < 90: Stage 2; 30 <= GFR < 60: Stage 3; 15 <= GFR < 30: Stage 4; GFR < 15: Stage 5. The appropriate race-specific eGFR lab is used when the patient's race is known. (See also [URSA-CKD] Is Chronic Dialysis Patient, [URSA-CKD] Kidney Transplantation Surgery Encounter) - Is CKD Stage 3a - Is CKD Stage 3b - Is CKD Stage 4 -- The stage of a patient’s chronic kidney disease (CKD), for stage 1 through stage 5 and ESRD. Stage is only calculated for patients already meeting the criteria for CKD. Stage is determined by a combination of the following: (1) ICD-10-CM codes specific to a particular stage; (2) eGFR lab results within certain bands associated with a stage (see below); (3) identification of the patient in a CMS Monthly Membership Report as an ESRD beneficiary; (4) documentation of a prior kidney transplantation surgery; and/or (5) status as a chronic dialysis patient. The patient’s CKD stage can change over time, so a patient timeline data structure is appropriate. The following eGFR bands are used: GFR >= 90: Stage 1; 60 <= GFR < 90: Stage 2; 30 <= GFR < 60: Stage 3; 15 <= GFR < 30: Stage 4; GFR < 15: Stage 5. The appropriate race-specific eGFR lab is used when the patient's race is known. (See also [URSA-CKD] Is Chronic Dialysis Patient, [URSA-CKD] Kidney Transplantation Surgery Encounter) - Is CKD Stage 5 -- The stage of a patient’s chronic kidney disease (CKD), for stage 1 through stage 5 and ESRD. Stage is only calculated for patients already meeting the criteria for CKD. Stage is determined by a combination of the following: (1) ICD-10-CM codes specific to a particular stage; (2) eGFR lab results within certain bands associated with a stage (see below); (3) identification of the patient in a CMS Monthly Membership Report as an ESRD beneficiary; (4) documentation of a prior kidney transplantation surgery; and/or (5) status as a chronic dialysis patient. The patient’s CKD stage can change over time, so a patient timeline data structure is appropriate. The following eGFR bands are used: GFR >= 90: Stage 1; 60 <= GFR < 90: Stage 2; 30 <= GFR < 60: Stage 3; 15 <= GFR < 30: Stage 4; GFR < 15: Stage 5. The appropriate race-specific eGFR lab is used when the patient's race is known. (See also [URSA-CKD] Is Chronic Dialysis Patient, [URSA-CKD] Kidney Transplantation Surgery Encounter) - Is ESRD -- The stage of a patient’s chronic kidney disease (CKD), for stage 1 through stage 5 and ESRD. Stage is only calculated for patients already meeting the criteria for CKD. Stage is determined by a combination of the following: (1) ICD-10-CM codes specific to a particular stage; (2) eGFR lab results within certain bands associated with a stage (see below); (3) identification of the patient in a CMS Monthly Membership Report as an ESRD beneficiary; (4) documentation of a prior kidney transplantation surgery; and/or (5) status as a chronic dialysis patient. The patient’s CKD stage can change over time, so a patient timeline data structure is appropriate. The following eGFR bands are used: GFR >= 90: Stage 1; 60 <= GFR < 90: Stage 2; 30 <= GFR < 60: Stage 3; 15 <= GFR < 30: Stage 4; GFR < 15: Stage 5. The appropriate race-specific eGFR lab is used when the patient's race is known. (See also [URSA-CKD] Is Chronic Dialysis Patient, [URSA-CKD] Kidney Transplantation Surgery Encounter) - Is CKD Stage Unknown - Is CKD Stage 3 or Higher - Is CKD Stage 4 or Higher - Is Chronic Dialysis Patient -- Indicates that the patient has either (1) documentation in the last 12 months of a chronic dialysis status code; or (2) is currently undergoing regular episode as part of an episode that contains at least one non-inpatient dialysis encounter. - Is History of Kidney Transplantation - Sum of ACE/ARB Days Supply in Last 12 Months - Sum of Ace Inhibitors Days Supply in Last 12 Months - Sum of ARB Days Supply in Last 12 Months - Sum of SGLT2 Days Supply in Last 12 Months - Sum of nsMRA Days Supply in Last 12 Months - Sum of Statin Days Supply in Last 12 Months - uACR Risk Level - Is ACE/ARB Fill in Last 12 Months - Is Ace Inhibitor Fill in Last 12 Months - Is ARB Fill in Last 12 Months - Is SGLT2 Fill in Last 12 Months - Is nsMRA Fill in Last 12 Months - Is Statin Fill in Last 12 Months - CKD Physician Management Category - Is CKD Stage 5 in Last 12 Months - **[No Field Group]**