dbo.kpiTableLookup_Deprecated

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key for this deprecated KPI status lookup row.
2	statusName	nvarchar(200)	yes		Job status name this KPI target row applies to.
3	averageDaysAtStatusKpiField	int	yes		Target average number of days a job should spend at this status for field-based work.
4	averageDaysAtStatusKpiDesktop	int	yes		Target average number of days a job should spend at this status for desktop-based work.
5	statusSort	int	yes		Sort order used to display job statuses in KPI reports.
6	desktopOrField	varchar(10)	yes		Indicates whether this status is worked on desktop or in the field ("Desktop"/"Field").
7	statusMerged	varchar(200)	yes		Consolidated status label grouping related job statuses together for KPI reporting.