Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 MEMBERSHIPSYSTEMIDFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the membership system ID in the source system.
 MEMBERIDFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the member ID 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.
 GIVENBYIDFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the ID of the constituent who gave the membership in the source system.
 EXPIRATIONDATEFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the membership's expiration date in the source system.
 ISGIFTFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the field in the source system indicating whether the membership was a gift.
 JOINDATEFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the membership's join date in the source system.
 LASTRENEWEDONDATEFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the membership's last renewed date in the source system.
 LEVELFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the membership's level in the source system.
 PROGRAMFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the membership's program in the source system.
 SENDRENEWALFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the field in the source system indicating to whom renewal notices should be sent.
 STATUSFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the membership's status in the source system.
 TERMFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the membership's term in the source system.
 TYPEFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the membership's type in the source system.
 MEMBERFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the member's name in the source system.
 GIVENBYFIELD nvarchar(255)   Default = '' The field name from the membership query view that maps to the name of the constituent who gave the membership in the source system.
 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 membership record source information.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_MKTMEMBERSHIPRECORDSOURCE_DATEADDED DATEADDED    
 IX_MKTMEMBERSHIPRECORDSOURCE_DATECHANGED DATECHANGED      
 PK_MKTMEMBERSHIPRECORDSOURCE ID  

Trigger Name Description
 TR_MKTMEMBERSHIPRECORDSOURCE_AUDIT_UPDATE
 TR_MKTMEMBERSHIPRECORDSOURCE_AUDIT_DELETE

Entity-Relationship diagram of this table