|
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 |
|
|
