condition_category

A category assigned to the condition, such as problem-list-item or encounter-diagnosis (Condition.category[]). One row per anchor_index on the normalized stage table.

Primary Keys:

• condition_category_id (surrogate)

Foreign Keys:

• condition_id – links to the condition table

Column	Data Type	Description
condition_category_id	varchar	Surrogate key for this category row
condition_id	varchar	Parent condition
text	varchar	Category narrative (Condition.category[].text)

Related Tables:

Parent:

• condition

Child:

• condition_category_coding