measure_report

The MeasureReport resource contains the results of the calculation of a measure; and optionally a reference to the resources involved in that calculation. See the HL7 FHIR R4 spec for full details. Previous version: measure_report Primary Keys:

measure_report_id

Foreign Keys:

patient_id - links to the patient table

_{† Metriport Platform added}

Column	Data Type	Description
measure_report_id	varchar	Unique identifier for the measure report (maps to `id`)
patient_id	varchar	The patient identifier (extracted from `subject.reference`)
measure	varchar	Reference to the measure (maps to `measure`, e.g., canonical URL)
status	varchar	Status of the report (maps to `status`, typically “complete”)
type	varchar	Type of report (maps to `type`, typically “individual”)
date	datetime	When the measure was calculated (maps to `date`)
period_start	date	Start date of the measurement period (maps to `period.start`)
period_end	date	End date of the measurement period (maps to `period.end`)
contained	variant	Array of contained resources (maps to `contained[]`). Parameters with detailed calculation parameters and supporting evidence are stored in this column.
group	variant	Array of measure groups with population data (maps to `group[]`)
meta_source	varchar	Source document filename from FHIR meta.source
data_source_ext†	varchar	Integration source of the data, derived from FHIR extension

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. Related Tables: Parent:

patient

Version diff

Renamed

data_source → meta_source

Getting Started

API Reference

Handling Data

FHIR

API Tools

More Info

Legacy API Reference

Version diff

​Version diff

Version diff