USP_RECORDOPERATION_GETMETADATA

        create procedure dbo.USP_RECORDOPERATION_GETMETADATA
        @ID uniqueidentifier
        as
        select 
            ROC.RECORDOPERATIONSPECXML AS SPECXML,
            ROC.IMPLEMENTATIONTYPE,
            ROC.RECORDTYPEID,
            ROC.DATECHANGED,
            ROC.TSLONG,
            cast(case when P.SPECIFIC_SCHEMA is null then 0 else 1 end as bit) as HASAPPUSER
        from 
            dbo.RECORDOPERATIONCATALOG ROC
            left outer join INFORMATION_SCHEMA.PARAMETERS P on P.SPECIFIC_SCHEMA='dbo' and P.SPECIFIC_NAME = ROC.PROCEDURENAME and P.PARAMETER_NAME = '@CURRENTAPPUSERID'
        where ROC.ID = @ID;

        return 0;