TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT

Contains name format information pertaining to the tribute acknowledgement process.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

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) yes 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) yes 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) yes CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Keys

Foreign Key Field Type Null Notes Description
TRIBUTEACKNOWLEDGEMENTPROCESSID uniqueidentifier TRIBUTEACKNOWLEDGEMENTPROCESS.ID The tribute acknowledgement process that uses this parameter set.
ADDRESSEEFORMATID uniqueidentifier yes NAMEFORMATTYPECODE.ID The addressee name format to use for individuals.
ALTADDRESSEEFORMATID uniqueidentifier yes NAMEFORMATTYPECODE.ID The alternate addressee name format to use for individuals.
ADDRESSEEFUNCTIONID uniqueidentifier yes NAMEFORMATFUNCTION.ID The addressee name format function to use for individuals.
SALUTATIONFORMATID uniqueidentifier yes NAMEFORMATTYPECODE.ID The salutation format to use for individuals.
ALTSALUTATIONFORMATID uniqueidentifier yes NAMEFORMATTYPECODE.ID The alternate salutation format to use for individuals.
SALUTATIONFUNCTIONID uniqueidentifier yes NAMEFORMATFUNCTION.ID The salutation format function to use for individuals.
CONTACTADDRESSEEFORMATID uniqueidentifier yes NAMEFORMATTYPECODE.ID The addressee name format to use for organization contacts.
ALTCONTACTADDRESSEEFORMATID uniqueidentifier yes NAMEFORMATTYPECODE.ID The alternate addressee format to use for organization contacts.
CONTACTADDRESSEEFUNCTIONID uniqueidentifier yes NAMEFORMATFUNCTION.ID The addressee name format function to use for organization contacts.
CONTACTSALUTATIONFORMATID uniqueidentifier yes NAMEFORMATTYPECODE.ID The salutation format to use for the organization contact.
ALTCONTACTSALUTATIONFORMATID uniqueidentifier yes NAMEFORMATTYPECODE.ID The alternate salutation format to use for the organization contact.
CONTACTSALUTATIONFUNCTIONID uniqueidentifier yes 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.

Indexes

Index Name Fields Unique Primary Clustered
IX_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_DATEADDED DATEADDED yes
IX_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_DATECHANGED DATECHANGED
PK_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT ID yes yes
UC_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_TRIBUTEACKNOWLEDGEMENTPROCESSID TRIBUTEACKNOWLEDGEMENTPROCESSID yes

Triggers

Trigger Name Description
TR_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_AUDIT_UPDATE
TR_TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT_AUDIT_DELETE