v_DIM_CAMPAIGN
The campaign dimension contains information about campaigns.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CAMPAIGNDIMID | int | BBDW.[DIM_CAMPAIGN].[CAMPAIGNDIMID] | |
| CAMPAIGNSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNSYSTEMID] |
| CAMPAIGNLOOKUPID | nvarchar(100) | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNLOOKUPID] |
| CAMPAIGNNAME | nvarchar(100) | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNNAME] |
| CAMPAIGNDESCRIPTION | nvarchar(300) | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNDESCRIPTION] |
| CAMPAIGNTYPE | nvarchar(100) | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNTYPE] |
| CAMPAIGNISACTIVE | bit | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNISACTIVE] |
| CAMPAIGNSTARTDATE | datetime | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNSTARTDATE] |
| CAMPAIGNSTARTDATEDIMID | int | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNSTARTDATEDIMID] |
| CAMPAIGNENDDATE | datetime | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNENDDATE] |
| CAMPAIGNENDDATEDIMID | int | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNENDDATEDIMID] |
| PARENTCAMPAIGNDIMID | int | yes | BBDW.[DIM_CAMPAIGN].[PARENTCAMPAIGNDIMID] |
| PARENTCAMPAIGNSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CAMPAIGN].[PARENTCAMPAIGNSYSTEMID] |
| CAMPAIGNHIERARCHYPATH | hierarchyid | yes | BBDW.[DIM_CAMPAIGN].[CAMPAIGNHIERARCHYPATH] |
Definition
Copy
CREATE view [BBDW].[v_DIM_CAMPAIGN] as
select
[CAMPAIGNDIMID],
[CAMPAIGNSYSTEMID],
[CAMPAIGNLOOKUPID],
[CAMPAIGNNAME],
[CAMPAIGNDESCRIPTION],
[CAMPAIGNTYPE],
[CAMPAIGNISACTIVE],
[CAMPAIGNSTARTDATE],
[CAMPAIGNSTARTDATEDIMID],
[CAMPAIGNENDDATE],
[CAMPAIGNENDDATEDIMID],
[PARENTCAMPAIGNDIMID],
[PARENTCAMPAIGNSYSTEMID],
[CAMPAIGNHIERARCHYPATH]
from BBDW.[DIM_CAMPAIGN]