Thursday, January 14, 2016

OIM 11g R2 PS3 Database schema Model

OIM 11g R2 PS3 Database schema Model


TABLE_NAME Component Table level COMMENTS in DB
AUD Audit Define the Auditors. 
AUD_JMS Audit Transactional table storing intermediate audit information.
AUDIT_EVENT Lightweight Audit Stores Audit Events.
AUDIT_EVENT_GROUP Lightweight Audit Stores metadata for Audit Event Groups.
AUDIT_EVENT_ENT_TYPE_ACTN Lightweight Audit Stores metadata for entity type and its corresponding audit action.
AUDIT_EVENT_GRP_ENT_TYPE_ACTN Lightweight Audit Stores the relationship between Audit Event Groups and Entity Type Audit actions.
GPA Audit Stores Group Profile audit snapshots and deltas.
UPA Audit Stores User Profile audit snapshots and deltas.
UPA_FIELDS Audit Stores changes only for user profile audit history in denomalized format.
UPA_GRP_MEMBERSHIP Audit Stores groups membership history in denomalized format.
UPA_RESOURCE Audit Stores user profile resource history in denomalized format.
UPA_UD_FORMFIELDS Audit This table would hold the history of changes to the process form data.
UPA_UD_FORMS Audit This table would hold the summary of changes to the process form data.
UPA_USR Audit Stores user profile history in denomalized format.
ARM_AUD Audit
ADMIN_ROLE Authorization OOTB Admin Roles.
ADMIN_ROLE_MEMBERSHIP Authorization Admin-role to user membership in an organization scope.
ENTITY_PUBLICATION Authorization Entity publication to organization.
ROLE_PUBLICATION_VW Authorization View to give additional Role specific details (like role-name etc) for published Role.
APP_INST_PUBLICATION_VW Authorization View to give additional App-instance specific details (like app-instance name etc) for published App-Instance.
ENTITLEMENT_PUBLICATION_VW Authorization View to give additional Entitlements specific details (like entitlement name etc) for published Entitlements.
ADMIN_ROLE_MEMBERSHIP_VW Authorization View to give additional organization specific details (like parent org-id) for published admin role membership.
USER_ARM_ROLES_VW Authorization
ADMIN_ROLE_CAPABILITY Authorization It stores the mapping between the
 Admin_Role to Capability tables
ADMIN_ROLE_RULE_SCOPES Authorization Stores the scope ids over which dynamic admin role membership will be granted when the rule for
an admin role will get evaluated.  It also stores with/without hierarchy flag for each scope.
CAPABILITY Authorization It stores the capabilities for every
action governed by the authorization policies
CATALOG Catalog Unified collection of catalog items.It will store the items of all the entities that will like to make themselves as Catalogable. At
present we have Role, Entitlement and Application Instance as the catalogable entities.
CATALOG_METADATA_DEFINITION Catalog Collection of additional metadata defined on Catalog items.
CATALOG_HIERARCHICAL_ATTR Catalog Stores hierarchical attributes or technical glossary for catalog items.
CPA_CATALOG Catalog Audit table for catalog item.
CPA_CATALOG_FIELDS Catalog Audit table for catalog item, this will contains attribute changes.
EIF Common Services Export Import Files. Each row contains one single file used in export/import operation. For export there is only one file.
EIH Common Services Export Import History. Each row represents one Data Deployment Management session.
EIL Common Services DB Based lock for export operation. Used to make sure only one user can import at a time. This is currently not managed through dataobjects.
EIO Common Services Export Import Objects. Each row represents one object exported/imported.
EIS Common Services Substitutions used during import process.
EMD Common Services Core -- Email Definition Information Table That Holds The Email Template Definitions.
JOB_HISTORY Common Services Historical Data for each Job Run.
LOCALTEMPLATE Common Services Table for Locale specific details for Notification Templates.
NOTIFICATIONLOG Common Services Logging specific to Notifications.
NOTIFICATIONTEMPLATE Common Services Table for Notification Templates.
PTY Common Services Client Properties Table.
QRTZ92_BLOB_TRIGGERS Common Services Quartz table to store Blob Triggers.
QRTZ92_CALENDARS Common Services Quartz table to store Calendars.
QRTZ92_CRON_TRIGGERS Common Services Quartz table to store Cron Triggers.
QRTZ92_FIRED_TRIGGERS Common Services Quartz table to store Fired Triggers.
QRTZ92_JOB_DETAILS Common Services Quartz table to store Job Details.
QRTZ92_JOB_LISTENERS Common Services Quartz table to store Job Listeners.
QRTZ92_LOCKS Common Services Quartz table to store Locks.
QRTZ92_PAUSED_TRIGGER_GRPS Common Services Quartz table to store Paused Trigger Groups.
QRTZ92_SCHEDULER_STATE Common Services Quartz table to store Scheduler State.
QRTZ92_SIMPLE_TRIGGERS Common Services Quartz table to store Simple Triggers.
QRTZ92_TRIGGERS Common Services Quartz table to store Triggers.
QRTZ92_TRIGGER_LISTENERS Common Services Quartz table to store Triggers Listeners.
AAD ID Admin List To Define The Administrators For Each Organization And Their Delegated Admin Privileges.
AAP ID Admin Table for storing Resource - Organization level parameter Values.
ACP ID Admin/Provisioning Acp - Link Table That Holds Reference To Act And Pkg Tables,
 Table That Defines The Objects (Resources) Allowed For A Particular Organization.
