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.
 DATELASTRUN datetime This date is used to filter records by the date the process was last run.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 ASSIGNALLLETTERCODES bit   Default = 1 Designates whether or not to execute the process for all letter codes.
 USEDATEFILTER bit   Default = 0 Designates whether or not to use a date filter when running the process.
 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.
 INCLUDEDONORASACKNOWLEDGEE bit   Default = 1 Indicates whether the revenue donor should be included as an acknowledgee.
 INCLUDERECOGNITIONRECIPIENTSASACKNOWLEDGEE bit   Default = 0 Indicates whether the recognition recipients should be included as an acknowledgee.

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 process.
 OUTPUTIDSETRECORDTYPEID uniqueidentifier RECORDTYPE.ID A foreign key to the record type of the output ID set to be created by this process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_ASSIGNLETTERCODESPROCESS_DATEADDED DATEADDED    
 IX_ASSIGNLETTERCODESPROCESS_DATECHANGED DATECHANGED      
 PK_ASSIGNLETTERCODESPROCESS ID  
 UC_ASSIGNLETTERCODESPROCESS_NAME NAME    

Trigger Name Description
 TR_ASSIGNLETTERCODESPROCESS_AUDIT_UPDATE
 TR_ASSIGNLETTERCODESPROCESS_AUDIT_DELETE

Referenced by Field
 ASSIGNLETTERCODESPROCESSLETTERCODES ASSIGNLETTERCODESPROCESSID
 ASSIGNLETTERCODESPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table