TASK_PATIENT_ACTIVITY

Description:

This table contains data about patient tasks assigned by MyChart Care Companion.

Primary Key

Column Name	Ordinal Position
ACTIVITY_ID	1

Column Information

	Name	Type	Discontinued?
1	ACTIVITY_ID	VARCHAR	No
	The unique identifier (.1 item) for the task record.
2	TASK_TYPE_C_NAME	VARCHAR	No
	The task type. May contain organization-specific values: No Category Entries: Patient Specific User Specific Patient Event Episode Specific MyChart Patient Created
3	TASK_CONTEXT_C_NAME	VARCHAR	No
	The functional context of a task. May contain organization-specific values: No Category Entries: General Checklist Willow Inventory Shortage Staff Activity Homecare Patient Encounter Health Plan Med Access Research Charge Group
4	DOCMNT_TYPE_C_NAME	VARCHAR	No
	The documentation type for this task. May contain organization-specific values: No Category Entries: MAR Notes COLLECTION I/O Flowsheet Education Care Plan Order Review Order Entry Patient Summary Procedure Result Multistep Multistep Collection Acknowledge Documentation Review Screening Form Discharge Transport Request Discharge Placement Approval Required Documentation Questionnaire Appointment Review Dialog Message Manual Denominator Entry Link Discharge Milestone (Rule-based) Infection/Isolation Discharge Milestone Group Document Signing General
5	TASK_SCHEDULE_STATUS_C_NAME	VARCHAR	No
	The scheduling status of a patient-assigned task. When a task is created it may not be scheduled right away. May contain organization-specific values: No Category Entries: Scheduled Not Scheduled Will Be Scheduled
6	IS_PAUSED_YN	VARCHAR	No
	Whether a task is assigned to the patient is paused. When a task is paused, it will not have future instances and will not displayed to the patient until resumed. May contain organization-specific values: No Category Entries: No Yes
7	GOAL_ID	VARCHAR	No
	The goal that the task is associated with.
8	FREQ_ID	VARCHAR	No
	If you would like this activity to be performed at a different frequency than the ordering frequency, enter it here.
9	FREQ_ID_FREQ_NAME	VARCHAR	No
	The name of the frequency record.
10	CASE_ID	VARCHAR	No
	If this task is anchored to an anchor target of type Surgery, then this item stores the surgical case associated with the surgery.
11	CARE_INTG_ID	VARCHAR	No
	The patient's care plan associated with the task
12	PROBLEM_ID	VARCHAR	No
	The problem associated with the task.
13	PREGNANCY_EPISODE_ID	NUMERIC	No
	If this task is anchored to an anchor target of type Pregnancy, then this item stores the episode associated with the pregnancy.
14	ESCALATE_YN	VARCHAR	No
	Whether or not the task should be escalated if not completed. The category values for this column were already listed for column: IS_PAUSED_YN
15	ESCL_ELAPSE_TIME_NUM	NUMERIC	No
	The amount of time before the task will be escalated, if escalation is enabled.
16	START_INST_DTTM	DATETIME (Local)	No
	Start instant for a PRN task
17	END_DATE	DATETIME	No
	The end date from the scheduler.
18	DISCONTINUE_DTTM	DATETIME (Local)	No
	Instant a task was discontinued
19	TASK_START_TIME_C_NAME	VARCHAR	No
	The start time of the task. May contain organization-specific values: No Category Entries: Source Now On a Specific Date Pend For Later
20	AUTO_COMPLETE_COND	VARCHAR	No
	Task Auto Complete Condition copied from LTR
21	NUM_OCCURRENCES	INTEGER	No
	The number of times this task will occur.
22	PERSONALIZABLE_STATUS_C_NAME	VARCHAR	No
	Defines the personalization status of the notification times for the task. May contain organization-specific values: Yes Category Entries: No Yes
23	ANCHOR_EVENT_TYPE_C_NAME	VARCHAR	No
	The type of anchor target this task is configured for. May contain organization-specific values: No Category Entries: Surgery Pregnancy Appointment Hospital Discharge Rule Defined Date - Encounter Level Rule Defined Date - Patient Level
24	ANCHOR_EVENT_NAME	VARCHAR	No
	The display name of the anchor target this task is configured for. This display name appears within the details of this task in the Patient To Do List activity.
25	RESUME_ON_DISCHARGE_YN	VARCHAR	No
	Whether a task paused on hospital admission or added during hospital admission will start after discharge. The category values for this column were already listed for column: IS_PAUSED_YN
