procedure_bodysite

Detailed and structured anatomical location information (Procedure.bodySite[]).

Primary Keys:

• procedure_bodysite_id

Foreign Keys:

• procedure_id - links to the procedure table

Column	Data Type	Description
procedure_bodysite_id	varchar	Unique identifier for the body site row
procedure_id	varchar	FK to the parent procedure record
text	varchar	Display text for the body site

Related Tables:

Parent:

• procedure

Child:

• procedure_bodysite_coding