dbo.ethKpiMeasures

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.ethKpiMeasures.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Surrogate primary key identifying this KPI measure definition.
2	StatusName	varchar(100)	no		The job status this KPI measure/target applies to.
3	DaysKPI	int	yes		The target number of days a job should spend in this status before breaching the KPI.
4	JobTag	varchar(50)	yes		Optional job tag used to restrict this KPI measure to jobs carrying a matching tag.
5	FromDate	date	no		The start date from which this KPI measure definition is effective.
6	ToDate	date	no		The end date until which this KPI measure definition is effective.
7	FromJobValue	money	yes		The lower bound of the job value (authorised total including tax) range this KPI measure applies to.
8	ToJobValue	money	yes		The upper bound of the job value (authorised total including tax) range this KPI measure applies to.
9	KPICalcMethod	tinyint	yes		A code selecting how elapsed time is calculated against the KPI target: 0 measures continuous elapsed time since the job entered the status, other values measure cumulative summed duration across repeat instances of the status.
10	Sort	int	no		The display/priority order used when selecting between multiple matching KPI measures for a job.
11	CreatedAt	datetime	no		The date and time this KPI measure definition was created.
12	HoursKPI	int	yes		The target number of hours a job should spend in this status before breaching the KPI.
13	KpiDurationDescription	varchar(32)	yes	computed	Computed human-readable rendering of HoursKPI as a duration string (e.g. '2 Days 4 Hours' or 'None').
14	JobFilterTagID	uniqueidentifier	yes		Optional foreign key to a Prime Ecosystem job filter tag; when set, restricts this KPI measure to jobs carrying that filter tag.

Relationships (inferred)

From	To	Confidence
dbo.ethKpiMeasures.StatusName	dbo.ethKpiJobInstance.StatusName	medium
dbo.ethKpiMeasures.StatusName	dbo.ethKpiJobSummary.StatusName	high
dbo.primeJobFilterTags.FilterTagId	dbo.ethKpiMeasures.JobFilterTagID	high

Referenced by

Views: dbo.vEthKpiResults_Deprecated, dbo.vEthKpiResultsActive_Deprecated, dbo.vEthKpiResultsClosed_Deprecated

Procedures: dbo.spEthKpiResultsActive, dbo.spEthKpiResultsActiveAll, dbo.spEthKpiResultsbyJobId