[SO/URSA-QUALITY] Completed uACR Tests

Prev Next

Object Description

One record per uACR result; defined as either of the following: (1) a quantitative urine albumin test performed within 4 calendar days of a urine creatinine test; or (2) a performed uACR test. Used as part of the numerator of the Diabetes Kidney Health Evaluation measure.

Metadata

  • Table Name: ursa.so_ursa_quality_pat_006
  • Layer: SYNTHETIC_OBJECT
  • Object Type: Integrator
  • Temporal Class: Event
  • Case ID: Document ID Robust
  • Event Date: uACR Date
  • Primary Key: Document ID Robust

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)
  • Module Fields

    • uACR Date
    • Document ID Robust
    • uACR Document ID
    • uACR LOINC Code
    • uACR Service Description
    • uACR Result Type Description
    • uACR Source ID
    • Quantitative Urine Albumin Document ID
    • Quantitative Urine Albumin HCPCS Code
    • Quantitative Urine Albumin HCPCS Description
    • Quantitative Urine Albumin Service Description
    • Quantitative Urine Albumin Result Type Description
    • Quantitative Urine Albumin Source ID
    • Urine Creatinine Document ID
    • Urine Creatinine HCPCS Code
    • Urine Creatinine HCPCS Description
    • Urine Creatinine Service Description
    • Urine Creatinine Result Type Description
    • Urine Creatinine Source ID