OIM TABLES AND SCHEMA DETAILS

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
AUD	Audit	None	Define the Auditors.
AUD_JMS	Audit	None	Transactional table storing intermediate audit information.
GPA	Audit	None	Stores Group Profile audit snapshots and deltas.
UPA	Audit	None	Stores User Profile audit snapshots and deltas.
UPA_FIELDS	Audit	None	Stores changes only for user profile audit history in denomalized
			format.
UPA_GRP_MEMBERSHIP	Audit	None	Stores groups membership history in denomalized format.
UPA_RESOURCE	Audit	None	Stores user profile resource history in denomalized format.
UPA_UD_FORMFIELDS	Audit	None	This table would hold the history of changes to the process form data.
UPA_UD_FORMS	Audit	None	This table would hold the summary of changes to the process form
			data.
UPA_USR	Audit	None	Stores user profile history in denomalized format.
ARM_AUD	Audit	None

ATTESTATION

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
APA	Attestation	None	To store Attestation process administrators.
APD	Attestation	None	To store Attestation process definition.
APT	Attestation	None	To store the Attestation tasks.
ATD	Attestation	None	To store Entitlement details for each Attestation task .
ATR	Attestation	None	To store Attestation requests.
RAO	Attestation	None	Resource audit objectives information.

AUTHORIZATION

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
ADMIN_ROLE	Authorization	Admin-Role Membership	OOTB Admin Roles.
ADMIN_ROLE_MEMBERSHIP	Authorization	Admin-Role Membership	Admin-role to user membership in an organization scope.
ENTITY_PUBLICATION	Authorization	Entity Publication	Entity publication to organization.
ROLE_PUBLICATION_VW	Authorization	Entity Publication	View to give additional Role specific details (like role-name etc) for
			published Role.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
APP_INST_PUBLICATION_VW	Authorization	Entity Publication	View to give additional App-instance specific details (like app-instance
			name etc) for published App-Instance.
ENTITLEMENT_PUBLICATION_V	Authorization	Entity Publication	View to give additional Entitlements specific details (like entitlement
W			name etc) for published Entitlements.
ADMIN_ROLE_MEMBERSHIP_V	Authorization	Admin-Role Membership	View to give additional organization specific details (like parent org-id)
W			for published admin role membership.
USER_ARM_ROLES_VW	Authorization	Admin-Role

CATALOG

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
			Unified collection of catalog items.It will store the items of all the
			entities
CATALOG	Catalog	None	that will like to make themselves as Catalogable. At present we have
			Role, Entitlement and Application Instance as the catalogable entities.
CATALOG_METADATA_DEFINITI	Catalog	None	present we have Role, Entitlement and Application Instance as the
ON			catalogable entities.
CATALOG_HIERARCHICAL_ATT	Catalog	None	Collection of additional metadata defined on Catalog items.
R
CPA_CATALOG	Catalog	None	Stores hierarchical attributes or technical glossary for catalog items.
CPA_CATALOG_FIELDS	Catalog	None	Audit table for catalog item.

COMMON SERVICES

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
ATTACHMENTS	Common Services	Notification
EIF	Common Services	DM Import	Export Import Files. Each row contains one single file used in
			export/import operation. For export there is only one file.
EIH	Common Services	DM Import	Export Import History. Each row represents one Data Deployment
			Management session.
			DB Based lock for export operation. Used to make sure only one user
EIL	Common Services	DM Import	can import at a time. This is currently not managed through
			dataobjects.
EIO	Common Services	DM Import	Export Import Objects. Each row represents one object
			exported/imported.
EIS	Common Services	DM Import	Substitutions used during import process.
EMD	Common Services	Notification	Core -- Email Definition Information Table That Holds The Email
			Template Definitions.
