dbo.primeExportsEndataScopeImport

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobNumber	varchar(20)	no		Human-readable job number/reference used in Prime Ecosystem
2	ClientReference	varchar(20)	no		Reference number/code supplied by the client (e.g. insurer claim number)
3	EstimateLabel	varchar(100)	yes		Display label/name of the estimate
4	Category	varchar(50)	yes		Scope category imported from Endata
5	Trade	varchar(100)	yes		Trade/skill category (e.g. Plumbing, Electrical, Carpentry)
6	Description	varchar(1000)	no		Free-text description
7	W	char(1)	yes		Width dimension imported from Endata scope
8	L	char(1)	yes		Length dimension imported from Endata scope
9	H	char(1)	yes		Height dimension imported from Endata scope
10	MaterialQty	int	yes		Quantity of materials
11	MaterialRate	decimal(10,2)	yes		Unit rate/price for materials
12	LabourQty	int	yes		Quantity of labour (hours/units)
13	TotalSell	decimal(10,2)	yes		Total sell (billed) amount
14	isStale	bit	yes		Flag indicating the record is stale and needs refreshing
15	GST	decimal(10,2)	yes		Goods and Services Tax amount
16	EstimateLabelKey	varchar(100)	no	computed	Key identifying the estimate label/category used for scope mapping
17	ScopeImportID	bigint	no	identity	Identifier of the scope import batch this row belongs to
18	RowHash	binary(20)	yes		Hash of the row content, used to detect changes

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeExportsEndataScopeImport	CLUSTERED	yes	yes	ScopeImportID
IX_PrimeScope_BusinessKey	NONCLUSTERED			JobNumber, ClientReference, EstimateLabel, Category, Trade, Description

Relationships (inferred)

From	To	Confidence
dbo.primeExportsEndataScopeImport.Category	dbo.primeExportsEndataScopeImport_stage.Category	high
dbo.primeExportsEndataScopeImport.ClientReference	dbo.primeExportsEndataScopeImport_stage.ClientReference	high
dbo.primeExportsEndataScopeImport.Description	dbo.primeExportsEndataScopeImport_stage.Description	medium
dbo.primeExportsEndataScopeImport.EstimateLabel	dbo.primeExportsEndataScopeImport_stage.EstimateLabel	high
dbo.primeExportsEndataScopeImport.GST	dbo.primeExportsEndataScopeImport_stage.GST	medium
dbo.primeExportsEndataScopeImport.H	dbo.primeExportsEndataScopeImport_stage.H	medium
dbo.primeExportsEndataScopeImport.JobNumber	dbo.primeExportsEndataScopeImport_stage.JobNumber	high
dbo.primeExportsEndataScopeImport.L	dbo.primeExportsEndataScopeImport_stage.L	medium
dbo.primeExportsEndataScopeImport.LabourQty	dbo.primeExportsEndataScopeImport_stage.LabourQty	medium
dbo.primeExportsEndataScopeImport.MaterialQty	dbo.primeExportsEndataScopeImport_stage.MaterialQty	medium
dbo.primeExportsEndataScopeImport.MaterialRate	dbo.primeExportsEndataScopeImport_stage.MaterialRate	medium
dbo.primeExportsEndataScopeImport.TotalSell	dbo.primeExportsEndataScopeImport_stage.TotalSell	medium
dbo.primeExportsEndataScopeImport.Trade	dbo.primeExportsEndataScopeImport_stage.Trade	high
dbo.primeExportsEndataScopeImport.W	dbo.primeExportsEndataScopeImport_stage.W	medium

Referenced by

Procedures: dbo.spEthGetEndataPrimeScopeImport, dbo.spPrimeScope_MarkJobStale, dbo.spPrimeScope_MarkOriginStale_FromStage, dbo.spPrimeScope_MergeRow_Hash, dbo.spPrimeScope_UpsertStageRowToOrigin, dbo.spTruncateScopeImportBeforeSync, dbo.spUpsertPrimeScopeImport, dbo.spUpsertPrimeScopeImportV2