Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(60)   The unique name of this data form
 DESCRIPTION nvarchar(1000)   Default = '' Description of this data form
 COMMITROWEDITDATAFORMIDFIELD nvarchar(100)   Default = '' The field name of the ID used in the batch commit row edit data form instance
 FORMDEFINITIONXML xml   Contains the form definition xml
 DATEADDED datetime   Default = getdate() Indicates the date this record was added
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed
 TS timestamp   Timestamp
 TSLONG bigint (Computed) convert(bigint, TS) Numeric representation of the timestamp
 ACTIVE bit   Default = 1
 CUSTOM bit   Default = 0 Indicates whether the batch template is a custom template.
 BATCHNUMBERINGSCHEMECODE tinyint   Default = 0
 IMPORTONLY bit   Default = 0
 DEFAULTVALIDATEBEFORECOMMIT bit   Default = 0
 DEFAULTCHECKFORDUPLICATES bit   Default = 0
 DEFAULTDELETEBATCHAFTERCOMMIT bit   Default = 0
 DEFAULTCREATEEXCEPTIONBATCH bit   Default = 1
 DEFAULTCREATECONTROLREPORT bit   Default = 0
 DEFAULTCREATEOUTPUTSELECTION bit   Default = 0
 AUTOSAVEONROWCHANGE bit   Default = 0
 TEMPLATEUSECODE tinyint   Default = 0
 AUTOMATCHTHRESHOLD int   Default = 0
 OVERALLMATCHTHRESHOLD int   Default = 0
 PARAMETERSXML xml
 USEGLOBALMATCHSETTINGS bit   Default = 0

Foreign Key Field Type Null Notes Description
 BATCHTYPECATALOGID uniqueidentifier   BATCHTYPECATALOG.ID FK to BATCHTYPECATALOG
 ADDROWDATAFORMINSTANCEID uniqueidentifier   DATAFORMINSTANCECATALOG.ID The ID for the batch add row data form instance
 EDITROWDATAFORMINSTANCEID uniqueidentifier   DATAFORMINSTANCECATALOG.ID The ID for the batch edit row data form instance
 COMMITROWADDDATAFORMINSTANCEID uniqueidentifier DATAFORMINSTANCECATALOG.ID The ID for the batch commit row add data form instance
 COMMITROWEDITDATAFORMINSTANCEID uniqueidentifier DATAFORMINSTANCECATALOG.ID The ID for the batch commit row edit data form instance
 ROWRECORDOPERATIONID uniqueidentifier   RECORDOPERATIONCATALOG.ID The ID for the batch row record operation.
 ROWCONTEXTVIEWDATAFORMINSTANCEID uniqueidentifier DATAFORMINSTANCECATALOG.ID View form for viewing context record for each row
 ROWCONTEXTEDITDATAFORMINSTANCEID uniqueidentifier DATAFORMINSTANCECATALOG.ID Edit form to allow editting of contect record for each row
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT
 BATCHWORKFLOWID uniqueidentifier   BATCHWORKFLOW.ID
 SITEID uniqueidentifier SITE.ID
 BATCHNUMBERINGSCHEMEID uniqueidentifier BATCHNUMBERINGSCHEME.ID
 ORIGINATINGTEMPLATEID uniqueidentifier BATCHTEMPLATE.ID

Index Name Field(s) Unique Primary Clustered
 IX_BATCHTEMPLATE_DATEADDED DATEADDED    
 IX_BATCHTEMPLATE_ID ID      
 IX_BATCHTEMPLATE_SITEID SITEID      
 PK_BATCHTEMPLATE ID  
 UC_BATCHTEMPLATE_NAME NAME    

Trigger Name Description
 TR_BATCHTEMPLATE_AUDIT_UPDATE
 TR_BATCHTEMPLATE_AUDIT_DELETE

Referenced by Field
 BATCH BATCHTEMPLATEID
 CREDITCARDPROCESSING BATCHTEMPLATEID
 GENERATEBACSFILEPROCESS BATCHTEMPLATEID
 GENERATEBATCHPROCESS BATCHTEMPLATEID
 GENERATEEFTFILEPROCESS BATCHTEMPLATEID
 GENERATESTEPUPDATEBATCHPROCESS BATCHTEMPLATEID
 GENERATETRANSACTIONSPROCESS BATCHTEMPLATEID
 IMPORTFILETEMPLATE BATCHTEMPLATEID
 IMPORTFIXEDWIDTHFILETEMPLATE BATCHTEMPLATEID
 IMPORTPROCESS BATCHTEMPLATEID
 NETCOMMUNITYMAPPINGRULE BATCHTEMPLATEID
 NETCOMMUNITYTRANSACTIONPROCESSOR BATCHTEMPLATEID
 STANDINGORDERSIMPORTPROCESS BATCHTEMPLATEID
 SYSTEMROLEPERM_BATCHTEMPLATE BATCHTEMPLATEID
 SYSTEMROLEPERM_BATCHTEMPLATEAPPROVER BATCHTEMPLATEID
 SYSTEMROLEPERM_BATCHTEMPLATECUSTOMIZE BATCHTEMPLATEID
 SYSTEMROLEPERM_BATCHTEMPLATEPROCESSOR BATCHTEMPLATEID

Entity-Relationship diagram of this table (BATCH-SITE)
Entity-Relationship diagram of this table (STANDINGORDERSIMPORTPROCESS-SYSTEMROLEPERM_BATCHTEMPLATEPROCESSOR)