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.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the tribute acknowledgement process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the tribute acknowledgement process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 MARKLETTERSACKNOWLEDGED bit   Default = 0 Indicates whether or not tribute letters for this process should be marked as acknowledged.
 ACKNOWLEDGEDATETYPECODE tinyint   Default = 0 Designates whether to use today's date or a specific date in the tribute acknowledgement process as the acknowledge date.
 ACKNOWLEDGEDATE datetime This date is used as the acknowledge date when marking records as acknowledged.
 LABELFILENAME nvarchar(255)   Default = '' The original file name for the label template.
 LABELFILE varbinary The actual file for the label template.
 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.
 ACKNOWLEDGEDATETYPE nvarchar(13) (Computed) CASE [ACKNOWLEDGEDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Specific date' END Provides a translation for the 'ACKNOWLEDGEDATETYPECODE' 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 tribute acknowledgement process.
 OUTPUTIDSETRECORDTYPEID uniqueidentifier RECORDTYPE.ID A foreign key to the record type of the output ID set to be created by the tribute acknowledgement process.
 TRIBUTELETTERCODEID uniqueidentifier   TRIBUTELETTERCODE.ID A foreign key to the tribute letter code this process will use to acknowledge.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_TRIBUTEACKNOWLEDGEMENTPROCESS_DATEADDED DATEADDED    
 IX_TRIBUTEACKNOWLEDGEMENTPROCESS_DATECHANGED DATECHANGED      
 PK_TRIBUTEACKNOWLEDGEMENTPROCESS ID  
 UC_TRIBUTEACKNOWLEDGEMENTPROCESS_NAME NAME    

Trigger Name Description
 TR_TRIBUTEACKNOWLEDGEMENTPROCESS_INSERT
 TR_TRIBUTEACKNOWLEDGEMENTPROCESS_AUDIT_UPDATE
 TR_TRIBUTEACKNOWLEDGEMENTPROCESS_AUDIT_DELETE
 TR_TRIBUTEACKNOWLEDGEMENTPROCESS_DELETE_BUSINESSPROCESSINSTANCE

Referenced by Field
 TRIBUTEACKNOWLEDGEMENTPROCESSEXPORTFORMAT PARAMETERSETID
 TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT TRIBUTEACKNOWLEDGEMENTPROCESSID
 TRIBUTEACKNOWLEDGEMENTPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table