JOB_HISTORY	Common Services	Scheduler	Historical Data for each Job Run.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
LOCALTEMPLATE	Common Services	Notification	Table for Locale specific details for Notification Templates.
NOTIFICATIONLOG	Common Services	Notification	Logging specific to Notifications.
NOTIFICATIONTEMPLATE	Common Services	Notification	Table for Notification Templates.
PTY	Common Services	System Properties	Client Properties Table.
QRTZ92_BLOB_TRIGGERS	Common Services	Scheduler	Quartz table to store Blob Triggers.
QRTZ92_CALENDARS	Common Services	Scheduler	Quartz table to store Calendars.
QRTZ92_CRON_TRIGGERS	Common Services	Scheduler	Quartz table to store Cron Triggers.
QRTZ92_FIRED_TRIGGERS	Common Services	Scheduler	Quartz table to store Fired Triggers.
QRTZ92_JOB_DETAILS	Common Services	Scheduler	Quartz table to store Job Details.
QRTZ92_JOB_LISTENERS	Common Services	Scheduler	Quartz table to store Job Listeners.
QRTZ92_LOCKS	Common Services	Scheduler	Quartz table to store Locks.
QRTZ92_PAUSED_TRIGGER_GR	Common Services	Scheduler	Quartz table to store Paused Trigger Groups.
PS
QRTZ92_SCHEDULER_STATE	Common Services	Scheduler	Quartz table to store Scheduler State.
QRTZ92_SIMPLE_TRIGGERS	Common Services	Scheduler	Quartz table to store Simple Triggers.
QRTZ92_TRIGGERS	Common Services	Scheduler	Quartz table to store Triggers.
QRTZ92_TRIGGER_LISTENERS	Common Services	Scheduler	Quartz table to store Triggers Listeners.
ARCH_JOB_HISTORY	Common Services	Scheduler

GENERIC

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
LKU	Generic	None	Lookup definition entries.
LKV	Generic	None	Lookup values.
WIN	Generic	None	Windows table: Windows keys, descriptions, and class names.
XSD	Generic	None	This table holds Xellerate System Data.
UWP	Generic	None	Window sequence, nesting in CarrierBase explorer for each user
			group.
		ID ADMIN
TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
AAD	ID Admin	Organization	List To Define The Administrators For Each Organization And Their
			Delegated Admin Privileges.
AAP	ID Admin	Organization	Table for storing Resource - Organization level parameter Values.
ACP	ID	Organization	Acp - Link Table That Holds Reference To Act And Pkg Tables,
	Admin/Provisioning
			Table That Defines The Objects (Resources) Allowed For A Particular
			Organization.
ACT	ID Admin	Organization	Defines information about all organizations created in OIM through
			Xellerate.
GPG	ID Admin	Role	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	Role	Stores entries of MLS display names of roles.
MLS_USR	ID Admin	User	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	Organization	Holds information about the complete organization Hierarchy.
ORG_USER_MEMBERSHIPS	ID Admin	Organization	Stores the User-Org membership details.
PCQ	ID Admin	User	Holds the challenging questions and answers for a user.
POG	ID Admin	Role	Join table between Policy and User Groups, Specifies the groups to
			whom an access policy will apply.
			These 2 tables are not IDAMDIN specific( PWR/PWH) . Same tables
PWH	ID Admin	Password Management	are used for password policy info when they are linked to the resource
			objects.
			Purpose-Used to maintain password history.
			These 2 tables are not IDAMDIN specific( PWR/PWH) . Same tables
PWR	ID Admin	Password Management	are used for password policy info when they are linked to the resource
			objects.
			Purpose-Used to store Password Rule Policies
RPW	ID Admin	Password Management	Rules To Apply To A Password Policy, Defines The Policy
			Determination Rules Attached To A Password Policy.
PXD	ID Admin	User	Table that holds the list of all Proxies Defined.
RGP	ID Admin	Role	Rules To Apply To A User Group,
			Defines The Auto-group Membership Rules Attached To A Particular
			Group.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
			The table is used to store role categories. A category is similar to a
ROLE_CATEGORY	ID Admin	Role	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	Role	Defines a group of users.
UHD	ID Admin	User	User Policy Profile History Details table.
UPD	ID Admin	User	User Policy Profile Details table.
UPH	ID Admin	User	User Policy Profile History table.
UPP	ID Admin	User	User Policy Profile table.
USG	ID Admin	Role	This table stores which users are in which groups.
USR	ID Admin	User	Stores all information regarding a user.
USR_ATTRIBUTE_RESERVATIO	ID Admin	User	To store User Attributes with their reserved values.
NS
USR_CONFIG_HISTORY	ID Admin	User	This table stores the audit data for all the modifications done to
			User.xml are audited here.
