Decide on naming of polymorphic columns in EPISODE_EVENT table.

[mgurley]

In the most current version of the Oncology/Episode of Care Combined Proposal #23, the polymorphic pair of columns that allow the EPISODE_EVENT table to reference any clinical event table are named 'event_id' and 'event_table_concept_id'. This diverges from the current OMOP naming convention for polymorphic column pairs:

• NOTE.note_event_id, NOTE.note_event_field_concept_id
• COST.cost_event_id, COST.cost_event_field_concept_id

Options:

• EPISODE_EVENT.event_id, EPISODE_EVENT.event_table_concept_id
• EPISODE_EVENT.event_id, EPISODE_EVENT.episode_event_field_concept_id
• EPISODE_EVENT.episode_event_id, EPISODE_EVENT.episode_event_field_concept_id

[mgurley]

Decided on the following: EPISODE_EVENT.event_id, EPISODE_EVENT.episode_event_field_concept_id