OHDSI Home | Forums | Wiki | Github

If plan_source_value IS NULL shall we create record in Payer_plan_period table?

Hi all,
I have a question on the Payer_plan_period table. We populate plan_source_value with plan type values and sometimes in the source data there are start and end dates but plan type IS NULL. Shall we create a record in this case?

Possible issue if we create: if several source records have plan type IS NULL and intersection by dates, we are not able to merge such records into one because plan type is unknown. So, we may get multiple payer_plan_period_id’s in COST table.

Thank you,
Tatiana

@Tatyana:

It’s a matter for the THEMIS group. We’ll add it to the list of things.

Observation period - There shouldn’t be a person record if there is no observation period. There is no overlapping periods

Payer plan period - is to represent the contractual relationship between a person and payer/sponsor/plan. This may be a subset of observation period. There may be overlapping periods in payer plan period table because a person may have a primary payer and secondary payer for the same time periods. There may be periods in observation period that are not in payer plan period - but not other way around. Periods in observation period, that are not in payer plan period indicates no contractual relationship.

1 Like
t