UFN_FUNDRAISER_GETDEFAULTSITEID

        create function dbo.UFN_FUNDRAISER_GETDEFAULTSITEID
        (
            @CONSTITUENTID uniqueidentifier
        )
        returns uniqueidentifier
        with execute as caller
        as begin
            declare @siteId uniqueidentifier
            declare @currentDate date = dbo.UFN_DATE_GETEARLIESTTIME(getdate())

            select @siteId = SITEID 
            from dbo.ORGANIZATIONPOSITIONHOLDER holder
            join dbo.ORGANIZATIONPOSITION pos on holder.POSITIONID = pos.ID
            where CONSTITUENTID = @CONSTITUENTID
              and DATEFROM <= @currentDate
              and (DATETO is null OR DATETO >= @currentDate)

            return @siteId    
        end