dbo.EthHOWCompliance

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobNumber	varchar(50)	yes		Human-readable job reference number this Home Owners Warranty compliance row is for.
2	Job Status	varchar(100)	yes		Current job status name.
3	Authorised Work Value	money	yes		Total authorised work value for the job.
4	State	nvarchar(10)	yes		Australian state the job is located in.
5	StartDate	datetime	yes		Scheduled/actual start date of the works.
6	Location_Type	varchar(10)	yes		Category of the job's location/property type.
7	Work Order	nvarchar(255)	yes		Reference/description of the work order raised for the job.
8	Work Order Cost	decimal(11,2)	yes		Cost of the work order raised for the job.
9	Amount Paid	decimal(18,4)	yes		Amount paid to date for the job.
12	Criteria	varchar(14)	no		Compliance rule/criteria code the job matched to be flagged for Home Owners Warranty review.
14	Address	nvarchar(100)	yes		Property address for the job.

Referenced by

Procedures: dbo.SPEthHOWCompliance