dbo.endataCostCentreDescriptions

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key identifier for this cost centre description record.
2	CostCentreId	int	no		Foreign key to the Endata cost centre this description text applies to.
3	Description	nvarchar(500)	no		Free-text description of the cost centre as sourced from Endata.
4	NormalizedDescription	nvarchar(500)	yes	computed	Computed lowercase, trimmed version of Description used for case-insensitive matching/deduplication.
5	DescriptionHash	varbinary(8000)	yes	computed	Computed SHA2_256 hash of the normalized description, used to quickly detect duplicate or changed descriptions.
6	IsStale	bit	no		Flag (1/0) indicating whether this record was not seen in the most recent Endata sync and should be treated as outdated.
7	CreatedAt	datetime2(7)	no		Timestamp when this record was first created in this table.
8	UpdatedAt	datetime2(7)	yes		Timestamp when this record was last updated by an Endata sync.
9	LastSeenAt	datetime2(7)	yes		Timestamp of the most recent Endata sync in which this record was present.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__endataCo__3214EC2783D267FF	CLUSTERED	yes	yes	ID
IX_CostCentre_DescriptionHash	NONCLUSTERED	yes		CostCentreId, DescriptionHash

Relationships (inferred)

From	To	Confidence
dbo.endataCostCentreDescriptions.CostCentreId	dbo.endataCostCentres.ID	medium

Referenced by

Procedures: dbo.spSyncCostCentreDescriptions