Table: AttributeValueHistorical

Database schema and system attributes for AttributeValueHistorical.

---

AttributeValueId

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

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

CurrentRowIndicator

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

EffectiveDateTime

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

ExpireDateTime

• Required Property: true
• 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

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

Value

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

ValueAsBoolean

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

ValueAsDateTime

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

ValueAsNumeric

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

ValueAsPersonId

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

ValueFormatted

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