v_DIM_SPONSORSHIP

Stores information about sponsorship

Fields

Field	Field Type	Null	Description
SPONSORSHIPDIMID	int		BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPDIMID]
SPONSORSHIPSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPSYSTEMID]
SPONSORCONSTITUENTDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORCONSTITUENTDIMID]
SPONSORCONSTITUENTSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORCONSTITUENTSYSTEMID]
SPONSORSHIPCOMMITMENTSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPCOMMITMENTSYSTEMID]
SPONSORSHIPCOMMITMENTSEQUENCE	smallint	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPCOMMITMENTSEQUENCE]
SPONSORSHIPCOMMITMENTLOOKUPID	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPCOMMITMENTLOOKUPID]
SPONSORSHIPPROGRAMNAME	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPPROGRAMNAME]
SPONSORSHIPPROGRAMAMOUNT	money	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPPROGRAMAMOUNT]
SPONSORSHIPPROGRAMISACTIVE	bit	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPPROGRAMISACTIVE]
ISAFFILIATESPONSORSHIPPROGRAM	bit	yes	BBDW.[DIM_SPONSORSHIP].[ISAFFILIATESPONSORSHIPPROGRAM]
AFFILIATECONSTITUENTDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[AFFILIATECONSTITUENTDIMID]
AFFILIATECONSTITUENTSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIP].[AFFILIATECONSTITUENTSYSTEMID]
SPONSORSHIPOPPORTUNITYGROUPNAME	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYGROUPNAME]
SPONSORSHIPOPPORTUNITYGROUPSEQUENCE	int	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYGROUPSEQUENCE]
SPONSORSHIPOPPORTUNITYGROUPISACTIVE	bit	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYGROUPISACTIVE]
SPONSORSPEROPPORTUNITY	smallint	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSPEROPPORTUNITY]
SPONSORSHIPOPPORTUNITY	nvarchar(154)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITY]
SPONSORSHIPOPPORTUNITYTYPE	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYTYPE]
SPONSORSHIPOPPORTUNITYELIGIBILITY	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYELIGIBILITY]
INELIGIBILESPONSORSHIPREASON	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[INELIGIBILESPONSORSHIPREASON]
SPONSORSHIPOPPORTUNITYAVAILABILITY	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYAVAILABILITY]
SPONSORSHIPOPPORTUNITYLOOKUPID	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYLOOKUPID]
SPONSORSHIPOPPORTUNITYSTATUS	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYSTATUS]
LASTDOCUMENTATIONDATEDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[LASTDOCUMENTATIONDATEDIMID]
LASTDOCUMENTATIONDATE	datetime	yes	BBDW.[DIM_SPONSORSHIP].[LASTDOCUMENTATIONDATE]
SPONSORSHIPOPPORTUNITYCHILDDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYCHILDDIMID]
SPONSORSHIPOPPORTUNITYCHILDCONSTITUENTDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYCHILDCONSTITUENTDIMID]
SPONSORSHIPOPPORTUNITYCHILDCONSTITUENTSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYCHILDCONSTITUENTSYSTEMID]
SPONSORSHIPOPPORTUNITYCHILDFULLNAME	nvarchar(154)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYCHILDFULLNAME]
SPONSORSHIPOPPORTUNITYPROJECTDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYPROJECTDIMID]
SPONSORSHIPOPPORTUNITYPROJECTNAME	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYPROJECTNAME]
SPONSORSHIPSTATUS	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPSTATUS]
SPONSORSHIPSTARTDATEDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPSTARTDATEDIMID]
SPONSORSHIPSTARTDATE	datetime	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPSTARTDATE]
SPONSORSHIPENDDATEDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPENDDATEDIMID]
SPONSORSHIPENDDATE	datetime	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPENDDATE]
SPONSORSHIPPLANNEDENDDATEDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPPLANNEDENDDATEDIMID]
SPONSORSHIPPLANNEDENDDATE	datetime	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPPLANNEDENDDATE]
CHILDGENDER	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIP].[CHILDGENDER]
ISHIVPOSITIVE	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIP].[ISHIVPOSITIVE]
HASCONDITION	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIP].[HASCONDITION]
ISORPHANED	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIP].[ISORPHANED]
AGERANGE	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[AGERANGE]
SPONSORSHIPLOCATIONDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPLOCATIONDIMID]
SPONSORSHIPLOCATIONNAME	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPLOCATIONNAME]
SPONSORSHIPLOCATIONLOOKUPID	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPLOCATIONLOOKUPID]
ISMOSTRECENTFORMCOMMITMENT	bit	yes	BBDW.[DIM_SPONSORSHIP].[ISMOSTRECENTFORMCOMMITMENT]
EXPIRATIONSPONSORSHIPREASONDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[EXPIRATIONSPONSORSHIPREASONDIMID]
EXPIRATIONSPONSORSHIPREASON	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[EXPIRATIONSPONSORSHIPREASON]
SPONSORSHIPOPPORTUNITYPROJECTCATEGORY	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYPROJECTCATEGORY]
ISSOLESPONSORSHIP	bit	yes	BBDW.[DIM_SPONSORSHIP].[ISSOLESPONSORSHIP]
ISGIFTSPONSORSHIP	bit	yes	BBDW.[DIM_SPONSORSHIP].[ISGIFTSPONSORSHIP]
FINANCIALSPONSORCONSTITUENTDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[FINANCIALSPONSORCONSTITUENTDIMID]
FINANCIALSPONSORCONSTITUENTSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIP].[FINANCIALSPONSORCONSTITUENTSYSTEMID]
FINANCIALTRANSACTIONFACTID	int	yes	BBDW.[DIM_SPONSORSHIP].[FINANCIALTRANSACTIONFACTID]
FINANCIALTRANSACTIONLINEITEMFACTID	int	yes	BBDW.[DIM_SPONSORSHIP].[FINANCIALTRANSACTIONLINEITEMFACTID]
SPONSORSHIPOPPORTUNITYSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIP].[SPONSORSHIPOPPORTUNITYSYSTEMID]
ACTIVESPONSORS	smallint	yes	BBDW.[DIM_SPONSORSHIP].[ACTIVESPONSORS]
OPPORTUNITYSPONSORSHIPLOCATIONDIMID	int	yes	BBDW.[DIM_SPONSORSHIP].[OPPORTUNITYSPONSORSHIPLOCATIONDIMID]

