Information for the FinancialTransactionAlertType

Columns

• Id (datatype: int) Required Primary Key
• Name (datatype: nvarchar(250)) Required Primary Key
• CampusId (datatype: int) Required Primary Key
• AlertType (datatype: int) Required Primary Key
• ContinueIfMatched (datatype: bit) Required Primary Key
• RepeatPreventionDuration (datatype: int) Required Primary Key
• FrequencySensitivityScale (datatype: decimal(6, 1)) Required Primary Key
• AmountSensitivityScale (datatype: decimal(6, 2)) Required Primary Key
• MinimumGiftAmount (datatype: decimal(18, 2)) Required Primary Key
• MaximumGiftAmount (datatype: decimal(18, 2)) Required Primary Key
• MinimumMedianGiftAmount (datatype: decimal(18, 2)) Required Primary Key
• MaximumMedianGiftAmount (datatype: decimal(18, 2)) Required Primary Key
• DataViewId (datatype: int) Required Primary Key
• WorkflowTypeId (datatype: int) Required Primary Key
• ConnectionOpportunityId (datatype: int) Required Primary Key
• SystemCommunicationId (datatype: int) Required Primary Key
• SendBusEvent (datatype: bit) 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
• Order (datatype: int) Required Primary Key
• MaximumDaysSinceLastGift (datatype: int) Required Primary Key
• RunDays (datatype: int) Required Primary Key
• AlertSummaryNotificationGroupId (datatype: int) Required Primary Key
• FinancialAccountId (datatype: int) Required Primary Key
• IncludeChildFinancialAccounts (datatype: bit) Required Primary Key
• AccountParticipantSystemCommunicationId (datatype: int) Required Primary Key