How to determine the correct payer_plan_period.plan_concept_id to map to based on information in the source

[burrowse]

How to determine the correct payer_plan_period.plan_concept_id to map to based on information in the source

CDM or THEMIS convention?

Themis

Table or Field level?

Field

Is this a general convention?

No

Summary of issues

• There are outstanding questions on the forum on how to populate plan_concept_id.
• For example, a forum post asks the question if the following logic is accurate:

Plan	Proposed Mapping
CDHP or HDHP	concept_id= 267 Catastrophic Health Plan with <60% actuarial plan value
Basic/major medical	concept_id = 270 Medical only plan
Comprehensive	concept_id= 268 Broad Benefit (Medical, Drug, Dental, Vision plan

• In the same post, another user has an unanswered question about differentiating medicare vs non medicare plans

Summary of answer

• Based on findings, there doesn't appear to be general guidance on how these should be mapped for the plan_concept_id

Related links

• Plan Mappings Question: https://forums.ohdsi.org/t/concepts-for-payer-and-plan-on-cdm-payer-plan-period-table/8535

Other comments/notes

• This topic needs more discussion to provide guidance to the community.

[MelaniePhilofsky]

Archiving this issue. Please reopen this issue if there are still questions.