MYC_MESG

Description: |
This table contains information on messages sent to and from web-based chart system patients.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
MESSAGE_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | MESSAGE_ID | VARCHAR | No |
The unique ID used to identify a web-based chart system message record. A new record is created each time a patient sends a message from a web-based chart system to a system user and each time a system user sends a message to a web-based chart system patient.
2 | CREATED_TIME | DATETIME (Local) | No |
The date and time the web-based chart system message record was created in local time.
3 | PARENT_MESSAGE_ID | VARCHAR | No |
The unique ID of the original message in a chain of web-based chart system messages between patients and system users.
4 | INBASKET_MSG_ID | VARCHAR | No |
The unique ID of the system message associated with the web-based chart system message. An example is when a patient sends a message to a system user.
5 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
6 | PAT_ENC_DATE_REAL | FLOAT | No |
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
7 | FROM_USER_ID | VARCHAR | No |
The unique ID of the system user who sent a web-based chart system message to a patient.
8 | FROM_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | TO_USER_ID | VARCHAR | No |
The unique ID of the system user who was sent a web-based chart system message from a patient.
10 | TO_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
11 | TOFROM_PAT_C_NAME | VARCHAR | No |
The message direction category number for the web-based chart system message. 1 corresponds to "To patient". 2 corresponds to "From patient".
May contain organization-specific values: No
Category Entries:
To Patient
From Patient
12 | ORIGINAL_TO | VARCHAR | No |
If a message sent from a web-based chart system patient is re-routed from its intended destination, then the ID of the original recipient is stored in the field. Most commonly this occurs when a system user does not accept messages directly from web-based chart system patients. In this case, the message will be re-routed to a pool, but the employee ID of the system user will be stored here. The ID of the final destination is stored in MODIFIED_TO.
13 | RQSTD_PHARMACY_ID | NUMERIC | No |
The unique ID of the pharmacy selected by the patient from the drop down list when sending a Medication Renewal Request message.
14 | RQSTD_PHARMACY_ID_PHARMACY_NAME | VARCHAR | No |
The name of the pharmacy.
15 | UPDATE_DATE | DATETIME (Local) | No |
The date and time that this web-based chart system message record was pulled into enterprise reporting.
16 | REQUEST_SUBJECT | VARCHAR | No |
This field is only used for medical advice request messages and indicates the subject selected by the patient from the drop down list.
17 | PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
18 | DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
19 | RESP_INFO | VARCHAR | No |
Some response types will include additional information, such as a phone number. If such data exists for the chosen response method, it will be stored in this field.
20 | SUBJECT | VARCHAR | No |
The subject line of the web-based chart system message.
21 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
22 | EOW_READ_STATUS_C_NAME | VARCHAR | No |
The read status category number for the web-based chart system message.
May contain organization-specific values: No
Category Entries:
Unread
Read
23 | BILL_ACCT_ID | NUMERIC | No |
The unique ID of the guarantor account associated with this web-based chart system message.
24 | BILL_ACCT_TYPE_C_NAME | VARCHAR | No |
The billing account type category number for the web-based chart system message. Only billing-specific customer service messages have a value specified for this column.
May contain organization-specific values: No
Category Entries:
Physician Billing
Hospital Billing
Single Billing Office
25 | BILL_ACCT_HAR_ID | NUMERIC | No |
The unique ID of the hospital account associated with this web-based chart system message.
26 | RELATED_MESSAGE_ID | VARCHAR | No |
The unique ID of the parent message of the original message chain. This applies only when the system is configured to allow patients to reply to messages associated with closed encounters by creating a new message chain. This item is populated for the message that starts a new chain.
27 | WPR_OWNER_WPR_ID | VARCHAR | No |
The unique ID of the web-based chart system patient who owns this message.
28 | CR_TX_CARD_ID | NUMERIC | No |
The unique ID of the credit card used for this transaction.
29 | CR_TX_MYPT_ID | VARCHAR | No |
The unique ID of the web-based chart system patient associated with this transaction.
30 | CR_TX_AMOUNT_AUTH | NUMERIC | No |
The amount authorized for this transaction.
31 | PAT_HX_QUESR_ID | VARCHAR | No |
The unique ID of the history questionnaire associated with this message.
32 | PAT_HX_QUESR_ID_RECORD_NAME | VARCHAR | No |
The name of the Visit Navigator (VN) History Template Definition (LQH) record.
33 | HX_QUESR_CONTEXT_C_NAME | VARCHAR | No |
The history questionnaire context category number for the web-based chart system message.
May contain organization-specific values: No
Category Entries:
Visit Type
Provider
Department
Message Task
Other
34 | HX_QUESR_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
35 | HX_QUESR_ENCPROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
36 | HX_QUESR_APPT_DAT | INTEGER | No |
The appointment contact date (DAT) if the questionnaire is linked to an appointment.
37 | HX_QUESR_FILED_YN | VARCHAR | No |
Indicates whether the history questionnaire has been filed for this web-based chart system message. Y indicates that the history questionnaire has been filed. N or a null value indicates that the history questionnaire has not been filed.
May contain organization-specific values: No
Category Entries:
No
Yes
38 | DELIVERY_DTTM | DATETIME (UTC) | No |
The instant that this message is scheduled for delivery to the patient. This item may not be populated. In the event that this item is not populated, then the instant the message is created is used to determine when the patient can view the message.
39 | RECORD_STATUS_C_NAME | VARCHAR | No |
The category title of the status of the message. If not populated, then the message is active; Soft deleted is set when a message is revoked.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
40 | CR_TX_TYPE_C_NAME | VARCHAR | No |
Stores the type of transaction (E-Visit or Copay).
May contain organization-specific values: No
Category Entries:
E-Visit
Copay
41 | HX_QUESR_REVIEW_YN | VARCHAR | No |
Indicates whether the history questionnaire has been viewed by a provider in edit mode for this web-based chart system message. Y indicates that the history questionnaire has been viewed, N or a null value indicates that the history questionnaire has not been viewed.
The category values for this column were already listed for column: HX_QUESR_FILED_YN
42 | HX_QUESR_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for the appt contact if questionnaire is linked to an appt. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
43 | OUTREACH_RUN_ID | NUMERIC | No |
This is the campaign outreach configuration template associated with this message.
44 | RENEWAL_REQ_SRC_C_NAME | VARCHAR | No |
This item stores the request source of a medication renewal request. The default is 2-Web.
May contain organization-specific values: No
Category Entries:
IVR
Web
Pharmacy
Ambulatory
Discharge
External E-Prescription
Other
Telephone
Hospital Outpatient
Surgery
Emergency
System
Call Center
Reporting Workbench
Automatic Refill
Pharmacy Front Counter
Dispense Activity
External System
Willow Home Infusion
Prescription Document
Willow Inpatient
Resupply Request
Residential Facility
Hospital
Test Billing
E-Transfer
45 | REQ_PHARM_FREE_TEXT | VARCHAR | No |
If the selected pharmacy was entered by the user as free-text, then it is stored here.
46 | HX_QUESR_EDIT_MYPT_ID | VARCHAR | No |
Stores the Patient Access Account (WPR) record for the user who last made changes to an in progress history questionnaire
47 | HX_QUESR_EDIT_INST_DTTM | DATETIME (UTC) | No |
Stores the time at which changes were last made to an in progress history questionnaire
48 | REFERRAL_ID | NUMERIC | No |
The unique ID of the referral this message is associated with.
49 | COMM_ID | NUMERIC | No |
The customer service record ID corresponding to the message
50 | AUTH_REQUEST_ID | NUMERIC | No |
The authorization request this message is associated with.
51 | INFO_REQ_CSN_ID | NUMERIC | No |
The Information Request this message is associated with.
52 | NON_HX_QUESR_WITH_HX_DATA_YN | VARCHAR | No |
1 - If WMG stores history data even though the WMG type is not 22 - HISTORY Questionnaire.
The category values for this column were already listed for column: HX_QUESR_FILED_YN
53 | OUTREACH_CSN_ID | NUMERIC | No |
The unique contact serial number (CSN) of the outreach contact that sent the message.
54 | HX_QUESR_FILED_USER_ID | VARCHAR | No |
The ID of the user who marked the history submission as done.
55 | HX_QUESR_FILED_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
56 | HX_QUESR_FILED_LOCAL_DTTM | DATETIME (Local) | No |
The instant (in local time) that the history questionnaire submission was marked as done.