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.
 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.
 PROCESSDATETYPECODE tinyint   Default = 0 Designates whether to use today's date or a specific date in the process as the processing date.
 PROCESSDATE datetime This date is used as the processing date.
 PROCESSDAYSAFTER int   Default = 1 Number of days after this process runs that will be used to calculate the cutoff date.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the paperless mandates instruction process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the paperless mandates instruction process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 PROCESSDATETYPE nvarchar(30) (Computed) CASE [PROCESSDATETYPECODE] 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 'PROCESSDATETYPECODE' field.
 APPENDLINEFEED bit   Default = 0 Designates wheter or not a line feed character will be appended to each record of the output file.
 REQUESTAUDITTRAIL bit   Default = 0 Designates whether to fill in the audit print identifier on the paperless mandate file header.

Foreign Key Field Type Null Notes Description
 SPONSORINGINSTITUTIONID uniqueidentifier FINANCIALINSTITUTION.ID A foreign key to the sponsoring bank of the EFT.
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID Indicates the IDSETREGISTER to use filter records included in the process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BANKACCOUNTID uniqueidentifier BANKACCOUNT.ID A foreign key to the bank account of the EFT.

Index Name Field(s) Unique Primary Clustered
 IX_PAPERLESSMANDATESINSTRUCTIONPROCESS_DATEADDED DATEADDED    
 IX_PAPERLESSMANDATESINSTRUCTIONPROCESS_DATECHANGED DATECHANGED      
 PK_PAPERLESSMANDATESINSTRUCTIONPROCESS ID  
 UC_PAPERLESSMANDATESINSTRUCTIONPROCESS_NAME NAME    

Trigger Name Description
 TR_PAPERLESSMANDATESINSTRUCTIONPROCESS_AUDIT_UPDATE
 TR_PAPERLESSMANDATESINSTRUCTIONPROCESS_AUDIT_DELETE

Referenced by Field
 PAPERLESSMANDATESINSTRUCTIONPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table