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	Snowflake ID for the plan record Generated through expression:
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 Generated through expression:
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 Generated through expression:
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 Generated through expression:
plan_template_id	bigint	Yes	Yes	Link to the plan template record. Generated through expression:
plan_status	plan_status_type	No	No	Status of plan, see enum.plan_status_type for details. Generated through expression:
group_id	bigint	No	Yes	Link to the group record. Generated through expression:
external_plan_id	text	No	Yes	Identifier that can be used to tie this plan to an external CRM or other system of record for plans Generated through expression: