Table: FinancialTransactionAlert

Database schema and system attributes for FinancialTransactionAlert.

---

AlertDateKey

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AlertDateTime

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

AlertTypeId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

Amount

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: decimal
• Property Values:
  • MaxLength = 9

AmountCurrentIqr

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: decimal
• Property Values:
  • MaxLength = 9

AmountCurrentMedian

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: decimal
• Property Values:
  • MaxLength = 9

AmountIqrMultiplier

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: decimal
• Property Values:
  • MaxLength = 5

CreatedByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CreatedDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

ForeignGuid

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

ForeignId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ForeignKey

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 200

FrequencyCurrentMean

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: decimal
• Property Values:
  • MaxLength = 5

FrequencyCurrentStandardDeviation

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: decimal
• Property Values:
  • MaxLength = 5

FrequencyDifferenceFromMean

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: decimal
• Property Values:
  • MaxLength = 5

FrequencyZScore

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: decimal
• Property Values:
  • MaxLength = 5

GivingId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 100

Guid

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

Id

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ModifiedByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ModifiedDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

PersonAliasId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ReasonsKey

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 5000

TransactionId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4