| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 NAME |
nvarchar(255) | Default = '' | A friendly name for the field. | |
| QUERYFIELD |
nvarchar(255) | Default = '' | The field name of this field from the query view. | |
| SEQUENCE |
int | Default = 0 | The sequence of the field. | |
| ISACTIVE |
bit | Default = 1 | Flag to determine if the field is actively being used in source analysis rules. | |
| PURPOSE |
nvarchar(255) | Default = '' | A definitive reason why this field should be part of the source analysis rule. | |
| ISCUSTOM |
bit | Default = 1 | A value of True means this is a field added by the user and is not a system field. | |
| DBOBJECTNAME |
nvarchar(255) | Default = '' | The name of the query view that displays this field. | |
| DATEADDED |
datetime | Default = getdate() | Indicates the date this record was added. | |
| DATECHANGED |
datetime | Default = getdate() | Indicates the date this record was last changed. | |
| TS |
timestamp | Timestamp. | ||
 TSLONG |
bigint (Computed) |  |
CONVERT(bigint, TS) | Numeric representation of the timestamp. |
| VIEWPATH |
nvarchar(4000) | Default = '' | Holds the view path to this field. | |
| CACHETABLECOLUMNNAME |
nvarchar(255) | Default = '' | Holds the name of the column in the data cache table that corresponds to this field. | |
| ISIDSET |
bit | Default = 0 | Identifies this field as coming from an IDSET, possibly an ADHOC query or a marketing segment. | |
| QUERYABLE |
bit | Default = 1 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 SOURCEANALYSISRULEID |
uniqueidentifier | MKTSOURCEANALYSISRULES.ID | The source analysis rule that this field applies to. | |
| QUERYVIEWCATALOGID |
uniqueidentifier | QUERYVIEWCATALOG.ID | The root query view this field is from. | |
| SMARTFIELDID |
uniqueidentifier | |
SMARTFIELD.ID | A foreign key to the smartfield that defines this field. |
| ADHOCQUERYID |
uniqueidentifier | |
ADHOCQUERY.ID | The ID of the selection that represents this field. |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_MKTSOURCEANALYSISRULEFIELDS_ADHOCQUERYID |
ADHOCQUERYID | |||
 IX_MKTSOURCEANALYSISRULEFIELDS_DATEADDED |
DATEADDED | |
||
| IX_MKTSOURCEANALYSISRULEFIELDS_DATECHANGED |
DATECHANGED | |||
| IX_MKTSOURCEANALYSISRULEFIELDS_QUERYVIEWCATALOGID |
QUERYVIEWCATALOGID | |||
| IX_MKTSOURCEANALYSISRULEFIELDS_SMARTFIELDID |
SMARTFIELDID | |||
| IX_MKTSOURCEANALYSISRULEFIELDS_SOURCEANALYSISRULEID |
SOURCEANALYSISRULEID | |||
| PK_MKTSOURCEANALYSISRULEFIELDS |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_MKTSOURCEANALYSISRULEFIELDS_AUDIT_UPDATE |
|
| TR_MKTSOURCEANALYSISRULEFIELDS_AUDIT_DELETE |