encounter_reasoncode

Normalized Encounter.reasonCode[] property on the Encounter FHIR resource.

Primary Keys:

• encounter_reasoncode_id

Foreign Keys:

• encounter_id - links to the encounter table

Column	Data Type	Description
encounter_reasoncode_id	varchar	Unique identifier for the reason code row
encounter_id	varchar	FK to the parent encounter record
text	varchar	Free-text reason for the encounter

Related Tables:

Parent:

• encounter

Child:

• encounter_reasoncode_coding