Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(255)   Default = '' Name of the KPI spec.
 DESCRIPTION nvarchar(max)   Default = '' Description of the KPI spec. If a detailed description is defined that value will be stored. If no detailed description is defined the spec's description will be stored.
 SPNAME nvarchar(100)   Default = '' SQL stored procedure used to calculate the KPI.
 GOALSPNAME nvarchar(100)   Default = '' SQL stored procedure used to calculate the KPI instance goal. If this field is empty, the user will be required to specify a goal value when the KPI instance is created.
 ASSEMBLYNAME nvarchar(100)   Default = '' CLR assembly containing the class to calculate the KPI.
 CLASSNAME nvarchar(150)   Default = '' CLR class to calculate the KPI.
 IMPLEMENTATIONTYPECODE tinyint   Default = 1 Indicates how the KPI is caluclated.
 GOALRETRIEVALTYPECODE tinyint   Default = 1 Indicates how the goal value is retrieved.
 GOALTYPECODE tinyint   Default = 0 Type of goal represented by the KPI.
 UIFOLDER nvarchar(255)   Default = '' The folder path where the KPI catalog item and instances will be displayed when presented in a UI tree view.
 SECURITYUIFOLDER nvarchar(255)   Default = '' The folder path where the KPI catalog item will be displayed in the security tree view.
 SPECXML xml   The XML which represents the KPI spec.
 CONTEXTRECORDIDPARAMETER nvarchar(255)   Default = '' Name of the parameter in the form metadata that represents the KPI's context ID.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 DECIMALPLACES tinyint   Default = 0 Number of decimal places to display for the goal and KPI values.
 IMPLEMENTATIONTYPE nvarchar(3) (Computed) CASE [IMPLEMENTATIONTYPECODE] WHEN 0 THEN N'CLR' WHEN 1 THEN N'SP' END Provides a translation for the 'IMPLEMENTATIONTYPECODE' field.
 GOALRETRIEVALTYPE nvarchar(9) (Computed) CASE [GOALRETRIEVALTYPECODE] WHEN 0 THEN N'Dynamic' WHEN 1 THEN N'UserInput' END Provides a translation for the 'GOALRETRIEVALTYPECODE' field.
 GOALTYPE nvarchar(7) (Computed) CASE [GOALTYPECODE] WHEN 0 THEN N'Money' WHEN 1 THEN N'Number' WHEN 2 THEN N'Percent' END Provides a translation for the 'GOALTYPECODE' field.
 HASSITEFILTER bit   Default = 0

Foreign Key Field Type Null Notes Description
 CONTEXTRECORDTYPEID uniqueidentifier RECORDTYPE.ID Context record type ID of the KPI spec.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_KPICATALOG_DATEADDED DATEADDED    
 IX_KPICATALOG_DATECHANGED DATECHANGED      
 PK_KPICATALOG ID  
 UC_KPICATALOG_NAME NAME    

Trigger Name Description
 TR_KPICATALOG_AUDIT_UPDATE
 TR_KPICATALOG_AUDIT_DELETE

Referenced by Field
 KPIINSTANCE KPICATALOGID
 MKTACKNOWLEDGEMENTMAILINGTEMPLATEKPI KPICATALOGID
 MKTMEMBERSHIPMAILINGTEMPLATEKPI KPICATALOGID
 MKTSEGMENTATIONACTIVATEDEFAULTKPI KPICATALOGID
 MKTSEGMENTATIONACTIVATEKPI KPICATALOGID
 MKTSPONSORSHIPMAILINGTEMPLATEKPI KPICATALOGID
 SYSTEMROLEPERM_KPI KPICATALOGID

Entity-Relationship diagram of this table