KPIINSTANCEMILESTONE (4.0)

Contains a list of values and dates which represent milestones on the way toward reaching the ultimate goal.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

KPIINSTANCEID

uniqueidentifier

false

KPI instance to which this milestone belongs.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

VALUE

decimal(19, 5)

false

0

Value for the KPI instance milestone.

ASOFDATE

datetime

false

Date on which the milestone value is expected to be reached.

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.

UPWARDLOWVALUE

decimal(19, 5)

false

0

UPWARDMIDVALUE

decimal(19, 5)

false

0

DOWNWARDMIDVALUE

decimal(19, 5)

false

0

DOWNWARDHIGHVALUE

decimal(19, 5)

false

0

Indexes
Index Name Field(s) Unique Primary Clustered

IX_KPIINSTANCEMILESTONE_ASOFDATE

ASOFDATE

False

False

False

IX_KPIINSTANCEMILESTONE_DATEADDED

DATEADDED

False

False

True

IX_KPIINSTANCEMILESTONE_DATECHANGED

DATECHANGED

False

False

False

IX_KPIINSTANCEMILESTONE_KPIINSTANCEID

KPIINSTANCEID

False

False

False

PK_KPIINSTANCEMILESTONE

ID

True

True

False
Triggers
Trigger Name Description

TR_KPIINSTANCEMILESTONE_AUDIT_DELETE

TR_KPIINSTANCEMILESTONE_AUDIT_UPDATE