ACT ID Admin Defines information about all organizations created in OIM through Xellerate.
GPG ID Admin List to define the (nested)group members of User Group in the 'User Group' form.
MLS_LOCALE ID Admin List of languages used for MLS [Multi Lingual Support] (for role) and MR [Multi Representation] (for user) representation of display names.
MLS_UGP ID Admin Stores entries of MLS display names of roles.
MLS_USR ID Admin Stores entries of MR display names of users.
MV_USER_COLS ID Admin/Recon This table stores the data from USER_TAB_COLUMNS to reduce the data dict. recursive calls for improved performance.
ORG_HIERARCHY ID Admin Holds information about the complete organization Hierarchy.
ORG_USER_MEMBERSHIPS ID Admin Stores the User-Org membership details.
PCQ ID Admin Holds the challenging questions and answers for a user.
POG ID Admin Join table between Policy and User Groups, Specifies the groups to whom an access policy will apply.
PWH ID Admin These 2 tables are not IDAMDIN specific( PWR/PWH) . Same tables are used for password policy info when they are linked to the resource objects.
Purpose-Used to maintain password history.
PWR ID Admin These 2 tables are not IDAMDIN specific( PWR/PWH) . Same tables are used for password policy info when they are linked to the resource objects.
Purpose-Used to store Password Rule Policies
RPW ID Admin Rules To Apply To A Password Policy, Defines The Policy Determination Rules Attached To A Password Policy.
PXD ID Admin Table that holds the list of all Proxies Defined.
RGP ID Admin Rules To Apply To A User Group,
Defines The Auto-group Membership Rules Attached To A Particular Group.
ROLE_CATEGORY ID Admin The table is used to store role categories. A category is similar to a folder that can be used to organize roles displayed in the console. Role categories simplify the administrators browse experience,
allowing for easy navigation to roles of interest.
UGP ID Admin Defines a group of users.
UHD ID Admin User Policy Profile History  Details table.
UPD ID Admin User Policy Profile Details table.
UPH ID Admin User Policy Profile History table.
UPP ID Admin User Policy Profile table.
USG ID Admin This table stores which users are in which groups.
USR ID Admin Stores all information regarding a user.
USR_ATTRIBUTE_RESERVATIONS ID Admin To store User Attributes with their reserved values.
USR_CONFIG_HISTORY ID Admin This table stores the audit data for all the modifications done to User.xml are audited here.
UWP ID Admin Window sequence, nesting in CarrierBase explorer for each user group.
OIM_TMP_MLS_TABLE ID Admin Oracle Global Temporary Table for intermediate processing of User entries of MLS data.
DYN_EVAL_CHANGELOG ID Admin Contains the changelog data for dynamic evaluation since last job run.
LATEST_PLUGINS Platform Stores latest version information for plugins.
OIMHOME_JARS Platform Stores the jars that are uploaded using upload or update jar utility. These jars are primarily used by adapters.
ORCHPROCESS Platform Stores the process instances that are being executed.
PLUGINS Platform Stores plugins that are uploaded using register plugin utility.
PLUGIN_METADATA Platform Stores Metadata associated with  plugins.
PLUGIN_ZIP Platform Stores plugin in zips as serialized blobs.
RESOURCES Platform Stores custom resource bundle information that are uploaded using upload or update resource bundle utilities.
FAILED_TASKS Platform Stores information related to failed JMS messages.
ORCHEVENTS_TMP Platform Available only in an an envoronment upgraded to R2PS3 (not OOTB)
ORCHFAILEDEVENTS_TMP Platform Available only in an an envoronment upgraded to R2PS3 (not OOTB)
ORCH_BENEFICIARIES_TMP Platform Available only in an an envoronment upgraded to R2PS3 (not OOTB)
ADL Provisioning Contains the all of the necessary parameters for an adapter task of type IF, ELSE IF, FOR, WHILE, SET, and VARIABLE tasks. These type of tasks are known as LOGIC TASKS.
ADM Provisioning Data mapping between parameters input/output parameters and source/sink.
ADP Provisioning Defines an adapter created through the Adapter Factory.
ADS Provisioning Database, schema and procedure name selections which define a stored procedure adapter task.
ADT Provisioning Defines a task attached to an adapter.
ADU Provisioning Contains the web service and method chosen for a task of the Adapter Factory.
ADV Provisioning Adapter variable table contains variables that have been created for specific adapters.
APP_INSTANCE Provisioning Application Instance definition information.
ARS Provisioning Contains custom response codes for 'Process Task' Adapters only.
ATP Provisioning Defines input and output parameters for the constructor and method of an adapter task of type JAVA, UTILITY, TAME, REMOTE, and XLAPI.
DAV Provisioning Stores the runtime data mappings for 'Entity' & 'Rule Generator' adapters. The data source being an Xellerate form or child table, or a user defined process form.
DEP Provisioning Dependencies Among Tasks Within A Workflow Process.
DOB Provisioning Data Resource definition consisting of the fully qualified class name of the data object.
DVT Provisioning Defines the one to many relationship between Data Resources and Event Handlers (this includes adapters).
ENT_ASSIGN Provisioning Stores Entitlement Assignments.
ENT_ASSIGN_DELTA Provisioning Intermediate table to store changes to Entitlement Assignments.
ENT_ASSIGN_HIST Provisioning Stores Historical Entitlement Assignment information.
ENT_LIST Provisioning Provisioning level Entitlement catalog.
ESD Provisioning Encrypted columns not within the bounds of the SDK.
EVT Provisioning Defines event handlers by providing a the process and class name. In addition the scheduling time of when the event handler can execute is set to  pre (insert, update, delete)  or post (insert, update, delete).
FUG Provisioning List to define the administrators for each user defined object in the 'Structure Utility' form or for each user defined field in the 'User Defined Field Definition' form.
MAP Provisioning XML MAP SCHEMA INFORMATION.
MAV Provisioning Stores the runtime data mappings for 'Process Task' adapters. The data source being a process form, Location, User, Organization, Process, IT Resource, or Literal data.
MEV Provisioning E-mail notification events.
MIL Provisioning Holds information about tasks of a process.
MSG Provisioning Defines the user groups that have permission to set the status of a process task.
MST Provisioning Task Status And Object Status Information. Holds All The Task Status To Object Status Mappings.
OBA Provisioning OBJECT AUTHORIZER INFORMATION.
OBD Provisioning OBJECT DEPENDENCIES.
OBI Provisioning OBJECT INSTANCE INFORMATION.
OBJ Provisioning Resource Object definition information.
ODF Provisioning HOLDS OBJECT TO PROCESS FORM DATA FLOW MAPPINGS.
ODV Provisioning OBJECT EVENTS/ADAPTERS INFORMATION.
OFFLINE_USER_ATTRIBUTES Provisioning
OIO Provisioning OBJECT INSTANCE REQUEST TARGET ORGANIZATION INFORMATION.
OIU Provisioning OBJECT INSTANCE REQUEST TARGET USER INFORMATION.
OOD Provisioning OBJECT INSTANCE REQUEST TARGET ORGANIZATION DEPENDENCY INFORMATION.
OPS Provisioning
ORC Provisioning This Entity Holds The Detail On Each Order. This Could Be Considered The Items Section Of An Invoice.
 This Entity Is The Instance Of A Particular Process.
