v_DIM_SPONSORSHIPREASON
Stores information about sponsorship reason
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORSHIPREASONDIMID | int | BBDW.[DIM_SPONSORSHIPREASON].[SPONSORSHIPREASONDIMID] | |
| SPONSORSHIPREASONSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SPONSORSHIPREASON].[SPONSORSHIPREASONSYSTEMID] |
| SPONSORSHIPREASON | nvarchar(100) | yes | BBDW.[DIM_SPONSORSHIPREASON].[SPONSORSHIPREASON] |
| SPONSORSHIPREASONTYPE | nvarchar(100) | yes | BBDW.[DIM_SPONSORSHIPREASON].[SPONSORSHIPREASONTYPE] |
Definition
Copy
create view [BBDW].[v_DIM_SPONSORSHIPREASON] as
select
[SPONSORSHIPREASONDIMID],
[SPONSORSHIPREASONSYSTEMID],
[SPONSORSHIPREASON],
[SPONSORSHIPREASONTYPE]
from [BBDW].[DIM_SPONSORSHIPREASON];