Table: WorkflowActivity

Database schema and system attributes for WorkflowActivity.

ActivatedByActivityId

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

ActivatedDateTime

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

ActivityTypeId

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

AssignedGroupId

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

AssignedPersonAliasId

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

CompletedDateTime

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

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

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

LastProcessedDateTime

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

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

WorkflowId

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

ApprovalStatus

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The status of the appoval (Approve,Deny)
  • Property Values:
    • ispassword = False

ApprovalStatus

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The status of the appoval (Approve,Deny)
  • Property Values:
    • ispassword = False

Approver

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Person
  • Description: Person who approved or denied this request

Approver

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Person
  • Description: Person who approved or denied this request

Note

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Memo
  • Description: Any notes that approver wants to provide to submitter for review
  • Property Values:
    • numberofrows = 5

Note

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Memo
  • Description: Any notes that approver wants to provide to submitter for review
  • Property Values:
    • numberofrows = 5

PersonEmailValid

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: Used to indicate if a person has a valid and active email before executing a background check.

PersonEmailValid

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: Used to indicate if a person has a valid and active email before executing a background check.

ReviewResult

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The result of the review (Pass,Fail)
  • Property Values:
    • ispassword = False

ReviewResult

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The result of the review (Pass,Fail)
  • Property Values:
    • ispassword = False

SelectedAction

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The action that was selected by user

SelectedAction

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The action that was selected by user

SelectedAction

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The action that was selected by user