Link_HK

Description

The Default Term named Link_HK  contains the Hask Key to identify a row in a Link uniquely.

Format

The Link_HK is a binary(20).

Value

It contains the Hask Key of the row calculated with the Terms declared Business Key in the Link. It uses the SHA1 algorithm.

Example for a Link with the Terms named FK_Customer_AccountNumber and FK_Order_SalesOrderID as Business Key:

HASHBYTES('SHA1', ISNULL([FK_Customer_AccountNumber], '_NULL_') + '_' + ISNULL(CAST([FK_Order_SalesOrderID] AS NVARCHAR(200)), '_NULL_')) AS [Link_HK]

Example of values: