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.