DIM_SPONSORSHIPOPPORTUNITYPROJECT

Stores information about sponsorship opportunity projects

Primary Key

Primary Key	Field Type
SPONSORSHIPOPPORTUNITYPROJECTDIMID	int

Fields

Field	Field Type	Null	Notes	Description
SPONSORSHIPOPPORTUNITYPROJECTSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[ID]
SPONSORSHIPOPPORTUNITYPROJECTNAME	nvarchar(100)	yes		dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[NAME]
SPONSORSHIPOPPORTUNITYPROJECTDESCRIPTION	nvarchar(255)	yes		dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[DESCRIPTION]
SPONSORSHIPOPPORTUNITYPROJECTSTATUS	nvarchar(115)	yes		Derived from dbo.[SPONSORSHIPOPPORTUNITY].[ELIGIBILITY]
STARTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[STARTDATE]
STARTDATE	datetime	yes		dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[STARTDATE]
ENDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[ENDDATE]
ENDDATE	datetime	yes		dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[ENDDATE]
SPONSORSHIPGOAL	money	yes		dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[ORGANIZATIONAMOUNT]
SPONSORGOAL	int	yes		dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[SPONSORGOAL]
DESIGNATIONDIMID	int	yes		Reference key to the designation dimension, derived from dbo.[SPONSORSHIPOPPORTUNITYPROJECT].[DESIGNATIONID]
SPONSORSHIPOPPORTUNITYPROJECTCATEGORYCODESYSTEMID	uniqueidentifier	yes		dbo.[SPROPPPROJECTCATEGORYCODE].[ID]
SPONSORSHIPOPPORTUNITYPROJECTCATEGORY	nvarchar(100)	yes		dbo.[SPROPPPROJECTCATEGORYCODE].[DESCRIPTION]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
SOURCEDIMID	int	yes		Source system used.
ETLCONTROLID	int	yes		ID generated through the ETL process.
CLOSEDSPONSORSHIPREASONDIMID	int	yes		Reference key to the sponsorship reason dimension, derived from dbo.[SPONSORSHIPOPPORTUNITY].[SPONSORSHIPREASONID]

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_DIM_SPONSORSHIPOPPORTUNITYPROJECT	SPONSORSHIPOPPORTUNITYPROJECTDIMID	yes	yes	yes