dbo.EthCompletiontimesObjectivedb

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Job_Id	uniqueidentifier	no		Unique identifier of the Prime Ecosystem job this row reports on.
2	JobNumber	varchar(50)	yes		Human-readable job reference number (e.g. J012966).
3	AuthorisedTotalExcludingTax	money	yes		Total authorised job value excluding tax.
4	JobType	nvarchar(50)	yes		Type/category of the job in Prime Ecosystem.
5	ClientReference	nvarchar(50)	yes		Insurer/client's own reference number for the job.
6	FilterTags	nvarchar(500)	yes		Delimited list of tags used to filter/categorise the job (e.g. Field, Desktop Video, Desktop Quotation).
7	Mode	varchar(7)	no		Estimating mode for the job (e.g. Field, Desktop).
8	Supervisor	nvarchar(200)	yes		Name of the supervisor assigned to the job.
9	Estimator	nvarchar(200)	yes		Name of the estimator assigned to the job.
10	Case_Manager	nvarchar(200)	yes		Name of the case manager assigned to the job.
11	State	nvarchar(10)	yes		Australian state the job is located in.
12	Instructig_CLient	nvarchar(255)	yes		Name of the insurer/client that instructed the job (misspelled column name).
13	ExcessAmount	decimal(18,2)	yes		Insurance excess amount payable on the job.
14	StartDate	datetime	yes		Current scheduled/actual start date of the appointment or works.
15	EndDate	datetime	yes		Current scheduled/actual end date of the appointment or works.
16	PrimeUrl	nvarchar(255)	yes		Deep link URL to the job record in Prime Ecosystem.
17	UpdatedAt	datetime	yes		Date/time this record was last updated.
18	CreatedAt	datetime	yes		Date/time this record was created.
19	CreatedBy	nvarchar(100)	yes		User who created the underlying appointment/record.
20	InitialStartDate	datetime	yes		Originally scheduled start date before any rescheduling.
21	InitialEndDate	datetime	yes		Originally scheduled end date before any rescheduling.
22	NewStatus	nvarchar(200)	yes		Job status the job was moved to at this status change.
23	statuschangedat	datetime	yes		Date/time the status change to NewStatus occurred.
24	Status_Id	uniqueidentifier	yes		Identifier of the job's current status in Prime Ecosystem.
25	name	varchar(100)	yes		Display name of the job's current status.
26	HistoryCategory	varchar(20)	no		Completion-time workflow stage category (e.g. Time to book, Under Review, Submitted) the job history entry falls into.
27	Category	varchar(20)	no		Current workflow stage category for the job (e.g. Time to book, Under Review, Submitted, Other).
28	ValueBand	varchar(8)	no		Job value bracket (e.g. based on AuthorisedTotalExcludingTax) used for grouping/reporting.
29	Category_Start	datetime	yes		Date/time the job entered its current workflow category.
30	Category_End	datetime	yes		Date/time the job left its current workflow category, if applicable.
31	DaysInCategory	int	yes		Number of days the job has spent in its current workflow category.
32	Pre_Quote_Pie	varchar(6)	yes		Flag/indicator marking the job as being in the pre-quote pipeline slice for reporting charts.
33	Awaiting_Approval_Pie	varchar(7)	yes		Flag/indicator marking the job as awaiting quote approval for reporting charts.
34	Awaiting_Maintenance_Pie	varchar(7)	yes		Flag/indicator marking the job as awaiting maintenance work for reporting charts.
35	Awaiting_Excess_Pie	varchar(7)	yes		Flag/indicator marking the job as awaiting excess payment for reporting charts.
36	Awaiting_Start_Pie	varchar(7)	yes		Flag/indicator marking the job as awaiting works start for reporting charts.
37	WIPCAT	varchar(21)	yes		Work-in-progress category label used for WIP reporting.
38	Works_In_Progress_Pie	varchar(9)	yes		Flag/indicator marking the job as in works-in-progress for reporting charts.
39	rn	bigint	yes		Row number used internally to de-duplicate/rank rows during the export build.

Referenced by

Procedures: dbo.spCompletiontimesObjectivedb