KPI Template table

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read
  • The KPI Template [sn_kpi_template] table stores the configurations required to create KPIs.

    KPI Template [sn_kpi_template] table

    The KPI Template [sn_kpi_template] table contains the following fields.
    Table 1. KPI Template table
    Field Data type Description
    Name String Name of the KPI template.
    Description String Brief description of the KPI template.
    Active Boolean Status of the KPI template.
    Threshold set Reference Set of thresholds created for this template.
    Domain Reference Performance domain of the template.
    Type Choice Indicates the type of the KPI template.
    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.
    Recommended weight Integer Determines the importance of the KPI in the overall performance score when multiple KPIs are collected.
    Supplier count Integer Total number of suppliers added to the KPI template.
    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.
    Template owner Reference The person who owns the KPI template.
    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.