dbo.ethListsFact

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Surrogate primary key for this list/lookup fact row.
2	RoomType	varchar(100)	no		Name of the room type this cost/labour fact row applies to.
3	Active	varchar(3)	no		Flag indicating whether this room type entry is currently active/in use.
4	PrimeTradeList	varchar(100)	no		Name of the corresponding Prime Ecosystem trade list this room type maps to.
5	EndataTrades	varchar(100)	no		Name of the corresponding Endata trade this room type maps to.
6	Rate	decimal(5,2)	no		Labour rate applied for this room type.
7	Labour	int	no		Standard labour quantity/allowance associated with this room type.
8	LabourType	varchar(20)	no		Unit or category of the labour measure (e.g. hours).
9	Material	varchar(50)	no		Standard material allowance associated with this room type.
10	LabourAndMaterials	varchar(50)	no		Combined labour and materials allowance associated with this room type.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__ethLists__3214EC2734B1BB4E	CLUSTERED	yes	yes	ID

Relationships (inferred)

From	To	Confidence
dbo.ethListsFact.EndataTrades	dbo.ethTradeMatchupFact.ProposedTrade	medium

Referenced by

Procedures: dbo.spEthGetAllLists, dbo.spEthGetTradesMatchup, dbo.spEthUpsertList, dbo.spGetEndataTradesMatchup