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
Enrolled Fruit
Enrolled Care Plan
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.