KPIINSTANCE (4.0)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Contains KPI goal, trigger, and alert settings for various KPIs.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
KPICATALOGID	uniqueidentifier	false	KPICATALOG.ID	ID of the KPI to which this record is associated.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
STATUSCHANGEDALERTID	uniqueidentifier	true	ALERTTYPE.ID	FK to ALERTTYPE. Represents the alert associated with this KPI when the status changes.
FOLDERID	uniqueidentifier	true	KPIINSTANCEFOLDER.ID

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(255)	false	''	Name of the KPI spec.
DESCRIPTION	nvarchar(1000)	false	''	Description of the KPI spec.
GOALVALUE	decimal(19, 5)	false	0	Goal for the KPI represented by a whole number.
GOALINDICATORTYPECODE	tinyint	false	0	Determines how the goal progress is rendered in the UI.
GOALAIMTYPECODE	tinyint	false	0	The direction in which the trend should ideally go.
GOALUPWARDLOWVALUE	decimal(20, 4)	false	0
GOALUPWARDMIDVALUE	decimal(20, 4)	false	0
GOALDOWNWARDMIDVALUE	decimal(20, 4)	false	0
GOALDOWNWARDHIGHVALUE	decimal(20, 4)	false	0
PARAMETERSXML	xml	true		Data form item which represents the parameters for the KPI instance.
HISTORYTYPECODE	tinyint	false	0	Method for archiving past KPI instance values.
NUMBEROFITEMSTOSTORE	int	false	0	Number of KPI instance values to archive.
CONTEXTRECORDID	nvarchar(100)	false	''	ID of the context record associated with this KPI instance.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
GOALINDICATORTYPE	nvarchar(13) (Computed)	true		Provides a translation for the 'GOALINDICATORTYPECODE' field.
GOALAIMTYPE	nvarchar(4) (Computed)	true		Provides a translation for the 'GOALAIMTYPECODE' field.
HISTORYTYPE	nvarchar(20) (Computed)	true		Provides a translation for the 'HISTORYTYPECODE' field.
SITEFILTERENABLEDFORINSTANCE	bit	false	0	Indicates whether this KPI instance should have site filtering applied for it.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_KPIINSTANCE_CONTEXTRECORDID	CONTEXTRECORDID	False	False	False
IX_KPIINSTANCE_DATEADDED	DATEADDED	False	False	True
IX_KPIINSTANCE_DATECHANGED	DATECHANGED	False	False	False
IX_KPIINSTANCE_FOLDERID	FOLDERID	False	False	False
IX_KPIINSTANCE_KPICATALOGID	KPICATALOGID	False	False	False
PK_KPIINSTANCE	ID	True	True	False
UC_KPIINSTANCE_NAME	NAME	True	False	False
UIX_KPIINSTANCE_STATUSCHANGEDALERTID	STATUSCHANGEDALERTID	True	False	False

Triggers
Trigger Name	Description
TR_KPIINSTANCE_AUDIT_UPDATE
TR_KPIINSTANCE_AUDIT_DELETE

Referenced by
Referenced by	Field
APPUSERKPIINSTANCEFAVORITE	KPIINSTANCEID
KPIDASHBOARDPAGETABKPIINSTANCE	KPIINSTANCEID
KPIINSTANCEHISTORY	KPIINSTANCEID
KPIINSTANCEMILESTONE	KPIINSTANCEID
KPIINSTANCESITE	KPIINSTANCEID
KPIINSTANCESTATUS	PARAMETERSETID
KPIINSTANCESTATUSHISTORY	KPIINSTANCEID
SYSTEMROLEKPIINSTANCE	KPIINSTANCEID