WF_ANONYMOUS_ACCESS

Stores information about the tasks that are configured to be accessed by anonymous form users, called anonymous tasks.

Columns

Column Name Definition

ANONYMOUS_ACCESS_ID

Function:
A unique ID for the anonymous task.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
Yes
Foreign Key:
No

ANONYMOUS_ACCESS_NAME

Function:
A unique name for the anonymous task, used for internal reference.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ACCESS_TOKEN_KEY

Function:
A unique key of the access token associated with the anonymous task.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ACTIVITY_NAME

Function:
The name of the activity associated with the anonymous task.
Data Type:
nvarchar
Size:
64
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ANONYMOUS_ACCESS_EXPIRES_ON

Function:
The datetime the anonymous access token expires.
Data Type:
datetime
Size:
8
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ACCESS_TOKEN_APPNAME

Function:
Gets the AgilePoint ID details. When you create an anonymous access token, it is necessary to associate it with an AgilePoint ID access token. This AgilePoint ID access token is an item in WF_APP_GLB_SETTINGS table, along with the APP_NAME and KEY_ columns, which act as a primary key for WF_APP_GLB_SETTINGS table. Therefore, it is necessary to store the APP_NAME and KEY_ in the WF_ANONYMOUS_ACCESS table to get the information.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ANONYMOUS_ACCESS_TOKEN

Function:
A unique access token that is generated to access an anonymous form.
Data Type:
nvarchar
Size:
2048
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

APPL_NAME

Function:
The name of the app associated with the anonymous task.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CREATED_BY

Function:
The user who created the anonymous task.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CREATED_DATE

Function:
The date the anonymous task was created.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CUSTOM_HEADER_ID

Function:
The ID (GUID) that uses a secondary key to get the list of custom header information that is configured for an anonymous task.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CUSTOM_PARAM_ID

Function:
The ID (GUID) of the custom parameter arguments that are supplied with an anonymous task URL.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

DEF_NAME

Function:
The name of the process model associated with the anonymous task.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

FIREWALL_SETTINGS_ID

Function:
The ID (GUID) of the firewall settings that uses a secondary key to get the list of firewall IP configuration settings.
Data Type:
nvarchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_BY

Function:
The user who last updated, or modified, the anonymous task.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_DATE

Function:
The date the anonymous task was last modified.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

REQUIRE_VALIDATION_CODE

Function:
Sets the multi-factor authentication for an anonymous form.
Values:
  • Yes - Multi-factor authentication is enabled for an anonymous form.
  • No - Multi-factor authentication is disabled for an anonymous form.
Data Type:
varchar
Size:
3
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
WF_LARGE_DATA1:1