Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ORGSALUTATIONCODE tinyint   Default = 0 The salutation option for organizations.
 CONTACTSALUTATIONOPTIONCODE tinyint   Default = 0 Flag that indicates whether to use a custom name for the contact if it is not available.
 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.
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' A description of the parameter set.
 ISDEFAULT bit   Default = 0 Indicates this is the default parameter set.
 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.
 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.
 GROUPNOCONTACTOPTIONCODE tinyint   Default = 0 Flag that indicates whether to use a custom name for the group if it is not available.
 GROUPNOCONTACTOPTION nvarchar(21) (Computed) CASE [GROUPNOCONTACTOPTIONCODE] WHEN 0 THEN N'Use organization name' WHEN 1 THEN N'Use custom name' END Provides a translation for the 'GROUPNOCONTACTOPTIONCODE' field.
 GROUPNOCONTACTCUSTOMNAME nvarchar(100)   Default = '' The custom name to use if the group name is not available.
 JOINTRULETYPECODE tinyint   Default = 1 Flag that indicates how to handle joint name formats.
 JOINTSELECTIONBOTHRULETYPECODE tinyint   Default = 1 Flag that indicates how to handle joint name formats when both in selection.
 JOINTSELECTIONNEITHERRULETYPECODE tinyint   Default = 1 Flag that indicates how to handle joint name formats when neither are in selection.
 JOINTRULETYPE nvarchar(18) (Computed) CASE [JOINTRULETYPECODE] WHEN 1 THEN N'Use default' WHEN 2 THEN N'Use primary member' WHEN 3 THEN N'Use male' WHEN 4 THEN N'Use female' WHEN 5 THEN N'Use selection' END Provides a translation for the 'JOINTRULETYPECODE' field.
 JOINTSELECTIONBOTHRULETYPE nvarchar(18) (Computed) CASE [JOINTSELECTIONBOTHRULETYPECODE] WHEN 1 THEN N'Use default' WHEN 2 THEN N'Use primary member' WHEN 3 THEN N'Use male' WHEN 4 THEN N'Use female' END Provides a translation for the 'JOINTSELECTIONBOTHRULETYPECODE' field.
 JOINTSELECTIONNEITHERRULETYPE nvarchar(18) (Computed) CASE [JOINTSELECTIONNEITHERRULETYPECODE] WHEN 1 THEN N'Use default' WHEN 2 THEN N'Use primary member' WHEN 3 THEN N'Use male' WHEN 4 THEN N'Use female' END Provides a translation for the 'JOINTSELECTIONNEITHERRULETYPECODE' field.
 GROUPSALUTATIONCODE tinyint   Default = 0 The salutation option for groups.
 GROUPSALUTATION nvarchar(24) (Computed) CASE [GROUPSALUTATIONCODE] WHEN 0 THEN N'Use group name' WHEN 1 THEN N'Use group primary member' WHEN 2 THEN N'Use custom name' END Provides a translation for the 'GROUPSALUTATIONCODE' field.
 JOINTEXCLUDESPOUSE bit   Default = 0 Bit that indicates whether or not to exclude the spouse that does not qualify for the process.
 JOINTSPOUSESMAILEDSEPARATELY bit   Default = 0 Bit that indicates to address spouses separately within the same process.
 ISSYSTEM bit   Default = 0

Foreign Key Field Type Null Notes Description
 ADDRESSEEFUNCTIONID uniqueidentifier NAMEFORMATFUNCTION.ID The addressee name format function to use for individuals.
 SALUTATIONFUNCTIONID uniqueidentifier NAMEFORMATFUNCTION.ID The salutation format function to use for individuals.
 CONTACTADDRESSEEFUNCTIONID uniqueidentifier NAMEFORMATFUNCTION.ID The addressee name format function to use for organization contacts.
 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.
 SITEID uniqueidentifier SITE.ID The site with which a name format parameter is associated.
 GROUPSALUTATIONFUNCTIONID uniqueidentifier NAMEFORMATFUNCTION.ID The salutation format function to use for the group primary member.
 GROUPADDRESSEEFUNCTIONID uniqueidentifier NAMEFORMATFUNCTION.ID The addressee name format function to use for groups.
 JOINTSELECTIONID uniqueidentifier IDSETREGISTER.ID FK to IDSETREGISTER

Index Name Field(s) Unique Primary Clustered
 IX_NAMEFORMATPARAMETER_DATEADDED DATEADDED    
 IX_NAMEFORMATPARAMETER_DATECHANGED DATECHANGED      
 IX_NAMEFORMATPARAMETER_SITEID SITEID      
 PK_NAMEFORMATPARAMETER ID  
 UC_NAMEFORMATPARAMETER_NAME NAME    

Trigger Name Description
 TR_NAMEFORMATPARAMETER_AUDIT_UPDATE
 TR_NAMEFORMATPARAMETER_AUDIT_DELETE

Referenced by Field
 INVITATION NAMEFORMATPARAMETERID
 INVITATIONHISTORY NAMEFORMATPARAMETERID
 MEMBERSHIPPROGRAM NAMEFORMATID
 MKTACKNOWLEDGEMENTMAILINGTEMPLATE NAMEFORMATPARAMETERID
 MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE NAMEFORMATPARAMETERID
 MKTMEMBERSHIPMAILINGTEMPLATE NAMEFORMATPARAMETERID
 MKTMEMBERSHIPMAILINGTEMPLATERULE NAMEFORMATPARAMETERID
 MKTSEGMENTATION NAMEFORMATPARAMETERID
 MKTSEGMENTATIONSEGMENT NAMEFORMATPARAMETERID
 MKTSPONSORSHIPMAILINGTEMPLATE NAMEFORMATPARAMETERID
 MKTSPONSORSHIPMAILINGTEMPLATERULE NAMEFORMATPARAMETERID
 NAMEFORMATPARAMETERGRPADDRESSEE NAMEFORMATPARAMETERID
 NAMEFORMATPARAMETERGRPSALUTATION NAMEFORMATPARAMETERID
 NAMEFORMATPARAMETERINDADDRESSEE NAMEFORMATPARAMETERID
 NAMEFORMATPARAMETERINDSALUTATION NAMEFORMATPARAMETERID
 NAMEFORMATPARAMETERORGADDRESSEE NAMEFORMATPARAMETERID
 NAMEFORMATPARAMETERORGSALUTATION NAMEFORMATPARAMETERID

Entity-Relationship diagram of this table (IDSETREGISTER-NAMEFORMATPARAMETERORGSALUTATION)
Entity-Relationship diagram of this table (SITE)