[SO/URSA-QUALITY] HbA1c Lab Results

Object Description

One row per HbA1c lab result considering all events with dates no more than 7 days apart to be the same test for HEDIS reporting.

Metadata

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

• Date Fields

  • Effective Document Effective Date
  • Effective Document Effective Date for 9
  • 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.
  • SL1 Document Effective Date

• 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)
  • Service LOINC Code
  • SL1 HCPCS Code
  • SL1 Service LOINC Code

• Patient Observation Fields

  • Result Type LOINC Code
  • Result Description
  • Result Numeric
  • SL1 Result Type LOINC Code
  • SL1 Result Description
  • SL1 Result Numeric

• [No Field Group]

  • Effective Lab Test Result Numeric
  • Effective Lab Test Result Numeric for 9
  • Is HbA1c Level < 8 Max Across Effective Document Effective Dates
  • Is HbA1c Level < = 9 Max Across Effective Document Effective Dates
  • Is Source Claim
  • Is Source Bill
  • Is Source EMR
  • Is HbA1c Lab Test Document
  • Is HbA1c LOINC 97506-0 Document
  • Is HbA1c Test Result or Finding Document
  • Is HbA1c Level Less than 8.0 Document
  • Is HbA1c Level Greater Than or Equal to 8.0 Document
  • Is HbA1c Level Less Than or Equal to 9.0 Document
  • Is SL1 Source Claim
  • Is SL1 Source Bill
  • Is SL1 Source EMR
  • Is SL1 HbA1c Lab Test Document
  • Is SL1 HbA1c LOINC 97506-0 Document
  • Is SL1 HbA1c Test Result or Finding Document
  • Is SL1 HbA1c Level Less than 8.0 Document
  • Is SL1 HbA1c Level Greater Than or Equal to 8.0 Document
  • Is SL1 HbA1c Level Less Than or Equal to 9.0 Document