For reasons stated by @hripcsa and @Mark_Danese, I like
- Keeping the visit_occurrence table’s name and definition
- Adding a micro table named visit_component
The intent matches what we did in our initial ETL efforts.
Thanks to all involved for the effort to sort this out.