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