dbo.ethretroactivejobsdataObjectivedb

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ReportMonth	date	yes		First day of the reporting month this row's rolling job/earnings figures are calculated as at.
2	State	nvarchar(10)	yes		Australian state this row's figures are aggregated for ('VIC', 'QLD', or 'ALL' for the combined total).
3	MakeSafes	int	yes		Count of distinct 'Make Safe' jobs with an estimate created in the trailing 3-month window ending before ReportMonth.
4	Jobs	int	yes		Count of distinct jobs created in the trailing 3-month window ending before ReportMonth.
5	QuoteValue	decimal(38,2)	yes		Total value (including tax) of Authorised Works estimates first quoted in the trailing 3-month window ending before ReportMonth.
6	AuthorisedValue	decimal(38,2)	yes		Total value (excluding tax) of Authorised Works estimates first accepted in the trailing 3-month window ending before ReportMonth.
7	Restorations	int	yes		Count of distinct restoration jobs (label starting 'Resto') with an estimate created in the trailing 3-month window ending before ReportMonth.
8	TargetMakeSafes	numeric(21,8)	yes		Target monthly Make Safe job count, calculated as the trailing 3-month average of MakeSafes plus a 5% uplift.
9	TargetJobs	numeric(21,8)	yes		Target monthly job count, calculated as the trailing 3-month average of Jobs plus a 5% uplift.
10	TargetQuoteValue	numeric(38,6)	yes		Target monthly quote value, calculated as the trailing 3-month average of QuoteValue plus a 5% uplift.
11	TargetAuthorisedValue	numeric(38,6)	yes		Target monthly authorised value, calculated as the trailing 3-month average of AuthorisedValue plus a 5% uplift.
12	TargetRestorations	numeric(21,8)	yes		Target monthly restoration job count, calculated as the trailing 3-month average of Restorations plus a 5% uplift.
13	MonthMakeSafes	int	yes		Count of distinct 'Make Safe' jobs with an estimate created during ReportMonth itself.
14	MonthJobs	int	yes		Count of distinct jobs created during ReportMonth itself.
15	MonthQuoteValue	decimal(38,2)	yes		Total value (including tax) of Authorised Works estimates first quoted during ReportMonth itself.
16	MonthAuthorisedValue	decimal(38,2)	yes		Total value (excluding tax) of Authorised Works estimates first accepted during ReportMonth itself.
17	MonthRestorations	int	yes		Count of distinct restoration jobs (label starting 'Resto') with an estimate created during ReportMonth itself.
18	MakesafePercentage	numeric(38,16)	no		MonthMakeSafes expressed as a percentage of TargetMakeSafes.
19	JobPercentage	numeric(38,16)	no		MonthJobs expressed as a percentage of TargetJobs.
20	QuotePercentage	numeric(38,18)	no		MonthQuoteValue expressed as a percentage of TargetQuoteValue.
21	AuthorisedValuePercentage	numeric(38,18)	no		MonthAuthorisedValue expressed as a percentage of TargetAuthorisedValue.
22	RestorationsPercentage	numeric(38,16)	no		MonthRestorations expressed as a percentage of TargetRestorations.

Referenced by

Procedures: dbo.spEthretroactivejobsdataObjectivedb