v_DIM_SPONSORSHIPLOCATION
Stores information about sponsorship location
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORSHIPLOCATIONDIMID | int | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONDIMID] | |
| SPONSORSHIPLOCATIONSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONSYSTEMID] |
| SPONSORSHIPLOCATIONLOOKUPID | nvarchar(100) | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONLOOKUPID] |
| SPONSORSHIPLOCATIONNAME | nvarchar(100) | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONNAME] |
| SPONSORSHIPLOCATIONSTATUS | nvarchar(25) | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONSTATUS] |
| SPONSORSHIPLOCATIONCOMMENT | nvarchar(255) | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONCOMMENT] |
| SPONSORSHIPLOCATIONTYPE | nvarchar(100) | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONTYPE] |
| DISPLAYONLINE | bit | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[DISPLAYONLINE] |
| DESIGNATIONDIMID | int | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[DESIGNATIONDIMID] |
| FIELDOFFICECONSTITUENTDIMID | int | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[FIELDOFFICECONSTITUENTDIMID] |
| FIELDOFFICECONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[FIELDOFFICECONSTITUENTSYSTEMID] |
| SPONSORSHIPREASONDIMID | int | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPREASONDIMID] |
| SPONSORSHIPLOCATIONHIERARCHYID | hierarchyid | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONHIERARCHYID] |
| PARENTSPONSORSHIPLOCATIONDIMID | int | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[PARENTSPONSORSHIPLOCATIONDIMID] |
| SPONSORSHIPLOCATIONFULLNAME | nvarchar(4000) | yes | BBDW.[DIM_SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONFULLNAME] |
Definition
Copy
CREATE view [BBDW].[v_DIM_SPONSORSHIPLOCATION] as
select
[SPONSORSHIPLOCATIONDIMID],
[SPONSORSHIPLOCATIONSYSTEMID],
[SPONSORSHIPLOCATIONLOOKUPID],
[SPONSORSHIPLOCATIONNAME],
[SPONSORSHIPLOCATIONSTATUS],
[SPONSORSHIPLOCATIONCOMMENT],
[SPONSORSHIPLOCATIONTYPE],
[DISPLAYONLINE],
[DESIGNATIONDIMID],
[FIELDOFFICECONSTITUENTDIMID],
[FIELDOFFICECONSTITUENTSYSTEMID],
[SPONSORSHIPREASONDIMID],
[SPONSORSHIPLOCATIONHIERARCHYID],
[PARENTSPONSORSHIPLOCATIONDIMID],
[SPONSORSHIPLOCATIONFULLNAME]
from [BBDW].[DIM_SPONSORSHIPLOCATION];