UWP	ID Admin	Role	Window sequence, nesting in CarrierBase explorer for each user
			group.
OIM_TMP_MLS_TABLE	ID Admin	User	Oracle Global Temporary Table for intermediate processing of User
			entries of MLS data.
DYN_EVAL_CHANGELOG	ID Admin	None	Contains the changelog data for dynamic evaluation since last job run.

PLATFORM

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
LATEST_PLUGINS	Platform	None	Stores latest version information for plugins.
OIMHOME_JARS	Platform	None	Stores the jars that are uploaded using upload or update jar utility.
			These jars are primarily used by adapters.
ORCH_BENEFICIARIES	Platform	None	To store beneficiary and context details of an orchestration.
ORCHEVENTS	Platform	None	Stores event handler names, status and result for all orchestration
			processes.
ORCHFAILEDEVENTS	Platform	None	Stores event handlers information that are executed because of
			failures in main flow.
ORCHPROCESS	Platform	None	Stores the process instances that are being executed.
PLUGINS	Platform	None	Stores plugins that are uploaded using register plugin utility.
PLUGIN_METADATA	Platform	None	Stores Metadata associated with plugins.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
PLUGIN_ZIP	Platform	None	Stores plugin in zips as serialized blobs.
RESOURCES	Platform	None	Stores custom resource bundle information that are uploaded using
			upload or update resource bundle utilities.
FAILED_TASKS	Platform	None	Stores information related to failed JMS messages.

PROVISIONING

TABLE_NAME	Component	Sub Component	COMMENTS
			Contains the all of the necessary parameters for an adapter task of
ADL	Provisioning	Adapter	type IF, ELSE IF, FOR, WHILE, SET, and VARIABLE tasks. These
			type of tasks are known as LOGIC TASKS.
ADM	Provisioning	Adapter	Data mapping between parameters input/output parameters and
			source/sink.
ADP	Provisioning	Adapter	Defines an adapter created through the Adapter Factory.
ADS	Provisioning	Adapter	Database, schema and procedure name selections which define a
			stored procedure adapter task.
ADT	Provisioning	Adapter	Defines a task attached to an adapter.
ADU	Provisioning	Adapter	Contains the web service and method chosen for a task of the Adapter
			Factory.
ADV	Provisioning	Adapter	Adapter variable table contains variables that have been created for
			specific adapters.
APP_INSTANCE	Provisioning	App Instance	Application Instance definition information.
ARS	Provisioning	Adapter	Contains custom response codes for 'Process Task' Adapters only.
ATP	Provisioning	Adapter	Defines input and output parameters for the constructor and method of
			an adapter task of type JAVA, UTILITY, TAME, REMOTE, and XLAPI.
			Stores the runtime data mappings for 'Entity' & 'Rule Generator'
DAV	Provisioning		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	Entitlement	Stores Entitlement Assignments.
ENT_ASSIGN_DELTA	Provisioning	Entitlement	Intermediate table to store changes to Entitlement Assignments.
ENT_ASSIGN_HIST	Provisioning	Entitlement	Stores Historical Entitlement Assignment information.
ENT_LIST	Provisioning	Entitlement	Provisioning level Entitlement catalog.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
ESD	Provisioning		Encrypted columns not within the bounds of the SDK.
			Defines event handlers by providing a the process and class name. In
EVT	Provisioning	Adapter	addition the scheduling time of when the event handler can execute is
			set to pre (insert, update, delete) or post (insert, update, delete).
			List to define the administrators for each user defined object in the
FUG	Provisioning	General	'Structure Utility' form or for each user defined field in the 'User
			Defined Field Definition' form.
MAP	Provisioning	Adapter	XML MAP SCHEMA INFORMATION.
			Stores the runtime data mappings for 'Process Task' adapters. The
MAV	Provisioning	Adapter	data source being a process form, Location, User, Organization,
			Process, IT Resource, or Literal data.
MEV	Provisioning	Notification	E-mail notification events.
MIL	Provisioning	General	Holds information about tasks of a process.
MSG	Provisioning	Role	Defines the user groups that have permission to set the status of a
			process task.
MST	Provisioning	General	Task Status And Object Status Information. Holds All The Task Status
			To Object Status Mappings.
OBA	Provisioning	General	OBJECT AUTHORIZER INFORMATION.
OBD	Provisioning	General	OBJECT DEPENDENCIES.
OBI	Provisioning	General	OBJECT INSTANCE INFORMATION.
OBJ	Provisioning	General	Resource Object definition information.
ODF	Provisioning	General	HOLDS OBJECT TO PROCESS FORM DATA FLOW MAPPINGS.
ODV	Provisioning	General	OBJECT EVENTS/ADAPTERS INFORMATION.
OFFLINE_USER_ATTRIBUTES	Provisioning
OIO	Provisioning	Organization	OBJECT INSTANCE REQUEST TARGET ORGANIZATION
			INFORMATION.
OIU	Provisioning	User	OBJECT INSTANCE REQUEST TARGET USER INFORMATION.
OOD	Provisioning	General	OBJECT INSTANCE REQUEST TARGET ORGANIZATION
			DEPENDENCY INFORMATION.
OPS	Provisioning	General
ORC	Provisioning	General	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	General	Holds information that is necessary to complete an order regardless of
			a process being ordered.
ORF	Recon/Provisioning	General	Resource Reconciliation Fields.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
ORR	Recon/Provisioning	General	OBJECT RECONCILIATION ACTION RULES.
OSH	Provisioning	General	Task Instance Assignment History.
OSI	Provisioning	General	Holds information about tasks that are created for an order.
OST	Provisioning	General	OBJECT STATUS INFORMATION.
			Holds specific information such as status or scheduled dates about an
OTI	Provisioning	General	instance of a task which are in Pending(Provisioning/Approval tasks )
			and Rejected (Provisioning tasks) status buckets.
OUD	Provisioning	General	Object Instance Request Target User Dependency Information.
			Holds The Dependency Between Different Resource Instances
			Provisioned To A User.
OUG	Provisioning	General	List to define the administrators for each Resource Resource.
PDF	Provisioning	General	PACKAGE DATA FLOW TABLE HOLDS THE DATA FLOW
			RELATIONSHIPS BETWEEN PACKAGES.
			PACKAGE DEPENDENCY TABLE HOLDS THE DEPENDENCY
PKD	Provisioning	General	RELATIONSHIPS BETWEEN CHILD PACKAGES OF A PARENT
			PACKAGE.
PKG	Provisioning	General	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	General	Package Hierarchy Table Holds The Parent-child Relationships
			Between Processes.
POC	Provisioning	Access Policy	Stores values for the child tables of the Object/Process form of a
			resource being provisioned by an access policy.
POF	Provisioning	General	POLICY FIELD TABLE HOLDS THE FIELD VALUE PAIRS THAT
			CONSTITUTE THE DEFINITION OF A POLICY.
POL	Provisioning	Access Policy	Policy Table Holds A Policy, Defines An Access Policy In The System.
POP	Provisioning	General	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	General	Process Reconciliation Field Mappings.
PUG	Provisioning	General	List To Define The Administrators And Their Delegated Admin Rights
			For Each Process.
QUE	Provisioning	General	ADMINISTRATIVE QUEUES DEFINITION
			Stores the runtime data mappings for 'Pre-populater' adapters. The
RAV	Provisioning	General	data source being an Xellerate form or child table, or a user defined
			form.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
RES	Provisioning	Adapter	This table is used to stored adapter resources entered by the user.
RGM	Provisioning	General	Table for Response Code Generated Milestones.
RGS	Provisioning	General	Defines all known registries. These are used by Web Service tasks in
			an Adapter to communicate with a web service.
RLO	Provisioning	Adapter	This table contains directory URLs which are referenced by Adapter
			Factory jar/class files.
RML	Provisioning	General	Rules To Apply To Task, Defines The Task Assignment Rules
			Attached To A Process Task.
ROP	Provisioning	General	Rules To Apply To An Object-process Pair, Defines The Process
			Determination Rules Attached To A Resource Object.
RPW	Provisioning	Password Management	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	Rule Engine	Defines The Elements In A Rule Definition.
RUL	Provisioning		RULE DEFINITIONS.
RVM	Provisioning		Holds Recovery Milestones.
SCH	Provisioning	Provisioning Tasks	Holds specific information about an instance of a ask such as its
			status or scheduled dates.
SDC	Provisioning	General	Column metadata.
SDH	Provisioning	General	Meta-Table Hierarchy.
SDK	Provisioning	General	User define data object meta data definition.
SDL	Provisioning	General	SDK VERSION LABELS.
SDP	Provisioning	General	User defined column properties.
SEL	Provisioning	Role	Data Object Permissions For Groups On A Specified Dataobject.
SPD	Provisioning	IT Resource	IT Resource parameter definition
SRE	Provisioning	General	Defines Which Pre-populate Rule Generator Will Run For A Field Of
			User Defined Data Object.
SRS	Provisioning	IT Resource	IT Resource - IT Resource join.
STA	Provisioning		Status Codes
SVD	Provisioning	IT Resource	IT Resource type definition.
SVP	Provisioning	IT Resource	IT Resource property definition.
SVR	Provisioning	IT Resource	It Resource Instance Definition.
TOS	Provisioning	General	Holds information about a process.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
UNM	Provisioning	General	"UnDo Milestone" Feature.
USER_PROVISIONING_ATTRS	Provisioning	General	Transactional table that stores Access Policy related provisioning
			information for Users.

RECONCILIATION

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
ORF	Recon/Provisioning	None	Resource Reconciliation Fields.
ORR	Recon/Provisioning	None	OBJECT RECONCILIATION ACTION RULES.
PRF	Recon/Provisioning	None	Process Reconciliation Field Mappings.
RA_LDAPROLE	Recon	OOTB LDAP Horz tables	To store ldap role reconciliation data.
RA_LDAPROLEHIERARCHY	Recon	OOTB LDAP Horz tables	To store ldap hierarchy reconciliation data .
RA_LDAPROLEMEMBERSHIP	Recon	OOTB LDAP Horz tables	To store ldap role membership reconciliation data.
RA_LDAPUSER	Recon	OOTB LDAP Horz tables	To store ldap user reconciliation data.
RA_MLS_LDAPROLE	Recon	OOTB LDAP Horz tables	To store MLS ldap role reconciliation data.
RA_MLS_LDAPUSER	Recon	OOTB LDAP Horz tables	To store MLS ldap user reconciliation data.
RA_XELLERATE_ORG	Recon	OOTB LDAP
		Horz tables	Recon Staging table for resource object Xellerate Organization.
RECON_ACCOUNT_MATCH	Recon	None	Reconciliation Event Processes Matched.
RECON_ACCOUNT_OLDSTATE	Recon	None	Intemediate Table for storing account specific audit data.
RECON_BATCHES	Recon	None	Reconciliation Batches.
RECON_CHILD_MATCH	Recon	None	Reconciliation Event Processes Child Table Matches.
RECON_EVENTS	Recon	None	Reconciliation Events.
RECON_EVENT_ASSIGNMENT	Recon	None	Reconciliation Event Assignments.
RECON_EXCEPTIONS	Recon	None	Exceptions found in Target data during Reconciliation.
RECON_HISTORY	Recon	None	Reconciliation Event Action History.
RECON_JOBS	Recon	None	Reconciliation Jobs.
RECON_ORG_MATCH	Recon	None	Reconciliation Event Organizations Matched.
RECON_ROLE_HIERARCHY_MA	Recon	None	Reconciliation Event Role Hierarchy Matched.
TCH
RECON_ROLE_MATCH	Recon	None	Reconciliation Event Role Matched.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
RECON_ROLE_MEMBER_MATC	Recon	None	Reconciliation Event Role Member Matched.
H
RECON_TABLES	Recon	None	Reconciliation Table Names.
RECON_UGP_OLDSTATE	Recon	None	Intemediate Table for storing role specific audit data.
RECON_USER_MATCH	Recon	None	Reconciliation Event Users Matched.
RECON_USER_OLDSTATE	Recon	None	Intemediate Table for storing User specific audit data.
OIM_TMP_RECON_MLS_TABLE	Recon	None	Oracle Global Temporary Table used in intermediate processing of
			CHANGELOG event entries of MLS data for Recon Horizontal Tables

REQUEST

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
REQUEST	Request	None	To Store Request summary information.
REQUEST_APPROVALS	Request	None	To store Request Approval instances in a request and their status.
			Stores approval policy details like policy name, associated approval
REQUEST_APPROVAL_POLICIE			process, rules etc . Each approval policy is uniquely identified by
	Request	None	APPROVAL_POLICY_KEY value, and is generated by sequence
S			object APPROVAL_POLICY_SEQ.
			Approval Rule is nested and defined in XML format.
REQUEST_BENEFICIARY	Request	None	Stores the ids of benificiaries for agiven request
REQUEST_BENEFICIARY_ENTITI	Request	None	Stores the entities that are part of a beneficiary in a Request.
ES
REQUEST_BENEFICIARY_ENTIT	Request	None	Stores the entity data for the entities pertaining to a Beneficiary.
YDATA
REQUEST_COMMENTS	Request	None	This table is deprecated and is no longer used.
REQUEST_ENTITIES	Request	None	Stores the entities that are requested in a Request.
REQUEST_ENTITY_ATTR_VALU	Request	None	This table stores values of multi-valued Request entity attributes.
ES			Binary values are stored in column REAV_VALUE_BLOB.
REQUEST_ENTITY_DATA	Request	None	Stores the entity data for the entities that are requested.
REQUEST_HISTORY	Request	None	To store Request History information.
REQUEST_PROFILES	Request	None	To store Request Profile summary information.
REQUEST_PROFILE_ENTITIES	Request	None	To store entities associated with a Request Profile.
REQUEST_PROFILE_ENTITY_DA	Request	None	To Store data associated with Request Profile entities.
TA
REQUEST_STAGES	Request	None	To store possible stages in a Request.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
REQUEST_TEMPLATE	Request	None	This table is deprecated and is no longer used.
			Used to store Request Template related information.
REQUEST_TEMPLATE_ATTRIBU	Request	None	Stores additional attributes associated with Request.
TES
WF_DEFINITION	Request	None	To Store SOA composite registration information.
WF_INSTANCE	Request	None	To store the SOA composite instances.

SEGREGATION OF DUTIES

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
ROLESOD_CONFLICTS	SOD	None	To store Role SOD Conflicts.
SIL_ASYNCH_INFO	SOD	None	Table contains Entry for each Asynchronous SODCheck.
SIL_PARAMETERS	SOD	None	IT Resource Instance names for each SIL System.
SIL_SCO_STY_JOIN	SOD	None	Service component implementation for every System Type.
SIL_SERVICE_COMP	SOD	None	Lists the various Service Components for completing and SoDCheck.
SIL_SYSTEM	SOD	None	Stores the SIL systems supported and required connection
			parameters.
SIL_SYSTEM_TYPE	SOD	None	Stores all the entries of SIL Systems.
SIL_TYPES	SOD	None	Types of all SIL category available.
SIL_TYPE_CATEGORY	SOD	None	Categories of SIL Types available.
WS_SODCHECK	SOD	None	Stores details of Webservice messages sent for SoD Check like
			Message ID, Callback URL, Request ID from BPEL workflow.

UI

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
ADF_LOOKUPS	UI	None	View to search in look up tables.
ADF_LOOKUP_TYPES	UI	None	View to search in look up tables for the appropriate look up type.
		OTHERS
TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
BULKLOAD_BATCH	Bulkload Post	None	Bulkload Post Processing.
	Processing
BULKLOAD_USR	Bulkload Post	None	Bulkload Post Processing.
	Processing

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
FAILED_CALLBACKS	None	Callback	Stores association information between callback destinations.
CALLBACK_INVOCATION_RESU	SPML	Callback	Table to store results of callbacks invoked by OIM. Used to aggregate
LT			status for both synchronous and asyncrhronous invocation.
CALLBACK_DESTINATIONS	None	Callback	Stores the list of failed callback destinations to retry .
CALLBACK_PAYLOAD	None	Callback	Stores the Callback notification data to be re-sent.
OIM_RECON_CHANGES_BY_RE	Report	None	Materialized View used in the BI Report-
S_MV
UPGRADE_FEATURE_LIST	Upgrade	None
UPGRADE_FEATURE_STATE	Upgrade	None
UPGRADE_MDS_MERGE	Upgrade	None	Table to store upgrade LCM data for Authorization.
OIM_DATAPRG_FAILED_KEYS	OOTB Online Purge	None	Logging table to store the entity keys for each module/entity which
	Table		were failed during scheduled purge run.
OIM_DATAPRG_TASKS_LOGDTL	OOTB Online Purge	None	Logging table to store the details of the OIM Scheduled Task
S	Table		controlled purge runs for the module/entity feature level details.
OIM_DATAPURGE_TASK_LOG	OOTB Online Purge	None	Logging table to store the details of the OIM Scheduled Task
	Table		controlled purge runs,for the deletion of Entity data.
OIM_TMP_TASK_ARCH_TAB	OOTB Task Archival	None	Temporary table used by Provisioning Task Archival utility to stage
	Table		data during the run.
ARCH_REQUEST	OOTB Request	None	Archival table for storing archived data from REQUEST table during
	Archival Table		Request Archival/Purge.
ARCH_REQUEST_APPROVALS	OOTB Request	None	Archival table for storing archived data from REQUEST_APPROVALS
	Archival Table		table during Request Archival/Purge.
ARCH_REQUEST_BE	OOTB Request	None	Archival table for storing archived data from REQUEST_BE table
	Archival Table		during Request Archival/Purge.
ARCH_REQUEST_BED	OOTB Request	None	Archival table for storing archived data from REQUEST_BED table
	Archival Table		during Request Archival/Purge.
ARCH_REQUEST_BENEFICIARY	OOTB Request	None	Archival table for storing archived data from
	Archival Table		REQUEST_BENEFICIARY table during Request Archival/Purge.
ARCH_REQUEST_COMMENTS	OOTB Request	None	Archival table for storing archived data from REQUEST_COMMENTS
	Archival Table		table during Request Archival/Purge.
ARCH_REQUEST_ENTITIES	OOTB Request	None	Archival table for storing archived data from REQUEST_ENTITIES
	Archival Table		table during Request Archival/Purge.
ARCH_REQUEST_ENTITY_DATA	OOTB Request	None	Archival table for storing archived data from
	Archival Table		REQUEST_ENTITY_DATA table during Request Archival/Purge.
ARCH_REQUEST_HISTORY	OOTB Request	None	Archival table for storing archived data from REQUEST_HISTORY
	Archival Table		table during Request Archival/Purge.
ARCH_REQUEST_TA	OOTB Request	None	Archival table for storing archived data from REQUEST_TA table
	Archival Table		during Request Archival/Purge.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
ARCH_ROLESOD_CONFLICTS	OOTB Request	None	Archival table for storing archived data from ROLESOD_CONFLICTS
	Archival Table		table during Request Archival/Purge.
ARCH_WF_INSTANCE	OOTB Request	None	Archival table for storing archived data from WF_INSTANCE table
	Archival Table		during Request Archival/Purge.
CIH	Connector [OOTB]	None	Holds connector specific installation history information. It also stores
			Connector Name, Connector Version, Connector XML, etc.
COUN_LOG_TAB	Connector [OOTB]	None	Used by the Connector Uninstall utility for storing temporary data.
GCD	Connector	None	GCD (Generic Connector Definition) is used by GTC for storing the
	Framework		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.
RCA	Old Recon Model		Reconciliation Event Organizations Matched.
RCB	Old Recon Model		Reconciliation Event Invalid Data.
RCD	Old Recon Model		Reconciliation Event Data.
RCE	Old Recon Model		Reconciliation Events.
RCH	Old Recon Model		Reconciliation Event Action History.
RCM	Old Recon Model		Reconciliation Event Multi-Valued Attribute Data.
RCP	Old Recon Model		Reconciliation Event Processes Matched.
RCU	Old Recon Model		Reconciliation Event Users Matched.
RCX	Old Recon Model		Exceptions found in Target data during Reconciliation.
REQ	Old Request Model		THIS TABLE HOLDS REQUEST INFORMATION.
RIO	Old Request Model		Request Organizations Resolved Object Instances.
RPC	Old Recon Model		Reconciliation Event Process Child Table Matches.
RPP	Old Recon Model		Parameters passed to report.
RPT	Old Recon Model		Stores information related to the creation of reports.
RQA	Old Request Model		REQUEST TARGET ORGANIZATION INFORMATION.
RQC	Old Request Model		REQUEST COMMMENT INFORMATION.

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
RQD	Old Request Model		Contains self-registration request data for web admin.
RQE	Old Request Model		REQUEST ADMINISTRATIVE QUEUES.
RQH	Old Request Model		REQUEST STATUS HISTORY.
RQO	Old Request Model		REQUEST OBJECT INFORMATION.
RQU	Old Request Model		REQUEST OBJECT TARGET USER INFORMATION.
RQY	Old Request Model		Request Organizations Requiring Resolution.
RQZ	Old Request Model		Request Users Requiring Resolution.
RRE	Old Recon Model		Reconciliation User Matching Rule Elements.
RRL	Old Recon Model		Reconciliation User Matching Rules.
RRT	Old Recon Model		Reconciliation User Matching Rule Element Properties.
RUG	Old Request Model		List to define the administrators for each Request.

OIM-OIA INTEGRATION

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
OIA_DC_ENTITY_DETAILS	OIM-OIA Integration	None
OIA_DC_SESSION_DETAILS	OIM-OIA Integration	None
OIA_STAGING_ACCOUNTS	OIM-OIA Integration	None
OIA_STAGING_ACCOUNT_ATTRI	OIM-OIA Integration	None
BUTES
OIA_STAGING_ENTITLEMENTS	OIM-OIA Integration	None
OIA_STAGING_ROLEGRANTS	OIM-OIA Integration	None
OIA_STAGING_USERS	OIM-OIA Integration	None
OIA_STAGING_USERS_EXT_PR	OIM-OIA Integration	None
OPS

CERTIFICATIONS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
CERTDS_ENT_ASGN	Certification	None	Decision and snapshot table for entitlement assignments in
			entitlement certifications.
CERTDS_USER_ROLE_ASGN	Certification	None	Decision and snapshot table for role memberships.
CERTD_ACCT_ENT_ASGN	Certification	None	Link table for certification and accounts entitlements .

OIM TABLES AND SCHEMA DETAILS

TABLE_NAME	Component	Sub Component	Table level COMMENTS in DB
CERTD_APP_INST	Certification	None	Decision table for application instances.
CERTD_ENT_DEFN	Certification	None	Decision table for entitlement definitions.
CERTD_POL_ENT_DEFN	Certification	None	Decision table for entitlement definitions in policies.
CERTD_ROLE	Certification	None	Decision table for roles.
CERTD_ROLE_POLICY	Certification	None	Decision table for Role Policies associations.
CERTD_USER	Certification	None	Decision table for users.
CERTD_USER_ACCT	Certification	None	Decision table for user accounts.
CERTS_ACCOUNT	Certification	None	Snapshot table for user accounts.
CERTS_ACCT_ENT_ASGN	Certification	None	Snapshot table for entitlement assignments.
CERTS_APP_INST	Certification	None	Snapshot table for application instances.
CERTS_CATALOG_UDF	Certification	None	Snapshot table for catalog UDF data.
CERTS_ENT_DEFN	Certification	None	Snapshot table for entitlement definitions.
CERTS_POLICY	Certification	None	Snapshot table for policies.
CERTS_POL_ENT_DEFN	Certification	None	Snapshot table for entitlement definitions in policies.
CERTS_ROLE	Certification	None	Snapshot table for roles.
CERTS_USER	Certification	None	Snapshot table for users.
CERTS_USR_UDF	Certification	None	Snapshot table for user UDF data.
CERT_ACTION_HISTORY	Certification	None	Event details for certification action history.
CERT_ACTION_HISTORY_SCOP	Certification	None	Link table defining scope for certification action history events.
E
CERT_CERTS	Certification	None	Certification Instances table.
CERT_CONFIG	Certification	None	Certification configuration table.
CERT_DEFN	Certification	None	Certification definition table.
CERT_EVT_LSNR	Certification	None	Certification event listener definition table.
			List of users requiring certification due to triggering of event
CERT_EVT_TRIG	Certification	None	listener rules.
CERT_LAST_DECISION	Certification	None	Last certification decision for an item.
CERT_TASK_ACTION	Certification	None	Decision table for certification items in a SOA task.
CERT_TASK_INFO	Certification	None	Link for a certification instance to a SOA task.