Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 AMOUNT money   Default = 0 The amount for given revenue detail split.
 TYPECODE tinyint   Default = 0 The type of revenue split.
 TYPE nvarchar(25) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Gift' WHEN 1 THEN N'Event registration' WHEN 2 THEN N'Membership' WHEN 3 THEN N'Grant award' WHEN 4 THEN N'Other' WHEN 5 THEN N'Ticket' WHEN 6 THEN N'Fee' WHEN 7 THEN N'Tax' WHEN 8 THEN N'Miscellaneous' WHEN 9 THEN N'Sponsorship' WHEN 10 THEN N'Supply/Equipment Resource' WHEN 11 THEN N'Staffing Resource' END Provides a translation for the 'TYPECODE' field.
 APPLICATIONCODE tinyint   Default = 0 What the revenue item is applied to.
 APPLICATION nvarchar(18) (Computed) CASE [APPLICATIONCODE] WHEN 0 THEN N'Donation' WHEN 1 THEN N'Event registration' WHEN 2 THEN N'Pledge' WHEN 3 THEN N'Recurring gift' WHEN 4 THEN N'Other' WHEN 5 THEN N'Membership' WHEN 6 THEN N'Planned gift' WHEN 7 THEN N'Matching gift' WHEN 8 THEN N'Grant award' WHEN 9 THEN N'Admission' WHEN 10 THEN N'Order' WHEN 11 THEN N'Miscellaneous' END Provides a translation for the 'APPLICATIONCODE' field.
 DESCRIPTION nvarchar(700) (Computed) dbo.UFN_REVENUESPLIT_GETDESCRIPTION(ID) Provides a translation field for the revenue split
 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.
 ORGANIZATIONAMOUNT money   Default = 0 The amount of the revenue split in organization currency.
 TRANSACTIONAMOUNT money   Default = 0 The amount of the revenue split in transaction currency.

Foreign Key Field Type Null Notes Description
 REVENUEID uniqueidentifier   REVENUE.LOCALID FK to REVENUE table.
 DESIGNATIONID uniqueidentifier DESIGNATION.ID FK to DESIGNATION table.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this revenue split.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the organization amount.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this revenue split.
 BASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the base amount.

Index Name Field(s) Unique Primary Clustered
 IX_PLANNEDGIFTPAYOUTSPLIT_BASECURRENCYID BASECURRENCYID      
 IX_PLANNEDGIFTPAYOUTSPLIT_BASEEXCHANGERATEID BASEEXCHANGERATEID      
 IX_PLANNEDGIFTPAYOUTSPLIT_DATEADDED DATEADDED    
 IX_PLANNEDGIFTPAYOUTSPLIT_DATECHANGED DATECHANGED      
 IX_PLANNEDGIFTPAYOUTSPLIT_DESIGNATIONID DESIGNATIONID      
 IX_PLANNEDGIFTPAYOUTSPLIT_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 IX_PLANNEDGIFTPAYOUTSPLIT_REVENUEID REVENUEID      
 IX_PLANNEDGIFTPAYOUTSPLIT_TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID      
 PK_PLANNEDGIFTPAYOUTSPLIT ID  

Trigger Name Description
 TR_PLANNEDGIFTPAYOUTSPLIT_INSERTUPDATE_CURRENCY
 TR_PLANNEDGIFTPAYOUTSPLIT_AUDIT_UPDATE
 TR_PLANNEDGIFTPAYOUTSPLIT_AUDIT_DELETE

Entity-Relationship diagram of this table