USP_WEALTHPOINT_GETCONSTITUENTINVALIDCONSTITUENTS

            create procedure dbo.USP_WEALTHPOINT_GETCONSTITUENTINVALIDCONSTITUENTS(
                @ID uniqueidentifier
            ) as begin
                set nocount on;

                select
                    C.ID,
                    C.NAME,
                    case when C.ISORGANIZATION = 1 then 0 when not DWU.ID is null then 1 else 2 end
                from
                    dbo.CONSTITUENT C
                    left outer join dbo.DISABLEDWEALTHUPDATES DWU on DWU.ID = C.ID
                where
                    C.ID = @ID and
                    (C.ISORGANIZATION = 1 or
                    not DWU.ID is null);

                return 0;

            end;