CASE_FLAGS

Description:

The CASE_FLAGS table holds the case flag information associated with the case records stored in the CASE_MGMT table. Each case record can have any number of flags assigned to it. This table stores every flag associated with each case record.

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 that this flag is associated with.
2	LINE	INTEGER	No
	The line number of the case flag that this row of information corresponds to. For instance, if the case has two flags, the first flag will have a Line value of 1 while the second will have a Line value of 2.
3	FLAG_C_NAME	VARCHAR	No
	The category number associated with the flag assigned to the case. May contain organization-specific values: Yes