UFN_GIFTAIDDISQ_GETRECORDS

            CREATE function dbo.UFN_GIFTAIDDISQ_GETRECORDS()
            returns table
            as return  

            --Disqualification Rules: Appeal, Campaign, Credit Card Type, Designation, Event, Membership, Payment Method, Revenue Category


                select
                    GIFTAIDDISQUALIFIEDBYAPPEAL.ID as ID,
                    'Appeal' as BASEDON
                from dbo.GIFTAIDDISQUALIFIEDBYAPPEAL

                UNION ALL

                select
                    GIFTAIDDISQUALIFIEDBYCAMPAIGN.ID as ID,
                    'Campaign' as BASEDON
                from dbo.GIFTAIDDISQUALIFIEDBYCAMPAIGN

                UNION ALL

                select
                    GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE.ID as ID,
                    'CreditCardType' as BASEDON
                from dbo.GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE

                UNION ALL

                select
                    GIFTAIDDISQUALIFIEDBYDESIGNATION.ID as ID,
                    'Designation' as BASEDON
                from dbo.GIFTAIDDISQUALIFIEDBYDESIGNATION

                UNION ALL

                select
                    GIFTAIDDISQUALIFIEDBYEVENT.ID as ID,
                    'Event' as BASEDON
                from dbo.GIFTAIDDISQUALIFIEDBYEVENT

                UNION ALL

                select
                    GIFTAIDDISQUALIFIEDBYMEMBERSHIPPROGRAM.ID as ID,
                    'Membership' as BASEDON
                from dbo.GIFTAIDDISQUALIFIEDBYMEMBERSHIPPROGRAM

                UNION ALL

                select
                    GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD.ID as ID,
                    'PaymentMethod' as BASEDON
                from dbo.GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD

                UNION ALL

                select
                    GIFTAIDDISQUALIFIEDBYREVENUECATEGORY.ID as ID,
                    'RevenueCategory' as BASEDON
                from dbo.GIFTAIDDISQUALIFIEDBYREVENUECATEGORY

                UNION ALL

                select
                    GIFTAIDDISQUALIFIEDBYOTHERPAYMENTTYPE.ID as ID,
                    'OtherPaymentType' as BASEDON
                from dbo.GIFTAIDDISQUALIFIEDBYOTHERPAYMENTTYPE