OR_CASE_AUDIT_TRL

Description: |
The OR_CASE_AUDIT_TRL table contains OR management system case audit trail information.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | OR_CASE_ID | VARCHAR | No |
The unique ID of the case record.
2 | LINE | INTEGER | No |
The number of the line of the audit information for the case.
3 | AUDIT_RESCHED_TO_DT | DATETIME | No |
This column stores the next scheduled date for the case if the rescheduling action took place. The rescheduling action includes the actions of moved, removed, and bumped.
4 | AUDIT_ADD_ON_SCH_YN | VARCHAR | No |
Indicates whether this case was added on after the schedule was finalized, as defined by settings in Location or System Definitions (not the add-on checkbox in the case). Y is returned if the case is an add-on and the actions are canceled, scheduled, or rescheduled. N is returned if the case is not an add-on and the actions are canceled, scheduled, or rescheduled. Null is returned if the action on the case is not canceled, scheduled, or rescheduled.
May contain organization-specific values: No
Category Entries:
No
Yes
5 | AUDIT_INCLUDE_ORG_CANC_RPT_YN | VARCHAR | No |
Indicates whether the case audit action is included in organizational cancellations reporting based on room, service, holiday, weekend, and add-on exclusions defined in System or Location Definitions. Y indicates that the case is included in cancellations reporting. N indicates that the case is not included in cancellations reporting. This column is only populated if the action is 'canceled', 'scheduled', 'moved', 'swapped OR', 'removed', or 'bumped'.
The category values for this column were already listed for column: AUDIT_ADD_ON_SCH_YN