This table contains exception records for kpi_types. These are generated periodically by a server process which detects when kpi_control or kpi_data data have violated target limits for a kpi_type. This table has an identifyijng relationship to the table kpi_exception_ack. However, that relationship is not representable in Erwin. The parent_key in this table is kpi_exception_id, and the foreign key in kpi_exception_ack is exception_id. The cardinality is Zero, One or More
| Column Name | Column Datatype | Column Null Option | Column Comment |
| kpi_exception_id | table_key | not null | Table primary key |
| kpi_id | integer | not null | Primary table key |
| datetime | date | not null | Timestamp of exception record |
| exception_name | varchar(255) | not null | Identifier for exception record |
| description | varchar(255) | with null | Description of exception record |
| status_symbol | varchar(50) | with null | Symbol to indicate whether exception is warn or alarm type |
| startdate | varchar(32) | with null | Displayable string representing the start of the interval this exception occurred in |
| enddate | varchar(32) | with null | Displayable string representing the end of the interval this exception occurred in |
Product Name: BPM
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| kpi_exception_id | kpi_exception_ack | kpi_exception_id |