Skip to content

dbo.EthPeerReviewStatus ​

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

Columns ​

#ColumnTypeNullableFlagsDescription
1JobNumbervarchar(50)yesHuman-readable job reference number that entered the AI Peer Review status.
2Suburbnvarchar(100)yesSuburb of the job's property.
3statenvarchar(10)yesAustralian state of the job's property.
4addressnvarchar(255)yesStreet address of the job's property.
5Estimatornvarchar(200)yesName of the estimator assigned to the job.
6Reviewedvarchar(10)noFlag indicating whether the job's AI peer review has been completed.
7Created DatedatetimenoDate/time this peer review status record was created.

Relationships (inferred) ​

FromToConfidence
dbo.EthPeerReviewStatus.JobNumberdbo.primeJobs.JobNumbermedium

Referenced by ​

Procedures: dbo.spEthPopulatePeerReviewStatus