Skip to main content
The MeasureReport resource represents the results of a quality measure calculation for an individual patient. It captures population membership (initial population, denominator, numerator) and supporting evidence used in the calculation. MeasureReport resources are used to represent care gaps and quality measure evaluations. MeasureReport Table: Primary Keys:
  • measure_report_id
Foreign Keys:
  • patient_id
ColumnData TypeDescription
measure_report_idvarcharUnique identifier for the measure report (maps to id)
patient_idvarcharThe patient identifier (extracted from subject.reference)
measurevarcharReference to the measure (maps to measure, e.g., canonical URL)
statusvarcharStatus of the report (maps to status, typically “complete”)
typevarcharType of report (maps to type, typically “individual”)
datetimestampWhen the measure was calculated (maps to date)
period_startdateStart date of the measurement period (maps to period.start)
period_enddateEnd date of the measurement period (maps to period.end)
containedvariantArray of contained resources (maps to contained[]). Parameters with detailed calculation parameters and supporting evidence are stored in this column.
groupvariantArray of measure groups with population data (maps to group[])
data_sourcevarcharSource of the measure report data
Note: The contained column holds the Parameters resource with detailed calculation parameters and supporting evidence. The group column holds the population stratifications (initial-population, denominator, numerator, etc.). Both use Snowflake’s VARIANT type for JSON array storage.