| 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 calculated. |
| 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) |
yes |
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) |
yes |
CASE [IMPLEMENTATIONTYPECODE] WHEN 0 THEN N'CLR' WHEN 1 THEN N'SP' END |
Provides a translation for the 'IMPLEMENTATIONTYPECODE' field. |
| GOALRETRIEVALTYPE |
nvarchar(9) (Computed) |
yes |
CASE [GOALRETRIEVALTYPECODE] WHEN 0 THEN N'Dynamic' WHEN 1 THEN N'UserInput' END |
Provides a translation for the 'GOALRETRIEVALTYPECODE' field. |
| GOALTYPE |
nvarchar(7) (Computed) |
yes |
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 |
|