ORD Provisioning Holds information that is necessary to complete an order regardless of a process being ordered.
ORF Recon/Provisioning Resource Reconciliation Fields.
ORR Recon/Provisioning OBJECT RECONCILIATION ACTION RULES.
OSH Provisioning Task Instance Assignment History.
OSI Provisioning Holds information about tasks that are created for an order.
OST Provisioning OBJECT STATUS INFORMATION.
OTI Provisioning Holds specific information such as status or scheduled dates about an instance of a task which are in Pending(Provisioning/Approval tasks ) and Rejected (Provisioning tasks) status buckets.
OUD Provisioning Object Instance Request Target User Dependency Information.
 Holds The Dependency Between Different Resource Instances Provisioned To A User.
OUG Provisioning List to define the administrators for each Resource Resource.
PDF Provisioning PACKAGE DATA FLOW TABLE HOLDS THE DATA FLOW RELATIONSHIPS BETWEEN PACKAGES.
PKD Provisioning PACKAGE DEPENDENCY TABLE HOLDS THE DEPENDENCY RELATIONSHIPS BETWEEN CHILD PACKAGES OF A PARENT PACKAGE.
PKG Provisioning Consists of names and system keys of service processs, which consist of a group of services from the TOS table.
 Defines a Process in Xellerate.
