Note: Custom Tables are created for user defined Object / Process Forms.
TABLE NAME IN OIM
DESCRIPTION OF TABLE
List To Define The Administrators For Each Organization And Their Delegated Admin Privileges
Table for storing Resource - Organization level parameter Values
ACP - Link Table That Holds Reference To ACT And PKG Tables, Table That Defines The Objects (Resources) Allowed For A Particular Organization
Link Table for Account Table(ACT) and Server Table(SVR)
Defines information about all organizations created through Xellerate
Contains the Java API information for the constructor with parameters and method name with parameters chosen for an adapter task of type JAVA, UTILITY, TAME,REMOTE, or XLAPI.
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 LOGICTASKS
Data mapping between parameters input/output parameters and source/sink
Defines an adapter created through the Adapter Factory
Database,schema and procedure name selections which define a stored procedure adaptertask
Defines a task attached to an adapter
Contains the web service and method chosen for a task of the Adapter Factory
Adapter variable table contains variables that have been created for specific adapters.
Links an adapter with a form
Holds the definition of organization/contact groups
Contains the OpenAdapter property file for OpenAdapter
To store attestation process administrators
To store attestation Process definition
To store the attestation tasks
Contains custom response codes for 'Process Task' Adapters only
To store entitlement details for each attestation task
Defines input and output parameters for the constructor and method of an adapter taskof type JAVA, UTILITY, TAME, REMOTE, and XLAPI
To store attestation requests
Stores which services or can be ordered by which organizations and which rates apply
Define the Auditors
Trusted Certificate Information
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.
Dependencies among Tasks Within A Workflow Process
Data Resource definition consisting of the fully qualified class name of the dataobject
Defines the one to many relationship between Data Resources and Event Handlers (this includes adapters)
Export Import Files. Each row contains one single file used in export/import operation. For export there is only one file
Export Import History. Each row represents one Data Deployment Management session.
DB Based lock for export operation. Used to make sure only one user can import at atime. This is currently not managed through data objects
Export Import Objects. Each row represents one object exported/imported
Substitutions used during import process
Core --Email Definition Information Table That Holds The Email Template Definitions
Encrypted columns not within the bounds of the SDK
Defines event handlers by providing a 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)
List to define the administrators for each user defined object in the 'StructureUtility' form or for each user defined field in the 'User Defined FieldDefinition' form
List to define the (nested) group members of User Group in the 'User Group' form.
List to define the Administrators and their delegated admin rights over a User Group
Joins Properties (PTY) and Groups (UGP).
Table where all the imports and exports are defined
Table where the layouts are defined for the various imports and exports
Lookup definition entries
Holds information about locations
XML MapSchema Information
Stores the runtime data mappings for 'Process Task' adapters. The data source being a process form, Location, User, Organization, Process, IT Resource, orLiteral data.
E-mail notification events
Holds information about tasks of a process
Defines the user groups that have permission to set the status of a process task.
Task Status And Object Status Information. Holds All The Task Status To Object Status Mappings
Object Authorizer Information
Object Instance Information
Resource Object definition information.
Holds Object To Process Form Data Flow Mappings.
Object Events/Adapters Information
Object Instance Request Target Organization Information.
Object Instance Request Target User Information.
Object Instance Request Target Organization Dependency Information.
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
Holds information that is necessary to complete an order regardless of a processbeing ordered
Resource Reconciliation Fields
Object Reconciliation Action Rules
Task Instance Assignment History
Holds information about tasks that are created for an order
Object Status Information
Object Instance Request Target User Dependency Information. Holds The Dependency Between Different Resource Instances Provisioned To A User.
List to define the administrators for each Resource
Holds the challenging questions and answers for a user
Package data flow table holds the data flow relationships between packages
Holds all communication addresses for this contact -- e.g., contact telephone numbers,fax numbers, e-mail, etc.
Package dependency table holds the dependency relationships between child packages of a parent package
Consists of names and system keys of service processes, which consist of a group ofservices from the TOS table. Defines a Process in Xellerate.
Package Hierarchy Table Holds The Parent-child Relationships Between Processes
Stores values for the child tables of the Object/Process form of a resource being provisioned by an access policy
Policy field table holds the field value pairs that constitute the definition of apolicy
Join table between Policy and User Groups, Specifies the groups to whom an access policy will apply.
Policy Table Holds A Policy, Defines An Access Policy In The System
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.
Process Reconciliation Field Mappings
Defines a process name, scheduling frequency, and priority. A process is made up of oneor more tasks
Client Properties Table
List to define The Administrators And Their Delegated Admin Rights For Each Process.
Table forPassword Rule Policies
Table that holds the list of all Proxies Defined
Administrative queues definition
Administrative queue members
Stores the runtime data mappings for 'Pre-populate' adapters. The data source being an Xellerate form or child table, or a user defined form
Reconciliation Event Organizations Matched
Reconciliation Event Invalid Data
Reconciliation Event Data
Reconciliation Event Action History
Reconciliation Event Multi-Valued Attribute Data
Reconciliation Event Processes Matched
Reconciliation Event Users Matched
Table that contains all information about reports in the system
This table holds request information
This table is used to stored adapter resources entered by the user.
Table for Response Code Generated Milestones
Rules To Apply To A User Group, Defines The Auto-group Membership Rules Attached To AParticular Group.
Defines all known registries. These are used by Web Service tasks in an Adapter to communicate with a web service
Request Organizations Resolved Object Instances
Request Users Resolved Object Instances
This table contains directory URLs which are referenced by Adapter Factoryjar/class files.
Rules To Apply To Task, Defines The Task Assignment Rules Attached To A Process Task.
Rules To Apply To An Object-process Pair, Defines The Process Determination Rules Attached To A Resource Object.
Reconciliation Event Process Child Table Matches
Link table between Group table and Report Table. Specifies which group has accessto which reports
Parameters passed to report.
Stores information related to the creation of reports
Rules To Apply To A Password Policy, Defines The Policy Determination Rules Attached To A Password Policy.
Request target organization information.
Request comment information
Contains self-registration request data for web admin.
Request administrative queues
Request object information.
Request object target user information
Request Organizations Requiring Resolution
Request Users Requiring Resolution
Reconciliation User Matching Rule Elements
Reconciliation User Matching Rules
Reconciliation User Matching Rule Element Properties
Defines the All The Possible Response Code For A Process Task.
Defines the Elements In A Rule Definition.
List to define the administrators for each Request
Holds Recovery Milestones
Holds specific information about an instance of a ask such as its status orscheduled dates
User define data object meta data definition
SDK version labels
User defined column properties
Data Object Permissions For Groups On A Specified Data object
The SIT table contains information about sites. Sites are subsets of locations.
IT Resource parameter definition
Defines Which Pre-populate Rule Generator Will Run For A Field Of User Defined DataObject.
Should be replaced by the rate table from a billing system. Here it holdspecific rates for specific services.
IT Resource - IT Resource join
IT Resource type definition
IT Resource property definition
IT Resource instance definition
IT Resource - Site Join
Holds parameter values for a task, which is an instantiation of Valid Task,i.e. value for parameter Company Name, etc.
Holds instances of Valid Task. Examples of Valid Tasks would be reports, imports, etc. Valid TaskParameters indicate what parameters can be assassigned to an instance of a task, i.e
Used by event manager/data objects, joins data objects, types of service, and events
Keeps logof SQL transactions.
Indicates which tasks are in a process. Tasks are defined in table; this way, one task can be in many processes.
To do list settings table.
Holds information about a process
Stores initialization params (name/value pairs) forscheduler tasks
Scheduler task definition information
User-defined field table
Defines a group of users
User Policy Profile History Details table
This table hold UHD allow / deny list
Stores changes only for user profile audit history in de-normalized format
Stores groups membership history in de-normalized format
Stores user profile resource history in de-normalized format
Stores user profile history in de-normalized format
User Policy Profile Details table
User Policy Profile History table
User-defined field table
User Policy Profile table
User-defined field table
Joins Properties (PTY) and User (USR) tables.
This table stores which users are in which groups.
Stores all information regarding a user.
Window sequence, nesting in CarrierBase explorer for each user group.
Defines automation task types such as reports, imports, and exports.
Valid Task Parameters. Indicates which parameters can be defined for an instance of a task.
Windows table: Windows keys, descriptions, and class names.
This table holds Xellerate System Data