USP_MATCHFINDERCONTACT_SIMPLELIST

                create procedure dbo.USP_MATCHFINDERCONTACT_SIMPLELIST
                (
                    @ORGANIZATIONID uniqueidentifier
                )
                as
                set nocount on;

                begin try
                    declare @CONTACTTYPECODEID uniqueidentifier;
                    select top 1
                        @CONTACTTYPECODEID = CONTACTTYPECODEID
                    from dbo.MATCHFINDERCONFIGURATION

                    if @CONTACTTYPECODEID is null
                        raiserror('ERR_MFCONFIG_NOCONTACTTYPECODE', 16, 1);

                    select 
                        RELATIONSHIP.RELATIONSHIPCONSTITUENTID as [VALUE],
                        CONSTITUENT.NAME as [LABEL]

                    from dbo.RELATIONSHIP
                    inner join dbo.CONSTITUENT on CONSTITUENT.ID = RELATIONSHIP.RELATIONSHIPCONSTITUENTID 
                    where RELATIONSHIP.RECIPROCALCONSTITUENTID = @ORGANIZATIONID
                    and RELATIONSHIP.ISCONTACT = 1
                    and RELATIONSHIP.CONTACTTYPECODEID = @CONTACTTYPECODEID                
                    order by CONSTITUENT.KEYNAME, CONSTITUENT.FIRSTNAME, CONSTITUENT.MIDDLENAME, RELATIONSHIP.DATEADDED
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch