dbo.ethKpiResultsClosed_Deprecated

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.ethKpiResultsClosed_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	JobClosedDate	datetime	no		Date/time the job was closed.
8	StatusName	nvarchar(100)	no		Name of the job's current Prime Ecosystem status.
9	KpiResultFromDate	datetime	no		Start date/time of the period this KPI measurement covers.
10	KpiResultToDate	datetime	no		End date/time of the period this KPI measurement covers.
11	SpanDuration	int	yes		Elapsed wall-clock hours spanned between the KPI measurement's from and to dates.
12	SumDuration	int	yes		Total accumulated hours counted towards the KPI.
13	KPICalcMethod	tinyint	no		Code identifying which calculation method was used to compute this KPI (e.g. span vs summed duration).
14	DaysKPI	int	yes		Target number of days allowed for this KPI to be considered met.
15	Sort	int	no		Sort order used to order KPI result rows for display.
16	SupervisorName	nvarchar(200)	yes		Name of the supervisor responsible for the job.
17	SupervisorStatus	nvarchar(50)	yes		Status of the supervisor's involvement/assignment on the job.
18	SupervisorId	uniqueidentifier	yes		ID of the supervisor responsible for the job.
19	SupervisorType	nvarchar(50)	yes		Type/category of supervisor responsible for the job (e.g. State Manager, Case Manager).
20	Assigned	nvarchar(200)	yes		Name of the person the job is currently assigned to.
21	CaseManager	nvarchar(200)	yes		Name of the case manager responsible for the job.
22	Estimator	nvarchar(200)	yes		Name of the estimator assigned to the job.
23	RoleResponsible	nvarchar(200)	yes		Name of the role responsible for meeting this KPI.
24	ManagerResponsible	nvarchar(200)	yes		Name of the manager responsible for oversight of this KPI/job.
25	KpiMet	bit	no		Flag indicating whether the KPI target was met for this job.