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