Appearance
dbo.EthPeerReviewStatus
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.EthPeerReviewStatus.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | JobNumber | varchar(50) | yes | Human-readable job reference number that entered the AI Peer Review status. | |
| 2 | Suburb | nvarchar(100) | yes | Suburb of the job's property. | |
| 3 | state | nvarchar(10) | yes | Australian state of the job's property. | |
| 4 | address | nvarchar(255) | yes | Street address of the job's property. | |
| 5 | Estimator | nvarchar(200) | yes | Name of the estimator assigned to the job. | |
| 6 | Reviewed | varchar(10) | no | Flag indicating whether the job's AI peer review has been completed. | |
| 7 | Created Date | datetime | no | Date/time this peer review status record was created. |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.EthPeerReviewStatus.JobNumber | dbo.primeJobs.JobNumber | medium |
Referenced by
Procedures: dbo.spEthPopulatePeerReviewStatus

