kpi_data
- Last UpdatedNov 20, 2024
- 2 minute read
Note: This table is currently not used.
The kpi_data table captures all the instances of KPI data collection and so provides historical data for each KPI/entity/item class/time period combination. This facilitates reporting and filtering based on any combination of these criteria.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
kpi_name |
string40 |
N |
N |
Identify the KPI |
|
key_int |
int32 |
N |
N |
Identifying integer (e.g., ent_id or user grp_id) for this KPI value. |
|
key_string |
string40 |
N |
Y |
Identifying string (e.g., item_class_id) for this KPI value. |
|
kpi_group |
string40 |
N |
N |
Group to which this KPI belongs for the purpose of grouping related KPIs for data entry and reporting. |
|
captured_at |
tdatetime |
N |
N |
When was this KPI value captured, such as shift_start for shift based data. |
|
kpi_value |
tfloat |
N |
N |
Actual value of the KPI for this instance. |
|
kpi_value_num |
tfloat |
N |
Y |
Numerator of the actual value of the KPI for this instance. Use in cases where weighted averages of multiple KPI’s are required. |
|
kpi_value_den |
tfloat |
N |
Y |
Denominator of the actual value of the KPI for this instance. Use in cases where weighted averages of multiple KPI’s are required. |
|
state_cd |
int32 |
N |
N |
State of this KPI that keys to the kpi_state table. |
|
shift_id |
int32 |
N |
Y |
Optional shift to which this kpi applies. |
|
period_id |
int32 |
N |
Y |
Integer identification of the period to which this KPI applies eg. week or day number. |
|
period_desc |
string40 |
N |
Y |
Description of the period for which this KPI applies, e.g., Shift 1. |
|
rawval1 |
tfloat |
N |
Y |
Raw KPI data values |
|
rawval2 |
tfloat |
N |
Y |
|
|
rawval3 |
tfloat |
N |
Y |
|
|
rawval4 |
tfloat |
N |
Y |
|
|
rawval5 |
tfloat |
N |
Y |
|
|
rawval6 |
tfloat |
N |
Y |
|
|
rawval7 |
tfloat |
N |
Y |
|
|
rawval8 |
tfloat |
N |
Y |
|
|
spare1 |
string40 |
N |
Y |
Spare value for this KPI that is copied to kpi_data table when a KPI is entered, where it may be updated for a specific instance if required. |
|
spare2 |
string40 |
N |
Y |
Spare value for this KPI as above. |
|
spare3 |
string40 |
N |
Y |
Spare value for this KPI as above. |
|
spare4 |
string40 |
N |
Y |
Spare value for this KPI as above. |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
N |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
Y |
N |
Unique row identifier, for audit trail |
FK from state_cd to kpi_state. (Inhibit delete)
kpi_name, key_int, key_string, captured_at is clustered UK.