[SO/URSA-QUALITY] URSA-QUALITY-CISDTAP: Childhood Immunizations DTaP (CISDTP)

Prev Next

Object Description

The percentage of children 2 years of age who had four diphtheria, tetanus and acellular pertussis (DTaP) vaccines by their second birthday. Unadjusted Certified Measure 7dee41f1-857b-4d45-ac19-5d14da9deb9b

Metadata

  • Table Name: ursa.mo_ursa_quality_cisdtp
  • 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

    • 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 Continuous Membership Criterion Met
    • Is Eligible Population
    • Is Any Required Exclusion
    • Is Required Exclusion for Hospice
    • Is Required Exclusion for Patient Death
    • Is Required Exclusion for History of Contraindication of Vaccine
    • Is Required Exclusion for History of Organ and Bone Marrow Transplant
    • Denominator Excluded Reasons Description
    • Measure ID
    • Measure Name
    • Is Qualifying Age per Report Designated Control
  • Numerator Fields

    • Numerator First DTaP Vaccination Document ID
    • Numerator First DTaP Vaccination Source ID
    • Numerator First DTaP Vaccination Document Effective Date
    • Numerator Second DTaP Vaccination Document ID
    • Numerator Second DTaP Vaccination Source ID
    • Numerator Second DTaP Vaccination Document Effective Date
    • Numerator Third DTaP Vaccination Document ID
    • Numerator Third DTaP Vaccination Source ID
    • Numerator Third DTaP Vaccination Document Effective Date
    • Numerator Fourth DTaP Vaccination Document ID
    • Numerator Fourth DTaP Vaccination Source ID
    • Numerator Fourth DTaP Vaccination Document Effective Date
    • Numerator DTaP Anaphylaxis Document ID
    • Numerator DTaP Anaphylaxis Source ID
    • Numerator DTaP Anaphylaxis Document Effective Date
    • Numerator DTaP Encephalitis Document ID
    • Numerator DTaP Encephalitis Source ID
    • Numerator DTaP Encephalitis Document Effective Date
    • Is Numerator Qualifying Using Standard End-of-Year Timing
    • Numerator Component Contribution Using Standard End-of-Year Timing
    • Numerator Category Description
    • Final Qualifying Numerator Document ID
  • Metadata Fields

    • Table Last Updated Datetime
    • Is Parameter Set to Override Continuous Enrollment Criteria
    • Is Parameter Set to Override Payor Criteria
    • Report Designated Control for Expanded Denominator Performance Period Start Date
    • Patient DOB plus 2 years
  • 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