PKH Provisioning Package Hierarchy Table Holds The Parent-child Relationships Between Processes.
POC Provisioning Stores values for the child tables of the Object/Process form of a resource being provisioned by an access policy.
POF Provisioning POLICY FIELD TABLE HOLDS THE FIELD VALUE PAIRS THAT CONSTITUTE THE DEFINITION OF A POLICY.
POL Provisioning Policy Table Holds A Policy, Defines An Access Policy In The System.
POP Provisioning Policy Package Join Table Holds The Packages That A Particular Policy Orders For User,
 Defines Which Resources Will Be Provisioned Or Denied For A Particular Access Policy.
PRF Recon/Provisioning Process Reconciliation Field Mappings.
PUG Provisioning List To Define The Administrators And Their Delegated Admin Rights  For Each Process.
QUE Provisioning ADMINISTRATIVE QUEUES DEFINITION
RAV Provisioning Stores the runtime data mappings for 'Pre-populater' adapters. The data source being an Xellerate form or child table, or a user defined form.
RES Provisioning This table is used to stored adapter resources entered by the user.
RGM Provisioning Table for Response Code Generated Milestones.
RGS Provisioning Defines all known registries. These are used by Web Service tasks in an Adapter to communicate with a web service.
RLO Provisioning This table contains directory URLs which are referenced by Adapter Factory jar/class files.
RML Provisioning Rules To Apply To Task, Defines The Task Assignment Rules Attached To A Process Task.
ROP Provisioning Rules To Apply To An Object-process Pair, Defines The Process Determination Rules Attached To A Resource Object.
RPW Provisioning Rules To Apply To A Password Policy, Defines The Policy Determination Rules Attached To A Password Policy.
RSC Provisioning Defines The All The Possible Response Code For A Process Task.
RUE Provisioning Defines The Elements In A Rule Definition.
RUL Provisioning RULE DEFINITIONS.
RVM Provisioning Holds Recovery Milestones.
SCH Provisioning Holds specific information about an instance of a ask such as its status or scheduled dates.
SDC Provisioning Column metadata.
SDH Provisioning Meta-Table Hierarchy.
SDK Provisioning User define data object meta data definition.
SDL Provisioning SDK VERSION LABELS.
SDP Provisioning User defined column properties.
SEL Provisioning Data Object Permissions For Groups On A Specified Dataobject.
SPD Provisioning IT Resource parameter definition
SRE Provisioning Defines Which Pre-populate Rule Generator Will Run For A Field Of User Defined Data Object.
SRS Provisioning IT Resource - IT Resource join.
STA Provisioning Status Codes
SVD Provisioning IT Resource type definition.
SVP Provisioning IT Resource property definition.
SVR Provisioning It Resource Instance Definition.
TOS Provisioning Holds information about a process.
UNM Provisioning  "UnDo Milestone" Feature.
USER_PROVISIONING_ATTRS Provisioning Transactional table that stores Access Policy related provisioning information for Users.
ORF Recon/Provisioning Resource Reconciliation Fields.
ORR Recon/Provisioning OBJECT RECONCILIATION ACTION RULES.
PRF Recon/Provisioning Process Reconciliation Field Mappings.
RA_LDAPROLE Recon To store ldap role reconciliation data.
RA_LDAPROLEHIERARCHY Recon To store ldap hierarchy reconciliation data .
RA_LDAPROLEMEMBERSHIP Recon To store ldap role membership reconciliation data.
RA_LDAPUSER Recon To store ldap user reconciliation data. 
RA_MLS_LDAPROLE Recon To store MLS ldap role reconciliation data.
RA_MLS_LDAPUSER Recon To store MLS ldap user reconciliation data.
RA_XELLERATE_ORG Recon Recon Staging table for resource object Xellerate Organization.
RECON_ACCOUNT_MATCH Recon Reconciliation Event Processes Matched.
RECON_ACCOUNT_OLDSTATE Recon Intemediate Table for storing account specific audit data.
RECON_BATCHES Recon Reconciliation Batches.
RECON_CHILD_MATCH Recon Reconciliation Event Processes Child Table Matches.
RECON_EVENTS Recon Reconciliation Events.
RECON_EVENT_ASSIGNMENT Recon Reconciliation Event Assignments.
RECON_EXCEPTIONS Recon Exceptions found in Target data during Reconciliation.
RECON_HISTORY Recon Reconciliation Event Action History.
RECON_JOBS Recon Reconciliation Jobs.
RECON_ORG_MATCH Recon Reconciliation Event Organizations Matched.
RECON_ROLE_HIERARCHY_MATCH Recon Reconciliation Event Role Hierarchy Matched.
RECON_ROLE_MATCH Recon Reconciliation Event Role Matched.
RECON_ROLE_MEMBER_MATCH Recon Reconciliation Event Role Member Matched.
RECON_TABLES Recon Reconciliation Table Names.
RECON_UGP_OLDSTATE Recon Intemediate Table for storing role specific audit data.
RECON_USER_MATCH Recon Reconciliation Event Users Matched.
RECON_USER_OLDSTATE Recon Intemediate Table for storing User specific audit data.
OIM_TMP_RECON_MLS_TABLE Recon Oracle Global Temporary Table used in  intermediate processing of CHANGELOG event entries of MLS data for Recon Horizontal Tables.
REQUEST Request To Store Request summary information.
REQUEST_APPROVALS Request To store Request Approval instances in a request and their status.
REQUEST_APPROVAL_POLICIES Request Stores approval policy details like policy name, associated approval process, rules etc . Each approval policy is uniquely identified by APPROVAL_POLICY_KEY value, and is generated by sequence object APPROVAL_POLICY_SEQ.
Approval Rule is nested and defined in XML format.
REQUEST_BENEFICIARY Request Stores the ids of benificiaries for agiven request
REQUEST_BENEFICIARY_ENTITIES Request Stores the entities that are part of a beneficiary in a Request.
REQUEST_BENEFICIARY_ENTITYDATA Request Stores the entity data for the entities pertaining to a Beneficiary.
REQUEST_COMMENTS Request This table is deprecated and is no longer used.
REQUEST_ENTITIES Request Stores the entities that are requested in a Request.
REQUEST_ENTITY_ATTR_VALUES Request This table stores values of multi-valued Request entity attributes. Binary values are stored in column REAV_VALUE_BLOB.
REQUEST_ENTITY_DATA Request Stores the entity data for the entities that are requested.
REQUEST_HISTORY Request To store Request History information.
REQUEST_PROFILES Request To store Request Profile summary information.
REQUEST_PROFILE_ENTITIES Request To store entities associated with a Request Profile.
REQUEST_PROFILE_ENTITY_DATA Request To Store data associated with Request Profile entities.
REQUEST_STAGES Request To store possible stages in a Request.
REQUEST_TEMPLATE Request This table is deprecated and is no longer used.
Used to store Request Template related information.
REQUEST_TEMPLATE_ATTRIBUTES Request Stores additional attributes associated with Request.
WF_DEFINITION Request To Store SOA composite registration information.
WF_INSTANCE Request To store the SOA composite instances.
ROLESOD_CONFLICTS SOD To store Role SOD Conflicts.
SIL_ASYNCH_INFO SOD Table contains Entry for each Asynchronous SODCheck.
SIL_PARAMETERS SOD IT Resource Instance names for each SIL System.
SIL_SCO_STY_JOIN SOD Service component implementation for every System Type.
SIL_SERVICE_COMP SOD Lists the various Service Components for completing and SoDCheck.
SIL_SYSTEM SOD Stores the SIL systems supported and required connection parameters.
SIL_SYSTEM_TYPE SOD Stores all the entries of SIL Systems.
SIL_TYPES SOD Types of all SIL category available.
SIL_TYPE_CATEGORY SOD Categories of SIL Types available.
WS_SODCHECK SOD Stores details of Webservice messages sent for SoD Check like Message ID, Callback URL, Request ID from BPEL workflow.
ADF_LOOKUPS UI View to search in look up tables.
ADF_LOOKUP_TYPES UI View to search in look up tables for the appropriate look up type.
CERTDS_ENT_ASGN Certification Decision and snapshot table for entitlement assignments in
entitlement certifications.
CERTDS_USER_ROLE_ASGN Certification Decision and snapshot table for role memberships.
CERTD_ACCT_ENT_ASGN Certification Link table for certification and accounts entitlements .
CERTD_APP_INST Certification Decision table for application instances.
CERTD_ENT_DEFN Certification Decision table for entitlement definitions.
CERTD_POL_ENT_DEFN Certification Decision table for entitlement definitions in policies.
CERTD_ROLE Certification Decision table for roles.
CERTD_ROLE_POLICY Certification Decision table for Role Policies associations.
CERTD_USER Certification Decision table for users.
CERTD_USER_ACCT Certification Decision table for user accounts.
CERTS_ACCOUNT Certification Snapshot table for user accounts.
CERTS_ACCT_ENT_ASGN Certification Snapshot table for entitlement assignments.
CERTS_APP_INST Certification Snapshot table for application instances.
CERTS_CATALOG_UDF Certification Snapshot table for catalog UDF data.
CERTS_ENT_DEFN Certification Snapshot table for entitlement definitions.
CERTS_POLICY Certification Snapshot table for policies.
CERTS_POL_ENT_DEFN Certification Snapshot table for entitlement definitions in policies.
CERTS_ROLE Certification Snapshot table for roles.
CERTD_STATS Certification Stores completion statistics for certifications.
CERTS_USER Certification Snapshot table for users.
CERTS_USR_UDF Certification Snapshot table for user UDF data.
CERT_ACTION_HISTORY Certification Event details for certification action history.
CERT_ACTION_HISTORY_SCOPE Certification Link table defining scope for certification action history events.
CERT_CERTS Certification Certification Instances table.
CERT_CONFIG Certification Certification configuration table.
CERT_DEFN Certification Certification definition table.
CERT_EVT_LSNR Certification Certification event listener definition table.
CERT_EVT_TRIG Certification List of users requiring certification due to triggering of event
listener rules.
CERT_LAST_DECISION Certification Last certification decision for an item. 
CERT_TASK_ACTION Certification Decision table for certification items in a SOA task.
CERT_TASK_INFO Certification Link for a certification instance to a SOA task.
IDA_POLICY_VIOLATION ID Audit Instances of a Policy Violation.
IDA_POLICY_VIOLATION_CAUSE ID Audit Instances of a Policy Violation Cause.
IDA_REMEDIATOR ID Audit Instances of a Policy Violation
Remediator.
IDA_SCAN_DEFN ID Audit Table for storing IDA SCAN
 DEFINITIONS.
