| CODE |
nvarchar(10) |
|
Default = '' |
A unique code that identifies the segment. |
| RESPONSERATE |
decimal(5, 2) |
|
Default = 0 |
The expected response rate for the segment. |
| GIFTAMOUNT |
money |
|
Default = 0 |
The average expected gift amount per donor for the segment. |
| SAMPLESIZE |
int |
|
Default = 100 |
The percent or number of records to use for the segment. |
| SAMPLESIZETYPECODE |
tinyint |
|
Default = 0 |
The sample size type. |
| SAMPLESIZEMETHODCODE |
tinyint |
|
Default = 0 |
The method to use when retrieving the sample of records. |
| SEQUENCE |
int |
|
Default = 0 |
The order of segments for each marketing effort. |
| NEXTBRIEFSEQUENCE |
int |
|
Default = 0 |
The sequence of the next marketing plan item brief that is displayed after the segment. |
| COLLAPSED |
bit |
|
Default = 0 |
The collapsed/expanded state of a segment in the UI. |
| 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. |
| SAMPLESIZEEXCLUDEREMAINDER |
bit |
|
Default = 1 |
Whether or not to exclude remaining records from the rest of the marketing effort when the sample size less than 100%. |
| USAGECODE |
tinyint |
|
Default = 1 |
Indicates whether the segment is being used for testing, retesting, or is a continuation or reuse. |
| SAMPLESIZETYPE |
nvarchar(7) (Computed) |
yes |
CASE [SAMPLESIZETYPECODE] WHEN 0 THEN N'Percent' WHEN 1 THEN N'Records' END |
Provides a translation for the 'SAMPLESIZETYPECODE' field. |
| USAGE |
nvarchar(12) (Computed) |
yes |
CASE [USAGECODE] WHEN 1 THEN N'Test' WHEN 2 THEN N'Retest' WHEN 3 THEN N'Continuation' WHEN 4 THEN N'Reuse' END |
Provides a translation for the 'USAGECODE' field. |
| TESTSEGMENTCODE |
nvarchar(10) |
|
Default = '' |
A code that identifies the type of test segment. |
| SAMPLESIZEMETHOD |
nvarchar(6) (Computed) |
yes |
CASE [SAMPLESIZEMETHODCODE] WHEN 0 THEN N'nth' WHEN 1 THEN N'Random' WHEN 2 THEN N'Top' END |
Provides a translation for the 'SAMPLESIZEMETHODCODE' field. |
| OVERRIDEADDRESSPROCESSING |
bit |
|
Default = 0 |
Determines whether or not to override the mailing-level address processing options when performing calculations and exporting this segment. |
| USEADDRESSPROCESSING |
bit |
|
Default = 0 |
If mailing-level options are overridden, determines whether or not to apply address processing options when performing calculations and exporting this segment. |
| ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE |
tinyint |
|
Default = 0 |
If mailing-level options are overridden, indicates the type of date to be used when considering seasonal addresses. |
| ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPE |
nvarchar(15) (Computed) |
yes |
CASE [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N<Specific date> END |
Provides a translation for the 'ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE' field. |
| ADDRESSPROCESSINGOPTIONSEASONALASOFDATE |
datetime |
yes |
|
If mailing-level options are overridden, the specific date to be used when considering seasonal addresses. |
| EXPOSURESTARTDATE |
datetime |
yes |
|
For public media segments, the date on which the media is revealed. |
| EXPOSUREENDDATE |
datetime |
yes |
|
For public media segments, the date on which the media ceases to be displayed. |
| EXCLUDESPOUSE |
bit |
|
Default = 0 |
Determines whether or not exclude the spouse name from the name format if the spouse is included in the mailing. |
| OVERRIDEBUSINESSUNITS |
bit |
|
Default = 0 |
Determines whether the business units on the effort are being overridden by the segment. |
| ORGANIZATIONGIFTAMOUNT |
money |
|
Default = 0 |
The amount of the gift in organization currency. |
| EXCLUDE |
bit |
|
Default = 0 |
Indicates that this segment functions as an inline exclusion. |
| HISTORICALQUANTITY |
int |
|
Default = 0 |
|