| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 BATCHNUMBER |
nvarchar(100) | Default = '' | The unique number of a given batch. | |
| DESCRIPTION |
nvarchar(1000) | Default = '' | ||
| PROJECTEDNUMBEROFRECORDS |
int | Default = 0 | The projected number of records in this batch. | |
| PROJECTEDTOTALAMOUNT |
money | Default = 0 | The projected total amount for records in this batch. | |
| STATUSCODE |
tinyint | Default = 0 | 0=Uncommitted, 1=Committed, 2=Deleted, 3=Committing | |
| DATECOMMITTED |
datetime |  |
The date that the batch was committed. | |
| COMMENTS |
nvarchar(2000) | Default = '' | ||
| CREATEOUTPUTIDSET |
bit | Default = 0 | Designates whether or not an ID set should be created as a result of the batch commit process. | |
| OUTPUTIDSETNAME |
nvarchar(100) | Default = '' | The name of the outpue ID set to be created by the batch commit process. | |
| OVERWRITEOUTPUTIDSET |
bit | Default = 0 | Designates whether or not to overwrite the output ID set if one with the same name already exists. | |
| CREATEEXCEPTIONBATCH |
bit | Default = 0 | Indicates whether a batch should be created for exceptions during the commit process. | |
| EXCEPTIONBATCHNAME |
nvarchar(60) | Default = '' | The name to use when creating an exception batch. | |
| PURGEBATCH |
bit | Default = 0 | Indicates whether or not to delete the batch data and mark the batch as deleted after the commit process. | |
| CREATECONTROLREPORT |
bit | Default = 0 | Indicates whether or not to generate data for a control report. | |
| EFTFILECREATED |
bit | Default = 0 | Indicates whether or not an EFT transmission file has been created for this batch. | |
| 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. |
| FORMDEFINITIONXML |
xml | |
Stores the field defaults for a batch. | |
| VALIDATEBATCH |
bit | Default = 0 | Indicates whether or not to validate the batch before the commit process runs. Only a successful validate will allow the batch to be committed. | |
| CHECKFORDUPLICATERECORDS |
bit | Default = 1 | Indicates whether or not to check for duplicate records in the batch. | |
| USEPROJECTEDTOTALS |
bit | Default = 1 | Indicates whether or not the projected totals values should be used in validation. | |
| AUTOSAVEONROWCHANGE |
bit | Default = 0 | Indicates whether or not the batch should auto save on each row change. | |
| OVERRIDE |
bit | Default = 0 | Indicates whether a exception batch number is overridden with a user defined value. | |
| STATUS |
nvarchar(11) (Computed) | |
CASE [STATUSCODE] WHEN 0 THEN N'Uncommitted' WHEN 1 THEN N'Committed' WHEN 2 THEN N'Deleted' WHEN 3 THEN N'Committing' END | Provides a translation for the 'STATUSCODE' field. |
| AUTOMATCHTHRESHOLD |
decimal(20, 4) | Default = 0 | ||
| OVERALLMATCHTHRESHOLD |
decimal(20, 4) | Default = 0 | ||
| PARAMETERSXML |
xml | |
||
| DISABLEADDNEWROW |
bit | Default = 0 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 BATCHTEMPLATEID |
uniqueidentifier | BATCHTEMPLATE.ID | FK to BATCHTEMPLATE | |
| APPUSERID |
uniqueidentifier | |
APPUSER.ID | FK to APPUSER |
| BATCHWORKFLOWSTATEID |
uniqueidentifier | BATCHWORKFLOWSTATE.ID | FK to BATCHWORKFLOWSTATE | |
| ORIGINATINGBATCHID |
uniqueidentifier | |
BATCH.ID | FK to BATCH |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_BATCH_BATCHTEMPLATEID |
BATCHTEMPLATEID | |||
 IX_BATCH_DATEADDED |
DATEADDED | |
||
| IX_BATCH_DATECHANGED |
DATECHANGED | |||
| IX_BATCH_ID_APPUSERID |
ID, APPUSERID | |||
| IX_BATCH_STATUSCODE_APPUSERID |
STATUSCODE, APPUSERID | |||
| PK_BATCH |
ID | |
|
|
| UIX_BATCH_BATCHNUMBER_BATCHTEMPLATEID |
BATCHNUMBER, BATCHTEMPLATEID | |
| Trigger Name | Description |
|---|---|
 TR_BATCH_AUDIT_UPDATE |
|
| TR_BATCH_AUDIT_DELETE |
Entity-Relationship diagram of this table (BATCHEDUCATIONALHISTORYUPDATE-BATCHRESULTS0A256446_D94F_4985_854D_519026268BC1)
Entity-Relationship diagram of this table (BATCHRESULTS17B315E1_F5A7_48C0_96A8_C9AF96247B03-BATCHRESULTS721C4686_8574_4456_A9AF_4DA79D94A0E6)
Entity-Relationship diagram of this table (BATCHRESULTS762EACC2_4E39_4118_ADE1_F8413DB213AB-BATCHRESULTSD85E7DC8_61DC_4F96_A7F5_2FE427FCE6ED)
Entity-Relationship diagram of this table (BATCHRESULTSDA6E4CD6_75AB_4D2B_A45D_996A40EB2A91-BATCHROWMETADATA3C43E751_4B2F_4C59_89A7_68AF42BDAE91)
Entity-Relationship diagram of this table (BATCHROWMETADATA454F688A_8A9A_4FE2_ACC5_FA28C1E71836-BATCHROWMETADATA91102EFD_E0E9_467F_B2CA_8B510D06C937)
Entity-Relationship diagram of this table (BATCHROWMETADATA98208E65_8334_4D3A_8496_4175352F1430-BATCHROWMETADATAED528F81_CA26_4DAF_B455_95AF3E0D12D5)
Entity-Relationship diagram of this table (BATCHROWMETADATAEE9C5694_EE80_4B3D_8C0F_BAF562251B07-EVENTBATCH)
Entity-Relationship diagram of this table (EXCHANGECALENDARITEMBATCH-UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH)