dbo.ethKpiResultsActive_Deprecated

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobId	uniqueidentifier	no		ID of the job this KPI result row relates to (links to the Prime Ecosystem job).
2	JobNumber	nvarchar(50)	no		Human-readable job number for the job.
3	PrimeUrl	nvarchar(255)	yes		Direct URL to the job's record in the Prime Ecosystem web application.
4	AuthorisedTotalIncludingTax	decimal(18,2)	yes		Total authorised job value including tax.
5	AddressState	nvarchar(50)	yes		Australian state/territory of the job address.
6	FullAddress	nvarchar(500)	yes		Full formatted street address of the job.
7	StatusName	nvarchar(100)	no		Name of the job's current Prime Ecosystem status.
8	KpiResultFromDate	datetime	no		Start date/time of the period this KPI measurement covers.
9	DaysDuration	int	yes		Number of days elapsed for the current measurement period.
10	KPICalcMethod	tinyint	no		Code identifying which calculation method was used to compute this KPI (e.g. span vs summed duration).
11	DaysKPI	int	no		Target number of days allowed for this KPI to be considered met.
12	Sort	int	no		Sort order used to order KPI result rows for display.
13	SupervisorName	nvarchar(200)	yes		Name of the supervisor responsible for the job.
14	SupervisorStatus	nvarchar(50)	yes		Status of the supervisor's involvement/assignment on the job.
15	SupervisorId	uniqueidentifier	yes		ID of the supervisor responsible for the job.
16	SupervisorType	nvarchar(50)	yes		Type/category of supervisor responsible for the job (e.g. State Manager, Case Manager).
17	KpiInstanceDebugId	int	no		ID of the underlying KPI job instance used for debugging/tracing how this result was computed.
18	Assigned	nvarchar(200)	yes		Name of the person the job is currently assigned to.
19	CaseManager	nvarchar(200)	yes		Name of the case manager responsible for the job.
20	Estimator	nvarchar(200)	yes		Name of the estimator assigned to the job.
21	RoleResponsible	nvarchar(200)	yes		Name of the role responsible for meeting this KPI.
22	ManagerResponsible	nvarchar(200)	yes		Name of the manager responsible for oversight of this KPI/job.
23	SumDurationToDate	int	yes		Total accumulated duration in hours counted towards the KPI so far.
24	KpiMet	bit	no		Flag indicating whether the KPI target was met for this job.