USP_DATALIST_GIFTAIDRULESTHATDISQUALIFYREVENUE

This datalist returns a list of the gift aid disqualification rules applicable to the given pledge or recurring gift.

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_GIFTAIDRULESTHATDISQUALIFYREVENUE
                (
                    @REVENUEID uniqueidentifier
                )
                as
                    set nocount on

                    select 
                        DISQUALIFICATIONS.CATEGORY,
                        DISQUALIFICATIONS.DESCRIPTION
                    from dbo.REVENUESPLIT
                    cross apply dbo.UFN_REVENUESPLIT_GETDISQUALIFICATIONS(REVENUESPLIT.ID, 1)as DISQUALIFICATIONS
                    where REVENUESPLIT.REVENUEID = @REVENUEID
                    order by CATEGORY;