MKTSEGMENTWHITEMAILCACHE (4.0)

Caches calculations pertaining to a white mail segment's performance.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

BASECURRENCYID

uniqueidentifier

true

The base currency associated with this white mail segment.
Fields
Field Field Type Null Notes Description

RESPONDERS

int

false

0

The number of people whose responses are attributed to the white mail segment.

RESPONSES

int

false

0

The number of gifts attributed to the white mail segment.

TOTALGIFTAMOUNT

money

false

0

The total amount of gifts attributed to the white mail segment, stored in its base currency.

AVERAGEGIFTAMOUNT

money

false

0

The average amount of gifts attributed to the white mail segment, stored in its base currency.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

ORGANIZATIONTOTALGIFTAMOUNT

money

false

0

The total amount of gifts attributed to the white mail segment, stored in the organization currency.

ORGANIZATIONAVERAGEGIFTAMOUNT

money

false

0

The average amount of gifts attributed to the white mail segment, stored in the organization currency.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_MKTSEGMENTWHITEMAILCACHE_AVERAGEGIFTAMOUNT

AVERAGEGIFTAMOUNT

False

False

False

IX_MKTSEGMENTWHITEMAILCACHE_BASECURRENCYID

BASECURRENCYID

False

False

False

IX_MKTSEGMENTWHITEMAILCACHE_DATEADDED

DATEADDED

False

False

True

IX_MKTSEGMENTWHITEMAILCACHE_DATECHANGED

DATECHANGED

False

False

False

IX_MKTSEGMENTWHITEMAILCACHE_RESPONDERS

RESPONDERS

False

False

False

IX_MKTSEGMENTWHITEMAILCACHE_RESPONSES

RESPONSES

False

False

False

IX_MKTSEGMENTWHITEMAILCACHE_TOTALGIFTAMOUNT

TOTALGIFTAMOUNT

False

False

False

PK_MKTSEGMENTWHITEMAILCACHE

ID

True

True

False
Triggers
Trigger Name Description

TR_MKTSEGMENTWHITEMAILCACHE_AUDIT_UPDATE

TR_MKTSEGMENTWHITEMAILCACHE_AUDIT_DELETE

TR_MKTSEGMENTWHITEMAILCACHE_INSERTUPDATE_CURRENCY