dbo.ethretroactiveinvoicedataObjectivedb

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ReportMonth	date	yes		First day of the reporting month this row's rolling invoicing figures are calculated as at.
2	State	varchar(3)	no		Australian state this row's figures are aggregated for ('VIC' or 'QLD').
3	ReceivedValue	decimal(38,4)	yes		Total invoiced amount received (excluding tax) over the trailing 3-month window ending before ReportMonth.
4	MonthReceivedValue	decimal(38,4)	yes		Total invoiced amount received (excluding tax) during ReportMonth itself.
5	TargetReceivedValue	numeric(38,6)	yes		Target monthly received value, calculated as the trailing 3-month average of ReceivedValue plus a 5% uplift.
6	Budget	int	yes		Fixed annual budget figure assigned to the state for reporting comparisons.
7	ReceivedPercentage	decimal(38,20)	no		MonthReceivedValue expressed as a percentage of TargetReceivedValue.

Referenced by

Procedures: dbo.spethretroactiveinvoicedataObjectivedb