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.