MYC_MESG_CNCL_RSN

Description: |
The MYC_MESG_CNCL_RSN table contains information about Secure Patient Message records sent to request the cancellation of an appointment. Specifically patients can enter comments on the reason for their cancellation request. This table allows you to report on those free text comments.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | MESSAGE_ID | VARCHAR | No |
The unique identifier for the message record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | CANCEL_REASON | VARCHAR | No |
The reason the patient is requesting cancellation of an appointment. This field will only be populated for appointment cancellation request messages and if the patient is required or chose to write an explanation as to why they are requesting cancellation.