Previous Topic: Used by Administration ConsoleNext Topic: Database Sizing Calculations


Used by User Data Service

The following table explains the database tables used by UDS:

Table Name

Description

ARUDSACCOUNTTYPE

Stores the details of all account types that are configured in the system.

ARUDSATTRMAP

Stores the configuration details that describe the field names of custom attributes for accounts, specific to each organization.

ARUDSAUTHSESSION

Stores authentication session details for currently active sessions. If this table is not replicated, then active authentication sessions can be lost.

ARUDSCALLOUT

Stores user-specific Callout configurations. These Callouts are called, if configured, for specific events, such as user creation and update.

ARUDSCALLOUTINTERNAL

Stores the configuration information (SDK method to be invoked), for Callouts when a delete event with cascade effect is triggered or enabled.

ARUDSCALLOUTINTERNALPARAMS

Stores the details, such as parameters and types specific to internal Callouts.

ARUDSCALLOUTPARAM

Stores the details, such as parameters and types specific to external Callouts.

ARUDSCONFIG

Stores the UDS configuration parameters and their values.

ARUDSCONFIGAUDITLOG

Stores the audit log information for the User Data Source (UDS) operations and their return status.

ARUDSCONTACTTYPE

Stores additional contact information (such as secondary email and telephone number) that can be configured at the organization or global level.

ARUDSCUSTOMATTREXT

Stores the additional user account custom attributes.

By default, up to 10 user account custom attributes are stored in the ARUDSUSERACCOUNT table. Any additional attributes (after the first 10) are stored in this table.

ARUDSCUSTOMATTREXT_ARCHIVE

Stores the archived information related to user account custom attributes when a user account is deleted.

ARUDSLDAPREPOSITORYCONFIG

Stores the LDAP Repository configurations, such as LDAP host and port details.

ARUDSORGANIZATION

Stores organization definitions, their attributes and repository connectivity details.

ARUDSORGANIZATIONAUDITLOG

Stores detailed organization-specific UDS audit logging information.

ARUDSORGREPOATTRIBUTES

Stores the organization-specific repository mapping information.

For example, if you are using LDAP as the user repository, then a CA attribute (say FNAME) might be mapped to a corresponding LDAP attribute (say GIVENNAME).

ARUDSORGSECUREATTRIBUTES

Stores organization-specific attributes that need to be encrypted, such as PII fields.

Note: These attributes are configured using the Administration Console.

ARUDSREPOCLONESTATUS

Stores the status of temporary cloning of user information from an external repository (such as LDAP) to the ARUDSREPOSITORYUSER table.

ARUDSREPOSITORYTYPES

Stores the definitions of all repositories supported by UDS.

ARUDSREPOSITORYUSER

Temporarily stores user information from an external repository (such as LDAP) to increase performance.

This is typically done when user data for a large number of users must be retrieved from the external repository.

ARUDSRESOURCESCOPE

Stores the resource-to-organization mapping.

In other words, this table specifies which resource is applicable for which organizations. For example, specific account types might be applicable only for specific organizations.

ARUDSRESOURCESCOPEALL

Stores the resource-to-organization mapping. However, it is different from the ARUDSRESOURCESCOPE table, because it specifies which resource is applicable for all organizations.

ARUDSSECUREATTRIBUTES

Stores information related to attributes that need to be encrypted, such as PII fields.

Note: These attributes are configured using the Administration Console.

ARUDSUSER

Stores user details and attributes of all users who belong to the organization.

ARUDSUSER_ARCHIVE

Stores user details for all user accounts that have been deleted from the system.

ARUDSUSERACCOUNT

Stores user account information for specific users.

ARUDSUSERACCOUNT_ARCHIVE

Stores user account information for all user accounts that have been deleted from the system.

ARUDSUSERATTRIBUTE

Stores all user attribute definitions. This table is expected to change rarely, only when new user attributes are added by individual products.

ARUDSUSERAUDITLOG

Stores user operation-specific detailed audit logging information.

ARUDSUSERCONTACT

Stores the secondary contact information (such as email or telephone numbers) for users.

ARUDSUSERCONTACT_ARCHIVE

Stores the secondary contact information (such as email or telephone numbers) for the user accounts that have been deleted from the system.