plan

The list of plans in use. To see the plans available for implementation, see the plan_template table

Primary Key:

• plan_id

Foreign Keys:

• group_id => group.group_id
• plan_template_id => plan_template.plan_template_id

Indexes:

• plan_external_plan_id_idx (Unique) - external_plan_id
• plan_group_id_idx - group_id
• plan_plan_template_id_idx - plan_template_id

Column	Data Type	Nullable	Indexed	Description
plan_id	bigint	No	Yes	-
plan_name	text	No	No	The name of the plan. This will periodically be overwritten by the external plan name if external_plan_id is set
start_date	date	No	No	The date the plan is scheduled to start. This will periodically be overwritten by the external plan name if external_plan_id is set
end_date	date	No	No	The date the plan is scheduled to end. This will periodically be overwritten by the external plan name if external_plan_id is set
plan_template_id	bigint	Yes	Yes	-
plan_status	plan_status_type	No	No	-
group_id	bigint	No	Yes	-
external_plan_id	text	Yes	Yes	Identifier that can be used to tie this plan to an external CRM or other system of record for plans