dbo.ethjobsdataObjectivedb

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

Columns

#	Column	Type	Nullable	Flags	Description
1	id	uniqueidentifier	no		Prime Ecosystem job (primeJobs.id) this row of exported job data represents.
2	JobNumber	varchar(50)	yes		Human-readable job number.
3	State	nvarchar(10)	yes		Australian state the job is located in (e.g. 'VIC', 'QLD').
4	createdAt	datetime	yes		Date and time the job was created in Prime Ecosystem.
5	totalIncludingTax	decimal(18,2)	yes		Total value including tax of the job's locked estimate.
6	Status	varchar(100)	yes		Current Prime Ecosystem status name of the job.
7	estimatecreated	datetime	yes		Date and time the job's locked estimate was created.
8	label	nvarchar(255)	yes		Label of the job's locked estimate (e.g. 'Make Safe', 'Restoration...'), used to categorise the job type.
9	estimateStatus	nvarchar(50)	yes		Status of the job's locked estimate (e.g. 'Authorised', 'Rejected', 'Pending').
10	estimateType	nvarchar(100)	yes		Type of the job's locked estimate (e.g. 'Authorised Works').
11	authorisedTotalExcludingTax	decimal(18,2)	yes		Total value excluding tax of the job's authorised (accepted) works.
12	Quoted_at	datetime	yes		Date and time the job first entered the 'Quote Submitted - Awaiting Approval' status.
13	Accepted_at	datetime	yes		Date and time the job first entered an authorised/accepted status ('Quote Authorised - Awaiting Excess/Owner Acceptance' or 'Restoration Component Authorised').
14	Closed_at	datetime	yes		Date and time the job first entered the 'Closed' status.
15	ReportMonth	date	yes		First day of the month the job was accepted, used to group this row for monthly reporting.

Referenced by

Procedures: dbo.spEthjobsdataObjectivedb