Information for the FinancialTransactionAlert

Columns

• Id (datatype: int) Required Primary Key
• TransactionId (datatype: int) Required Primary Key
• PersonAliasId (datatype: int) Required Primary Key
• GivingId (datatype: nvarchar(50)) Required Primary Key
• AlertTypeId (datatype: int) Required Primary Key
• Amount (datatype: decimal(18, 2)) Required Primary Key
• AmountCurrentMedian (datatype: decimal(18, 2)) Required Primary Key
• AmountCurrentIqr (datatype: decimal(18, 2)) Required Primary Key
• AmountIqrMultiplier (datatype: decimal(6, 1)) Required Primary Key
• FrequencyCurrentMean (datatype: decimal(6, 1)) Required Primary Key
• FrequencyCurrentStandardDeviation (datatype: decimal(6, 1)) Required Primary Key
• FrequencyDifferenceFromMean (datatype: decimal(6, 1)) Required Primary Key
• FrequencyZScore (datatype: decimal(6, 1)) Required Primary Key
• ReasonsKey (datatype: nvarchar(2500)) Required Primary Key
• AlertDateTime (datatype: datetime) Required Primary Key
• AlertDateKey (datatype: int) Required Primary Key
• CreatedDateTime (datatype: datetime) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• CreatedByPersonAliasId (datatype: int) Required Primary Key
• ModifiedByPersonAliasId (datatype: int) 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