Default Terms
      Back to home
      1. biGENIUS-X Help Center
      2. Generators
      3. Default Terms

      BG_RowHash

      Description

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

      Format

      The BG_RowHash is a binary(20).

      Value

      It contains the Hask Key of the row calculated with all the Terms (except the Foreign Key Terms) in the Satellite or Link Satellite. It uses the SHA1 algorithm.

      Example for a Satellite with the Terms named Marital_Status, Gender, and Number_Of_Children :

      HASHBYTES('SHA1', ISNULL([Marital_Status], '_NULL_') + '_' + ISNULL([Gender], '_NULL_') + '_' + ISNULL(CAST([Number_Of_Children] AS NVARCHAR(200)), '_NULL_')) AS [BG_RowHash]

      Example of values: