dbo.EthEstimatorStageSummary

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Jobnumber	varchar(50)	yes		Human-readable job reference number this stage-timing summary row is for.
2	jobType	nvarchar(50)	yes		Type/category of the job.
3	Status	varchar(100)	yes		Current job status name at the time the summary was generated.
4	Estimator	nvarchar(200)	yes		Name of the estimator assigned to the job.
5	State	nvarchar(10)	yes		Australian state the job is located in.
6	Case Manager	nvarchar(200)	yes		Name of the case manager assigned to the job.
7	Instructing Client	nvarchar(255)	yes		Name of the insurer/client that instructed the job.
8	Quoted Date	datetime	yes		Date/time the quote was submitted for approval (status changed to Quote Submitted - Awaiting Approval).
9	book	int	yes		Cumulative hours elapsed reaching the booking stage of the job workflow.
10	esti	int	yes		Cumulative hours elapsed reaching the estimator-submission stage of the job workflow.
11	fsub	int	yes		Cumulative hours elapsed reaching the job's first review/submission stage.
12	lsub	int	yes		Cumulative hours elapsed reaching the job's last review/submission stage.
13	app	int	yes		Cumulative hours elapsed reaching quote approval for the job.
14	total_time	numeric(17,6)	yes		Total elapsed time in days across all tracked workflow stages.
15	preActioned	int	no		Flag (1/0) indicating the estimator submission occurred before/at the booking stage completed, i.e. work was pre-actioned.
16	Submission_Attempts	int	yes		Number of times the estimate was submitted for review/approval on this job.
17	time to booking	numeric(17,6)	yes		Elapsed time in days from job registration to the estimator appointment being booked.
18	time to estimator submission	numeric(17,6)	yes		Elapsed time in days from booking to the estimator submitting the estimate.
19	review to first submission	numeric(17,6)	yes		Elapsed time in days from estimator submission to the first review/re-submission cycle.
20	time to last submission	numeric(17,6)	yes		Elapsed time in days from the first submission cycle to the final (last) submission before approval.
21	Time to Quote Responce	numeric(17,6)	yes		Elapsed time in days from the last submission to the client's response/decision on the quote.

Referenced by

Procedures: dbo.spRefreshEstimatorStageSummary