dbo.EthPeerReviewedErrors

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Id	int	no	identity	Auto-incrementing primary key identifying the peer-reviewed error record.
2	JobNumber	varchar(20)	no		Human-readable job reference number the flagged estimate error relates to.
3	Estimate	varchar(50)	yes		Reference/label of the estimate the flagged error was found on.
4	Estimator	nvarchar(50)	yes		Name of the estimator who authored the estimate containing the error.
5	Category	varchar(50)	yes		Estimate category the flagged line item belongs to.
6	ItemDescription	nvarchar(2000)	yes		Description of the line item the peer review error was flagged against.
7	TypeOfIssue	varchar(50)	no		Category/type of the issue found during peer review (e.g. pricing error, missing scope).
8	FlaggedIssue	nvarchar(2000)	no		Detailed description of the specific error/issue flagged by the peer reviewer.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_FlaggedIssues	CLUSTERED	yes	yes	Id

Referenced by

Procedures: dbo.spEthPeerReviewedErrors