USP_SIMPLEDATALIST_GIVINGLEVELPROGRAMREPORT

                create procedure dbo.USP_SIMPLEDATALIST_GIVINGLEVELPROGRAMREPORT
                (
                    @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    set nocount on;

                    declare @SYSADMIN bit = 0;
                    declare @SITEFILTERMODE tinyint = 0;

                    select @SYSADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID)

                    if @SYSADMIN = 1
                        select @SITEFILTERMODE = 0;
                    if (not @SYSADMIN = 1) and (select count(SITE.ID) from dbo.SITE inner join dbo.UFN_SITESFORUSER(@CURRENTAPPUSERID) as SITESFORUSER on SITESFORUSER.SITEID = SITE.ID) > 0
                        select @SITEFILTERMODE = 1;

                    select
                        GIVINGLEVELPROGRAM.[ID] as VALUE,
                        GIVINGLEVELPROGRAM.[NAME] as LABEL
                    from
                        dbo.[GIVINGLEVELPROGRAM]
                    left join
                        dbo.GIVINGLEVELPROGRAMSITE on GIVINGLEVELPROGRAMSITE.[GIVINGLEVELPROGRAMID] = GIVINGLEVELPROGRAM.[ID]
                    where
                    (
                        @SITEFILTERMODE = 0 
                        or 
                        GIVINGLEVELPROGRAMSITE.[SITEID] in (select APPUSER.SITEID as SITEID from dbo.APPUSER where APPUSER.ID = @CURRENTAPPUSERID)
                    )
                    order by
                        GIVINGLEVELPROGRAM.[NAME];