UFN_GIFTFEE_CONSTITUENTEXCLUDED

            CREATE function dbo.UFN_GIFTFEE_CONSTITUENTEXCLUDED
            (
                @CONSTITUENTID uniqueidentifier
            )
            returns bit
            as

            begin;

                --Check User defined constituencies    

                if exists(
                    select top 1 CONSTITUENCY.ID
                    from CONSTITUENCY
                    inner join dbo.GIFTFEECONSTITUENCY
                        on CONSTITUENCY.CONSTITUENCYCODEID = GIFTFEECONSTITUENCY.USERCONSTITUENCYCODEID
                    where CONSTITUENTID = @CONSTITUENTID
                )
                    return 1

                -- Check advocate

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'F828E957-5F5E-479A-8F23-2FFD6C7C6899')
                        if dbo.UFN_CONSTITUENT_ISADVOCATE(@CONSTITUENTID) = 1
                            return 1;

                -- Check alumnus

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '46EC3424-BA54-4431-A7DC-C6CEBB3B4592')
                        if dbo.UFN_CONSTITUENT_ISALUMNUS(@CONSTITUENTID) = 1
                            return 1;

                -- Check bank

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '171AB3CD-C4E1-4825-B693-10F524A7A594')
                        if dbo.UFN_CONSTITUENT_ISBANK(@CONSTITUENTID) = 1
                            return 1;

                -- Check board member

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'F828E957-5F5E-479A-8F23-2FFD6C7C68FF')
                        if dbo.UFN_CONSTITUENT_ISBOARDMEMBER(@CONSTITUENTID) = 1 
                            return 1;

                -- Check committee

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'AC9DB5A4-14E0-416A-9FB2-04038AC66799')
                        if dbo.UFN_CONSTITUENT_ISCOMMITTEE(@CONSTITUENTID) = 1 
                            return 1;

                -- Check committee member

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '093A3D4F-2974-447F-AD92-870EB4A04593')
                        if dbo.UFN_CONSTITUENT_ISCOMMITTEEMEMBER(@CONSTITUENTID) = 1
                            return 1;

                -- Check community member

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '55FE8E7C-2B68-44C8-B35C-818AD1944C03')
                        if dbo.UFN_CONSTITUENT_ISCOMMUNITYMEMBER(@CONSTITUENTID) = 1
                            return 1;

                -- Check donor

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '70165682-4324-46EC-9439-83FC0CC67E7F')
                        if dbo.UFN_CONSTITUENT_ISDONOR(@CONSTITUENTID) = 1
                            return 1;

                -- Check event registrant

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'C49D4B46-72A7-4206-91AA-BEABA2323E3C')
                        if dbo.UFN_CONSTITUENT_ISREGISTRANT(@CONSTITUENTID) = 1
                            return 1;

                -- Check faculty

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '08D55D6A-10C8-4a72-92A0-EF87033AD7B6')
                        if dbo.UFN_CONSTITUENT_ISFACULTY(@CONSTITUENTID) = 1
                            return 1;

                --Check fundraiser

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'D2DCA06A-BE6E-40B3-B95D-59A926181923')
                        if dbo.UFN_CONSTITUENT_ISFUNDRAISER(@CONSTITUENTID) = 1 
                            return 1;

                -- Check grantor

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'D9982C99-15C1-4C90-873E-56FD4B164056')
                        if dbo.UFN_CONSTITUENT_ISGRANTOR(@CONSTITUENTID) = 1
                            return 1;

                -- Check loyal donor

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'E5A0EA42-65BA-4B25-AFE2-9B709F99E72B')
                        if dbo.UFN_CONSTITUENT_ISLOYALDONOR(@CONSTITUENTID) = 1
                            return 1;

                -- Check major donor

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '1A9BFE80-604D-4B5B-8065-E751DDF6EF39')
                        if dbo.UFN_CONSTITUENT_ISMAJORDONOR(@CONSTITUENTID) = 1
                            return 1;

                -- Check major giving prospect

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '00E748FB-940D-4A7D-A133-C148B29410A8')
                        if dbo.UFN_CONSTITUENT_ISPROSPECT(@CONSTITUENTID) = 1 
                            return 1;

                -- Check matching gift organization

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '2D04A9C5-27D0-4646-BF0F-6826E4C12632')
                    begin
                        declare @MATCHFINDERONLINERECORDID int
                        select top 1
                            @MATCHFINDERONLINERECORDID = MATCHFINDERRECORDID 
                        from dbo.MATCHFINDERCONSTITUENT
                        where ID = @CONSTITUENTID;

                        if not @MATCHFINDERONLINERECORDID is null and @MATCHFINDERONLINERECORDID <> 0
                            return 1;
                    end

                -- Check member

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '2d11326e-8f3b-4322-9797-57c1aacfa5df')
                        if dbo.UFN_CONSTITUENT_ISMEMBER(@CONSTITUENTID,null) = 1
                            return 1;

                -- Check patron

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'A843B859-4C6B-445B-97F3-179582E270A5')
                        if dbo.UFN_CONSTITUENT_ISPATRON(@CONSTITUENTID) = 1
                            return 1;

                -- Check planned giver

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'CEE46FE7-3FBB-4DFE-97EB-BA67DD33C634')
                        if dbo.UFN_CONSTITUENT_ISPLANNEDGIVER(@CONSTITUENTID) = 1
                            return 1;

                -- Check recognized donor

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '3dfac92e-78bd-4051-abdc-02c675deb8f6')
                        if dbo.UFN_CONSTITUENT_ISRECOGNITION(@CONSTITUENTID,null) = 1
                            return 1;

                -- Check relation only

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '8B6ECCFD-6829-4FBC-B092-58CA083F9322')
                        if dbo.UFN_CONSTITUENT_ISRELATION(@CONSTITUENTID) = 1
                            return 1;

                -- Check school

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '97688220-0AFA-4354-A327-590D715961D7')
                        if dbo.UFN_CONSTITUENT_ISSCHOOL(@CONSTITUENTID) = 1
                            return 1;

                -- Check sponsor

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '4D746A03-A0AB-45F3-A30B-1AD4F304E622')
                        if dbo.UFN_CONSTITUENT_SPONSORTYPECODE(@CONSTITUENTID) = 0
                            return 1;

                -- Check sponsorship donor

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '908E521C-B0A5-4832-B664-7D7B079D77C2')
                        if dbo.UFN_CONSTITUENT_SPONSORTYPECODE(@CONSTITUENTID) = 2
                            return 1;

                -- Check sponsorship recipient

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'F89E03BC-E724-4e5d-943B-72D4D1E1E916')
                        if dbo.UFN_CONSTITUENT_SPONSORTYPECODE(@CONSTITUENTID) = 1
                            return 1;

                -- Check staff

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '6093915E-ADE9-42BE-88AE-304731754467')
                        if dbo.UFN_CONSTITUENT_ISSTAFF(@CONSTITUENTID) = 1 
                            return 1;

                -- Check student

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '4DB8F4FC-BC43-421D-B592-69BEF109B5FC')
                        if dbo.UFN_CONSTITUENT_ISSTUDENT(@CONSTITUENTID) = 1
                            return 1;

                -- Check vendor

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '5435C96D-8617-46C3-9A62-5AFF08451A53')
                        if dbo.UFN_CONSTITUENT_ISVENDOR(@CONSTITUENTID) = 1
                            return 1;

                -- Check volunteer

                    if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'E7489703-3D63-4017-A2BC-88C092563C5D')
                        if dbo.UFN_CONSTITUENT_ISVOLUNTEER(@CONSTITUENTID) = 1 
                            return 1;

         -- Check national fundraising group  

         if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = 'A499228A-7619-40DF-AE75-BBA1EE20FB4E')  
           if dbo.UFN_CONSTITUENT_ISNATIONALFUNDRAISINGGROUP(@CONSTITUENTID) = 1  
              return 1;  

         -- Check fundraising group constituency

         if exists(select top 1 ID from dbo.GIFTFEECONSTITUENCY where GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID = '264818E9-3F59-44C1-9BBF-1BB1F9C78CA5')  
           if dbo.UFN_CONSTITUENT_ISFUNDRAISINGGROUP(@CONSTITUENTID) = 1  
              return 1;

                return 0;
            end