This table contains Aion RAS KPI (ie. performance metric) data which was parsed from XML documents from the kpi_infer_summary_docs table. The kpi_process_stats records are aggregated by server processes which run periodically. Aggregation is done according to configuration settings stored in the kpi_types table. Aggregation results are stored in the kpi_data or the kpi_control tables. This table also has complex keyed relationships to the kpi_names and kpi_values tables, which cannot be represented as standard ERwin relationships. See Comments for kpi_names and kpi_values for descriptions of these relationships.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| kpi_process_stats_key | table_key | not null | Table primary key |
| log_date | date | not null | Timestamp to associate with stat record |
| doc_class_key | table_key | not null | Foreign key to XML document class name string |
| doc_type_key | table_key | not null | Foreign key to XML document type key |
| doc_name_key | table_key | not null | Foreign key to XML document name key |
| doc_rulebase_dt | date | not null | Effective of the rulebase this stat record comes from |
| sess_id | varchar(64) | with null | ID for RAS session instance |
| asset_id | varchar(64) | with null | Lifecycle version for this rulebase (not used in r10) |
| doc_timestamp | date | not null | Timestamp of XML document |
| msg_name_key | table_key | not null | Name of metric associated with this record |
| msg_value_key | table_key | not null | Value of metric associated with this record |
| p1_name_key | table_key | with null | Foreign key to name of 1st characteristic/property associated with this record (if used) |
| p1_value_key | table_key | with null | Foreign key to value of 1st characteristic/property associated with this record (if used) |
| p2_name_key | table_key | with null | Foreign key to name of 2nd characteristic/property associated with this record (if used) |
| p2_value_key | table_key | with null | Foreign key to value of 2nd characteristic/property associated with this record (if used) |
| p3_name_key | table_key | with null | Foreign key to name of 3rd characteristic/property associated with this record (if used) |
| p3_value_key | table_key | with null | Foreign key to value of 3rd characteristic/property associated with this record (if used) |
| p4_name_key | table_key | with null | Foreign key to name of 4th characteristic/property associated with this record (if used) |
| p4_value_key | table_key | with null | Foreign key to value of 4th characteristic/property associated with this record (if used) |
| p5_name_key | table_key | with null | Foreign key to name of 5th characteristic/property associated with this record (if used) |
| p5_value_key | table_key | with null | Foreign key to value of 5th characteristic/property associated with this record (if used) |
| p6_name_key | table_key | with null | Foreign key to name of 6th characteristic/property associated with this record (if used) |
| p6_value_key | table_key | with null | Foreign key to value of 6th characteristic/property associated with this record (if used) |
| p7_name_key | table_key | with null | Foreign key to name of 7th characteristic/property associated with this record (if used) |
| p7_value_key | table_key | with null | Foreign key to value of 7th characteristic/property associated with this record (if used) |
| p8_name_key | table_key | with null | Foreign key to name of 8th characteristic/property associated with this record (if used) |
| p8_value_key | table_key | with null | Foreign key to value of 8th characteristic/property associated with this record (if used) |
| p9_name_key | table_key | with null | Foreign key to name of 9th characteristic/property associated with this record (if used) |
| p9_value_key | table_key | with null | Foreign key to value of 9th characteristic/property associated with this record (if used) |
| p10_name_key | table_key | with null | Foreign key to name of 10th characteristic/property associated with this record (if used) |
| p10_value_key | table_key | with null | Foreign key to value of 10th characteristic/property associated with this record (if used) |
Product Name: BPM
Table Type: Table