Monday, April 5, 2010

OIM Tables Descriptions

Note: Custom Tables are created for user defined Object / Process Forms.

TABLE NAME IN OIM

DESCRIPTION OF TABLE

AAD

List To Define The Administrators For Each Organization And Their Delegated Admin Privileges

AAP

Table for storing Resource - Organization level parameter Values

ACP

ACP - Link Table That Holds Reference To ACT And PKG Tables, Table That Defines The Objects (Resources) Allowed For A Particular Organization

ACS

Link Table for Account Table(ACT) and Server Table(SVR)

ACT

Defines information about all organizations created through Xellerate

ADJ

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.

ADL

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

ADM

Data mapping between parameters input/output parameters and source/sink

ADP

Defines an adapter created through the Adapter Factory

ADS

Database,schema and procedure name selections which define a stored procedure adaptertask

ADT

Defines a task attached to an adapter

ADU

Contains the web service and method chosen for a task of the Adapter Factory

ADV

Adapter variable table contains variables that have been created for specific adapters.

AFM

Links an adapter with a form

AGS

Holds the definition of organization/contact groups

AOA

Contains the OpenAdapter property file for OpenAdapter

APA

To store attestation process administrators

APD

To store attestation Process definition

APT

To store the attestation tasks

ARS

Contains custom response codes for 'Process Task' Adapters only

ATD

To store entitlement details for each attestation task

ATP

Defines input and output parameters for the constructor and method of an adapter taskof type JAVA, UTILITY, TAME, REMOTE, and XLAPI

ATR

To store attestation requests

ATS

Stores which services or can be ordered by which organizations and which rates apply

AUD

Define the Auditors

AUD_JMS

 

CRT

Trusted Certificate Information

DAV

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

Dependencies among Tasks Within A Workflow Process

DOB

Data Resource definition consisting of the fully qualified class name of the dataobject

DVT

Defines the one to many relationship between Data Resources and Event Handlers (this includes adapters)

EIF

Export Import Files. Each row contains one single file used in export/import operation. For export there is only one file

EIH

Export Import History. Each row represents one Data Deployment Management session.

EIL

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

EIO

Export Import Objects. Each row represents one object exported/imported

EIS

Substitutions used during import process

EMD

Core --Email Definition Information Table That Holds The Email Template Definitions

ERR

Error codes

ESD

Encrypted columns not within the bounds of the SDK

EVT

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)

FUG

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

GPG

List to define the (nested) group members of User Group in the 'User Group' form.

GPP

List to define the Administrators and their delegated admin rights over a User Group

GPY

Joins Properties (PTY) and Groups (UGP).

IEI

Table where all the imports and exports are defined

LAY

Table where the layouts are defined for the various imports and exports

LIT

Import/export table.

LKU

Lookup definition entries

LKV

Lookup values

LOB

Import/export table.

LOC

Holds information about locations

MAP

XML MapSchema Information

MAV

Stores the runtime data mappings for 'Process Task' adapters. The data source being a process form, Location, User, Organization, Process, IT Resource, orLiteral data.

MEV

E-mail notification events

MIL

Holds information about tasks of a process

MSG

Defines the user groups that have permission to set the status of a process task.

MST

Task Status And Object Status Information. Holds All The Task Status To Object Status Mappings

OBA

Object Authorizer Information

OBD

Object Dependencies

OBI

Object Instance Information

OBJ

Resource Object definition information.

ODF

Holds Object To Process Form Data Flow Mappings.

ODV

Object Events/Adapters Information

OIO

Object Instance Request Target Organization Information.

OIU

Object Instance Request Target User Information.

OOD

Object Instance Request Target Organization Dependency Information.

ORC

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

Holds information that is necessary to complete an order regardless of a processbeing ordered

ORF

Resource Reconciliation Fields

ORR

Object Reconciliation Action Rules

OSH

Task Instance Assignment History

OSI

Holds information about tasks that are created for an order

OST

Object Status Information

OUD

Object Instance Request Target User Dependency Information. Holds The Dependency Between Different Resource Instances Provisioned To A User.

OUG

List to define the administrators for each Resource

PCQ

Holds the challenging questions and answers for a user

PDF

Package data flow table holds the data flow relationships between packages

PHO

Holds all communication addresses for this contact -- e.g., contact telephone numbers,fax numbers, e-mail, etc.

PKD

Package dependency table holds the dependency relationships between child packages of a parent package

PKG

Consists of names and system keys of service processes, which consist of a group ofservices from the TOS table. Defines a Process in Xellerate.

PKH

Package Hierarchy Table Holds The Parent-child Relationships Between Processes

POC

Stores values for the child tables of the Object/Process form of a resource being provisioned by an access policy

POF

Policy field table holds the field value pairs that constitute the definition of apolicy

POG

Join table between Policy and User Groups, Specifies the groups to whom an access policy will apply.

POL

Policy Table Holds A Policy, Defines An Access Policy In The System

POP

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

Process Reconciliation Field Mappings

PRO

Defines a process name, scheduling frequency, and priority. A process is made up of oneor more tasks

