plan_hierarchy

Tracks relationships between different components of a plan.

Primary Key:

• plan_id
• parent_plan_id

Foreign Keys:

• parent_plan_id => plan.plan_id
• plan_id => plan.plan_id

Indexes:

• plan_hierarchy_parent_plan_id_idx - parent_plan_id
• plan_hierarchy_plan_id_idx - plan_id

Column	Data Type	Nullable	Indexed	Description
plan_id	bigint	No	Yes	Link to the plan Generated through expression:
parent_plan_id	bigint	No	Yes	Link to the parent plan. Generated through expression:
is_admin_id_inherited	boolean	Yes	No	- Generated through expression:
is_group_name_inherited	boolean	Yes	No	- Generated through expression:
is_group_code_list_inherited	boolean	Yes	No	- Generated through expression:
is_member_filter_rule_inherited	boolean	Yes	No	- Generated through expression:
is_pcn_inherited	boolean	Yes	No	- Generated through expression:
is_bin_inherited	boolean	Yes	No	- Generated through expression:
is_payer_id_inherited	boolean	Yes	No	- Generated through expression:
is_start_date_inherited	boolean	Yes	No	- Generated through expression:
is_end_date_inherited	boolean	Yes	No	- Generated through expression:
is_member_id_formula_inherited	boolean	Yes	No	- Generated through expression:
are_documents_inherited	boolean	Yes	No	- Generated through expression:
are_partners_inherited	boolean	Yes	No	- Generated through expression:
are_roles_inherited	boolean	Yes	No	- Generated through expression: