USP_SIMPLEDATALIST_DONATIONATTRIBUTECATEGORIES

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



CREATE PROCEDURE dbo.USP_SIMPLEDATALIST_DONATIONATTRIBUTECATEGORIES
(   
    @CURRENTAPPUSERID uniqueidentifier=NULL
)
AS 
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 IN('Constituent' , 'Revenue')
       AND ATTRIBUTECATEGORY.FLAGGEDFORDELETE=0
       AND dbo.UFN_SECURITY_APPUSER_GRANTED_ATTRIBUTECATEGORY_IN_SYSTEMROLE (@CURRENTAPPUSERID , ATTRIBUTECATEGORY.ID)=1
ORDER BY   ATTRIBUTECATEGORY.NAME;