Guide of Decisions Entities Locations in SQL Tables
  • 08 Aug 2024
  • 1 Minute to read
  • Dark
    Light

Guide of Decisions Entities Locations in SQL Tables

  • Dark
    Light

Article summary

Overview 

The following document takes a look at a few different Decisions Entities and which SQL tables relate to each one.


Decisions Entities Locations in SQL Tables

SQL TableDescription
Account_group_joinContains a list of Accounts created in Decisions and which Group those accounts belong to.
Active_directory_settingsThis table stores information about Active Directory Settings such as who Modified the settings last and the Modified Date.
Assigned_to_groupInformation that links Assignments with the Group that was assigned the task.
Assigned_to_idContains information that links Assignments to the User that is assigned the task.
Database_query_definitionStores information about Queries made in Decisions such as the Query itself, the Database that is being queried, and the Query Name.
DocumentStores details about Documents in Decisions such as the Document ID, the Document Size, and the Folder that the Document resides in.
Element_registrationContains information about various Entities in Decisions (Flows, Rules, ect) such as the Entity Name, Folder ID, and the Modified Date.
Entity_accountStores information about accounts created in Decisions such as the Account ID, Authentication Type, and the Last Login Date.
Entity_assignmentThis table contains information about Assignments such as the Assignment ID, Assignment Name, Notes, and the State.
Entity_folderStores details about Folders in Decisions such as the Folder ID, Behavior, the Path, and Folder Name.
Entity_groupContains a list of Groups created in Decisions and related information such as the Group ID, Group Name, and the Type of Group (remote, local).
Job_scheduleStores information about scheduled jobs such as whether the job is Active, the Last Run Date, and the Last Run Duration.
Module_installationDetails about the Modules installed in Decisions like the Module Name, Size, and Version.

For further information on Administration, visit the Decisions Forum.

Was this article helpful?