Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 FULLNAMEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the full name in the source system.
 FIRSTNAMEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the first name in the source system.
 MIDDLENAMEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the middle name in the source system.
 LASTNAMEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the last name in the source system.
 TITLEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the title in the source system.
 SUFFIXFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the suffix in the source system.
 COUNTRYFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the country in the source system.
 ADDRESSLINE1FIELD nvarchar(255)   Default = '' The field name from the record source that maps to the address line 1 in the source system.
 ADDRESSLINE2FIELD nvarchar(255)   Default = '' The field name from the record source that maps to the address line 2 in the source system.
 CITYFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the city in the source system.
 STATEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the state in the source system.
 POSTCODEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the zip in the source system.
 CARTFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the carrier route in the source system.
 DPCFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the DPC in the source system.
 LOTFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the lot number in the source system.
 PHONENUMBERFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the phone number in the source system.
 EMAILADDRESSFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the email address in the source system.
 FIRSTGIFTDATEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the first gift date 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.
 ADDRESSLINE3FIELD nvarchar(255)   Default = '' The field name from the record source that maps to the address line 3 in the source system.
 ADDRESSLINE4FIELD nvarchar(255)   Default = '' The field name from the record source that maps to the address line 4 in the source system.
 ADDRESSLINE5FIELD nvarchar(255)   Default = '' The field name from the record source that maps to the address line 5 in the source system.
 HOUSEHOLDIDFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the household ID in the source system.
 HEADOFHOUSEHOLDFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the head of household in the source system.
 DATELASTCHANGEDFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the date last changed for the donor record in the source system.
 ADDRESSEEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the addressee in the source system.
 SALUTATIONFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the salutation in the source system.
 ORGNAMEFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the organization name in the source system.
 ISHOUSEHOLDFIELD nvarchar(255)   Default = '' The field name from the record source that maps to the is household field in the source system.
 TITLE2FIELD nvarchar(255)   Default = '' The field name from the record source that maps to the title2 in the source system.
 SUFFIX2FIELD nvarchar(255)   Default = '' The field name from the record source that maps to the suffix2 in the source system.
 LOOKUPIDFIELD nvarchar(255)   Default = ''

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   MKTRECORDSOURCE.ID Primary Key.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_MKTRECORDSOURCEFIELDMAPPINGS_DATEADDED DATEADDED    
 IX_MKTRECORDSOURCEFIELDMAPPINGS_DATECHANGED DATECHANGED      
 PK_MKTRECORDSOURCEFIELDMAPPINGS ID  

Trigger Name Description
 TR_MKTRECORDSOURCEFIELDMAPPINGS_AUDIT_UPDATE
 TR_MKTRECORDSOURCEFIELDMAPPINGS_AUDIT_DELETE

Entity-Relationship diagram of this table