OR_CASE_LAST_MINUTE_CANC

Description: |
Table enables you to report on the last minute case cancellations data.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CASE_ID | VARCHAR | No |
The unique identifier (.1 item) for the case request 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_DT | DATETIME | No |
Stores the cancellation date when the case is canceled at the last minute (i.e., on the day of surgery or on the day of admission).
4 | CANCEL_TM | DATETIME (Local) | No |
Stores the cancellation time when the case is canceled at the last minute (i.e., on the day of surgery or on the day of admission).
5 | CANCEL_REASON_C_NAME | VARCHAR | No |
Stores the reason for canceling the case at the last minute (i.e., on the day of surgery or on the day of admission).
May contain organization-specific values: Yes
6 | SCHEDULED_SURGERY_DT | DATETIME | No |
Stores the scheduled surgery date when the case is canceled at the last minute (i.e., on the day of surgery or on the day of admission).
7 | SCHEDULED_SURGERY_TM | DATETIME (Local) | No |
Stores the scheduled surgery time when the case is canceled at the last minute (i.e., on the day of surgery or on the day of admission).
8 | CANCEL_LOG_ID | VARCHAR | No |
This item stores the log associated with the last minute cancellation entry. The presence of this item indicates that the procedure was canceled after the log was created but the case was not moved to a status of canceled. The cancel reason used to determine if the cancellation is non-clinical will be determined by the mapping of Procedure Not Performed reason (ORL 7802) to Case Cancel reasons.
9 | IS_REASON_EDITED_YN | VARCHAR | No |
This item stores if the cancel reason was edited via the Edit Last Minute Cancellations activity. For cancellations originating from logs that are marked Procedure Not Performed without canceling the case, once this is set, updates to the Procedure Not Performed Reason in I ORL 7802 will no longer update the reason here.
May contain organization-specific values: No
Category Entries:
No
Yes