This table holds the trending data for each KPI in the application, for each data refresh process that is executed.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| uuid | byte(16) | not null | Primary key for si_rec_kpi |
| kpi_uuid | byte(16) | with null | FK to si_rec_kpi tto get where clause |
| last_update_date | date | with null | Date time stamp the value was generated |
| source_table | varchar(64) | with null | The original si_ table that the metrics was derrived from. |
| data_sequence | integer4 | with null | Sequence Order in which to the query will execute |
| data_type | nvarchar(16) | with null | Type of expected return dataset: str, int, uuid, money, date, blob, or clob |
| data_str | nvarchar(100) | with null | place holder for a single string result |
| data_int | integer | with null | place holder for count result |
| data_uuid | byte(16) | with null | place holder for uuid result, usually related to the string result. |
| data_money | money | with null | Placeholder for return dataset |
| data_date | date | with null | Placeholder for return dataset |
| data_clob | long nvarchar | with null | Placeholder for return dataset |
| data_blob | long byte | with null | Placeholder for return dataset |
Product Name: Unicenter Service Intelligence
Table Type: Table