USP_SEARCHLIST_GETMETADATA_FORSEARCHPROMPT

                CREATE procedure [dbo].[USP_SEARCHLIST_GETMETADATA_FORSEARCHPROMPT](@ID uniqueidentifier)
                as begin

                    select 
                        SEARCHLISTCATALOG.SEARCHLISTSPEC,
                        SEARCHLISTSETTINGS.SETTINGSXML,
                        cast(case when P1.SPECIFIC_SCHEMA is null then 0 else 1 end as bit) as HASAPPUSER,
                        cast(case when P2.SPECIFIC_SCHEMA is null then 0 else 1 end as bit) as HASCONSTITUENTDUPLICATEMATCHINGENABLED
                    from 
                        dbo.SEARCHLISTCATALOG 
                        left outer join dbo.SEARCHLISTSETTINGS on SEARCHLISTCATALOG.ID = SEARCHLISTSETTINGS.ID
                        left outer join INFORMATION_SCHEMA.PARAMETERS P1 on P1.SPECIFIC_SCHEMA = 'dbo' and P1.SPECIFIC_NAME = SEARCHLISTCATALOG.PROCEDURENAME and P1.PARAMETER_NAME = '@CURRENTAPPUSERID'
                        left outer join INFORMATION_SCHEMA.PARAMETERS P2 on P2.SPECIFIC_SCHEMA = 'dbo' and P2.SPECIFIC_NAME = SEARCHLISTCATALOG.PROCEDURENAME and P2.PARAMETER_NAME = '@CONSTITUENTDUPLICATEMATCHINGENABLED'
                    where 
                        SEARCHLISTCATALOG.ID = @ID;

                    return 0;
                end