DIM_SMARTFIELD

Contains information about smart fields.

Primary Key

Primary Key	Field Type
SMARTFIELDDIMID	int

Fields

Field	Field Type	Null	Notes	Description
SMARTFIELDVALUEGROUPSYSTEMID	uniqueidentifier	yes		dbo.[SMARTFIELDVALUEGROUP].[ID]
SMARTFIELDSYSTEMID	uniqueidentifier	yes		dbo.[SMARTFIELD].[ID]
SMARTFIELDCATALOGSYSTEMID	uniqueidentifier	yes		dbo.[SMARTFIELDCATALOG].[ID]
SMARTFIELDVALUEGROUPNAME	nvarchar(100)	yes		dbo.[SMARTFIELDVALUEGROUP].[GROUPNAME]
SMARTFIELDNAME	nvarchar(100)	yes		dbo.[SMARTFIELD].[NAME]
SMARTFIELDDESCRIPTION	nvarchar(4000)	yes		dbo.[SMARTFIELD].[DESCRIPTION]
SMARTFIELDTYPENAME	nvarchar(100)	yes		dbo.[SMARTFIELDCATALOG].[DISPLAYNAME]
SMARTFIELDTYPEDESCRIPTION	nvarchar(4000)	yes		dbo.[SMARTFIELDCATALOG].[DESCRIPTION]
SMARTFIELDDATATYPE	nvarchar(20)	yes		dbo.[SMARTFIELDCATALOG].[DATATYPE]
SMARTFIELDRECORDTYPE	nvarchar(50)	yes		dbo.[RECORDTYPE].[NAME]
SMARTFIELDLASTRUNON	datetime	yes		dbo.[SMARTFIELD].[LASTRUNON]
SMARTFIELDFORREPORTING	bit	yes		This field is true when there is a row in dbo.[OLAPDATASOURCESMARTFIELD] with a matching [SMARTFIELDID] for this data mart.
SMARTFIELDHASVALUEGROUP	bit	yes		dbo.[SMARTFIELD].[USEVALUEGROUP]
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_DIM_SMARTFIELD	SMARTFIELDDIMID	yes	yes	yes