FACT_CONSTITUENCY

The Constituency fact associates constituents to constituencies. This includes user defined constituencies as well as system defined ones (Volunteer, Board Member, Fundraiser, Group Member, Staff, and Committee).

Primary Key

Primary Key	Field Type
CONSTITUENCYFACTID	int

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENCYSYSTEMID	uniqueidentifier	yes		dbo.[CONSTITUENCY].[ID]
CONSTITUENTDIMID	int	yes		Reference key to the constituent dimension
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[CONSTITUENCY].[CONSTITUENTID]
CONSTITUENCYDIMID	int	yes		Reference key to the constituency dimension, derived from dbo.[CONSTITUENCY].[CONSTITUENCYCODEID]
FROMDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[CONSTITUENCY].[FROMDATE]
FROMDATE	datetime	yes		dbo.[CONSTITUENCY].[DATEFROM]
TODATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[CONSTITUENCY].[TODATE]
TODATE	datetime	yes		dbo.[CONSTITUENCY].[DATETO]
ISCURRENTCONSTITUENCY	bit	yes		Flag indicating if the constituent constituency is currently active.
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process
SOURCEDIMID	int	yes		Source system used

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_CONSTITUENCY	CONSTITUENCYFACTID	yes	yes	yes