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