WF_APP_GLB_SETTINGS

Description

Contains information about the global and application level access tokens.

Columns

For the descriptions in this table, the term item refers to a global or application level access token.

Column Name Data Type Size Description
IDvarchar32(Primary key) The unique item ID.
APP_NAMEnvarchar256 The internal name of the application. The value can be the name of a global access token or an application.
KEY_nvarchar64 A free text unique name of the item.
DESCRIPTIONnvarchar1023A free text description of the item.
DATA_TYPEvarchar 128 A string with the literal name of an external system, such as SharePoint, Salesforce, Database, or Active Directory, with which the item connects.
ENCYPTEDvarchar3 Stores the item information in the AgilePoint workflow database as encrypted data.
RENEW_RATEint 4 The rate at which the access token gets renewed.
  • Every 15 minutes
  • Every 30 minutes
  • Every hour
  • Every 2 hours
  • Every 4 hours
  • Every 6 hours
  • Every 8 hours
  • Every half day
  • Once a day at midnight
  • Once a day at noon
  • Every other day at midnight
  • Every Sunday at midnight
VALUEntext 16 Stores the configuration data associated with the item.
LAST_MODIFIED_DATE datetime8 The date the item was last modified.
LAST_MODIFIED_BY nvarchar64 The user who last updated, or modified, the item.
RESCHEDULEDvarchar3 The execution status of the item.
  • Yes - The item is executed.
  • No - The item is not executed.
CREATED_DATEdatetime8 The date the item was created.
CREATED_BYnvarchar64 The user who created the item.

Relationships

Table Name Relationship
NoneNot Applicable