26	DAYS_AFTER_DISCHARGE_NUM	INTEGER	No
	Indicates the number of days after hospital discharge this reminder will start. Value must be larger than or equal to 0.
27	ENSURE_DELIVERY_C_NAME	VARCHAR	No
	Determines the scheduling behavior of this anchored task when its start date falls in the past. May contain organization-specific values: No Category Entries: Start immediately Skip in-between occurrences Don't start Resolve task as discontinued
28	APPT_SERIAL_NUM	NUMERIC	No
	If this task is anchored to an anchor target of type Procedural Appointment, then this item stores the appointment serial number associated with the procedural appointment.
29	ADMISSION_ENC_CSN_ID	NUMERIC	No
	If this task is anchored to an anchor target of type Hospital Discharge, then this item stores the contact serial number associated with the admission.
30	PERSISTENT_QUESR_SERIE_C_NAME	VARCHAR	No
	Indicates that the questionnaire series associated with this task is persistent and what type of persistent questionnaire series it is. May contain organization-specific values: No Category Entries: General Symptom Check-in
31	LINK_TEXT	VARCHAR	No
	This item stores the display text for the associated hyperlink of this task.
32	LINK_TYPE_C_NAME	VARCHAR	No
	This item stores the type of content found at the associated link of this task. May contain organization-specific values: No Category Entries: Text Webpage Video File Video Stream Audio File Audio Stream PDF Document Google Play Link FDI Audio FDI Video FDI Read FDI Direct Link
33	APPOINTMENT_MODALITY_C_NAME	VARCHAR	No
	The modality of the appointment the patient will schedule for this task. May contain organization-specific values: No Category Entries: Video Visit
34	TELEHEALTH_REASON_FOR_VISIT_C_NAME	VARCHAR	No
	The telehealth reason for visit that will be used when the patient schedules the video visit. May contain organization-specific values: Yes Category Entries: General Video Visit Cough Sinus Rash Back Pain Headache Ear Infection Muscular Skeletal Injury Urinary Tract Infection Asthma Birth Control Evaluation Insect Bite Nausea Diarrhea Lactation Consultation Nutrition Consultation Chronic Obstructive Pulmonary Disease Sore Throat Gout Pink Eye General E-Visit Vaginal Discharge / Irritation Heartburn Fatigue Acne Constipation Sunburn Head Lice Emergency Contraception Poison Ivy Cold and Flu Anxiety Athlete's Foot Allergies COVID Concern Fever Tooth Pain Quitting Smoking Sleep Concerns Ear Pain Urgent Care Video Visit Urgent Care Video Visit (Covered) Abdominal Pain Diabetes Management Body Aches Breathing Difficulty Cold Sore Depression Dizziness Erectile Dysfunction Hair Loss High Blood Pressure Leg Swelling Menopause Motion Sickness Bloody Stool Eye Redness Snoring Sexually Transmitted Infection Sexually Transmitted Diseases Vaginal Bleeding Vomiting Wound Urinary Symptoms Lightheadedness Primary Care Video Visit Behavioral Health Video Visit
35	DEF_DISCHRG_BEHAV_C_NAME	VARCHAR	No
	This item defines the behavior for the task during admission. May contain organization-specific values: No Category Entries: Pause Until Manually Resume Pause Until Discharge Unaffected By Admission
36	SERIES_ANS_ID	NUMERIC	No
	The questionnaire series answer associated with the task.
37	ORDER_ID	NUMERIC	No
	The medication order associated with the task.
38	POINT_TEACHING_TTP_ID_TTP_NAME	VARCHAR	No
	The name of the Title/Topic/Point.
39	TOPIC_TEACHING_TTP_ID_TTP_NAME	VARCHAR	No
	The name of the Title/Topic/Point.
40	TITLE_TEACHING_TTP_ID_TTP_NAME	VARCHAR	No
	The name of the Title/Topic/Point.
41	TOTAL_INST_CNT	INTEGER	No
	The total number of patient-assigned task instances which are no longer actionable or have been acted upon.
42	COMPLETED_INST_CNT	INTEGER	No
	The total number of completed patient-assigned task instances.
43	LINK_DESCRIPTION_SMARTTEXT_ID	VARCHAR	No
	This column stores a smart text record ID that displays a detailed description of a link task to the patient on MyChart. This stores a particular instance of a task.
44	LINK_DESCRIPTION_SMARTTEXT_ID_SMARTTEXT_NAME	VARCHAR	No
	The name of the SmartText record.
