CANCELED_APPTS_EDI
Description:
This table contains the list of visit IDs of appointments that used to be linked to an order, but were cancelled due to the order being cancelled. This item is used by the incoming orders-to-cadence interface to rebook appointments if the order is un-cancelled.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier for the order 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_APPTS_EDI INTEGER No
List of appointment serial numbers (ASNs) linked to the order.
4 CANC_APPT_PREV_STAT VARCHAR No
This item holds the status of the appointments before cancellation.