[SO/URSA-QUALITY] URSA-QUALITY-AMR: Asthma Medication Ratio (AMR)

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

Object Description

The percentage of members 5–64 years of age who were identified as having persistent asthma and had a ratio of controller medications to total asthma medications of 0.50 or greater in the last 12 months. Unadjusted Certified Measure 110d6d12-1139-4df5-9512-e7b48223dba9

Metadata

  • Table Name: ursa.mo_ursa_quality_amr
  • Layer: SYNTHETIC_OBJECT
  • Object Type: Replicated Measure
  • Temporal Class: Event
  • Case ID: Snapshot Date, Patient ID, Output NCQA Payer Type Code
  • Event Date: Snapshot Date
  • Primary Key: Snapshot Date, Patient ID, Output NCQA Payer Type Code

Published Fields

  • Data Model Keys

    • Measure ID
    • Measure Name
    • 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)
    • 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.

  • Patient Fields

    • Patient Operational ID -- The user-facing value used by staff used to uniquely identify the Patient in their administrative systems and/or day-to-day operations. (See also [URSA-CORE] Patient)
    • 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 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 State Abbreviation
    • Patient ZIP Code 5-Digit
    • Patient Date of Death

  • Date Fields

    • 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)
    • 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

    • Primary Plan Attributee Provider ID
    • Primary Plan Attributee Provider Description
    • Primary Plan Attributee Primary NUCC Provider Taxonomy Description

  • Insurance Fields

    • Primary Payor Description
    • Primary Plan Description
    • Primary Plan Financial Class Description

  • Denominator Fields

    • Is Denominator Event Criterion Met
    • Reason For Measure Eligibility in Year with Med Logic
    • Year Prior AMR Reason For Measure Eligibility in Year with Med Logic
    • Is Continuous Membership Criterion Met
    • Is Eligible Population
    • Is Any Required Exclusion
    • Is Required Exclusion for No Asthma Controller and Reliever Medications in MY
    • Is Required Exclusion for Hospice
    • Is Required Exclusion for Patient Death
    • Denominator Excluded Reasons Description

  • Numerator Fields

    • Numerator Category Description
    • Ratio

  • Metadata Fields

    • Table Last Updated Datetime
    • Is Parameter Set to Override Continuous Enrollment Criteria
    • Is Parameter Set to Override Payor Criteria

  • Measure Fields

    • Denominator
    • Numerator

  • NCQA Cert Fields

    • Is NCQA Numerator Criteria Met
    • Output NCQA Payer Type Code
    • NCQA Race Code -- The code used to identify race in official NCQA measure submissions; e.g., 1 = White, 2 = Black or African American, 3 = American Indian and Alaska Native, 4 = Asian, etc.
    • NCQA Ethnicity Code -- The code used to identify ethnicity in official NCQA measure submissions; e.g., 1 = Hispanic or Latino, 2 = Not Hispanic or Latino, 3 = Unknown Ethnicity.
    • NCQA Gender Code -- The code used to identify gender in official NCQA measure submissions; e.g., M = male; F = female.
    • Patient Age Integer Unbounded by Death

  • [No Field Group]

    • Ursa Serial ID