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 prenotification transmission file.
 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.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the prenotification process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the prenotification process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 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(13) (Computed) CASE [DATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Specific date' END Provides a translation for the 'DATETYPECODE' field.

Foreign Key Field Type Null Notes Description
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID A foreign key to the ID set used to filter the records included in the prenotification process.
 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.
 BANKACCOUNTID uniqueidentifier BANKACCOUNT.ID Foreign key to the bank account table

Index Name Field(s) Unique Primary Clustered
 IX_PRENOTIFICATIONPROCESS_DATEADDED DATEADDED    
 IX_PRENOTIFICATIONPROCESS_DATECHANGED DATECHANGED      
 PK_PRENOTIFICATIONPROCESS ID  
 UC_PRENOTIFICATIONPROCESS_NAME NAME    

Trigger Name Description
 TR_PRENOTIFICATIONPROCESS_AUDIT_UPDATE
 TR_PRENOTIFICATIONPROCESS_AUDIT_DELETE

Referenced by Field
 PRENOTIFICATIONPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table