45	UNANC_BEHAV_C_NAME	VARCHAR	No
	The behavior when this task is unanchored from its anchor target. May contain organization-specific values: No Category Entries: Unschedule Immediately find new anchor target Resolve if no longer actionable Always resolve
46	AE_EVENT_UTC_DTTM	DATETIME (UTC)	No
	The instant in UTC of the event associated with an anchored task.
47	AE_PAT_ENC_CSN_ID	NUMERIC	No
	The CSN of the encounter associated with this anchored task. Only applies to if the anchor target is of type rule defined date (encounter level).
48	AE_EVENT_DTTM	DATETIME (Local)	No
	The instant in local of the event associated with an anchored task.
49	PRIOR_TIME	INTEGER	No
	Indicates how long before its due time a patient can complete a task
50	PRIOR_TIME_UNIT_C_NAME	VARCHAR	No
	Unit for how long before its due time a patient can complete a task May contain organization-specific values: No Category Entries: Occurrences Minutes Hours Days Weeks Months
51	POST_TIME	INTEGER	No
	Indicates how long after its due time a patient can complete a task
52	POST_TIME_UNIT_C_NAME	VARCHAR	No
	Unit for how long after its due time a patient can complete a task The category values for this column were already listed for column: PRIOR_TIME_UNIT_C_NAME
53	IS_AUTOGENERATED_YN	VARCHAR	No
	This item determines whether a task is autogenerated. The category values for this column were already listed for column: IS_PAUSED_YN
54	AI_SUGGESTED_SOURCE_C_NAME	VARCHAR	No
	Stores what source the AI model used to generate a suggested task from. May contain organization-specific values: No Category Entries: Instructions Clinical Notes Visit Orders
55	AI_PREDICTED_DURATION_C_NAME	VARCHAR	No
	Stores the predicted duration it will take a patient to complete an AI generated suggested task. This predicted duration is determined by an AI model. May contain organization-specific values: No Category Entries: <5 minutes 5-10 minutes 10-20 minutes 20-30 minutes >30 minutes
56	AI_IS_RECURRING_YN	VARCHAR	No
	Virtual item that returns whether or not the AI suggested task is recurring. The category values for this column were already listed for column: IS_PAUSED_YN
