Database Tables Used By Admin Console

The following table lists all database tables that are used by the Administration Console:
aa813test
The following table lists all database tables that are used by the Administration Console:
Table Name
Description
ARADMINAUDITTRAIL
Stores administrator activity audit.
ARADMINAUTHTOKEN
Stores the tokens that Administration Console uses for pluggable authentication.
Every time you log in to the Console by using password, a token is internally generated after password match and stored in this table.
ARADMINBASICAUTHPWDHISTORY
Stores the last
n
occurrences of password of all administrators in all organizations that use Basic Authentication (for administrators) to log in to the Administration Console. This information is stored to prevent password reuse.
ARADMINBASICAUTHUSER
Stores the basic authentication credentials of all administrators in all organizations that use Basic Authentication (for administrators) to log in to the Administration Console.
ARADMINCONFIG
Stores the Administration Console configurations.
ARADMINCUSTOMROLE
Stores the configurations for all custom-defined roles.
ARADMINMANAGEROLE
Stores the list of roles that a specified role can manage.
ARADMINMAP
Stores the information of the AuthMinder Server instance, which is entered as a key-value pair.
ARADMINPAFCONFIG
Stores the authentication configurations for all administrators in all organizations in the system.
ARADMINPREDEFINEDROLE
Stores the role information for all supported administrators.
ARADMINPWDPOLICY
Stores the details of password policies for all administrators in all organizations.
ARADMINROLEPRIVILEGE
Stores the mapping of all administrative actions (or tasks) supported by the Administration Console, the scope of each task, and which role can perform the task.
ARADMINSCOPE
Stores the list of organizations over which each administrator has control (scope).
ARADMINSCOPEALL
Stores the list of all administrators who have control (scope) over
all
the existing organizations in the system.
ARADMINSUPPORTEDAUTHMECH
Stores the information about all supported authentication mechanisms to log in to the Administration Console.
ARADMINSUPPORTEDTIMEZONE
Stores the list of all available time zones.
Note:
This is an internal table.
ARADMINTURNEDOFFPRIVILEGE
Stores the list of the privileges that are not available for the given custom role.
ARADMINTXID
Stores the information required to generate a unique ID for each transaction.
ARADMINUITAB
Stores the information about the tabs that are available and the order in which they are available in the Administration Console.
ARADMINUITASK
Stores the information about all the tasks that are available and the order in which they are available through the Administration Console.
ARADMINUITASKATTRIBUTES
Stores the details of the tasks that are displayed, when the first-level and the second-level tabs in the Administration Console are clicked. These tasks are referred to as landing pages.
ARADMINUITASKCONTAINER
Stores the information related to available
task containers
. A task container can either be a second-level tab ID or the task group in the Administration Console.
ARADMINUSER
Stores the detailed information (such as organization to which they belong, current status, time zone, locale, last login time) of all existing administrators.
ARADMINUSER_ARCHIVE
Stores the information related to all deleted users.
ARADMINWIZARDTASK
Stores the information about all the tasks that can be performed by using the Bootstrap Wizard.
ARCMNBULKOPERATION
Stores information related to all supported bulk operations that include uploading users and uploading user accounts.
ARCMNBULKOPERATIONATTRIBUTE
Stores attributes for all bulk operations in  the ARCMNBULKOPERATION table.
ARCMNBULKREQUEST
Stores details (such as organization name, Request ID, status of the request, data uploaded, and operation) for each bulk-upload request.
ARCMNBULKTASKPARAM
Stores the name and the value of each attribute for each task supported in the system.
ARCMNBULKUPLOADTASK
Stores the status of each task for every bulk-upload request.
ARCMNCACHEREFRESH
Stores cache-related housekeeping information that indicates whether the Administration Console needs to be refreshed or not.
ARCMNCONFIG
Stores common Administration Console configuration information. Some of these include whether Bootstrap is complete, whether the cache refresh is automatic or manual, whether attribute encryption is enabled, and whether the bulk upload feature is enabled or not.
ARCMNDBERRORCODES
Stores vendor-specific database error codes and SQL state values that signify whether the database is down or non-responsive. This information is used by the system to decide if database should be failed over, in case a backup database is configured.
ARCMNMAPDATATYPE
Stores CA product-specific information that the Administration Console uses for rendering the Console pages.
ARCMNKEY
Stores the key configurations used while creating or updating organizations.
ARPFCMNCACHEREFRESHEVENT
Stores details of all cache refresh events for all instances in the system.
ARPFCMNCACHEREFRESHSCOPE
Stores information about all organizations that will be affected if a server cache refresh event occurs.
ARPFCMNCACHEREFRESHSTATUS
Stores the status of each cache refresh event for every instance for which it was triggered.
ARPFCMNINSTANCE
Stores detailed information for all AuthMinder Server instances configured in the system. This also includes the last time the instance was refreshed.
ARPFCMNORGCONFIGDATA
Stores configuration details for each organization. This includes global configurations that can be, typically, overridden at the organization-level.
ARPFCMNORGCONFIGSTATE
Stores the status of each assigned configuration from the ARPFCMNORGCONFIGDATA table.
ARPFCMNPRIVILEGEMAPPING
Stores the details of each privilege available through the Administration Console.
ARREPORTTABLES
Stores the information about the reports that are generated using Administration Console.
ARSEQUENCETABLE
Simulates sequences using stored procedures.
Note:
This table is used
only
by MS SQL Server.