Contains name format information pertaining to the tribute acknowledgement process.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
TRIBUTEACKNOWLEDGEMENTPROCESSID
|
uniqueidentifier
|
false
|
|
The tribute acknowledgement process that uses this parameter set.
|
|
ADDRESSEEFORMATID
|
uniqueidentifier
|
true
|
|
The addressee name format to use for individuals.
|
|
ALTADDRESSEEFORMATID
|
uniqueidentifier
|
true
|
|
The alternate addressee name format to use for individuals.
|
|
ADDRESSEEFUNCTIONID
|
uniqueidentifier
|
true
|
|
The addressee name format function to use for individuals.
|
|
SALUTATIONFORMATID
|
uniqueidentifier
|
true
|
|
The salutation format to use for individuals.
|
|
ALTSALUTATIONFORMATID
|
uniqueidentifier
|
true
|
|
The alternate salutation format to use for individuals.
|
|
SALUTATIONFUNCTIONID
|
uniqueidentifier
|
true
|
|
The salutation format function to use for individuals.
|
|
CONTACTADDRESSEEFORMATID
|
uniqueidentifier
|
true
|
|
The addressee name format to use for organization contacts.
|
|
ALTCONTACTADDRESSEEFORMATID
|
uniqueidentifier
|
true
|
|
The alternate addressee format to use for organization contacts.
|
|
CONTACTADDRESSEEFUNCTIONID
|
uniqueidentifier
|
true
|
|
The addressee name format function to use for organization contacts.
|
|
CONTACTSALUTATIONFORMATID
|
uniqueidentifier
|
true
|
|
The salutation format to use for the organization contact.
|
|
ALTCONTACTSALUTATIONFORMATID
|
uniqueidentifier
|
true
|
|
The alternate salutation format to use for the organization contact.
|
|
CONTACTSALUTATIONFUNCTIONID
|
uniqueidentifier
|
true
|
|
The salutation format function to use for the organization contact.
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
USEADDRESSEEFORMAT
|
bit
|
false
|
|
A flag indicating to use pre-defined name formats for the individual addressee.
|
|
USESALUTATIONFORMAT
|
bit
|
false
|
|
A flag indicating to use pre-defined name formats for the individual salutation.
|
|
USECONTACTADDRESSEEFORMAT
|
bit
|
false
|
|
A flag indicating to use pre-defined name formats for the contact addressee.
|
|
ORGSALUTATIONCODE
|
tinyint
|
false
|
|
The salutation option for organizations.
|
|
ORGSALUTATION
|
nvarchar(24) (Computed)
|
true
|
|
Provides a translation for the 'ORGSALUTATIONCODE' field.
|
|
USECONTACTSALUTATIONFORMAT
|
bit
|
false
|
|
A flag indicating to use pre-defined name formats for the contact salutation.
|
|
CONTACTSALUTATIONOPTIONCODE
|
tinyint
|
false
|
|
Flag that indicates whether to use a custom name for the contact if it is not available.
|
|
CONTACTSALUTATIONOPTION
|
nvarchar(21) (Computed)
|
true
|
|
Provides a translation for the 'CONTACTSALUTATIONOPTIONCODE' field.
|
|
CUSTOMNAME
|
nvarchar(100)
|
false
|
|
The custom name to use if the contact name is not available.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
