CAREPLAN_ENROLLMENT_INFO

Description:

This table cotains the enrollment information for a care plan.

Primary Key

Column Name	Ordinal Position
CAREPLAN_ID	1

Column Information

	Name	Type	Discontinued?
1	CAREPLAN_ID	VARCHAR	No
	The unique identifier (.1 item) for the care plan record.
2	CP_ENROLL_WORKFLOW_C_NAME	VARCHAR	No
	This item store the Care Companion workflow from where this care plan was applied to the patient. May contain organization-specific values: No Category Entries: OurPractice Advisory Reporting Workbench Self-Enrollment Care Plan Activity Extension Autogenerated
3	ALERT_CSN_ID	NUMERIC	No
	OurPractice Advisory ALT CSN used to enroll the patient in the care plan.
4	SIGNUP_MYPT_ID	VARCHAR	No
	MyChart user ID who enrolled the patient in the care plan.
5	PREG_SELF_EPISODE_ID	NUMERIC	No
	Pregnancy episode ID (HSB) associated with the self-enrolled care plan.
6	ENROLLING_USER_ID	VARCHAR	No
	User who enrolled the patient in the care plan.
7	ENROLLING_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	SURGICAL_PAT_ENC_CSN_ID	NUMERIC	No
	Patient CSN linked to the surgical encounter where the enrollment was done