57	DOCSIGN_DOC_INFO_TYPE_C_NAME	VARCHAR	No
	This item stores the document type of the document signing task. May contain organization-specific values: Yes Category Entries: Other Waveform Strip Annotation Advance Directives and Living Will Power of Attorney HIPAA Notice of Privacy National POLST Form Clinical Unknown Patient Photo SmartTextBox Patient Image Study Attachment for Report Study Attachment DICOM Study DICOM Series DICOM Image ECG Spirometry Holter Authorization to Release Protected Health Information HIM Release of Information Output Kanta Informing Kanta Consent to Data Sharing Kanta Denial of Consent to Data Sharing Kanta PikaXML CHF Kanta GWN Disclosure Auth Kanta Secondary Use Prohibition Kanta Social Care Consent to Data Sharing Kanta Social Care Denial of Consent to Data Sharing Generated Form Organ Donation Will Living Will Consent Form Vaccine Information Statement ABN Waiver Discharge Instruction Release of Information Behavior Contract Clinical References Attachment External Medication Information Consent After Visit Summary Summary of Care CMS IM for Patient Signature CMS IM Copy of Signed Detailed Notice of Discharge Communication Verbal Consent Referral Implied Consent Unverified Proxy Video Visit After Visit Summary Fetal Monitoring Strip Lab Result Scan Lab Requisition Scan Lab Result Document Lab Managed Result Scan Lab Managed Requisition Scan Lab Instrument Image Lab External Image Encounter Dictation History Dictation Order Dictation Clinician Jot Clinical Note Import View Private Medications Consent FMK Med Card PDF FMK Dose Dispensing PDF Research Consent Research Data Capture Plan of Care E-Sig Form Plan of Care Snapshot CCAPS Profile Report PDF Safety Plan Patient Belongings Patient Belongings Intake Patient Belongings Discharge Hospice Election EOB Payment / Check Historic Transaction Historic Correspondence Billing Correspondence My Files Document Employer Contract Employer Reference PDF Report PDF Letter Prov Comm E-Letter PDF Prospective Auth Dental Tooth Chart Dental Baseline Dental Perio Chart Member Attachment Coverage Attachment Coverage ID Card Coverage Enrollment Application Coverage COB Information AP Claim Attachment AP Claim Image Vendor Contract Attachment Vendor Attachment Benefit Plan Attachment CRM Attachment Appeal or Grievance Attachment PB Account Attachment Referral Attachment Referral Notification Document Authorization Notification Document Payer Notification Document Payer Approval Document Payer Notification of Extension Document Payer Request for Information Document Payer Denial Document Payer Cancellation Document Payer Partial Approval Document Provider Attachment Payer No Auth Required Document Payer Withdrawal Document Payer Dismissal Document Payer Closure Document Employer Group Attachment Case Management Attachment Broadcast Message Attachment Member Appointment of Representative Form Tapestry Payer Exchange Clinical Attachment Managed Care Periodic Explanation of Benefits Managed Care Periodic Summary EOB Medical Policy Medical Record Review Document Biometric Enrollment PDR Authorization PDR Disclaimer MOON Obsolete Type 1 Community Upload Account Request Attachment HH Care Summary Proof of Assets Proof of Expenses Patient Entered Attachment Patient Entered Drawing MyChart COVID-19 Vaccination Record Document MyChart Test Results Record Document Electronic Prior Authorization Attachment Sent via Secure Chat MDS CMS PDF Unused Self-Pay Consent Estimate Visit Auto Pay Consent Financial Arrangement Endoscopy Image Endoscopy Anatomical Diagram Endoscopy Video Child Resistant Cap Waiver Rx Prescription Rx Prescription Sale E-Signature Rx Prescription Dispense Customer ID Rx Dispense Prep Image Rx CNR Image ED Patient Billing Extract Imaging Order Key Image Object Screening Form Annotated Cardiology Image Archived Procedural Result IRF-PAI THL Form Filler Derm Clinical Image Pedigree Image Occ Med Form Spreadsheet Report Data Clinical Spreadsheet Report Data CE Point of Care Auth CE Prospective Auth CE Persistent Point of Care Auth CE Auth Form (Scanned) System-Retrieved CE Auth Form E-Signed CE Auth Form PDF CE Auth Form CE Attachment MyChart-Signed CE Auth Form Document Generation Template External Administration External Clinical External Billing External Insurance Card External Insurance-Related Form External Patient Consent External ROI / HIM Consent External Legal Document External Living Will External DNR External Power of Attorney External Legal Letter External Photo ID External Birth Certificate External Death Certificate External Misc Administration External Medication External Medication Order Report External Medication Reconciliation External Prescription List External Radiology and Imaging External Cardiology Imaging External Endoscopy Imaging External OB/GYN Imaging External Dental Imaging External Oncology Imaging External Lab External Procedure External Referral Request / Referral Report External Other Order External Note External Consult Note External H&P Note External Progress Note External Procedure Note External Operative Note External Nurse Note External ED Note External Cardiology Note External GI Note External Oncology Note External Behavior Health Note External Referral Note External Physical Therapy Note External Occupational Therapy Note External OB/GYN Note External Clinical Consent External Procedure Consent External Anesthesia Consent External Surgical Consent External Abortion Consent External Sterilization Consent External Organ Donation Consent External Research Consent External Photographic Image External Wound Care Image External Dermatology Image External Plastic Surgery Image External Flowsheet External Physician Letter External Patient Summary External Discharge Summary External Transfer Summary External Immunization Summary External Labor and Delivery Summary External Physical Therapy Summary External Occupational Therapy Summary External After Visit Summary External Patient Reported Information External Questionnaire External Patient Upload External Patient History External Patient Education and Instructions External Discharge Instructions External Evaluation and Plan External Transplant Evaluation External Risk Assessment External Physical Therapy Treatment Plan External Occupational Therapy Treatment Plan External Oncology Treatment Plan External Case Management External Episode Summary External Surgical Treatment Plan External Misc Clinical Auto-filled Result Image Waiver of Liability for Claim Appeal Pharmacy Prior Request AN Patient Billing Extract Hospice Non-Covered Documentation Face Sheet Capture Patient-Created Image Patient-Created Audio Patient-Created Video Patient-Created Text Continuing Care Options Continuing Care Preferences Dental Soft Tissue Obsolete Type 2
58	DOCSIGN_DOC_TMPLT_ID_TEMPLT_DISPLAY_NAME	VARCHAR	No
	A name for the template designed for display purposes.
59	DOCSIGN_DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
60	DOCSIGN_PXP_RECORD_ID	NUMERIC	No
	This item stores the Procedure Pass ID of a document signing task when it is autogenerated for Procedure Pass.
61	DOCSIGN_OUTREACH_TASK_ID	VARCHAR	No
	This item stores the outreach task ID of a document signing task when it is autogenerated for an outreach workflow.