Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SPONSORSHIPSYSTEMIDFIELD nvarchar(255)   Default = '' The field name from the sponsorship query view that maps to the sponsorship system ID in the source system.
 SPONSORIDFIELD nvarchar(255)   Default = '' The field name from the sponsorship query view that maps to the sponsor 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.
 ACTIONFIELD nvarchar(255)   Default = '' The field name from the sponsorship query view that maps to the last action of a sponsorship in the source system.
 REASONFIELD nvarchar(255)   Default = '' The field name from the sponsorship query view that maps to the reason of the last action of a sponsorship in the source system.
 GIFTSPONSORSHIPFIELD nvarchar(255)   Default = '' The field name from the sponsorship query view that maps to a flag for gift sponsorship in the source system.
 SPONSORSHIPOPPORTUNITYIDCHILDFIELD nvarchar(255)   Default = '' The field name from the sponsorship query that maps to the sponsorship's child id in the source system.
 SPONSORSHIPOPPORTUNITYIDPROJECTFIELD nvarchar(255)   Default = '' The field name from the sponsorship query that maps to the sponsorship's project id in the source system.
 SPONSORSHIPCHILDPROGRAMIDFIELD nvarchar(255)   Default = '' The field name from the sponsorship query that maps to the sponsorship's child program id in the source system.
 SPONSORSHIPPROJECTPROGRAMIDFIELD nvarchar(255)   Default = '' The field name from the sponsorship query that maps to the sponsorship's project program id in the source system.
 SPONSORSHIPLOCATIONIDFIELD nvarchar(255)   Default = '' The field name from the sponsorship query that maps to the sponsorship opportunity's location id in the source system.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   MKTRECORDSOURCE.ID Primary Key.
 QUERYVIEWCATALOGID uniqueidentifier   QUERYVIEWCATALOG.ID The query view that contains sponsorship 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_MKTSPONSORSHIPRECORDSOURCE_DATEADDED DATEADDED    
 IX_MKTSPONSORSHIPRECORDSOURCE_DATECHANGED DATECHANGED      
 PK_MKTSPONSORSHIPRECORDSOURCE ID  

Trigger Name Description
 TR_MKTSPONSORSHIPRECORDSOURCE_AUDIT_UPDATE
 TR_MKTSPONSORSHIPRECORDSOURCE_AUDIT_DELETE

Entity-Relationship diagram of this table