v_FACT_OPPORTUNITYFUNDING

Relates opportunities to prospect funding interests.

Fields

Field	Field Type	Null	Description
OPPORTUNITYFUNDINGFACTID	int		BBDW.[FACT_OPPORTUNITYFUNDING].[OPPORTUNITYFUNDINGFACTID]
OPPORTUNITYFUNDINGSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_OPPORTUNITYFUNDING].[OPPORTUNITYFUNDINGSYSTEMID]
OPPORTUNITYFACTID	int	yes	BBDW.[FACT_OPPORTUNITYFUNDING].[OPPORTUNITYFACTID]
PROSPECTFUNDINGINTERESTDIMID	int	yes	BBDW.[FACT_OPPORTUNITYFUNDING].[PROSPECTFUNDINGINTERESTDIMID]
CONSTITUENTDIMID	int	yes	BBDW.[FACT_OPPORTUNITYFUNDING].[CONSTITUENTDIMID]

Definition

Copy


create view [BBDW].[v_FACT_OPPORTUNITYFUNDING] as 
  select 
    [OPPORTUNITYFUNDINGFACTID],
    [OPPORTUNITYFUNDINGSYSTEMID],
    [OPPORTUNITYFACTID],
    [PROSPECTFUNDINGINTERESTDIMID],
    [CONSTITUENTDIMID]
  from [BBDW].[FACT_OPPORTUNITYFUNDING];