[SO/URSA-PQA] Document Aggregator for URSA-PQA Concepts

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

Object Description

None

Metadata

  • Table Name: ursa.so_ursa_pqa_pat_001
  • Layer: SYNTHETIC_OBJECT
  • Object Type: Single Stack
  • Case ID: None
  • Primary Key: Ursa Serial 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)
    • 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)
    • Medication Dispense ID
    • 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.
    • 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.
    • Filled Date -- The date a prescription or medication order was filled, with medications dispensed.
    • Prescribed Date -- The date the prescription or medication order was signed.

  • Clinical Services Fields

    • 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)
    • 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)
    • CMS Admission Type Code -- The standard CMS 1-digit Admission Type code; 1 = Emergency, 2 = Urgent, etc.
    • CMS Admission Type Description -- The natural language description of a CMS Admission Type code (See also [URSA-CORE] CMS Admission Type Code)
    • CMS Patient Discharge Status Code -- The standard 2-digit CMS Patient Discharge Status code; 01 = Discharged to Home or Self Care, etc. Patient Discharge Status codes should include leading zeros.
    • CMS Patient Discharge Status Description -- The natural language description of a standard CMS Patient Discharge Status code. (See also [URSA-CORE] CMS Patient Discharge Status Code)

  • Medication Fields

    • NDC Code -- 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.
    • 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)
    • Quantity Dispensed -- The quantity of medication dispensed in the fill. For medications with discrete forms (e.g., tablets, capsules, etc.) this is the number of those discrete units dispensed. For non-discrete forms (e.g., solution, cream, etc.) this is some other measure of quantity, including (but not necessarily) the number of doses dispensed.
    • 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.

  • Diagnosis Fields

    • 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.
    • APR-DRG Code -- The standard 3-digit All Patient Refined Diagnosis Related Group code; APR-DRG codes should include leading zeros, and do not include the Severity of Illness or Risk of Mortality modifiers.
    • APR-DRG Description -- The natural language description of a standard 3-digit All Patient Refined Diagnosis Related Group code. (See also [URSA-CORE] APR-DRG Code)
    • ICD-10-CM Code
    • ICD-10-CM Description
    • Diagnosis SNOMED CT Code
    • Diagnosis SNOMED CT 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.

  • 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

  • Module Fields

    • Is Hospice Encounter Document
    • Is Hospice Intervention Document

  • [No Field Group]

    • Is Cancer Document
    • Is Cancer Related Pain Document
    • Is Cirrhosis Document
    • Is ESRD Document
    • Is Lactation Document
    • Is Palliative Care Document
    • Is PCOS Document
    • Is Prediabetes Document
    • Is Pregnancy Document
    • Is Rhabdomyolysis Myopathy Document
    • Is Sickle Cell Disease Document
    • Is Any PQA Other Value Set Concept
    • Is Anticholinergic Medication Document
    • Is Benzodiazepines Medication Document
    • Is Biguanides Medication Document
    • Is Diabetes Medication Document
    • Is DPP4 Inhibitor Medication Document
    • Is Fertility Medication Document
    • Is GIP GLP1 Receptor Agonists Medication Document
    • Is Insulin Medication Document
    • Is Meglitinides Medication Document
    • Is Opioids COB Medication Document
    • Is Renin Angiotensin System RAS Antagonists Medication Document
    • Is Sacubitril Valsartan Exclusion Medication Document
    • Is Sodium Glucose CO Transporter Medication Document
    • Is Statin Medication Document
    • Is Sulfonylureas Medication Document
    • Is Thiazolidinediones Medication Document
    • Is Any PQA Medication Value
    • Primary Agent Description -- The primary active ingredient in the medication. In medications with multiple active ingredients, this identifies by name only the primary agent.
    • Manufacturer Description -- Identifies the name of the company that markets the product. The name appearing in this field corresponds to the FDA-registered labeler name identified by the five-digit labeler code on the NDC number. Therefore, names appearing in this field will include distributors and repackagers in addition to original manufacturers.
    • 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)
    • Ursa Serial ID