KPI master data

View and update KPI framework, algorithm, modules, queries, categories, and settings. Changes are saved to the STC database (via API).

Core configuration

KPI framework

Stages, sub-steps, dates, prerequisite/impact. Updates kpi_framework* tables.

KPI algorithm

Algorithm meta & sub-meta. Updates kpi_algorithm* tables.

Supporting masters

KPI module

Module codes and query links. kpi_module

KPI query

SQL templates ({{matchCode}}). kpi_query

KPI category

Categories & leg conditions. kpi_category*

KPI settings

Settings master. kpi_settings*

Reference

KPI schema diagram

Entity relationships

KPI schema data

Browse table rows