PTY

Client Properties Table

PUG

List to define The Administrators And Their Delegated Admin Rights For Each Process.

PWR

Table forPassword Rule Policies

PXD

Table that holds the list of all Proxies Defined

QUE

Administrative queues definition

QUM

Administrative queue members

RAV

Stores the runtime data mappings for 'Pre-populate' adapters. The data source being an Xellerate form or child table, or a user defined form

RCA

Reconciliation Event Organizations Matched

RCB

Reconciliation Event Invalid Data

RCD

Reconciliation Event Data

RCE

Reconciliation Events

RCH

Reconciliation Event Action History

RCM

Reconciliation Event Multi-Valued Attribute Data

RCP

Reconciliation Event Processes Matched

RCU

Reconciliation Event Users Matched

REP

Table that contains all information about reports in the system

REQ

This table holds request information

RES

This table is used to stored adapter resources entered by the user.

RGM

Table for Response Code Generated Milestones

RGP

Rules To Apply To A User Group, Defines The Auto-group Membership Rules Attached To AParticular Group.

RGS

Defines all known registries. These are used by Web Service tasks in an Adapter to communicate with a web service

RIO

Request Organizations Resolved Object Instances

RIU

Request Users Resolved Object Instances

RLO

This table contains directory URLs which are referenced by Adapter Factoryjar/class files.

RML

Rules To Apply To Task, Defines The Task Assignment Rules Attached To A Process Task.

ROP

Rules To Apply To An Object-process Pair, Defines The Process Determination Rules Attached To A Resource Object.

RPC

Reconciliation Event Process Child Table Matches

RPG

Link table between Group table and Report Table. Specifies which group has accessto which reports

RPP

Parameters passed to report.

RPT

Stores information related to the creation of reports

RPW

Rules To Apply To A Password Policy, Defines The Policy Determination Rules Attached To A Password Policy.

RQA

Request target organization information.

RQC

Request comment information

RQD

Contains self-registration request data for web admin.

RQE

Request administrative queues

RQH

Requeststatus history

RQO

Request object information.

RQU

Request object target user information

RQY

Request Organizations Requiring Resolution

RQZ

Request Users Requiring Resolution

RRE

Reconciliation User Matching Rule Elements

RRL

Reconciliation User Matching Rules

RRT

Reconciliation User Matching Rule Element Properties

RSC

Defines the All The Possible Response Code For A Process Task.

RUE

Defines the Elements In A Rule Definition.

RUG

List to define the administrators for each Request

RUL

Rule definitions

RVM

Holds Recovery Milestones

SCH

Holds specific information about an instance of a ask such as its status orscheduled dates

SDC

Column metadata.

SDH

Meta-Table Hierarchy.

SDK

User define data object meta data definition

SDL

SDK version labels

SDP

User defined column properties

SEL

Data Object Permissions For Groups On A Specified Data object

SIT

The SIT table contains information about sites. Sites are subsets of locations.

SPD

IT Resource parameter definition

SRE

Defines Which Pre-populate Rule Generator Will Run For A Field Of User Defined DataObject.

SRP

Should be replaced by the rate table from a billing system. Here it holdspecific rates for specific services.

SRS

IT Resource - IT Resource join

STA

Status Codes

SUG

 

SVD

IT Resource type definition

SVP

IT Resource property definition

SVR

IT Resource instance definition

SVS

IT Resource - Site Join

TAP

Holds parameter values for a task, which is an instantiation of Valid Task,i.e. value for parameter Company Name, etc.

TAS

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

TDV

Used by event manager/data objects, joins data objects, types of service, and events

TLG

Keeps logof SQL transactions.

TMP

Indicates which tasks are in a process. Tasks are defined in table; this way, one task can be in many processes.

TOD

To do list settings table.

TOS

Holds information about a process

TSA

Stores initialization params (name/value pairs) forscheduler tasks

TSK

Scheduler task definition information

UDP

User-defined field table

UGP

Defines a group of users

UHD

User Policy Profile History Details table

ULN

This table hold UHD allow / deny list

UNM

"UnDoMilestone" Feature

UPA

 

UPA_FIELDS

Stores changes only for user profile audit history in de-normalized format

UPA_GRP_MEMBERSHIP

Stores groups membership history in de-normalized format

UPA_RESOURCE

Stores user profile resource history in de-normalized format

UPA_USR

Stores user profile history in de-normalized format

UPD

User Policy Profile Details table

UPH

User Policy Profile History table

UPL

User-defined field table

UPP

User Policy Profile table

UPT

User-defined field table

UPY

Joins Properties (PTY) and User (USR) tables.

USG

This table stores which users are in which groups.

USR

Stores all information regarding a user.

UWP

Window sequence, nesting in CarrierBase explorer for each user group.

VTK

Defines automation task types such as reports, imports, and exports.

VTP

Valid Task Parameters. Indicates which parameters can be defined for an instance of a task.

WIN

Windows table: Windows keys, descriptions, and class names.

XSD

This table holds Xellerate System Data