v_DIM_SPONSORSHIPOPPORTUNITYPROJECT

Stores information about sponsorship opportunity children

Fields

Field	Field Type	Null	Description
SPONSORSHIPOPPORTUNITYPROJECTDIMID	int		BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[SPONSORSHIPOPPORTUNITYPROJECTDIMID]
SPONSORSHIPOPPORTUNITYPROJECTSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[SPONSORSHIPOPPORTUNITYPROJECTSYSTEMID]
SPONSORSHIPOPPORTUNITYPROJECTNAME	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[SPONSORSHIPOPPORTUNITYPROJECTNAME]
SPONSORSHIPOPPORTUNITYPROJECTDESCRIPTION	nvarchar(255)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[SPONSORSHIPOPPORTUNITYPROJECTDESCRIPTION]
SPONSORSHIPOPPORTUNITYPROJECTSTATUS	nvarchar(115)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[SPONSORSHIPOPPORTUNITYPROJECTSTATUS]
CLOSEDSPONSORSHIPREASONDIMID	int	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[CLOSEDSPONSORSHIPREASONDIMID]
STARTDATEDIMID	int	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[STARTDATEDIMID]
STARTDATE	datetime	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[STARTDATE]
ENDDATEDIMID	int	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[ENDDATEDIMID]
ENDDATE	datetime	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[ENDDATE]
SPONSORSHIPGOAL	money	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[SPONSORSHIPGOAL]
SPONSORGOAL	int	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[SPONSORGOAL]
DESIGNATIONDIMID	int	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[DESIGNATIONDIMID]
SPONSORSHIPOPPORTUNITYPROJECTCATEGORY	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYPROJECT].[SPONSORSHIPOPPORTUNITYPROJECTCATEGORY]

Definition

Copy


CREATE view [BBDW].[v_DIM_SPONSORSHIPOPPORTUNITYPROJECT] as 
  select 
    [SPONSORSHIPOPPORTUNITYPROJECTDIMID],
    [SPONSORSHIPOPPORTUNITYPROJECTSYSTEMID],
    [SPONSORSHIPOPPORTUNITYPROJECTNAME],
    [SPONSORSHIPOPPORTUNITYPROJECTDESCRIPTION],
    [SPONSORSHIPOPPORTUNITYPROJECTSTATUS],
    [CLOSEDSPONSORSHIPREASONDIMID],
    [STARTDATEDIMID],
    [STARTDATE],
    [ENDDATEDIMID],
    [ENDDATE],
    [SPONSORSHIPGOAL],
    [SPONSORGOAL],
    [DESIGNATIONDIMID],
    [SPONSORSHIPOPPORTUNITYPROJECTCATEGORY]
  from [BBDW].[DIM_SPONSORSHIPOPPORTUNITYPROJECT];