Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(200)   Default = ''
 DESCRIPTION nvarchar(1000)   Default = ''
 EXPORTDEFINITIONXML xml   Xml field containing the entire export definition structure, including all output fields and criteria.
 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.
 LOCKFIELDS bit   Default = 0
 ISSYSTEM bit   Default = 0 Flag for hiding export definitions meant for system use only.
 USEFIELDNAMESFORONETOONECOLUMNHEADERS bit   Default = 0 Flag used to force export to use just the field name for column headers for fields and nodes with a one to one relationship with the root node. Allows for backwards compatibility for marketing export definitions.
 USESHORTCOLUMNHEADERS bit   Default = 1 Flag used to indicate that abbreviations should be used when building column header prefixes when possible.
 OUTPUTCOLUMNMETADATA xml

Foreign Key Field Type Null Notes Description
 RECORDTYPEID uniqueidentifier   RECORDTYPE.ID FK to RECORDTYPE
 SITEID uniqueidentifier SITE.ID FK to SITE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 VIEWDATAFORMTEMPLATEID uniqueidentifier DATAFORMTEMPLATECATALOG.ID FK to DATAFORMTEMPLATECATALOG
 QUERYVIEWCATALOGID uniqueidentifier QUERYVIEWCATALOG.ID FK to QUERYVIEWCATALOG

Index Name Field(s) Unique Primary Clustered
 IX_EXPORTDEFINITION_DATEADDED DATEADDED    
 IX_EXPORTDEFINITION_DATECHANGED DATECHANGED      
 IX_EXPORTDEFINITION_RECORDTYPEID RECORDTYPEID      
 IX_EXPORTDEFINITION_SITEID SITEID      
 IX_EXPORTDEFINITION_VIEWDATAFORMTEMPLATEID VIEWDATAFORMTEMPLATEID      
 PK_EXPORTDEFINITION ID  

Trigger Name Description
 TR_EXPORTDEFINITION_AUDIT_UPDATE
 TR_EXPORTDEFINITION_AUDIT_DELETE

Referenced by Field
 APPEALMAILINGSETUP MAILEXPORTDEFINITIONID
 APPEALMAILINGSETUP EMAILEXPORTDEFINITIONID
 CORRESPONDENCEPROCESS EXPORTDEFINITIONID
 CREDITCARDPROCESSING PERMANENTREJECTIONEXPORTDEFINITIONID
 EmailTemplate EXPORTDEFINITIONID
 EXPORTPROCESS EXPORTDEFINITIONID
 LETTERCODE EXPORTDEFINITIONID
 LETTERTEMPLATE EXPORTDEFINITIONID
 MKTACKNOWLEDGEMENTMAILINGTEMPLATEEXPORT MAILEXPORTDEFINITIONID
 MKTACKNOWLEDGEMENTMAILINGTEMPLATEEXPORT EMAILEXPORTDEFINITIONID
 MKTEXPORTDEFINITION EXPORTDEFINITIONID
 MKTMEMBERSHIPMAILINGTEMPLATEEXPORT MAILEXPORTDEFINITIONID
 MKTMEMBERSHIPMAILINGTEMPLATEEXPORT EMAILEXPORTDEFINITIONID
 MKTMEMBERSHIPMAILINGTEMPLATEEXPORT PHONEEXPORTDEFINITIONID
 MKTPACKAGE EXPORTDEFINITIONID
 MKTSEGMENTATIONEXPORTPROCESS MAILEXPORTDEFINITIONID
 MKTSEGMENTATIONEXPORTPROCESS EMAILEXPORTDEFINITIONID
 MKTSEGMENTATIONEXPORTPROCESS PHONEEXPORTDEFINITIONID
 MKTSEGMENTATIONEXPORTPROCESS INLINEEXCLUSIONEXPORTDEFINITIONID
 MKTSEGMENTATIONEXPORTPROCESS2 MAILEXPORTDEFINITIONID
 MKTSEGMENTATIONEXPORTPROCESS2 EMAILEXPORTDEFINITIONID
 MKTSEGMENTATIONEXPORTPROCESS2 PHONEEXPORTDEFINITIONID
 MKTSPONSORSHIPMAILINGTEMPLATEEXPORT MAILEXPORTDEFINITIONID
 MKTSPONSORSHIPMAILINGTEMPLATEEXPORT EMAILEXPORTDEFINITIONID
 MKTSPONSORSHIPMAILINGTEMPLATEEXPORT PHONEEXPORTDEFINITIONID
 PLANNEDGIFTLETTERCODE EXPORTDEFINITIONID
 PLEDGEREMINDERPROCESS EXPORTDEFINITIONID
 RECEIPTINGPROCESS EXPORTDEFINITIONID
 REMINDEROPTION EXPORTDEFINITIONID
 SIMPLEACKNOWLEDGEMENT EXPORTDEFINITIONID
 TRIBUTELETTERCODE EXPORTDEFINITIONID

Entity-Relationship diagram of this table (APPEALMAILINGSETUP-RECEIPTINGPROCESS)
Entity-Relationship diagram of this table (RECORDTYPE-TRIBUTELETTERCODE)