Contains saved name format parameter sets used by various business processes.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
ADDRESSEEFUNCTIONID
|
uniqueidentifier
|
true
|
|
The addressee name format function to use for individuals.
|
|
SALUTATIONFUNCTIONID
|
uniqueidentifier
|
true
|
|
The salutation format function to use for individuals.
|
|
CONTACTADDRESSEEFUNCTIONID
|
uniqueidentifier
|
true
|
|
The addressee name format function to use for organization contacts.
|
|
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.
|
|
SITEID
|
uniqueidentifier
|
true
|
|
The site with which a name format parameter is associated.
|
|
GROUPSALUTATIONFUNCTIONID
|
uniqueidentifier
|
true
|
|
The salutation format function to use for the group primary member.
|
|
GROUPADDRESSEEFUNCTIONID
|
uniqueidentifier
|
true
|
|
The addressee name format function to use for groups.
|
|
JOINTSELECTIONID
|
uniqueidentifier
|
true
|
|
FK to IDSETREGISTER
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
ORGSALUTATIONCODE
|
tinyint
|
false
|
|
The salutation option for organizations.
|
|
CONTACTSALUTATIONOPTIONCODE
|
tinyint
|
false
|
|
Flag that indicates whether to use a custom name for the contact if it is not available.
|
|
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.
|
|
NAME
|
nvarchar(100)
|
false
|
|
The name of the parameter set.
|
|
DESCRIPTION
|
nvarchar(255)
|
false
|
|
A description of the parameter set.
|
|
ISDEFAULT
|
bit
|
false
|
|
Indicates this is the default parameter set.
|
|
ORGSALUTATION
|
nvarchar(24) (Computed)
|
true
|
|
Provides a translation for the 'ORGSALUTATIONCODE' field.
|
|
CONTACTSALUTATIONOPTION
|
nvarchar(21) (Computed)
|
true
|
|
Provides a translation for the 'CONTACTSALUTATIONOPTIONCODE' field.
|
|
GROUPNOCONTACTOPTIONCODE
|
tinyint
|
false
|
|
Flag that indicates whether to use a custom name for the group if it is not available.
|
|
GROUPNOCONTACTOPTION
|
nvarchar(21) (Computed)
|
true
|
|
Provides a translation for the 'GROUPNOCONTACTOPTIONCODE' field.
|
|
GROUPNOCONTACTCUSTOMNAME
|
nvarchar(100)
|
false
|
|
The custom name to use if the group name is not available.
|
|
JOINTRULETYPECODE
|
tinyint
|
false
|
|
Flag that indicates how to handle joint name formats.
|
|
JOINTSELECTIONBOTHRULETYPECODE
|
tinyint
|
false
|
|
Flag that indicates how to handle joint name formats when both in selection.
|
|
JOINTSELECTIONNEITHERRULETYPECODE
|
tinyint
|
false
|
|
Flag that indicates how to handle joint name formats when neither are in selection.
|
|
JOINTRULETYPE
|
nvarchar(18) (Computed)
|
true
|
|
Provides a translation for the 'JOINTRULETYPECODE' field.
|
|
JOINTSELECTIONBOTHRULETYPE
|
nvarchar(18) (Computed)
|
true
|
|
Provides a translation for the 'JOINTSELECTIONBOTHRULETYPECODE' field.
|
|
JOINTSELECTIONNEITHERRULETYPE
|
nvarchar(18) (Computed)
|
true
|
|
Provides a translation for the 'JOINTSELECTIONNEITHERRULETYPECODE' field.
|
|
GROUPSALUTATIONCODE
|
tinyint
|
false
|
|
The salutation option for groups.
|
|
GROUPSALUTATION
|
nvarchar(24) (Computed)
|
true
|
|
Provides a translation for the 'GROUPSALUTATIONCODE' field.
|
|
JOINTEXCLUDESPOUSE
|
bit
|
false
|
|
Bit that indicates whether or not to exclude the spouse that does not qualify for the process.
|
|
JOINTSPOUSESMAILEDSEPARATELY
|
bit
|
false
|
|
Bit that indicates to address spouses separately within the same process.
|
|
ISSYSTEM
|
bit
|
false
|
|
|
