MYC_CONVO

Description:

MyChart conversations.

Primary Key

Column Name	Ordinal Position
THREAD_ID	1

Column Information

	Name	Type	Discontinued?
1	THREAD_ID	NUMERIC	No
	The unique identifier (.1 item) for the thread record.
2	PAT_ID	VARCHAR	No
	The patient this conversation is about. Currently only ever expected to be one, but that could change in the future.
3	COMM_ID	NUMERIC	No
	Contains a link the communication record created for a customer service conversation. Not all customer service conversations will have this link, its creation is controlled by settings.
4	SUBJECT	VARCHAR	No
	Subject of the conversation.
5	MYC_MSG_TYP_C_NAME	VARCHAR	No
	The MyChart message type of this conversation. This is the primary message type that will be used for messages on this conversation. May contain organization-specific values: Yes Category Entries: User Message Patient Medical Advice Request Patient Appointment Schedule Request Patient Appointment Cancel Request Patient Customer Service Request Patient HM Schedule Request Patient Medication Renewal Request Patient Information Update Request Patient Referral Message Credit Card Payment Patient preferences update request Patient HM Reminder Message History Questionnaire Submission General Questionnaire Submission Insurance Update Request E-Visit Questionnaire Series Submission Questionnaire Submission CC Test Results Message Admin Non Member Proxy Signup Duplicate Alert Check Admin WPR merge-unmerge status Admin MPI Add Login Failed Admin Alert - General Partially Answered History Questionnaire Case Reminder Message Video Visit Social Care Unidentified Client Concern Advance Care Planning Request Campaign Outreach Message Billing Message Draft Patient Immunization Screening Validation Failure Notification Proxy Upgrade Request Education Question Care Plan Escalation Pharmacy Message Release of Information PCP Update Request Patient Referral Notification Patient-Entered Immunization Reconciliation Request Patient Immunization Reconciliation Notification Treatment Team Message Patient-Entered Flowsheet Notification Unviewed Test Result Notification System Message IB - SMART FORWARDING CE - Referral CE - Discharge CE - General Communication CE - Patient Initiated CE - Emergency Discharge CE - Inpatient Discharge CE - Unknown CE - Not Specified CE - Event Notification CE - Medication Adherence CE - Share Everywhere Message CE - Healthy Planet Link Upload CE - General Communication Reply CE - Incoming External Encounter CE - Update Notification CE - Referral Outcome CE - Referral Interim Note CE - General Event Notification Community Staff Message Community Referral Message Community Custom Message 1 Community Custom Message 2 Community Custom Message 3 Community Custom Message 4 Community Custom Message 5 Community Custom Message 6 Community Custom Message 7 Community Custom Message 8 Community Custom Message 9 Community Custom Message 10
6	PAT_TASK_ID	VARCHAR	No
	Stores related patient assigned task ID for the conversation.