USP_BATCH_GETMETADATA

            CREATE procedure dbo.USP_BATCH_GETMETADATA
            (
                @ID 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,
                BATCH.BATCHTEMPLATEID,
                BATCH.BATCHNUMBER,
                BATCH.STATUSCODE,
                BATCH.APPUSERID PROCESSORID,
                case when PROCESSOR.DISPLAYNAME = '' then PROCESSOR.USERNAME else PROCESSOR.DISPLAYNAME end PROCESSORNAME,
                BATCH.PROJECTEDNUMBEROFRECORDS,
                BATCH.PROJECTEDTOTALAMOUNT,
                Coalesce((select NAME from dbo.RECORDTYPE inner join dbo.DATAFORMTEMPLATECATALOG on RECORDTYPE.ID = DATAFORMTEMPLATECATALOG.RECORDTYPEID where DATAFORMTEMPLATECATALOG.ID = BATCHTYPECATALOG.ROWCONTEXTEDITDATAFORMTEMPLATEID), '') as ROWCONTEXTEDITFORMRECORDTYPE,
                BATCH.BATCHWORKFLOWSTATEID,
                (select NAME from dbo.BATCHWORKFLOWSTATE where ID = BATCH.BATCHWORKFLOWSTATEID) as BATCHWORKFLOWSTATE,
                BATCH.AUTOSAVEONROWCHANGE, 
                dt.TEMPLATESPECXML EDITDATAFORMTEMPLATESPECXML,
                BATCH.CHECKFORDUPLICATERECORDS,
                BATCH.DISABLEADDNEWROW,
        BATCH.PARAMETERSXML,
        BATCH.OVERALLMATCHTHRESHOLD,
        BATCH.AUTOMATCHTHRESHOLD
            from 
                dbo.BATCH 
                inner join dbo.BATCHTEMPLATE on BATCH.BATCHTEMPLATEID = BATCHTEMPLATE.ID
                inner join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
                inner join dbo.DATAFORMINSTANCECATALOG dc ON BATCHTEMPLATE.EDITROWDATAFORMINSTANCEID = dc.ID
                inner join dbo.DATAFORMTEMPLATECATALOG dt on dc.DATAFORMTEMPLATECATALOGID = dt.ID
                left join dbo.APPUSER PROCESSOR on BATCH.APPUSERID = PROCESSOR.ID
            where 
                BATCH.ID = @ID