Open topic with navigation

SMARTFIELD (4.0)

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Contains data describing smart field instances.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
TABLECATALOGID	uniqueidentifier	true	TABLECATALOG.ID	FK to TABLECATALOG
SMARTFIELDCATALOGID	uniqueidentifier	false	SMARTFIELDCATALOG.ID	Join field for the smart field definition.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
SOURCEQUERYVIEWCATALOGID	uniqueidentifier	true	QUERYVIEWCATALOG.ID	Join field for the queryview that is the source value queryview for this smart field.
CURRENCYID	uniqueidentifier	true	CURRENCY.ID	The currency associated with this smart field.

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)	false	''
SMARTFIELDDATAFORMITEM	xml	true		Stores the saved parameters for the smart field stored procedure.
VALUECOLUMNNAME	nvarchar(128)	false	''
USEVALUEGROUP	bit	false	0
LASTRUNON	datetime	true		Stores the date that the smart field was last updated. This value is used to filter records based on the record's DATECHANGED value.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
SYSTEMFIELD	bit	false	0	A flag to indicate if this is a field that is used by other parts of the system and cannot be modified or deleted.
DATEVALUEGROUPUNITCODE	tinyint	false	0	Stores the scale of value groups for date smart fields.
DATEVALUEGROUPUNIT	nvarchar(8) (Computed)	true		Provides a translation for the 'DATEVALUEGROUPUNITCODE' field.
SITEFILTERENABLEDFORINSTANCE	bit	false	0	Indicates whether this smart field should have site filtering applied for it.
DESCRIPTION	nvarchar(4000)	false	''

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_SMARTFIELD_CURRENCYID	CURRENCYID	False	False	False
IX_SMARTFIELD_DATEADDED	DATEADDED	False	False	True
IX_SMARTFIELD_DATECHANGED	DATECHANGED	False	False	False
IX_SMARTFIELD_SOURCEQUERYVIEWCATALOGID	SOURCEQUERYVIEWCATALOGID	False	False	False
PK_SMARTFIELD	ID	True	True	False
UIX_SMARTFIELD_SMARTFIELDCATALOGID_NAME	SMARTFIELDCATALOGID NAME	True	False	False
UIX_SMARTFIELD_TABLECATALOGID	TABLECATALOGID	True	False	False

Triggers
Trigger Name	Description
TR_SMARTFIELD_INSERT
TR_SMARTFIELD_UPDATE
TR_SMARTFIELD_AUDIT_UPDATE
TR_SMARTFIELD_AUDIT_DELETE
TR_SMARTFIELD_AUDIT_ETLDELETEDID

Referenced by
Referenced by	Field
GIVINGLEVELPROGRAM	SMARTFIELDID
MKTSOURCEANALYSISRULEFIELDS	SMARTFIELDID
OLAPDATASOURCESMARTFIELD	SMARTFIELDID
SMARTFIELDSITE	SMARTFIELDID
SMARTFIELDSTATUS	PARAMETERSETID
SMARTFIELDVALUEGROUP	SMARTFIELDID
SPONSORSHIPGREATESTNEEDRULESETREF	SMARTFIELDID