Application Tables

Application Tables are a special category of data table available to each PagerDuty Workflow Automation team. An Application Table is a read-only table that collects and stores helpful information that can be used in automation.

The Process Template Application Table will automatically collect and store basic information about every process on your team. Including Process ID, name, category, owner, created date, and other general information about each process template.

The User Application Table will automatically collect and store basic information about your team’s Users, such as user name, name, last login date, status, and other general information about each user.

Examples of use

Application Tables are helpful references. They are read-only and are most useful when manipulated with Table actions to filter, sort, and create conditions based on the fields. Application Tables are a high level view where critical information is stored all in one place.

For example, you could automate switching owners of processes using the Process Template Application Table:

• If someone switches roles in a company, filter the application table for processes they own and use the Workflow: Update a process template action to change the old owner to another user.

As another example, you could automate user account management using the User Application Table:

• Filter your users for people that haven’t logged in for more than 3 months and automatically send an email with a reminder that their account may be deactivated.

How to access each Application Table

Every data table you create or have shared with you is tracked and listed on the data tables screen, accessible from the Data section of the menu on the top navigation bar. Application Tables will start with “Application Table:”, like for example, “Application Table: Process Templates”

You can also search for a specific Application Table. Select in the top right corner of any screen to start a search. A global search will search within your entire PagerDuty Workflow Automation team. Search for “Application Table” to look for these tables across your team.

Description of Application Table fields

The Application Tables are preloaded with a bunch of helpful data on each Workflow and user. See a description of each field from the Application Tables below.

Process Templates

Table Field	Field Description
Process ID	The ID for the Workflow. The ID can be used when referencing a Workflow by table, field, or ID.
Process Name	The process name is the unique name for the Workflow. Two Workflows can have the same display names, but process names are always unique.
Display Name	The Workflow’s name. This is the name that displays when browsing Workflows.
Category	The Workflow’s category.
Owner	The Workflow’s owner.
Created By	The username of whoever created the Workflow.
Created Date	The date the Workflow was created.
Archived	Whether the Workflow is archived. True or False.
Public	Whether the Workflow is public. True or False.
Manually Startable	Whether the Workflow can be started manually. True or False.
Duration After Completion to Delete Instances	For a given Workflow, how long after an instance completes that the instance data is deleted. See the data retention article to learn more about deleting instance data.
Root Workflow ID	If this Workflow is a draft of another, then the Root Workflow ID is the published Workflow that this is a draft of.
Published Date	The date the Worflow was last published.
Is Current Published Version	Whether the Workflow is the current published version, as opposed to being a draft version. True or False.
Default Field Permissions	Whether field permissions are enabled for new fields added to the Workflow. True or False.
Users with field access by default	A comma separated list of users with access to field data by default. Only appies when default field permissions are “confidential” or higher.
Run Permissions	Whether run instances are visible or restricted by default. open or restricted.
Users who can find and start this Workflow	A comma separated list of users who can find and start this Workflow.
Users who can edit, find, and start this Workflow	A comma separated list of users who can edit, find, or start this Workflow.
Last Start Date	Date this Workflow last ran.
Last Modified Date	Date this Workflow was last edited.
Last Modified By	The user who last modified this Workflow.

Users

Table Field	Field Description
User ID	The user’s ID. The ID is unique to a user.
Team Name	The user’s team name.
Username	The username is retired throughout PagerDuty Workflow Automation—the full name is now used as a username.
Email	The user’s email address. This is set during account creation.
Phone	The user’s phone number, if supplied.
Slack Username	The user’s Slack username, if supplied.
Created Date	The date the user was created.
Full Name	The user’s full name. This is set during account creation.
Experience	What version of PagerDuty Workflow Automation the user has enabled. Either beta or stable
Team Owner	Whether the user is the team owner. True or False.
Team Admin	Whether the user is the team admin. True or False.
Deactivated	Whether the user has been deactivated. True or False.
Locked Out	Whether the user is locked out. True or False.
Last Login Date	The date the user last logged in.
Last Login IP Address	The IP address of the last login.
User External ID	Used for SSO and SCIM user provisioning. Represents the UID that’s passed to your IdP.
Building Allowed	Whether the user has building permissions. True or False.

Groups

Table Field	Field Description
Group ID	The ID for the group.
Group Name	The name of the group, commonly used when referencing groups in fields.
Display Name	The display name of the group, or how it appears across PagerDuty Workflow Automation.
Team Owner	Will always be false for groups.
Team Admin	Will always be false for groups.
Archived	Whether the group has been archived. True or False.
Created By	The username of whoever created the group.
Created Date	The date the group was created.
Member Usernames	A comma separated list of all members of the group.
Building Allowed	Whether the group has building permissions. True or False.

Actions Completed per Workflow per Day

Table Field	Field Description
Process ID	The ID for the Workflow.
Date	The date in reference.
Number of Actions Completed	The number of actions completed for a given Workflow on a given day.

Instances Started per Workflow per Day

Table Field	Field Description
Process ID	The ID for the Workflow.
Date	The date in reference.
Number of Instances Started	The number of instances started for a given Workflow on a given day.

Triggers

Table Field	Field Description
Webhook ID	The ID for the trigger.
Webhook Name	The technical name of the trigger. Two triggers can have the same display name, but webhook names are always unique.
Display Name	The name of the trigger, used when referencing the trigger.
Process ID	The ID for the Workflow associated with the trigger.
Process Name	The process name of the Workflow associated with the trigger.
Process Display Name	The process display name of the Workflow associated with the trigger.
App ID	The technical name of the trigger type.
Integration User	For triggers that use connections, the technical name of the integration connection.
Public	Whether the trigger is public, or internal/confidential. True or False.
Created By	The username of whoever created the trigger.
Created Date	The date the trigger was created.

Integrations

Table Field	Field Description
Integration ID	The ID for the integration connection. Each connection is unique, even if they use the same integration app.
Integration Name	The technical name of the integration connection.
Connection Name	The name of the integration connection, used when referencing the connection. Two connections can have the same display name, but connection names are always unique.
Display Name	The name of the integration connection, used when referencing the connection.
Integration App	The app or service the connection is associated with.
Created By	The username of whoever created the connection.
Created Date	The date the connection was created.
Integration permissions	Whether the connection is open or restricted. Restricted connections can only be used by specified users.
Users with Permission	A comma separated list of all users with permission to use the connection.