Information for the AnalyticsSourceGivingUnit
Columns
Id
(datatype: int) Required Primary Key
GivingId
(datatype: nvarchar(20)) Required Primary Key
GivingLeaderPersonId
(datatype: int) Required Primary Key
GivingSalutation
(datatype: nvarchar(max)) Required Primary Key
GivingSalutationFull
(datatype: nvarchar(max)) Required Primary Key
GivingBin
(datatype: int) Required Primary Key
GivingPercentile
(datatype: int) Required Primary Key
GiftAmountMedian
(datatype: decimal(18, 2)) Required Primary Key
GiftAmountIqr
(datatype: decimal(18, 2)) Required Primary Key
GiftFrequencyMean
(datatype: decimal(18, 2)) Required Primary Key
GiftFrequencyStandardDeviation
(datatype: decimal(18, 2)) Required Primary Key
PercentGiftsScheduled
(datatype: int) Required Primary Key
Frequency
(datatype: nvarchar(250)) Required Primary Key
PreferredCurrencyValueId
(datatype: int) Required Primary Key
PreferredCurrency
(datatype: nvarchar(250)) Required Primary Key
PreferredSourceValueId
(datatype: int) Required Primary Key
PreferredSource
(datatype: nvarchar(250)) Required Primary Key
Guid
(datatype: uniqueidentifier) Required Primary Key
ForeignId
(datatype: int) Required Primary Key
ForeignGuid
(datatype: uniqueidentifier) Required Primary Key
ForeignKey
(datatype: nvarchar(100)) Required Primary Key