V_QUERY_BBDW_APPEAL
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTDIMID | int | yes | |
| CONSTITUENTAPPEALSYSTEMID | uniqueidentifier | ||
| APPEALSYSTEMID | uniqueidentifier | yes | |
| APPEALNAME | nvarchar(100) | yes | |
| APPEALSTARTDATEDIMID | int | yes | |
| APPEALSTARTDATE | datetime | yes | |
| APPEALENDDATEDIMID | int | yes | |
| APPEALENDDATE | datetime | yes | |
| APPEALCATEGORY | nvarchar(100) | yes | |
| APPEALDESCRIPTION | nvarchar(300) | yes | |
| APPEALGOAL | money | yes | |
| SEGMENTATIONDATEDIMID | int | yes | |
| SEGMENTATIONDATE | date | yes | |
| SEGMENTATIONID | int | yes | |
| SEGMENTATIONNAME | nvarchar(100) | yes | |
| SEGMENTATIONDESCRIPTION | nvarchar(255) | yes | |
| SEGMENTATIONCOMMUNICATIONTYPE | nvarchar(25) | yes | |
| SEGMENTATIONSEGMENTNAME | nvarchar(203) | yes | |
| SEGMENTCATEGORY | nvarchar(100) | yes | |
| ISTESTSEGMENT | bit | yes | |
| PACKAGENAME | nvarchar(100) | yes | |
| PACKAGEDESCRIPTION | nvarchar(255) | yes | |
| PACKAGECHANNEL | nvarchar(12) | yes | |
| PACKAGECATEGORY | nvarchar(100) | yes | |
| SOURCECODE | nvarchar(50) | yes | |
| SOURCECODELAYOUT | nvarchar(100) | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes | |
| FINDERNUMBER | bigint | yes | |
| APPEALDIMID | int | yes | |
| APPEALREPORTCODE | nvarchar(100) | yes | |
| APPEALISACTIVE | bit | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_APPEAL] as
select
ca.[CONSTITUENTDIMID],
ca.[CONSTITUENTAPPEALSYSTEMID],
a.[APPEALSYSTEMID],
a.[APPEALNAME],
a.[APPEALSTARTDATEDIMID],
a.[APPEALSTARTDATE],
a.[APPEALENDDATEDIMID],
a.[APPEALENDDATE],
a.[APPEALCATEGORY],
a.[APPEALDESCRIPTION],
a.[APPEALGOAL],
ms.[SEGMENTATIONDATEDIMID],
ms.[SEGMENTATIONDATE],
ms.[SEGMENTATIONID],
ms.[SEGMENTATIONNAME],
ms.[SEGMENTATIONDESCRIPTION],
ms.[SEGMENTATIONCOMMUNICATIONTYPE],
ms.[SEGMENTATIONSEGMENTNAME],
ms.[SEGMENTCATEGORY],
ms.[ISTESTSEGMENT],
ms.[PACKAGENAME],
ms.[PACKAGEDESCRIPTION],
ms.[PACKAGECHANNEL],
ms.[PACKAGECATEGORY],
sc.[SOURCECODE],
sc.[SOURCECODELAYOUT],
c.[CURRENCYSYSTEMID],
ca.[FINDERNUMBER],
ca.[APPEALDIMID],
a.[APPEALREPORTCODE],
a.[APPEALISACTIVE]
from BBDW.[FACT_CONSTITUENTAPPEAL] ca
left join BBDW.[DIM_APPEAL] a on ca.[APPEALDIMID] = a.[APPEALDIMID] and ca.[APPEALDIMID] <> 0
left join BBDW.[DIM_MARKETINGSEGMENT] ms on ms.[MARKETINGSEGMENTDIMID] = ca.[MARKETINGSEGMENTDIMID] and ca.[MARKETINGSEGMENTDIMID] <> 0
left join BBDW.[DIM_MARKETINGSOURCECODE] sc on sc.[MARKETINGSEGMENTDIMID] = ms.[MARKETINGSEGMENTDIMID] and ms.[MARKETINGSEGMENTDIMID] <> 0
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1