UFN_TRIBUTELETTERCODE_USERHASSITEACCESS

Validates that the application user has access to the tribute letter based on site permissions.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN
@TRIBUTELETTERCODEID	uniqueidentifier	IN

Definition

Copy



          create function dbo.UFN_TRIBUTELETTERCODE_USERHASSITEACCESS
          (
            @APPUSERID uniqueidentifier,
            @TRIBUTELETTERCODEID uniqueidentifier
          )
          returns bit with execute as caller
          as
          begin                

            if exists(select SITEID from dbo.UFN_SITEID_MAPFROM_TRIBUTELETTERCODEID(@TRIBUTELETTERCODEID) as TRIBUTELETTERCODESITES where dbo.UFN_SITEALLOWEDFORUSER(@APPUSERID, TRIBUTELETTERCODESITES.SITEID) = 1)                
              return 1
            else
              return 0

            return 0
          end