v_FACT_CONSTITUENTSITE

Contains information about sites associated with constituents.

Fields

Field	Field Type	Null	Description
CONSTITUENTSITEFACTID	int		BBDW.[FACT_CONSTITUENTSITE].[CONSTITUENTSITEFACTID]
CONSTITUENTSITESYSTEMID	uniqueidentifier	yes	BBDW.[FACT_CONSTITUENTSITE].[CONSTITUENTSITESYSTEMID]
SITEDIMID	int	yes	BBDW.[FACT_CONSTITUENTSITE].[SITEDIMID]
CONSTITUENTDIMID	int	yes	BBDW.[FACT_CONSTITUENTSITE].[CONSTITUENTDIMID]
SITESYSTEMID	uniqueidentifier		BBDW.[FACT_CONSTITUENTSITE].[SITESYSTEMID]

Definition

Copy


CREATE view [BBDW].[v_FACT_CONSTITUENTSITE] as
  select
  cs.[CONSTITUENTSITEFACTID],
  cs.[CONSTITUENTSITESYSTEMID],
  cs.[SITEDIMID],
  cs.[CONSTITUENTDIMID],
  cs.[SITESYSTEMID]
  from BBDW.[FACT_CONSTITUENTSITE] cs;