Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 APPEALSYSTEMIDFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the appeal system ID in the source system.
 APPEALIDFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the appeal ID in the source system.
 APPEALDESCRIPTIONFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the appeal description in the source system.
 AMOUNTFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the gift amount in the source system.
 DONORIDFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the donor ID in the source system.
 SOURCECODEFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the source code in the source system.
 MAILINGIDFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the effort ID in the source system.
 DATEFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the date field in the source system.
 FINDERNUMBERFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the finder number in the source system.
 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.
 DATEADDEDFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the date added field in the source system.
 DONOTACKNOWLEDGEFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the do not acknowledge field in the source system.
 DONOTRECEIPTFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the do not receipt field in the source system.
 DATECHANGEDFIELD nvarchar(255)   Default = '' The field name from the gift query view that maps to the date changed field in the source system.
 BASECURRENCYIDFIELD nvarchar(255)   Default = ''
 LOOKUPIDFIELD nvarchar(255)   Default = ''

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   MKTRECORDSOURCE.ID Primary Key.
 QUERYVIEWCATALOGID uniqueidentifier   QUERYVIEWCATALOG.ID The query view that contains gift record source information.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 MARKETINGINFOQUERYVIEWCATALOGID uniqueidentifier   QUERYVIEWCATALOG.ID The query view for displaying revenue marketing information.

Index Name Field(s) Unique Primary Clustered
 IX_MKTGIFTRECORDSOURCE_DATEADDED DATEADDED    
 IX_MKTGIFTRECORDSOURCE_DATECHANGED DATECHANGED      
 PK_MKTGIFTRECORDSOURCE ID  
 UC_MKTGIFTRECORDSOURCE_MARKETINGINFOQUERYVIEWCATALOGID MARKETINGINFOQUERYVIEWCATALOGID    

Trigger Name Description
 TR_MKTGIFTRECORDSOURCE_AUDIT_UPDATE
 TR_MKTGIFTRECORDSOURCE_AUDIT_DELETE

Entity-Relationship diagram of this table