goal_extension - Metriport

Normalized Goal.extension[] property on the Goal FHIR resource. Primary Keys:

goal_extension_id

Foreign Keys:

goal_id - links to the goal table

_{† Metriport Platform added}

Column	Data Type	Description
goal_extension_id	varchar	Unique identifier for the extension row
goal_id	varchar	FK to the parent goal record
extension_rank†	int	1-based position of this extension in the source array
url	varchar	Extension URL identifying the extension type
valuestring	varchar	String value
valueboolean	bool	Boolean value
valuecode	varchar	Code value
valuedatetime	datetime	Datetime value
valueinteger	int	Integer value
valuedecimal	numeric	Decimal value
valuecoding_code	varchar	Coding code value
valuecoding_display	varchar	Coding display text
valuecoding_system	varchar	Coding system URI
valuecodeableconcept_text	varchar	CodeableConcept text
valuereference_reference	varchar	Reference value

Related Tables: Parent:

goal

Child:

goal_extension_vcc_coding

goal_target_measure_coding goal_extension_vcc_coding

⌘I