dbo.ethKpiResults

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.ethKpiResults.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	yes		Start date/time of the period this KPI measurement covers.
9	KpiResultToDate	datetime	yes		End date/time of the period this KPI measurement covers.
10	KpiResultChurn	int	yes		Count of how many times this KPI measurement has been recalculated/reset (churn count) for the job.
11	SpanDurationHours	int	yes		Elapsed wall-clock hours spanned between the KPI measurement's from and to dates.
12	SumDurationHours	int	yes		Total accumulated hours counted towards the KPI (e.g. excluding paused/non-business time).
13	KPICalcMethod	tinyint	yes		Code identifying which calculation method was used to compute this KPI (e.g. span vs summed duration).
14	HoursKPI	int	yes		Target number of hours allowed for this KPI to be considered met.
15	ActualDurationHours	int	yes		Actual measured duration in hours used to assess the KPI.
16	KpiMet	bit	no		Flag indicating whether the KPI target was met for this job.
17	Sort	int	yes		Sort order used to order KPI result rows for display.
18	Supervisor	nvarchar(200)	yes		Name of the supervisor responsible for the job at the time of measurement.
19	Assigned	nvarchar(200)	yes		Name of the person the job is currently assigned to.
20	CaseManager	nvarchar(200)	yes		Name of the case manager responsible for the job.
21	Estimator	nvarchar(200)	yes		Name of the estimator assigned to the job.
22	Role	nvarchar(200)	yes		Name of the role responsible for meeting this KPI.
23	Manager	nvarchar(200)	yes		Name of the manager responsible for oversight of this KPI/job.
24	KpiResultFromDateFY	varchar(25)	no	computed	Computed Australian financial year (e.g. '2024/2025') that the KPI's from-date falls within.
25	SpanDurationDescription	varchar(32)	yes	computed	Human-readable description of SpanDurationHours (e.g. '2 Days 3 Hours').
26	SumDurationDescription	varchar(32)	yes	computed	Human-readable description of SumDurationHours (e.g. '2 Days 3 Hours').
27	HoursKPIDescription	varchar(32)	yes	computed	Human-readable description of the HoursKPI target duration (e.g. '2 Days 3 Hours').
28	ActualDurationDescription	varchar(32)	yes	computed	Human-readable description of ActualDurationHours (e.g. '2 Days 3 Hours').
30	ActualDurationDays	decimal(18,2)	yes	computed	Actual measured duration converted to (fractional) days.
31	MeasureJobTag	nvarchar(50)	yes		Job tag used to segment/scope which KPI measure applies to this job (e.g. Field/Desktop/Complex).
32	MeasureFromJobValue	money	yes		Lower bound of job value used to determine which KPI measure/threshold applies.
33	MeasureToJobValue	money	yes		Upper bound of job value used to determine which KPI measure/threshold applies.
35	MeasureSummary	nvarchar(4000)	yes	computed	Human-readable summary describing the job tag and value range this KPI measure applies to.
37	MeasureJobType	varchar(7)	no	computed	Computed classification of the job (Field, Desktop, or Blank) derived from MeasureJobTag.
38	ManagerResponsibleList	varchar(83)	no	computed	Computed comma-delimited list of manager role titles responsible for this KPI/job type.
39	InstructingClient	nvarchar(255)	yes		Name of the client/insurer who instructed the job.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
nci_msft_1_ethKpiResults_7B7259BB83702185C4E5165B3B4D0E21	NONCLUSTERED			JobId	SpanDurationDescription

Referenced by

Procedures: dbo.spEthKpiResultsbyJobId