Object Description
Among diabetes patients aged 18 to 85 without ESRD, the percentage with both a eGFR test and a uACR test performed in the last 12 months. Unadjusted Certified Measure 0a33c3c1-0758-4b50-904f-ae1f0ccda2bc
Metadata
- Table Name: ursa.mo_ursa_quality_ked
- 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
- Is Eligible Population
- Is Continuous Membership Criterion Met
- Is Required Exclusion for Medicare 66+ Institutionalized Status
- Is Any Required Exclusion
- Is Required Exclusion for Hospice
- Is Required Exclusion for Patient Death
- Is Required Exclusion for Palliative Care
- Is Required Exclusion for ESRD or Dialysis
- Denominator Excluded Reasons Description
- Is Required Exclusion for Age 66-80 with Frailty and Advanced Illness
- Is Required Exclusion for Age 81+ with Frailty
-
Numerator Fields
- Numerator Criteria Met Date
- Numerator eGFR Document ID
- Numerator eGFR Date
- Numerator eGFR HCPCS Code
- Numerator eGFR HCPCS Description
- Numerator eGFR Source ID
- Numerator uACR Document ID
- Numerator uACR Date
- Numerator uACR HCPCS Code
- Numerator uACR HCPCS Description
- Is Numerator Qualifying Using Standard End-of-Year Timing
- Numerator Component Contribution Using Standard End-of-Year Timing
- Numerator Contribution
- Numerator Category Description
-
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