USP_BATCHTEMPLATE_GETMETADATA

CREATE procedure [dbo].[USP_BATCHTEMPLATE_GETMETADATA]
    @ID uniqueidentifier
as
    select 
        BATCHTYPECATALOG.BASETABLENAME, 
        BATCHTEMPLATE.ADDROWDATAFORMINSTANCEID, 
        BATCHTEMPLATE.EDITROWDATAFORMINSTANCEID, 
        BATCHTEMPLATE.COMMITROWADDDATAFORMINSTANCEID, 
        BATCHTEMPLATE.COMMITROWEDITDATAFORMINSTANCEID, 
        BATCHTEMPLATE.COMMITROWEDITDATAFORMIDFIELD, 
        BATCHTEMPLATE.ROWRECORDOPERATIONID,
        BATCHTEMPLATE.ROWCONTEXTVIEWDATAFORMINSTANCEID, 
        BATCHTEMPLATE.ROWCONTEXTEDITDATAFORMINSTANCEID, 
        BATCHTYPECATALOG.ROWCONTEXTFIELD, 
        BATCHTEMPLATE.BATCHWORKFLOWID, 
        BATCHTEMPLATE.CUSTOM, 
        BATCHTEMPLATE.FORMDEFINITIONXML,
        case when exists 
            (select DATAFORMTEMPLATECATALOG.ID 
                from dbo.DATAFORMTEMPLATECATALOG 
                inner join dbo.DATAFORMINSTANCECATALOG on DATAFORMINSTANCECATALOG.DATAFORMTEMPLATECATALOGID = DATAFORMTEMPLATECATALOG.ID 
                where DATAFORMINSTANCECATALOG.ID = BATCHTEMPLATE.ADDROWDATAFORMINSTANCEID and DATAFORMTEMPLATECATALOG.ID = BATCHTYPECATALOG.ADDROWDATAFORMTEMPLATEIDNOEXTENSION
            ) then
            1
        else
            0
        end CREATEDFROMBASEDATAFORMTEMPLATE
    from dbo.BATCHTEMPLATE 
    inner join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
    where BATCHTEMPLATE.ID = @ID