Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' The description of the parameter set.
 DATETYPECODE tinyint   Default = 0 Designates whether to use today's date or a specific date in the process as the financial processing date.
 DATE datetime This date is used as the financial processing date for the direct debits.
 IMMEDIATEDESTINATIONNAME nvarchar(23)   Default = '' The name of the authorizing institution that approves and authorizes all banking account transactions.
 CREATECREDITOFFSETTRANSACTION bit   Default = 0 Designates whether or not the credit offset transaction is included in the EFT transmission file.
 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.
 DATETYPE nvarchar(30) (Computed) CASE [DATETYPECODE] WHEN 0 THEN N'Date this process runs' WHEN 1 THEN N'Specific date' WHEN 2 THEN N'X days after this process runs' END Provides a translation for the 'DATETYPECODE' field.
 DUEDATETYPECODE tinyint   Default = 0 Designates whether to use the date this process runs or a number of days after this process runs or a specific date in the process as the cutoff date.
 DUEDATETYPE nvarchar(30) (Computed) CASE [DUEDATETYPECODE] WHEN 0 THEN N'Date this process runs' WHEN 1 THEN N'Specific date' WHEN 2 THEN N'X days after this process runs' END Provides a translation for the 'DUEDATETYPECODE' field.
 CUTOFFDATE datetime Specifies the cut-off date for transactions to be included in the process.
 DAYSAFTER int   Default = 1 Number of days after this process runs that will be used to calculate the cutoff date
 TRANSACTIONTYPECODE tinyint   Default = 0 Specifies the type of transactions to generate.
 TRANSACTIONTYPE nvarchar(32) (Computed) CASE [TRANSACTIONTYPECODE] WHEN 0 THEN N'Pledge & Recurring Gift Payments' WHEN 1 THEN N'Pledge Payments' WHEN 2 THEN N'Recurring Gift Payments' END Provides a translation for the 'TRANSACTIONTYPECODE' field.
 FINDAYSAFTER int   Default = 1 Number of days after this process runs that will be used to calculate the financial processing date
 CONSOLIDATEPAYMENTS bit   Default = 0

Foreign Key Field Type Null Notes Description
 SPONSORINGINSTITUTIONID uniqueidentifier FINANCIALINSTITUTION.ID A foreign key to the sponsoring bank of the EFT.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BATCHID uniqueidentifier BATCH.ID A foreign key to the batch used to filter the records included in the generate EFT file process.
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID Indicates the IDSETREGISTER to use filter records included in the process.
 BATCHTEMPLATEID uniqueidentifier BATCHTEMPLATE.ID Specifies the batch instance to be used to create the batch to hold the transactions.
 OWNERID uniqueidentifier APPUSER.ID The user who will be the owner of the batch once it is created by the process.
 BANKACCOUNTID uniqueidentifier BANKACCOUNT.ID Foreign key to the bank account table

Index Name Field(s) Unique Primary Clustered
 IX_GENERATEEFTFILEPROCESS_DATEADDED DATEADDED    
 IX_GENERATEEFTFILEPROCESS_DATECHANGED DATECHANGED      
 PK_GENERATEEFTFILEPROCESS ID  
 UC_GENERATEEFTFILEPROCESS_NAME NAME    

Trigger Name Description
 TR_GENERATEEFTFILEPROCESS_AUDIT_UPDATE
 TR_GENERATEEFTFILEPROCESS_AUDIT_DELETE

Referenced by Field
 GENERATEEFTFILEPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table