Definition

Copy


CREATE view [BBDW].[v_DIM_SPONSORSHIP] as 
  select 
    [SPONSORSHIPDIMID],
    [SPONSORSHIPSYSTEMID],
    [SPONSORCONSTITUENTDIMID],
    [SPONSORCONSTITUENTSYSTEMID],
    [SPONSORSHIPCOMMITMENTSYSTEMID],
    [SPONSORSHIPCOMMITMENTSEQUENCE],
    [SPONSORSHIPCOMMITMENTLOOKUPID],
    [SPONSORSHIPPROGRAMNAME],
    [SPONSORSHIPPROGRAMAMOUNT],
    [SPONSORSHIPPROGRAMISACTIVE],
    [ISAFFILIATESPONSORSHIPPROGRAM],
    [AFFILIATECONSTITUENTDIMID],
    [AFFILIATECONSTITUENTSYSTEMID],
    [SPONSORSHIPOPPORTUNITYGROUPNAME],
    [SPONSORSHIPOPPORTUNITYGROUPSEQUENCE],
    [SPONSORSHIPOPPORTUNITYGROUPISACTIVE],
    [SPONSORSPEROPPORTUNITY],
    [SPONSORSHIPOPPORTUNITY],
    [SPONSORSHIPOPPORTUNITYTYPE],
    [SPONSORSHIPOPPORTUNITYELIGIBILITY],
    [INELIGIBILESPONSORSHIPREASON],
    [SPONSORSHIPOPPORTUNITYAVAILABILITY],
    [SPONSORSHIPOPPORTUNITYLOOKUPID],
    [SPONSORSHIPOPPORTUNITYSTATUS],
    [LASTDOCUMENTATIONDATEDIMID],
    [LASTDOCUMENTATIONDATE],
    [SPONSORSHIPOPPORTUNITYCHILDDIMID],
    [SPONSORSHIPOPPORTUNITYCHILDCONSTITUENTDIMID],
    [SPONSORSHIPOPPORTUNITYCHILDCONSTITUENTSYSTEMID],
    [SPONSORSHIPOPPORTUNITYCHILDFULLNAME],
    [SPONSORSHIPOPPORTUNITYPROJECTDIMID],
    [SPONSORSHIPOPPORTUNITYPROJECTNAME],
    [SPONSORSHIPSTATUS],
    [SPONSORSHIPSTARTDATEDIMID],
    [SPONSORSHIPSTARTDATE],
    [SPONSORSHIPENDDATEDIMID],
    [SPONSORSHIPENDDATE],
    [SPONSORSHIPPLANNEDENDDATEDIMID],
    [SPONSORSHIPPLANNEDENDDATE],
    [CHILDGENDER],
    [ISHIVPOSITIVE],
    [HASCONDITION],
    [ISORPHANED],
    [AGERANGE],
    [SPONSORSHIPLOCATIONDIMID],
    [SPONSORSHIPLOCATIONNAME],
    [SPONSORSHIPLOCATIONLOOKUPID],
    [ISMOSTRECENTFORMCOMMITMENT],
    [EXPIRATIONSPONSORSHIPREASONDIMID],
    [EXPIRATIONSPONSORSHIPREASON],
    [SPONSORSHIPOPPORTUNITYPROJECTCATEGORY],
    [ISSOLESPONSORSHIP],
    [ISGIFTSPONSORSHIP],
    [FINANCIALSPONSORCONSTITUENTDIMID], 
    [FINANCIALSPONSORCONSTITUENTSYSTEMID],
    [FINANCIALTRANSACTIONFACTID], 
    [FINANCIALTRANSACTIONLINEITEMFACTID],
    [SPONSORSHIPOPPORTUNITYSYSTEMID],
    [ACTIVESPONSORS],
    [OPPORTUNITYSPONSORSHIPLOCATIONDIMID]
  from [BBDW].[DIM_SPONSORSHIP];