| 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) |
yes |
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) |
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. |
| 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. |
| 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) |
yes |
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) |
yes |
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) |
yes |
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) |
yes |
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) |
yes |
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 |
|