[SO/URSA-PHARM] PDC Measure Fills

Object Description

One record per patient - calendar date - ingredient triple for a targeted PDC medication medication; includes information on the medication therapy episode containing that fill.

Metadata

• Table Name: ursa.so_ursa_pharm_meds_101
• Layer: SYNTHETIC_OBJECT
• Object Type: Medication Therapy Episode
• Temporal Class: Event
• Case ID: Document ID
• Event Date: Filled 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)
  • Claim ID -- The internal database identifier (used, e.g., for joins and primary keys) for the claim. (See also [URSA-CORE] Claim)
  • 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)
  • Filling Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the filling provider.
  • Prescribing Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the prescribing provider. (See also [URSA-CORE] Prescribing Provider)

• Operations Support Fields

  • Prescription Number -- The unique, user-facing (“real-world”) identifier used by operational systems or staff to identify the medication order. (See also [URSA-CORE] Medication Order)

• Date Fields

  • Filled Date -- The date a prescription or medication order was filled, with medications dispensed.

• Medication Fields

  • NDC Code 11-Digit -- 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.
  • 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.
  • Total Paid Amount
  • Calendar Date Aggregate Days Supply

• Financial Fields

  • Plan Paid Amount -- The amount actually paid by the health plan to the provider for a service or product. Subtracting the plan paid amount from the total due amount typically yields the patient responsibility amount. On billing records, which may identify up to three plans responsible for payment, the Primary Plan Paid Amount, Secondary Plan Paid Amount, and Tertiary Plan Paid Amount fields identify the amounts paid by the primary, secondary, and tertiary plans listed on the bill, respectively; the total paid by any and all plans on a bill is identified by the Any Plan Paid Amount field.
  • COB Paid Amount -- The total amount paid to the provider by one or more health plans other than the plan identified on the claim record as part of a "coordination of benefit" (COB) action; a COB scenario can arise when a patient has multiple concurrent plan memberships.
  • Patient Paid Amount -- The amount paid by the patient to the provider for health care services or products.

• Module Fields

  • Is Oral Antidiabetic
  • Is Oral ACEI/ARB
  • Is Statin

• [No Field Group]

  • Episode ID
  • Episode Start Date
  • Episode End Date
  • Episode Length Days
  • Episode Aggregate Days Supply
  • Episode Count Fills
  • Is First Fill In Episode
  • Is Last Fill In Episode
  • Episode First Prescribing Provider ID
  • Episode Last Prescribing Provider ID
  • Episode First Filling Provider ID
  • Episode Last Filling Provider ID

Foreign Keys

• document_id → ursa.so_ursa_pharm_meds_001.document_id
• claim_id → ursa.no_ursa_core_fin_004.claim_id
• pat_id → ursa.no_ursa_core_pat_001.pat_id
• filling_prov_id → ursa.so_ursa_pharm_prov_001.prov_id
• prescribing_prov_id → ursa.no_ursa_core_prov_001.prov_id