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