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
Research Study
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
SMART Health Patient-Submitted
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
Lab Pathology Result
Encounter Dictation
History Dictation
Order Dictation
Clinician Jot
Clinical Note Import
Clinical Progress Note
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
Activity Schedule
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 Ins Card
Coverage Enrollment Application
Coverage COB Information
AP Claim Attachment
AP Claim Image
Vendor Contract Attachment
Vendor Attachment
W-9 Form
Benefit Plan Attachment
CRM Attachment
Appeal or Grievance Attachment
Prescriber Supporting Statement
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
Broker Agreement
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
Journal Entry Supporting Document
AP Invoice
Endoscopy Image
Endoscopy Anatomical Diagram
Endoscopy Video
Medication Consent
MCSA-5876 ME Certificate
MCSA-5875 ME Report
CG-719K Mariner Medical Certificate
CA-17 Duty Status Report
CA-20 Attending Physician's Report
MCSA-5870 Insulin-Treated Diabetes Mellitus Assessment Form
MCSA-5871 Vision Evaluation Report
MCSA-5872 Non-Insulin Treated Diabetes Mellitus Assessment Form
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
Care Everywhere Authorization
PDF CE Auth Form
CE Attachment
MyChart-Signed CE Auth Form
Uploaded 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
External Occupational Health Form
Auto-filled Result Image
Waiver of Liability for Claim Appeal
Pharmacy Prior Request
Driver's License
Passport Visa
DD214
Passport
State ID
Credentialing Curriculum Vitae
Research Protocol
Research Contract
Research CDA
Grid Capture
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.
62 | PAUSE_REASON_C_NAME | VARCHAR | No |
The pause reason if the task is currently paused.
May contain organization-specific values: No
Category Entries:
Admission Behavior
Pause Extension