UFN_SITEID_MAPFROM_DESIGNATIONLEVELID

create function [BBDW].[UFN_SITEID_MAPFROM_DESIGNATIONLEVELID]
  (  
    @DESIGNATIONLEVELID uniqueidentifier
  )   
  returns uniqueidentifier
    as  

    begin
      declare @ID uniqueidentifier;

      select @ID = p.[SITESYSTEMID]
      from BBDW.[DIM_PURPOSELEVEL] p

      where p.[PURPOSELEVELSYSTEMID] = @DESIGNATIONLEVELID

      return @ID;
    end