UFN_REVENUESPLITGIFTAID_GETELIGIBLE

Returns the revenue split gift aid records that meet the criteria.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@ACTUALONLY bit IN

Definition

Copy


            CREATE function dbo.UFN_REVENUESPLITGIFTAID_GETELIGIBLE
            (
                @ACTUALONLY bit    
            )
            returns table
            as
            return
            (
                select
                    ID,
                    case dbo.UFN_GIFTAIDREVENUESPLIT_ISRECURRINGGIFTSPLIT(ID) when 0 then TAXCLAIMAMOUNT
                                                                    else dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATENEXTCLAIMAMOUNT(ID) end as TAXCLAIMAMOUNT,
                    TAXCLAIMNUMBER,
                    BASETAXCLAIMAMOUNT,
                    TRANSITIONALTAXCLAIMAMOUNT,
                    INCLUDETRANSITIONALAMOUNTCODE,
                    REVENUESPLITGIFTAIDELIGIBILITY.DATETAXDECLARATIONCHANGED
                from dbo.REVENUESPLITGIFTAID
                outer apply dbo.UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMELIGIBILITYSTATUS_INLINE_2(ID) as REVENUESPLITGIFTAIDELIGIBILITY
                where
                (
                    @ACTUALONLY = 1 and
                    (RULES_STATUS & ATTRIBUTES_STATUS) = 1 and DECLINESGIFTAID = 0 and
                    REVENUESPLITGIFTAIDELIGIBILITY.ELIGIBILITY in (2,3,4)
                ) 
                or
                (
                    @ACTUALONLY = 0 and
                    (RULES_STATUS & ATTRIBUTES_STATUS) = 1 and
                    REVENUESPLITGIFTAIDELIGIBILITY.ELIGIBILITY != 1
                )
            )