CASE_SAVINGS

Description:

The CASE_SAVINGS table contains information about savings associated with case records, such as the amount, type of savings, and reason for savings.

Primary Key

Column Name	Ordinal Position
CASE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CASE_ID	NUMERIC	No
	The unique identifier for the case 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	SAVINGS_AMOUNT	NUMERIC	No
	Specifies the savings amount.
4	SAVINGS_TYPE_C_NAME	VARCHAR	No
	Specifies the savings type. May contain organization-specific values: Yes
5	SAVINGS_REASON	VARCHAR	No
	Specifies the savings reason.
6	SAVINGS_USER_ID	VARCHAR	No
	The unique ID of the savings user.
7	SAVINGS_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	SAVINGS_DATE	DATETIME	No
	Specifies the savings date.
9	SAVINGS_REVERSAL_LINE	INTEGER	No
	Holds the line number of the savings-related group that this line is a reversal of.