USP_SIMPLEDATALIST_GIFTAIDDISQUALIFICATIONATTRIBUTECATEGORIES

A simple data list of attribute categories for a Gift Aid disqualification.

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPE	nvarchar(100)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_GIFTAIDDISQUALIFICATIONATTRIBUTECATEGORIES
            (
                @RECORDTYPE nvarchar(100) = '',
                @CURRENTAPPUSERID uniqueidentifier = null  
            ) 
            as                
                set nocount on;

                select   
                    ATTRIBUTECATEGORY.ID as VALUE,   
                    ATTRIBUTECATEGORY.NAME as LABEL   
                from   
                    dbo.ATTRIBUTECATEGORY  
                    inner join dbo.ATTRIBUTERECORDTYPE on ATTRIBUTERECORDTYPE.ID = ATTRIBUTECATEGORY.ATTRIBUTERECORDTYPEID  
                    inner join dbo.RECORDTYPE on RECORDTYPE.ID = ATTRIBUTERECORDTYPE.RECORDTYPEID  
                where   
                    RECORDTYPE.NAME = @RECORDTYPE and   
                    dbo.UFN_SECURITY_APPUSER_GRANTED_ATTRIBUTECATEGORY_IN_SYSTEMROLE(@CURRENTAPPUSERID,ATTRIBUTECATEGORY.ID) = 1    
                    and ATTRIBUTECATEGORY.DATATYPECODE <> 3
                order by   
                    ATTRIBUTECATEGORY.NAME;