USP_BATCHTEMPLATE_GETMETADATA_1_3

            create procedure dbo.USP_BATCHTEMPLATE_GETMETADATA_1_3
            (
                @BATCHTEMPLATEID uniqueidentifier    
            )
            as
            set nocount on;

            select 
                BATCHTYPECATALOG.BASETABLENAME,
                BATCHTYPECATALOG.SPECXML,
                BATCHTEMPLATE.ADDROWDATAFORMINSTANCEID,
                BATCHTEMPLATE.EDITROWDATAFORMINSTANCEID, 
                BATCHTEMPLATE.COMMITROWADDDATAFORMINSTANCEID,
                BATCHTEMPLATE.COMMITROWEDITDATAFORMINSTANCEID, 
                BATCHTEMPLATE.COMMITROWEDITDATAFORMIDFIELD, 
                BATCHTEMPLATE.ROWRECORDOPERATIONID,
                BATCHTEMPLATE.ROWCONTEXTVIEWDATAFORMINSTANCEID, 
                BATCHTEMPLATE.ROWCONTEXTEDITDATAFORMINSTANCEID, 
                BATCHTYPECATALOG.ROWCONTEXTFIELD,
                BATCHTYPECATALOG.ROWCONTEXTCAPTION,
                BATCHTYPECATALOG.ROWCONTEXTIMAGEKEY,
                BATCHTYPECATALOG.ROWCONTEXTDOCKLOCATION,    
                BATCHTYPECATALOG.AMOUNTCOLUMN,
                BATCHTYPECATALOG.VALIDATIONREPORTID,
                BATCHTYPECATALOG.CONTROLREPORTQUERYVIEWID,
                BATCHTYPECATALOG.CONTROLREPORTQUERYVIEWJOINFIELD,
                BATCHTYPECATALOG.CONTROLREPORTREPORTSPECID,
                BATCHTYPECATALOG.EXCEPTIONREPORTQUERYVIEWID,
                BATCHTYPECATALOG.EXCEPTIONREPORTQUERYVIEWJOINFIELD,
                BATCHTYPECATALOG.EXCEPTIONREPORTREPORTSPECID,
                BATCHTEMPLATE.FORMDEFINITIONXML,
                BATCHTEMPLATE.BATCHWORKFLOWID,
                coalesce((select NAME from dbo.RECORDTYPE inner join dbo.DATAFORMTEMPLATECATALOG on RECORDTYPE.ID = DATAFORMTEMPLATECATALOG.RECORDTYPEID where DATAFORMTEMPLATECATALOG.ID = BATCHTYPECATALOG.ROWCONTEXTEDITDATAFORMTEMPLATEID), '') as [ROWCONTEXTEDITFORMRECORDTYPE]
            from dbo.BATCHTEMPLATE 
            inner join dbo.BATCHTYPECATALOG on BATCHTYPECATALOG.ID = BATCHTEMPLATE.BATCHTYPECATALOGID
            where BATCHTEMPLATE.ID = @BATCHTEMPLATEID