CASE_HISTORY

Description:

The CASE_HISTORY table contains the case history information associated with each case record stored in the CASE_MGMT table. It contains details of all changes that have ever been made to the case record. It stores such information as the action performed, the time and date the action was performed, and the user that performed the action.

Primary Key

Column Name	Ordinal Position
CASE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CASE_ID	NUMERIC	No
	The internal ID of the case record.
2	LINE	INTEGER	No
	The line number of the case history. For example, if the case has two history events, the first will have a line value of 1, while the second will have a line value of 2.
3	ACTION_DATETIME	DATETIME (Local)	No
	The date and time associated with the case history action entry.
4	ACTION_C_NAME	VARCHAR	No
	The category number of the action associated with this history entry. May contain organization-specific values: No Category Entries: Create Case Open Case Re-Open Case Close Case Create Contact Review Case Name Changed Priority Changed Link Referral Unlink Referral Link Claim Unlink Claim Link Charge Unlink Charge Change Bed Days Start Date Change Bed Days End Date Change Estimated Bed Days Change Override Bed Days Change Converted Bed Days Change Bed Days Day Type Delete Bed Days Row Create Event Edit Event Link Episode Unlink Episode
5	PREV_VALUE	VARCHAR	No
	The "Note or Previous Value" information from the case history action.
6	ACTION_USER_ID	VARCHAR	No
	The internal ID of the user who performed the action associated with this line of the change history.
7	ACTION_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	HISTORY_REV_DUE_DATE	DATETIME	No
	Tracks the current review due date.