New KPI_Data Table (in FI_Large)

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,e.g., 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

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 0

Y

N

Unique row identifier, for audit trail