IDA_SCAN_RUN ID Audit Instances of running a scan
definition.
IDA_SCAN_RUN_POLICIES ID Audit Table for storing relationship
information between IDA_SCAN_RUN and POLICY.
IDA_SCAN_RUN_POLICY_VIOLATION ID Audit Table for storing relationship
information between IDA_SCAN_RUN and IDA_POLICY_VIOLATION.
IDA_SCAN_RUN_USER ID Audit Table for storing relationship
information between IDA_SCAN_RUN and USER.
IDA_TASK_POLICY_VIOLATION ID Audit Table for storing external
relationship information between SOA TSK and POLICY VIOLATION.
POLICY Policy Engine The table holds the definitions for the policy engine policies.
POLICY_RULE_ASSIGNMENT Policy Engine The table holds the relations between policies and rules.
POLICY_TYPE Policy Engine The table holds the definitions for the policy engine policy types.
RETURN_VALUES Policy Engine The child table holds return value definitions for the policy engine rules.
RULE Policy Engine The table holds the definitions for the policy engine rules.
BULKLOAD_BATCH Bulkload Post Processing Bulkload Post Processing.
BULKLOAD_USR Bulkload Post Processing Bulkload Post Processing.
FAILED_CALLBACKS None Stores association information between callback destinations.
CALLBACK_INVOCATION_RESULT SPML Table to store results of callbacks invoked by OIM. Used to aggregate status for both synchronous and asyncrhronous invocation.
CALLBACK_DESTINATIONS None Stores the list of failed callback destinations to retry .
CALLBACK_PAYLOAD None Stores the Callback notification data to be re-sent.
OIM_RECON_CHANGES_BY_RES_MV Report Materialized View used in the BI Report-
UPGRADE_FEATURE_LIST Upgrade
UPGRADE_FEATURE_STATE Upgrade
UPGRADE_MDS_MERGE Upgrade Table to store upgrade LCM data for Authorization.
OIM_DATAPRG_FAILED_KEYS  OOTB Online Purge Table Logging table to store the entity keys for each module/entity which were failed during scheduled purge run.
OIM_DATAPRG_TASKS_LOGDTLS    OOTB Online Purge Table Logging table to store the details of the OIM Scheduled Task controlled purge runs for the module/entity feature level details.
OIM_DATAPURGE_TASK_LOG       OOTB Online Purge Table Logging table to store the details of the OIM Scheduled Task controlled purge runs,for the deletion of Entity data.
OIM_TMP_TASK_ARCH_TAB       OOTB Task Archival Table Temporary table used by Provisioning Task Archival utility to stage data during the run.
ARCH_REQUEST       OOTB Request Archival Table Archival table for storing archived data from REQUEST table during Request Archival/Purge.
ARCH_REQUEST_APPROVALS        OOTB Request Archival Table Archival table for storing archived data from REQUEST_APPROVALS table during Request Archival/Purge.
ARCH_REQUEST_BE               OOTB Request Archival Table Archival table for storing archived data from REQUEST_BE table during Request Archival/Purge.
ARCH_REQUEST_BED              OOTB Request Archival Table Archival table for storing archived data from REQUEST_BED table during Request Archival/Purge.
ARCH_REQUEST_BENEFICIARY      OOTB Request Archival Table Archival table for storing archived data from REQUEST_BENEFICIARY table during Request Archival/Purge.
ARCH_REQUEST_COMMENTS         OOTB Request Archival Table Archival table for storing archived data from REQUEST_COMMENTS table during Request Archival/Purge.
ARCH_REQUEST_ENTITIES         OOTB Request Archival Table Archival table for storing archived data from REQUEST_ENTITIES table during Request Archival/Purge.
ARCH_REQUEST_ENTITY_DATA      OOTB Request Archival Table Archival table for storing archived data from REQUEST_ENTITY_DATA table during Request Archival/Purge.
ARCH_REQUEST_HISTORY          OOTB Request Archival Table Archival table for storing archived data from REQUEST_HISTORY table during Request Archival/Purge.
ARCH_REQUEST_TA               OOTB Request Archival Table Archival table for storing archived data from REQUEST_TA table during Request Archival/Purge.
ARCH_ROLESOD_CONFLICTS        OOTB Request Archival Table Archival table for storing archived data from ROLESOD_CONFLICTS table during Request Archival/Purge.
ARCH_WF_INSTANCE       OOTB Request Archival Table Archival table for storing archived data from WF_INSTANCE table during Request Archival/Purge.
CIH Connector [OOTB] Holds connector specific installation history information. It also stores Connector Name, Connector Version, Connector XML, etc.
COUN_LOG_TAB Connector [OOTB] Used by the Connector Uninstall utility for storing temporary data.
GCD Connector Framework GCD (Generic Connector Definition) is used by GTC for storing the information about the connectors that are created using GTC.
ATS Deprecated Stores which services or can be ordered by which organizations and which rates apply.
QUG Deprecated ADMINISTRATIVE GROUP MEMBERS.
QUM Deprecated ADMINISTRATIVE QUEUE MEMBERS.
TSA Deprecated STORES INITIALIZATION PARAMS (NAME/VALUE PAIRS) FOR SCHEDULER TASKS.
TSH Deprecated Recording History of Task Execution in Scheduler.
TSK Deprecated SCHEDULER TASK DEFINITION INFORMATION.
REQ Deprecated THIS TABLE HOLDS REQUEST INFORMATION.
RIO Deprecated Request Organizations Resolved Object Instances.
RQA Deprecated REQUEST TARGET ORGANIZATION INFORMATION.
RQC Deprecated REQUEST COMMMENT INFORMATION.
RQD Deprecated Contains self-registration request data for web admin.
RQE Deprecated REQUEST ADMINISTRATIVE QUEUES.
RQH Deprecated REQUEST STATUS HISTORY.
RQO Deprecated REQUEST OBJECT INFORMATION.
RQU Deprecated REQUEST OBJECT TARGET USER INFORMATION.
RQY Deprecated Request Organizations Requiring Resolution.
RQZ Deprecated Request Users Requiring Resolution.
RUG Deprecated List to define the administrators for each Request.
APA Attestation To store Attestation process administrators.
APD Attestation To store Attestation process definition.
APT Attestation To store the Attestation tasks.
ATD Attestation To store Entitlement details for each Attestation task .
ATR Attestation To store Attestation requests.
RAO Attestation Resource audit objectives information.
LKU Lookup Lookup definition entries.
LKV Lookup Lookup values.
WIN Generic Windows table: Windows keys, descriptions, and class names.
XSD Metadata This table holds Xellerate System Data.
UWP Generic Window sequence, nesting in CarrierBase explorer for each user group.


Thank you,
Arihant Jain