|
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 |
|
|
| 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) |
| 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 |
|
|
| 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 Visit |
| Urgent Care 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 |
|
|
| 35 |
DEF_DISCHRG_BEHAV_C_NAME |
VARCHAR |
No |
|
|
|
| This item defines the default behavior for this task when the patient is discharged. By default, the task will remain paused. |
| May contain organization-specific values: No |
| Category Entries: |
| Keep Task Paused |
| Resume Task |
|
|
| 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 |
VARCHAR |
No |
|
|
|
| The education point associated with the task. |
|
|
| 39 |
TOPIC_TEACHING_TTP_ID |
VARCHAR |
No |
|
|
|
| The education topic associated with the task. |
|
|
| 40 |
TITLE_TEACHING_TTP_ID |
VARCHAR |
No |
|
|
|
| The education title associated with the task. |
|
|
| 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. |
|
|
