Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TRANSACTIONSEQUENCE smallint   Default = ((0)) For ordering the transactions for a commitment.
 ACTIONCODE tinyint   Default = 0 The action taken for this transaction.
 TRANSACTIONDATE date The date on which this transaction occurred.
 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.
 ACTION nvarchar(24) (Computed) CASE [ACTIONCODE] WHEN 0 THEN N'Add' WHEN 1 THEN N'Transfer' WHEN 2 THEN N'Cancel' WHEN 3 THEN N'Terminate' WHEN 4 THEN N'Reactivate' WHEN 5 THEN N'Reassign' WHEN 6 THEN N'Initiate transfer' WHEN 7 THEN N'Override transfer' WHEN 8 THEN N'Complete transfer' WHEN 9 THEN N'Change financial sponsor' END Provides a translation for the 'ACTIONCODE' field.

Foreign Key Field Type Null Notes Description
 SPONSORSHIPCOMMITMENTID uniqueidentifier   SPONSORSHIPCOMMITMENT.ID The commitment for this transaction.
 SPONSORSHIPREASONID uniqueidentifier SPONSORSHIPREASON.ID The reason for this transaction.
 CONTEXTSPONSORSHIPID uniqueidentifier SPONSORSHIP.ID The sponsorship in whose context the action is being performed.
 TARGETSPONSORSHIPID uniqueidentifier SPONSORSHIP.ID Sponsorship created or activated by the action.
 DECLINEDSPONSORSHIPID uniqueidentifier SPONSORSHIP.ID Pending transfer that is being declined by an override or cancel.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 GIFTFINANCIALSPONSORID uniqueidentifier CONSTITUENT.LOCALID The financial sponsor on gift sponsorships.

Index Name Field(s) Unique Primary Clustered
 IX_SPONSORSHIPTRANSACTION_CONTEXTSPONSORSHIPID_TRANSACTIONSEQUENCE CONTEXTSPONSORSHIPID, TRANSACTIONSEQUENCE      
 IX_SPONSORSHIPTRANSACTION_DATEADDED DATEADDED    
 IX_SPONSORSHIPTRANSACTION_DATECHANGED DATECHANGED      
 IX_SPONSORSHIPTRANSACTION_GIFTFINANCIALSPONSORID GIFTFINANCIALSPONSORID      
 IX_SPONSORSHIPTRANSACTION_SPONSORSHIPREASONID SPONSORSHIPREASONID      
 IX_SPONSORSHIPTRANSACTION_TARGETSPONSORSHIPID_TRANSACTIONSEQUENCE TARGETSPONSORSHIPID, TRANSACTIONSEQUENCE      
 PK_SPONSORSHIPTRANSACTION ID  
 UIX_SPONSORSHIPTRANSACTION_DECLINEDSPONSORSHIPID DECLINEDSPONSORSHIPID    
 UIX_SPONSORSHIPTRANSACTION_SPONSORSHIPCOMMITMENTID_TRANSACTIONSEQUENCE SPONSORSHIPCOMMITMENTID, TRANSACTIONSEQUENCE    

Trigger Name Description
 TR_SPONSORSHIPTRANSACTION_AUDIT_UPDATE
 TR_SPONSORSHIPTRANSACTION_AUDIT_DELETE

Entity-Relationship diagram of this table