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.