[SO/URSA-MSSP] Document Aggregator for URSA-MSSP eCQM Concepts

  • Published on Aug 21, 2025
  • 8 minute(s) read
Prev Next

Object Description

One record per patient document related to an URSA-MSSP module concept for eCQM measures

Metadata

  • Table Name: ursa.so_ursa_mssp_ecqm_pat_001
  • Layer: SYNTHETIC_OBJECT
  • Object Type: Single Stack
  • Temporal Class: Event
  • Case ID: Document ID
  • Event Date: Document Effective Date
  • Primary Key: Document ID

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)
    • Parent Document ID -- The document ID for the document one level above the current document in the object hierarchy, (See also [URSA-CORE] Document ID)
    • Grandparent Document ID -- The document ID for the document two levels above the current document in the object hierarchy, (See also [URSA-CORE] Document ID)
    • 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)
    • Claim ID -- The internal database identifier (used, e.g., for joins and primary keys) for the claim. (See also [URSA-CORE] Claim)
    • Service Line Number -- The integer-valued ordinal representing the position of a service line item in a claim, bill, encounter, or other master record. May not necessarily match the analogous value in the source data for the same record.
    • Diagnosis Line Number -- The integer-valued ordinal representing the position of a diagnosis on a claim, bill, encounter, or other master record. May not necessarily match the analogous value in the source data for the same record. Typically, the diagnosis in the first position is considered the principal diagnosis, though this is not an absolute rule, and the Is Principal Diagnosis field should be used to identify the principal diagnosis.
    • Procedure Line Number -- The integer-valued ordinal representing the position of a procedure on a claim, bill, encounter, or other master record. May not necessarily match the analogous value in the source data for the same record.
    • Billing Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the billing provider. (See also [URSA-CORE] Billing Provider)
    • Service Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the service provider. (See also [URSA-CORE] Service Provider)
    • Facility Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the facility provider. (See also [URSA-CORE] Facility Provider)
    • Attending Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the attending provider. (See also [URSA-CORE] Attending Provider)
    • Source ID -- The identifier for the original source data system from which the current record originated.
    • Master Document ID

  • Date Fields

    • Document Effective Date -- The most appropriate single date that events associated with the document occurred. For documents spanning multiple calendar days, the earliest date is typically used; Document Effective Start Date and Document Effective End Date can be used for a more precise range of dates, if necessary.
    • Document Effective Start Date -- The date that the events associated with the document began.
    • Document Effective End Date -- The last date on which events associated with the document occurred or continued until.
    • Parent Document Effective Start Date -- The date that the events associated with the current document's parent document began.
    • Parent Document Effective End Date -- The last date on which events associated with the current document's parent document occurred or continued until.

  • Clinical Services Fields

    • ICD-10-PCS Code
    • ICD-10-PCS Description
    • HCPCS Code -- The Healthcare Common Procedure Coding System (HCPCS) code associated with a service. Includes both HCPCS Level I codes (commonly called CPT codes) and Level II codes (which includes products, supplies, and services not included in CPT). Level II codes consist of a letter followed by four numeric digits. Current Dental Terminology codes are included in the Level II codes as HCDT. (See also [URSA-CORE] HCPCS Description)
    • HCPCS Description -- The natural language description of a HCPCS code. (See also [URSA-CORE] HCPCS Code)
    • HCPCS Modifier 1 Code -- The 2-character code modifying a HCPCS code.
    • HCPCS Modifier 1 Description -- The natural language description of a HCPCS code modifier. (See also [URSA-CORE] HCPCS Modifier Code)
    • HCPCS Modifier 2 Code
    • HCPCS Modifier 2 Description
    • HCPCS Modifier 3 Code
    • HCPCS Modifier 3 Description
    • HCPCS Modifier 4 Code
    • HCPCS Modifier 4 Description
    • HCPCS Modifier 5 Code
    • HCPCS Modifier 5 Description
    • Service LOINC Code
    • Service SNOMED CT Code
    • CMS Revenue Center Code -- The standard CMS 4-digit Revenue Center code; e.g., 0001 = Total charge, etc. CMS Revenue Center codes should include leading zeros.
    • CMS Revenue Center Description -- The natural language description of a CMS Revenue Center code (See also [URSA-CORE] CMS Revenue Center Code)
    • CMS Place of Service Code -- The standard CMS 2-digit Place of Service code; e.g., 01 = Pharmacy, 02 = Telehealth, etc.
    • CMS Place of Service Description -- The natural language description of a standard CMS Place of Service code (See also [URSA-CORE] CMS Place of Service Code)

  • Medication Fields

    • RxNorm Code -- The standard RxNorm code for medications; e.g., 315253 = acetaminophen 160 MG.
    • Label Description -- Supplies the name given to the product by the manufacturer.
    • 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.
    • 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)

  • Diagnosis Fields

    • ICD-10-CM Code
    • ICD-10-CM Description
    • Is Admitting Diagnosis -- Indicates that a diagnosis was the admitting diagnosis for an encounter.
    • Is Principal Diagnosis -- Indicates that a diagnosis was documented as the principal diagnosis for the claim, bill, encounter, etc.
    • Diagnosis SNOMED CT Code
    • Diagnosis SNOMED CT Description
    • MS-DRG Code -- The standard 3-digit Medicare Severity Diagnosis Related Group code; MS-DRG codes should include leading zeros.
    • MS-DRG Description -- The natural language description of a standard 3-digit Medicare Severity Diagnosis Related Group code.

  • Billing and Claims Fields

    • CMS Type of Bill Code -- The standard CMS 3-digit Type of Bill (TOB) Code; 111 = Hospital Inpatient Admit Through Discharge, etc.
    • CMS Type of Bill Description -- The natural language description of a standard CMS Type of Bill (TOB) code. (See also [URSA-CORE] CMS Type of Bill Code)

  • Metadata Fields

    • Document Type Description

  • Validation Only Fields

    • Is Document Type with Uninherited HCPCS
    • Result Type LOINC Code Robust
    • Result Type SNOMED CT Code Robust
    • Diagnosis SNOMED CT Code Robust

  • Patient Observation Fields

    • Result Type Description
    • Result Type LOINC Code
    • Result Type SNOMED CT Code
    • Result Description
    • Result Numeric

  • Module Fields

    • Is Shared Lineage with eCQM Left Qualifier Document
    • Is Shared Lineage with eCQM Right Qualifier Document
    • Is Shared Lineage with eCQM Yes Qualifier Document
    • Is Shared Lineage with eCQM Encounter Inpatient
    • Is Shared Lineage with eCQM Emergency Department Evaluation and Management Visit Document
    • Is Shared Lineage with eCQM Encounter to Screen for Depression Document
    • Is Shared Lineage with eCQM Physical Therapy Evaluation Document
    • Is Shared Lineage with eCQM Telephone Visits Document
    • Is eCQM Yes Qualifier Value Document
    • Is eCQM Left Qualifier Document
    • Is eCQM Right Qualifier Document
    • Is eCQM Office Visit Document
    • Is eCQM Annual Wellness Document
    • Is eCQM Preventive Care Services Established Office Visit, 18 and Up Document
    • Is eCQM Preventive Care Services Initial Office Visit, 18 and Up Document
    • Is eCQM Home Healthcare Services Document
    • Is eCQM Virtual Encounter Document
    • Is eCQM Telephone Visits Document
    • Is eCQM Nutrition Services Document
    • Is eCQM Any Medical Nutrition Therapy Document
    • Is eCQM Encounter to Screen for Depression Document
    • Is eCQM Physical Therapy Evaluation Document
    • Is eCQM Hospice Encounter Document
    • Is eCQM Encounter Inpatient Document
    • Is eCQM Discharge to Home for Hospice Care Procedure Document
    • Is eCQM Discharge to Healthcare Facility for Hospice Care Procedure Document
    • Is eCQM Hospice Care Ambulatory Document
    • Is eCQM Hospice Diagnosis Document
    • Is eCQM Hospice Care Document
    • Is Any eCQM Hospice Document
    • Is eCQM Functional Assessment of Chronic Illness Therapy Palliative Care Questionnaire Document
    • Is eCQM Palliative Care Diagnosis Document
    • Is eCQM Palliative Care Encounter Document
    • Is eCQM Palliative Care Intervention Document
    • Is eCQM Advanced Illness Document
    • Is eCQM Frailty Device Document
    • Is eCQM Frailty Diagnosis Document
    • Is eCQM Frailty Encounter Document
    • Is eCQM Frailty Symptom Document
    • Is eCQM Medical Equipment Used Document
    • Is eCQM Dementia Medications Document
    • Is eCQM Housing Status Document
    • Is eCQM Lives in Nursing Home Finding Document
    • Is eCQM Bilateral Mastectomy Document
    • Is eCQM History of Bilateral Mastectomy Document
    • Is eCQM Mammography Document
    • Is eCQM Status Post Left Mastectomy Document
    • Is eCQM Status Post Right Mastectomy Document
    • Is eCQM Unilateral Mastectomy Left Document
    • Is eCQM Unilateral Mastectomy Right Document
    • Is eCQM Unilateral Mastectomy Unspecified Laterality Document
    • Is eCQM Adolescent Depression Medications Document
    • Is eCQM Adult Depression Medications Document
    • Is eCQM Bipolar Disorder Document
    • Is eCQM Follow Up for Adolescent Depression Document
    • Is eCQM Follow Up for Adult Depression Document
    • Is eCQM Medical Reason Document
    • Is eCQM Referral for Adolescent Depression Document
    • Is eCQM Referral for Adult Depression Depression Document
    • Is eCQM Adolescent Depression Screening Assessment Document
    • Is eCQM Adult Depression Screening Assessment Document
    • Is eCQM Depression Screening Declined Document
    • Is eCQM Depression Screening Negative Document
    • Is eCQM Depression Screening Positive Document
    • Is eCQM Chronic Kidney Disease Stage 5 Document
    • Is eCQM Dialysis Services Document
    • Is eCQM Emergency Department Evaluation and Management Visit Document
    • Is eCQM End Stage Renal Disease Document
    • Is eCQM ESRD Monthly Outpatient Services Document
    • Is eCQM Essential Hypertension Document
    • Is eCQM Kidney Transplant Document
    • Is eCQM Kidney Transplant Recipient Document
    • Is eCQM Pregnancy Document
    • Is eCQM Systolic Blood Pressure Document
    • Is eCQM Diastolic Blood Pressure Document
    • Is eCQM Diabetes Document
    • Is eCQM HbA1c Laboratory Test Document
    • Is eCQM Glucose Management Indicator Document