BATCHTEMPLATE
The BATCHTEMPLATE table stores batch instances that are used to view and update batches throughout the system.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| 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) | yes | 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 | yes | ||
| USEGLOBALMATCHSETTINGS | bit | Default = 0 |
Foreign Keys
| 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 | yes | DATAFORMINSTANCECATALOG.ID | The ID for the batch commit row add data form instance |
| COMMITROWEDITDATAFORMINSTANCEID | uniqueidentifier | yes | 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 | yes | DATAFORMINSTANCECATALOG.ID | View form for viewing context record for each row |
| ROWCONTEXTEDITDATAFORMINSTANCEID | uniqueidentifier | yes | DATAFORMINSTANCECATALOG.ID | Edit form to allow editting of connect record for each row |
| ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT | |
| CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT | |
| BATCHWORKFLOWID | uniqueidentifier | BATCHWORKFLOW.ID | ||
| SITEID | uniqueidentifier | yes | SITE.ID | |
| BATCHNUMBERINGSCHEMEID | uniqueidentifier | yes | BATCHNUMBERINGSCHEME.ID | |
| ORIGINATINGTEMPLATEID | uniqueidentifier | yes | BATCHTEMPLATE.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_BATCHTEMPLATE_BATCHTYPECATALOGID | BATCHTYPECATALOGID | |||
| IX_BATCHTEMPLATE_DATEADDED | DATEADDED | yes | ||
| IX_BATCHTEMPLATE_ID | ID | |||
| IX_BATCHTEMPLATE_SITEID | SITEID | |||
| PK_BATCHTEMPLATE | ID | yes | yes | |
| UC_BATCHTEMPLATE_NAME | NAME | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_BATCHTEMPLATE_AUDIT_UPDATE | |
| TR_BATCHTEMPLATE_AUDIT_DELETE |
Referenced by
| Referenced by | Field |
|---|---|
| BATCH | BATCHTEMPLATEID |
| CREDITCARDPROCESSING | BATCHTEMPLATEID |
| GENERATEBACSFILEPROCESS | BATCHTEMPLATEID |
| GENERATEBATCHPROCESS | BATCHTEMPLATEID |
| GENERATEBATCHPROCESSCUB | 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 |
| USERSETTINGSBATCHTEMPLATE | BATCHTEMPLATEID |