Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 USEADDRESSEEFORMAT bit   Default = 1 A flag indicating to use pre-defined name formats for the individual addressee.
 USESALUTATIONFORMAT bit   Default = 1 A flag indicating to use pre-defined name formats for the individual salutation.
 USECONTACTADDRESSEEFORMAT bit   Default = 1 A flag indicating to use pre-defined name formats for the contact addressee.
 ORGSALUTATIONCODE tinyint   Default = 0 The salutation option for organizations.
 ORGSALUTATION nvarchar(24) (Computed) CASE [ORGSALUTATIONCODE] WHEN 0 THEN N'Use organization name' WHEN 1 THEN N'Use organization contact' WHEN 2 THEN N'Use custom name' END Provides a translation for the 'ORGSALUTATIONCODE' field.
 USECONTACTSALUTATIONFORMAT bit   Default = 1 A flag indicating to use pre-defined name formats for the contact salutation.
 CONTACTSALUTATIONOPTIONCODE tinyint   Default = 0 Flag that indicates whether to use a custom name for the contact if it is not available.
 CONTACTSALUTATIONOPTION nvarchar(21) (Computed) CASE [CONTACTSALUTATIONOPTIONCODE] WHEN 0 THEN N'Use organization name' WHEN 1 THEN N'Use custom name' END Provides a translation for the 'CONTACTSALUTATIONOPTIONCODE' field.
 CUSTOMNAME nvarchar(100)   Default = '' The custom name to use if the contact name is not available.
 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.

Foreign Key Field Type Null Notes Description
 TRIBUTEACKNOWLEDGEMENTPROCESSID uniqueidentifier   TRIBUTEACKNOWLEDGEMENTPROCESS.ID The tribute acknowledgement process that uses this parameter set.
 ADDRESSEEFORMATID uniqueidentifier NAMEFORMATTYPECODE.ID The addressee name format to use for individuals.
 ALTADDRESSEEFORMATID uniqueidentifier NAMEFORMATTYPECODE.ID The alternate addressee name format to use for individuals.
 ADDRESSEEFUNCTIONID uniqueidentifier NAMEFORMATFUNCTION.ID The addressee name format function to use for individuals.
 SALUTATIONFORMATID uniqueidentifier NAMEFORMATTYPECODE.ID The salutation format to use for individuals.
 ALTSALUTATIONFORMATID uniqueidentifier NAMEFORMATTYPECODE.ID The alternate salutation format to use for individuals.
 SALUTATIONFUNCTIONID uniqueidentifier NAMEFORMATFUNCTION.ID The salutation format function to use for individuals.
 CONTACTADDRESSEEFORMATID uniqueidentifier NAMEFORMATTYPECODE.ID The addressee name format to use for organization contacts.
 ALTCONTACTADDRESSEEFORMATID uniqueidentifier NAMEFORMATTYPECODE.ID The alternate addressee format to use for organization contacts.
 CONTACTADDRESSEEFUNCTIONID uniqueidentifier NAMEFORMATFUNCTION.ID The addressee name format function to use for organization contacts.
 CONTACTSALUTATIONFORMATID uniqueidentifier NAMEFORMATTYPECODE.ID The salutation format to use for the organization contact.
 ALTCONTACTSALUTATIONFORMATID uniqueidentifier NAMEFORMATTYPECODE.ID The alternate salutation format to use for the organization contact.
 CONTACTSALUTATIONFUNCTIONID uniqueidentifier NAMEFORMATFUNCTION.ID The salutation format function to use for the organization contact.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_DATEADDED DATEADDED    
 IX_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_DATECHANGED DATECHANGED      
 PK_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT ID  
 UC_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_TRIBUTEACKNOWLEDGEMENTPROCESSID TRIBUTEACKNOWLEDGEMENTPROCESSID    

Trigger Name Description
 TR_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_AUDIT_UPDATE
 TR_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_AUDIT_DELETE

Entity-Relationship diagram of this table