v_FACT_CAMPAIGNGOAL
Contains information about the campaign goals and campaign hierarchy goals.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CAMPAIGNGOALFACTID | int | BBDW.[FACT_CAMPAIGNGOAL].[CAMPAIGNGOALFACTID] | |
| CAMPAIGNGOALSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CAMPAIGNGOAL].[CAMPAIGNGOALSYSTEMID] |
| CAMPAIGNDIMID | int | yes | BBDW.[FACT_CAMPAIGNGOAL].[CAMPAIGNDIMID] |
| CAMPAIGNGOALNAME | nvarchar(100) | yes | BBDW.[FACT_CAMPAIGNGOAL].[CAMPAIGNGOALNAME] |
| CAMPAIGNGOALAMOUNT | money | yes | BBDW.[FACT_CAMPAIGNGOAL].[CAMPAIGNGOALAMOUNT] |
| CAMPAIGNGOALSTARTDATE | datetime | yes | BBDW.[FACT_CAMPAIGNGOAL].[CAMPAIGNGOALSTARTDATE] |
| CAMPAIGNGOALENDDATE | datetime | yes | BBDW.[FACT_CAMPAIGNGOAL].[CAMPAIGNGOALENDDATE] |
| CAMPAIGNGOALSTARTDATEDIMID | int | yes | BBDW.[FACT_CAMPAIGNGOAL].[CAMPAIGNGOALSTARTDATEDIMID] |
| CAMPAIGNGOALENDDATEDIMID | int | yes | BBDW.[FACT_CAMPAIGNGOAL].[CAMPAIGNGOALENDDATEDIMID] |
| ISCAMPAIGNHIERARCHYGOAL | bit | yes | BBDW.[FACT_CAMPAIGNGOAL].[ISCAMPAIGNHIERARCHYGOAL] |
Definition
Copy
create view [BBDW].[v_FACT_CAMPAIGNGOAL] as
select
[CAMPAIGNGOALFACTID],
[CAMPAIGNGOALSYSTEMID],
[CAMPAIGNDIMID],
[CAMPAIGNGOALNAME],
[CAMPAIGNGOALAMOUNT],
[CAMPAIGNGOALSTARTDATE],
[CAMPAIGNGOALENDDATE],
[CAMPAIGNGOALSTARTDATEDIMID],
[CAMPAIGNGOALENDDATEDIMID],
[ISCAMPAIGNHIERARCHYGOAL]
from [BBDW].[FACT_CAMPAIGNGOAL];