| SEGMENTATIONSYSTEMID |
uniqueidentifier |
|
|
dbo.[MKTSEGMENTATION].[ID] |
| SEGMENTATIONSITEDIMID |
int |
yes |
|
Reference key to the site dimension, derived from dbo.[MKTSEGMENTATION].[SITEID] |
| SEGMENTATIONID |
int |
yes |
|
dbo.[MKTSEGMENTATION].[IDINTEGER] |
| SEGMENTATIONCODE |
nvarchar(10) |
yes |
|
dbo.[MKTSEGMENTATION].[CODE] |
| SEGMENTATIONNAME |
nvarchar(100) |
yes |
|
dbo.[MKTSEGMENTATION].[NAME] |
| SEGMENTATIONDESCRIPTION |
nvarchar(255) |
yes |
|
dbo.[MKTSEGMENTATION].[DESCRIPTION] |
| SEGMENTATIONACTIVE |
bit |
yes |
|
dbo.[MKTSEGMENTATION].[ACTIVE] |
| SEGMENTATIONTYPE |
nvarchar(25) |
yes |
|
dbo.[MKTSEGMENTATION].[MAILINGTYPE] |
| SEGMENTATIONDATE |
date |
yes |
|
If dbo.[MKTSEGMENTATION].[MAILDATE] is not null then dbo.[MKTSEGMENTATION].[MAILDATE] else dbo.[MKTSEGMENTATION].[ACTIVATEDATE] |
| SEGMENTATIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from BBDW.[MARKETINGSEGMENTATION].[SEGMENTATIONDATE] |
| HOUSEHOLDINGTYPE |
nvarchar(40) |
yes |
|
dbo.[MKTSEGMENTATION].[HOUSEHOLDINGTYPE] |
| SEGMENTATIONTOTALGIFTAMOUNT |
money |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[TOTALGIFTAMOUNT] |
| SEGMENTATIONRESPONSES |
int |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[RESPONSES] |
| SEGMENTATIONTOTALCOST |
money |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[TOTALCOST] |
| SEGMENTATIONROIAMOUNT |
money |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[ROIAMOUNT] |
| SEGMENTATIONCOSTPERDOLLARRAISED |
money |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[COSTPERDOLLARRAISED] |
| SEGMENTATIONCOSTTOACQUIRE |
money |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[COSTTOACQUIRE] |
| SEGMENTATIONAVERAGEGIFTAMOUNT |
money |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[AVERAGEGIFTAMOUNT] |
| SEGMENTATIONRESPONSERATE |
decimal(19, 4) |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[RESPONSERATE] |
| SEGMENTATIONCOSTPERTHOUSAND |
decimal(22, 4) |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[COSTPERTHOUSAND] |
| SEGMENTATIONGROSSPERTHOUSAND |
decimal(22, 4) |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[GROSSPERTHOUSAND] |
| SEGMENTATIONNETPERTHOUSAND |
decimal(22, 4) |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[NETPERTHOUSAND] |
| SEGMENTATIONFIRSTRESPONSEDATE |
datetime |
yes |
|
[dbo].[MKTSEGMENTATIONACTIVE].[FIRSTRESPONSEDATE] |
| SEGMENTATIONFIRSTRESPONSEDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from [dbo].[MKTSEGMENTATIONACTIVE].[FIRSTRESPONSEDATE] |
| BASECURRENCYDIMID |
int |
yes |
|
Reference key to the currency dimension, derived from dbo.[MKTSEGMENTATION].[BASECURRENCYID] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| SEGMENTATIONQUANTITY |
int |
yes |
|
dbo.[MKTSEGMENTATIONACTIVE].[QUANTITY] |