dbo.primeExportsEndataScopeImport_stage

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobNumber	varchar(20)	yes		Human-readable job number/reference used in Prime Ecosystem
2	ClientReference	varchar(20)	yes		Reference number/code supplied by the client (e.g. insurer claim number)
3	EstimateLabel	varchar(50)	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)	yes		Free-text description
7	W	varchar(1)	yes		Width dimension imported from Endata scope
8	L	varchar(1)	yes		Length dimension imported from Endata scope
9	H	varchar(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	GST	decimal(10,2)	yes		Goods and Services Tax amount
15	RowHash	binary(20)	yes		Hash of the row content, used to detect changes
16	isStale	bit	yes		Flag indicating the record is stale and needs refreshing

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
nci_msft_1_primeExportsEndataScopeImport_stage_BEE8C5928399E27DDB6EC9D0AF2DFD5D	NONCLUSTERED			JobNumber, Category, ClientReference, EstimateLabel, Trade	Description, GST, H, isStale, L, LabourQty, MaterialQty, MaterialRate, RowHash, TotalSell, W

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.spPrimeScope_MarkOriginStale_FromStage, dbo.spPrimeScope_MergeCSV_ToStage, dbo.spPrimeScope_UpsertStageRowToOrigin, dbo.spSyncPrimeExportsEndataScopeImport, dbo.spUpsertPrimeScopeImportV2