APPT_TKT_ID
Description:
This table stores information on appointment tickets.

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 TKT_ID_FOR_APPT_ID NUMERIC No
This stores the ID to the ticket for the appointment that was requested through a patient message.