| NAME |
nvarchar(100) |
|
Default = 'PhoneFinder Submit Process' |
The name of the submit process |
| CREATEOUTPUTIDSET |
bit |
|
Default = 0 |
Whether or not to create a selection of constituents as a result of the submit process |
| OUTPUTIDSETNAME |
nvarchar(300) |
|
Default = '' |
The name of the selection to create as a result of the submit process |
| OVERWRITEOUTPUTIDSET |
bit |
|
Default = 0 |
Whether or not to overwrite an existing selection if one by the same name already exists |
| 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. |
| INDIVIDUALADDRESSINCLUDECODE |
tinyint |
|
Default = 0 |
The type of address to use in the process |
| INDIVIDUALADDRESSINCLUDE |
nvarchar(16) (Computed) |
yes |
CASE [INDIVIDUALADDRESSINCLUDECODE] WHEN 0 THEN N'Primary address' WHEN 1 THEN N'Specific address' END |
Provides a translation for the 'INDIVIDUALADDRESSINCLUDECODE' field. |
| ORGANIZATIONADDRESSINCLUDECODE |
tinyint |
|
Default = 0 |
The type of address to use in the process |
| ORGANIZATIONADDRESSINCLUDE |
nvarchar(16) (Computed) |
yes |
CASE [ORGANIZATIONADDRESSINCLUDECODE] WHEN 0 THEN N'Primary address' WHEN 1 THEN N'Specific address' END |
Provides a translation for the 'ORGANIZATIONADDRESSINCLUDECODE' field. |
| INDIVIDUALPHONENUMBERINCLUDECODE |
tinyint |
|
Default = 0 |
The type of phone number to use in the process for individuals |
| INDIVIDUALPHONENUMBERINCLUDE |
nvarchar(21) (Computed) |
yes |
CASE [INDIVIDUALPHONENUMBERINCLUDECODE] WHEN 0 THEN N'Primary phone number' WHEN 1 THEN N'Specific phone number' END |
Provides a translation for the 'INDIVIDUALPHONENUMBERINCLUDECODE' field. |
| ORGANIZATIONPHONENUMBERINCLUDECODE |
tinyint |
|
Default = 0 |
The type of phone number to use in the process for organizations |
| ORGANIZATIONPHONENUMBERINCLUDE |
nvarchar(21) (Computed) |
yes |
CASE [ORGANIZATIONPHONENUMBERINCLUDECODE] WHEN 0 THEN N'Primary phone number' WHEN 1 THEN N'Specific phone number' END |
Provides a translation for the 'ORGANIZATIONPHONENUMBERINCLUDECODE' field. |
| INCLUDEINACTIVE |
bit |
|
Default = 0 |
Include inactive constituents |
| INCLUDEINCOMPLETEADDRESSES |
bit |
|
Default = 0 |
Include incomplete addresses |
| DATELASTRUN |
datetime |
yes |
|
The last date this process was run |
| CREATENEWBATCH |
bit |
|
Default = 0 |
Whether or not a new batch should be created the next time this process is run |
| INCLUDECONSTITUENTDNM |
bit |
|
Default = 1 |
|