v_DIM_CAMPAIGNPRIORITY
The campaign priority dimension contains information about campaign priorities.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CAMPAIGNPRIORITYDIMID | int | BBDW.[DIM_CAMPAIGNPRIORITY].[CAMPAIGNPRIORITYDIMID] | |
| CAMPAIGNSUBPRIORITYSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CAMPAIGNPRIORITY].[CAMPAIGNSUBPRIORITYSYSTEMID] |
| CAMPAIGNDIMID | int | yes | BBDW.[DIM_CAMPAIGNPRIORITY].[CAMPAIGNDIMID] |
| CAMPAIGNSUBPRIORITY | nvarchar(100) | yes | BBDW.[DIM_CAMPAIGNPRIORITY].[CAMPAIGNSUBPRIORITY] |
| CAMPAIGNPRIORITY | nvarchar(100) | yes | BBDW.[DIM_CAMPAIGNPRIORITY].[CAMPAIGNPRIORITY] |
| CAMPAIGNSUBPRIORITYGOAL | money | yes | BBDW.[DIM_CAMPAIGNPRIORITY].[CAMPAIGNSUBPRIORITYGOAL] |
| CAMPAIGNPRIORITYGOAL | money | yes | BBDW.[DIM_CAMPAIGNPRIORITY].[CAMPAIGNPRIORITYGOAL] |
Definition
Copy
create view [BBDW].[v_DIM_CAMPAIGNPRIORITY] as
select
[CAMPAIGNPRIORITYDIMID],
[CAMPAIGNSUBPRIORITYSYSTEMID],
[CAMPAIGNDIMID],
[CAMPAIGNSUBPRIORITY],
[CAMPAIGNPRIORITY],
[CAMPAIGNSUBPRIORITYGOAL],
[CAMPAIGNPRIORITYGOAL]
from BBDW.[DIM_CAMPAIGNPRIORITY]