Guide of Decisions Entities Locations in SQL Tables
- 23 Mar 2022
- 1 Minute to read
- Print
- DarkLight
Guide of Decisions Entities Locations in SQL Tables
- Updated on 23 Mar 2022
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
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 Table | Description |
|---|---|
| Account_group_join | Contains a list of Accounts created in Decisions and which Group those accounts belong to. |
| Active_directory_settings | This table stores information about Active Directory Settings such as who Modified the settings last and the Modified Date. |
| Assigned_to_group | Information that links Assignments with the Group that was assigned the task. |
| Assigned_to_id | Contains information that links Assignments to the User that is assigned the task. |
| Database_query_definition | Stores information about Queries made in Decisions such as the Query itself, the Database that is being queried, and the Query Name. |
| Document | Stores details about Documents in Decisions such as the Document ID, the Document Size, and the Folder that the Document resides in. |
| Element_registration | Contains information about various Entities in Decisions (Flows, Rules, ect) such as the Entity Name, Folder ID, and the Modified Date. |
| Entity_account | Stores information about accounts created in Decisions such as the Account ID, Authentication Type, and the Last Login Date. |
| Entity_assignment | This table contains information about Assignments such as the Assignment ID, Assignment Name, Notes, and the State. |
| Entity_folder | Stores details about Folders in Decisions such as the Folder ID, Behavior, the Path, and Folder Name. |
| Entity_group | Contains 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_schedule | Stores information about scheduled jobs such as whether the job is Active, the Last Run Date, and the Last Run Duration. |
| Module_installation | Details 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?
