FACT_CONSTITUENTSMARTFIELD

Contains information from constituent smart fields.

Primary Key

Primary Key	Field Type
CONSTITUENTSMARTFIELDFACTID	bigint

Fields

Field	Field Type	Null	Notes	Description
SMARTFIELDDIMID	int	yes		Reference key to the Smart Field dimension, derived from dbo.[SMARTFIELD].[ID] and the smart field's [GROUPNAME] column
SMARTFIELDSYSTEMID	uniqueidentifier	yes		dbo.[SMARTFIELD].[ID]
CONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from the smart field's [ID] column
CONSTITUENTSYSTEMID	uniqueidentifier	yes		The smart field's [ID] column
SMARTFIELDVALUE	nvarchar(255)	yes		The smart field's [VALUE] column
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.

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_CONSTITUENTSMARTFIELD	CONSTITUENTSMARTFIELDFACTID	yes	yes	yes