MYC_PLAN_SELF_SIGNUP_STAT
Description:
Status for all MyChart users that are viewing an episode-related MyChart self-signup care plan.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
The unique identifier (.1 item) for the episode record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 MYC_PLAN_SIGNUP_MYPT_ID VARCHAR No
MyChart User ID (WPR ID) to be associated with current line for self-signup care plan.
4 MYC_PLAN_STATUS_C_NAME VARCHAR No
Current status of the self-signup plan for MyChart User.
May contain organization-specific values: No
Category Entries:
None
Offered
Declined
Enrolled
Unenrolled
Completed
Viewing
Stopped Viewing
5 MYC_PLAN_CAREPLAN_ID VARCHAR No
Care plan ID for the MyChart self-signup plan
6 LAST_GEST_AGE_DISMISSED_DAYS INTEGER No
Day number of gestation age when MyChart pregnancy progress health feed card was last dismissed.