USP_SIMPLEDATALIST_CONSTITUENTMERGECONFIGURATION

                create procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTMERGECONFIGURATION
                as
                    select
                        m.ID as VALUE,
                        m.NAME as LABEL
                    from
                        dbo.MERGECONFIGURATION m
                        inner join dbo.RECORDTYPE r
                        on m.RECORDTYPEID = r.ID
                        and r.NAME = 'Constituent'
                    order by
                        m.NAME;