Table: WorkflowActionType

Database schema and system attributes for WorkflowActionType.

ActivityTypeId

  • 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

CriteriaAttributeGuid

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

CriteriaComparisonType

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

CriteriaValue

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

EntityTypeId

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

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

IsActionCompletedIfCriteriaUnmet

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

IsActionCompletedOnSuccess

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

IsActivityCompletedOnSuccess

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

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

Name

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

Order

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

WorkflowFormId

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

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Active

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Should Service be used?

Activity

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Activity
  • Description: The activity type to activate

AssessmentTypesKey

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The attribute that contains the selected list of assessments being requested.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.AssessmentTypesFieldType

Attribute

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The person attribute to set the value of.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.PersonFieldType

Attribute

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The attribute to set the value of.

Attribute

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The attribute to set the value of.

Attribute

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The person or group attribute value to assign this activity to.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.PersonFieldType|Rock.Field.Types.GroupFieldType

AttributeValue

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Text Or Attribute
  • Description: The text or attribute to set the value from.

BCC

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Text Or Attribute
  • Description: The email addresses or an attribute that contains the person, email address, group or security role that the email should be BCC'd (blind carbon copied) to. Any address in this field will be copied on the email sent to every recipient.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.TextFieldType|Rock.Field.Types.EmailFieldType|Rock.Field.Types.PersonFieldType|Rock.Field.Types.GroupFieldType|Rock.Field.Types.SecurityRoleFieldType

Body

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Code Editor
  • Description: The body of the email that should be sent.
  • Property Values:
    • editorHeight = 200
    • editorMode = Html

Campus

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: Workflow attribute that contains the Campus to get the Campus team member for. If both Person and Campus are provided, Campus takes precedence over the Person's Campus. If Campus is not provided, the Person's primary Campus will be assigned to this attribute.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.CampusFieldType

CampusRole

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: Workflow attribute that contains the Role of the Campus team member to get. If multiple team members are in this role for a given Campus, the first match will be selected.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.GroupRoleFieldType

CampusTeamMember

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: Workflow attribute to assign the Campus team member to.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.PersonFieldType

CC

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Text Or Attribute
  • Description: The email addresses or an attribute that contains the person, email address, group or security role that the email should be CC'd (carbon copied) to. Any address in this field will be copied on the email sent to every recipient.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.TextFieldType|Rock.Field.Types.EmailFieldType|Rock.Field.Types.PersonFieldType|Rock.Field.Types.GroupFieldType|Rock.Field.Types.SecurityRoleFieldType

DueDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The attribute that contains the Due Date (if any) for the requests.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.DateFieldType

EnableSavingLabelData

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if the label data should be temporarily saved on the attendance record. Select 'No' to disable saving label data.

From

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Text Or Attribute
  • Description: The email address or an attribute that contains the person or email address that email should be sent from (will default to organization email).
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.TextFieldType|Rock.Field.Types.EmailFieldType|Rock.Field.Types.PersonFieldType

Group

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The attribute containing the group whose attribute will be set.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.GroupFieldType

GroupAttributeKey

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The attribute key to use for the group attribute.

LoadAll

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: By default groups are only loaded for the selected person, group type, and location. Select this option to load groups for all the loaded people and group types.

LoadAll

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: By default locations are only loaded for the selected person and group type. Select this option to load locations for all the loaded people and group types.

LoadAll

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: By default schedules are only loaded for the selected person, group type, location, and group. Select this option to load schedules for all the loaded people, group types, locations, and groups.

NameValue

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Text Or Attribute
  • Description: The value to use for the workflow's name.

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Order

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The order that this service should be used (priority)

Person

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Person
  • Description: The person to set attribute value to. Leave blank to set person to nobody.

Person

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The attribute containing the person being requested to take the assessment(s).
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.PersonFieldType

Person

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: Workflow attribute that contains the person to get the Campus team member for.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.PersonFieldType

Person

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Person
  • Description: The person to assign this activity to.

PersonAttribute

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The attribute to set to the currently logged in person.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.TextFieldType|Rock.Field.Types.PersonFieldType

Provider

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Component
  • Description: The Background Check provider to use
  • Property Values:
    • container = Rock.Security.BackgroundCheckContainer, Rock

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if schedules should be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if locations should be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if groups should be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if groups should be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if locations should be be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if groups should be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if groups should be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if locations should be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if group types should be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if group types should be removed. Select 'No' if they should just be marked as excluded.

Remove

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Select 'Yes' if groups should be removed. Select 'No' if they should just be marked as excluded.

RequestedBy

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: The attribute containing the person requesting the test be taken.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.PersonFieldType

ResultAttribute

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Attribute
  • Description: An optional attribute to set to the scalar result of SQL query.

SQLQuery

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Code Editor
  • Description: The SQL query to run.
  • Property Values:
    • editorHeight = 400
    • editorMode = Sql

Subject

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The subject that should be used when sending email.

To

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Text Or Attribute
  • Description: The email addresses or an attribute that contains the person, email address, group or security role that the email should be sent to.
  • Property Values:
    • attributefieldtypes = Rock.Field.Types.TextFieldType|Rock.Field.Types.EmailFieldType|Rock.Field.Types.PersonFieldType|Rock.Field.Types.GroupFieldType|Rock.Field.Types.SecurityRoleFieldType

UseId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Most entity attribute field types expect the Guid of the entity (which is used by default). Select this option if the entity's Id should be used instead (should be rare).

Value

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Workflow Text Or Attribute
  • Description: The text or attribute to set the value from.