V_QUERY_BATCHDESIGN

Provides the ability to query batch designs.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(60)		Name
DESCRIPTION	nvarchar(1000)		Description
BATCHTYPE	nvarchar(60)	yes	Batch type
BATCHWORKFLOWID	uniqueidentifier		Batch workflow
CATEGORY	nvarchar(100)	yes	Category
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value
ADDEDBY_APPLICATION	nvarchar(200)	yes	Added by application
ADDEDBY_USERNAME	nvarchar(128)	yes	Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)	yes	Changed by application
CHANGEDBY_USERNAME	nvarchar(128)	yes	Changed by user name
PARENTTEMPLATENAME	nvarchar(60)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  10/10/2019 2:48:07 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2200.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BATCHDESIGN AS



                select
                            CURRENTBATCHTEMPLATE.ID,
                            CURRENTBATCHTEMPLATE.NAME,
                            CURRENTBATCHTEMPLATE.DESCRIPTION,
                            BATCHTYPECATALOG.NAME BATCHTYPE,
                            CURRENTBATCHTEMPLATE.BATCHWORKFLOWID,
                            BATCHTYPECATALOG.CATEGORY,
                            CURRENTBATCHTEMPLATE.DATEADDED,
                            CURRENTBATCHTEMPLATE.DATECHANGED,
                            CURRENTBATCHTEMPLATE.TSLONG,
                            ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
                            ADDEDBY.USERNAME as ADDEDBY_USERNAME,
                            CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
                            CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
                            ORGINIATINGBATCHTEMPLATE.NAME PARENTTEMPLATENAME
                            from dbo.BATCHTEMPLATE CURRENTBATCHTEMPLATE
                            left join dbo.BATCHTYPECATALOG  on CURRENTBATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
                            left join dbo.BATCHTEMPLATE ORGINIATINGBATCHTEMPLATE on CURRENTBATCHTEMPLATE.ORIGINATINGTEMPLATEID = ORGINIATINGBATCHTEMPLATE.ID
                            left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = CURRENTBATCHTEMPLATE.ADDEDBYID
                            left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = CURRENTBATCHTEMPLATE.CHANGEDBYID