USP_DATALIST_CONSTITUENTMERGECONFIGURATION

List of available merge configurations that can be used with the constituent merge process

Definition

Copy 


                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTMERGECONFIGURATION
                    as
                        set nocount on;

                        select m.ID, 
                               m.NAME,
                               m.DESCRIPTION
                        from MERGECONFIGURATION m
                        inner join dbo.RECORDTYPE r
                        on m.RECORDTYPEID = r.ID
                        and r.NAME = 'Constituent'
            order by m.NAME