V_QUERY_BBDW_SPONSORSHIPLOCATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORSHIPLOCATIONDIMID | int | ||
| SPONSORSHIPLOCATIONSYSTEMID | uniqueidentifier | yes | |
| SPONSORSHIPLOCATIONNAME | nvarchar(100) | yes | |
| SPONSORSHIPLOCATIONFULLNAME | nvarchar(4000) | yes | |
| SPONSORSHIPLOCATIONSTATUS | nvarchar(25) | yes | |
| SPONSORSHIPLOCATIONCOMMENT | nvarchar(255) | yes | |
| SPONSORSHIPLOCATIONTYPE | nvarchar(100) | yes | |
| SPONSORSHIPREASON | nvarchar(100) | yes | |
| SPONSORSHIPLOCATIONLOOKUPID | nvarchar(100) | yes | |
| DISPLAYONLINE | bit | yes | |
| DESIGNATIONDIMID | int | yes | |
| FIELDOFFICENAME | nvarchar(154) | yes | |
| FIELDOFFICESYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_SPONSORSHIPLOCATION] as
select
l.[SPONSORSHIPLOCATIONDIMID],
l.[SPONSORSHIPLOCATIONSYSTEMID],
l.[SPONSORSHIPLOCATIONNAME],
l.[SPONSORSHIPLOCATIONFULLNAME],
l.[SPONSORSHIPLOCATIONSTATUS],
l.[SPONSORSHIPLOCATIONCOMMENT],
l.[SPONSORSHIPLOCATIONTYPE],
sr.[SPONSORSHIPREASON],
l.[SPONSORSHIPLOCATIONLOOKUPID],
l.[DISPLAYONLINE],
l.[DESIGNATIONDIMID],
c.[FULLNAME] [FIELDOFFICENAME],
c.[CONSTITUENTSYSTEMID] [FIELDOFFICESYSTEMID]
from [BBDW].[DIM_SPONSORSHIPLOCATION] l
left join [BBDW].[DIM_SPONSORSHIPREASON] sr on l.[SPONSORSHIPREASONDIMID] = sr.[SPONSORSHIPREASONDIMID] and l.[SPONSORSHIPREASONDIMID] <> 0
left join [BBDW].[DIM_CONSTITUENT] c on l.[FIELDOFFICECONSTITUENTDIMID] = c.[constituentdimid] and l.[FIELDOFFICECONSTITUENTDIMID] <> 0
where l.[SPONSORSHIPLOCATIONDIMID] > 0