dbo.EthSalesPipelinejobsObjectivedb

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Job_Id	uniqueidentifier	no		Unique identifier of the Prime Ecosystem job this sales pipeline row is for.
2	JobNumber	varchar(50)	yes		Human-readable job reference number.
3	ClientReference	nvarchar(50)	yes		Insurer/client's own reference number for the job.
4	JobType	nvarchar(50)	yes		Type/category of the job in Prime Ecosystem.
5	State	nvarchar(10)	yes		Australian state the job is located in.
6	Instructing_Client	nvarchar(255)	yes		Name of the insurer/client that instructed the job.
7	ExcessAmount	decimal(18,2)	yes		Insurance excess amount payable on the job.
8	Supervisor	nvarchar(200)	yes		Name of the supervisor assigned to the job.
9	StartDate	datetime	yes		Current scheduled/actual start date of the appointment or works.
10	EndDate	datetime	yes		Current scheduled/actual end date of the appointment or works.
11	PrimeUrl	nvarchar(255)	yes		Deep link URL to the job record in Prime Ecosystem.
12	CreatedAt	datetime	yes		Date/time this record was created.
13	CreatedBy	nvarchar(100)	yes		User who created the underlying appointment/record.
14	UpdatedAt	datetime	yes		Date/time this record was last updated.
15	UpdatedBy	nvarchar(100)	yes		User who last updated the underlying appointment/record.
16	InitialStartDate	datetime	yes		Originally scheduled start date before any rescheduling.
17	InitialEndDate	datetime	yes		Originally scheduled end date before any rescheduling.
18	estimatecreated	datetime	yes		Date/time the job's estimate was created.
19	label	nvarchar(255)	yes		Display label of the estimate/appointment associated with the job.
20	estimateStatus	nvarchar(50)	yes		Current status of the job's estimate (e.g. In Review, Pending, Authorised).
21	estimateType	nvarchar(100)	yes		Type of the job's estimate (e.g. Authorised Works).
22	Total_ex_tax	numeric(23,6)	yes		Total value of the estimate excluding tax.
23	Status_Id	uniqueidentifier	yes		Identifier of the job's current status in Prime Ecosystem.
24	name	varchar(100)	yes		Display name of the job's current status.
25	Category	varchar(20)	no		Sales pipeline stage category the job is grouped into for Objective reporting.

Referenced by

Procedures: dbo.spEthSalesPipelinejobsObjectivedb