USP_MAPENTITY_GETMETADATA

            create procedure USP_MAPENTITY_GETMETADATA(
                @ID uniqueidentifier
            ) as 
                set nocount on;

                select
                    MEC.MAPENTITYXML as SPECXML,
                    MEC.FROMRECORDTYPEID,
                    MEC.MAPPEDRECORDTYPEID,
                    MEC.ADDRESSRECORDTYPEID,
                    MEC.MAPPINGPROCEDURE,
                    MEC.SEARCHLISTID,
                    MEC.ADDDATAFORMINSTANCEID
                from
                    dbo.MAPENTITYCATALOG MEC
                where MEC.ID = @ID;

                return 0;