v_FACT_MARKETINGCONSTITUENT
The marketing constituent fact table contains information about constituents in marketing efforts.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MARKETINGCONSTITUENTFACTID | bigint | BBDW.[FACT_MARKETINGCONSTITUENT].[MARKETINGCONSTITUENTFACTID] | |
| MARKETINGSEGMENTDIMID | int | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[MARKETINGSEGMENTDIMID] |
| MARKETINGSOURCECODEDIMID | int | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[MARKETINGSOURCECODEDIMID] |
| SEGMENTATIONDATEDIMID | int | yes | BBDW.[DIM_MARKETINGSEGMENT].[SEGMENTATIONDATEDIMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[CONSTITUENTSYSTEMID] |
| CONSTITUENTAGE | int | yes | BBDW.[DIM_CONSTITUENT].[AGE] |
| CONSTITUENTINFORMATIONDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTINFORMATIONDIMID] |
| CONSTITUENTADDRESSDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDIMID] |
| CONSTITUENTADDRESSDETAILDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDETAILDIMID] |
| CONSTITUENTADDRESSFLAGDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSFLAGDIMID] |
| CONSTITUENTADDRESSTYPEDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSTYPEDIMID] |
| CONSTITUENTDEMOGRAPHICDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTDEMOGRAPHICDIMID] |
| APPEALDIMID | int | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[APPEALDIMID] |
| APPEALSTARTDATEDIMID | int | yes | BBDW.[DIM_APPEAL].[APPEALSTARTDATEDIMID] |
| APPEALENDDATEDIMID | int | yes | BBDW.[DIM_APPEAL].[APPEALENDDATEDIMID] |
| FIXEDCOSTPERPIECE | numeric(28, 14) | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[FIXEDCOSTPERPIECE] |
| VARCOSTPERPIECE | numeric(28, 14) | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[VARCOSTPERPIECE] |
| BASECURRENCYDIMID | int | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[BASECURRENCYDIMID] |
| RESPONSECOSTPERPIECE | numeric(28, 14) | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[RESPONSECOSTPERPIECE] |
| BASEFIXEDCOSTPERPIECE | numeric(28, 14) | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[BASEFIXEDCOSTPERPIECE] |
| BASEVARCOSTPERPIECE | numeric(28, 14) | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[BASEVARCOSTPERPIECE] |
| BASERESPONSECOSTPERPIECE | numeric(28, 14) | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[BASERESPONSECOSTPERPIECE] |
| MARKETINGSEGMENTATIONDIMID | int | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[MARKETINGSEGMENTATIONDIMID] |
| FINDERNUMBER | bigint | yes | BBDW.[FACT_MARKETINGCONSTITUENT].[FINDERNUMBER] |
Definition
Copy
CREATE view [BBDW].[v_FACT_MARKETINGCONSTITUENT] as
select
mc.[MARKETINGCONSTITUENTFACTID],
mc.[MARKETINGSEGMENTDIMID],
mc.[MARKETINGSOURCECODEDIMID],
ms.[SEGMENTATIONDATEDIMID],
mc.[CONSTITUENTDIMID],
mc.[CONSTITUENTSYSTEMID],
c.[AGE] as [CONSTITUENTAGE],
c.[CONSTITUENTINFORMATIONDIMID],
c.[CONSTITUENTADDRESSDIMID],
c.[CONSTITUENTADDRESSDETAILDIMID],
c.[CONSTITUENTADDRESSFLAGDIMID],
c.[CONSTITUENTADDRESSTYPEDIMID],
c.[CONSTITUENTDEMOGRAPHICDIMID],
mc.[APPEALDIMID],
a.[APPEALSTARTDATEDIMID],
a.[APPEALENDDATEDIMID],
mc.[FIXEDCOSTPERPIECE],
mc.[VARCOSTPERPIECE],
mc.[BASECURRENCYDIMID],
mc.[RESPONSECOSTPERPIECE],
mc.[BASEFIXEDCOSTPERPIECE],
mc.[BASEVARCOSTPERPIECE],
mc.[BASERESPONSECOSTPERPIECE],
mc.[MARKETINGSEGMENTATIONDIMID],
mc.[FINDERNUMBER]
from
BBDW.[FACT_MARKETINGCONSTITUENT] mc
left join BBDW.[DIM_CONSTITUENT] c
on mc.[CONSTITUENTDIMID] = c.[CONSTITUENTDIMID]
left join BBDW.[DIM_APPEAL] a
on mc.[APPEALDIMID] = a.[APPEALDIMID]
left join BBDW.[DIM_MARKETINGSEGMENT] ms
on mc.[MARKETINGSEGMENTDIMID] = ms.[MARKETINGSEGMENTDIMID]