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