| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 NAME |
nvarchar(100) | Default = '' | A unique name for the export definition. | |
| 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. |
| POSTALEXPORT |
bit | Default = 0 | Whether or not to do a postal export using Satori. | |
| MAILINGTYPECODE |
tinyint | Default = 0 | The marketing effort type with which this export definition is compatible. | |
| NETCOMMUNITYDATASOURCEID |
int | Default = 0 | The ID NetCommunity data source to which this export definition is tied. | |
| CHANGEDBYCULTURE |
nvarchar(30) | Default = '' | The culture that last saved the export definition. | |
| ISSYSTEM |
bit | Default = 0 | Flag for hiding export definitions meant for system use only. | |
| MAILINGTYPE |
nvarchar(25) (Computed) | |
CASE [MAILINGTYPECODE] WHEN 0 THEN N'Direct marketing' WHEN 1 THEN N'Marketing acknowledgement' WHEN 2 THEN N'Membership' WHEN 3 THEN N'Sponsorship' WHEN 5 THEN N'Communication revenue' END |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 PREVIEWDATALISTCATALOGID |
uniqueidentifier | |
DATALISTCATALOG.ID | The datalist ID used for previewing the export definition. |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| POSTALTEMPLATEID |
uniqueidentifier | |
MKTPOSTALTEMPLATE.ID | The postal template to use during a postal export of a marketing effort. |
| EXPORTDEFINITIONID |
uniqueidentifier | |
EXPORTDEFINITION.ID | The export definition to which these marketing-specific properties apply. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_MKTEXPORTDEFINITION_DATEADDED |
DATEADDED | |
||
 IX_MKTEXPORTDEFINITION_DATECHANGED |
DATECHANGED | |||
| IX_MKTEXPORTDEFINITION_NETCOMMUNITYDATASOURCEID |
NETCOMMUNITYDATASOURCEID | |||
| IX_MKTEXPORTDEFINITION_POSTALTEMPLATEID |
POSTALTEMPLATEID | |||
| PK_MKTEXPORTDEFINITION |
ID | |
|
|
| UC_MKTEXPORTDEFINITION_NAME |
NAME | |
||
| UIX_MKTEXPORTDEFINITION_EXPORTDEFINITIONID |
EXPORTDEFINITIONID | |
||
| UIX_MKTEXPORTDEFINITION_PREVIEWDATALISTCATALOGID |
PREVIEWDATALISTCATALOGID | |
| Trigger Name | Description |
|---|---|
 TR_MKTEXPORTDEFINITION_AUDIT_UPDATE |
|
| TR_MKTEXPORTDEFINITION_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 MKTEXPORTDEFINITIONOUTPUTFIELD |
EXPORTDEFINITIONID |