Default Terms
      Back to home
      1. biGENIUS-X Knowledge Base
      2. Generators
      3. Default Terms

      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: