KPI table

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • The KPI [sn_kpi_kpi] table stores the important information about the KPIs created.

    KPI [sn_kpi_kpi] table

    The KPI [sn_kpi_kpi] table contains the following fields.
    Tableau 1. KPI table
    Field Data type Description
    Name String Name of the KPI.
    Description String Brief description of the KPI.
    Active Boolean Status of the KPI.
    KPI Template Reference KPI Template used to create the KPI.
    Supplier Reference Supplier for which this KPI is created.
    Threshold set Reference Set of thresholds created for this KPI.
    Domain Reference Performance domain of the KPI.
    Type Choice Indicates the type of the KPI.
    Nature Choice Indicates whether the KPI is leading (predicts future), lagging (measures past performance), or current (monitors ongoing activities).
    Collected from user Reference The person who provides the data.
    Weight Integer Determines the importance of the KPI in the overall performance score when multiple KPIs are collected.
    Direction Choice Indicates whether the KPI should be minimized or maximised to show the ideal trend of the values.
    Precision Integer Specifies the number of decimal points to be used for data collection to ensure accuracy and consistency.
    Collection source type Choice The user persona that provides the data.
    Unit Reference Measurement unit used to quantify the KPI.
    Collection frequency String The frequency for collecting the KPI data.
    Instructions Translated html Populated in KPI collection tasks to give more context to the user providing the KPI data.
    Next run date Date Next scheduled run date of the KPI to collect the data.
    Last collected date Date Latest date on which KPI data is collected.
    Last period data Reference Latest KPI data.
    Entity table Table name Table in which the entity belongs.
    Entity Sys ID Document ID Sys ID of the entity.