Table postgres.omop.payer_plan_period
[ECONOMIC] The PAYER_PLAN_PERIOD table captures details of the period of time that a Person is continuously enrolled under a specific health Plan benefit structure from a given Payer. Each Person receiving healthcare is typically covered by a health benefit plan, which pays for (fully or partially), or directly provides, the care. These benefit plans are provided by payers, such as health insurances or state or government agencies. In each plan the details of the health benefits are defined for the Person or her family, and the health benefit Plan might change over time typically with increasing utilization (reaching certain cost thresholds such as deductibles), plan availability and purchasing choices of the Person. The unique combinations of Payer organizations, health benefit Plans and time periods in which they are valid for a Person are recorded in this table.

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
payer_plan_period_id int4 10
cost.payer_plan_period_id fpk_visit_cost_period R
A identifier for each unique combination of payer, plan, family code and time span.
person_id int4 10
person.person_id fpk_payer_plan_period R
A foreign key identifier to the Person covered by the payer. The demographic details of that Person are stored in the PERSON table.
payer_plan_period_start_date date 13 The start date of the payer plan period.
payer_plan_period_end_date date 13 The end date of the payer plan period.
payer_source_value varchar 50  √  null The source code for the payer as it appears in the source data.
plan_source_value varchar 50  √  null The source code for the Person's health benefit plan as it appears in the source data.
family_source_value varchar 50  √  null The source code for the Person's family as it appears in the source data.

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:
Column(s) Type Sort Constraint Name
payer_plan_period_id Primary key Asc xpk_payer_plan_period
person_id Performance Asc idx_period_person_id

Close relationships  within of separation: