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.