JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Identity Analytics 11gR1 Database Administrator's Guide
search filter icon
search icon

Document Information

Preface

1.  GlobalUsers Module

2.  Business Structure Module

3.  Resource Types Metadata Module

4.  Accounts Module

5.  Roles Module

6.  Policies Module

7.  Applications Module

8.  Import and Export Module

9.  Event Listener Module

10.  Identity Certification Module

11.  Identity Audit Module

12.  Rule Engine Module

13.  Workflow Module

14.  Scheduling Module

Tables in the Workflow Module

OS_WFENTRY Table

Structure

Indexes

Description

Primary Keys

Foreign Keys

Indexes

OS_CURRENTSTEP Table

Structure

Indexes

Description

Primary Keys

Foreign Keys

Indexes

OS_HISTORYSTEP Table

Structure

Indexes

Description

Primary Keys

Foreign Keys

Indexes

OS_CURRENTSTEP_PREV Table

Structure

Indexes

Description

Primary Keys

Foreign Keys

Indexes

OS_HISTORYSTEP_PREV Table

Structure

Indexes

Description

Primary Keys

Foreign Keys

Indexes

OS_PROPERTYENTRY Table

Structure

Indexes

Description

Primary Keys

Foreign Keys

Indexes

APPROVAL_REQUESTS Table

Structure

Indexes

Description

Primary Keys

Foreign Keys

Indexes

APPROVAL_REQUEST_HISTORY Table

Structure

Indexes

Description

Primary Keys

Foreign Keys

Indexes

ROLE_MATCHING_ANALYSIS Table

Structure

Indexes

Description

Primary Keys

Foreign Keys

Indexes

15.  Reporting Module

16.  Security Module

17.  Miscellaneous Tables

Tables in the Workflow Module

This chapter describes the tables that make up the Oracle Identity Analytics Workflow module.

OS_WFENTRY Table

Structure
OS_WFENTRY
PK
ID
NAME

STATE

CALLER

START_DATE

Indexes
Index
PK
Unique
Keys
PK_WFENTRY
            ✓
ID
Description

The OS_WFENTRY table stores workflow instances, along with the NAME, STATE, CALLER, and START_DATE information for each instance.

Primary Keys

ID - primary key on column ID

Foreign Keys

None

Indexes

None

OS_CURRENTSTEP Table

Structure
OS_CURRENTSTEP
PK
ID
FK
ENTRY_ID

STEP_ID

ACTION_ID

OWNER

START_DATE

FINISH_DATE

DUE_DATE

STATUS

CALLER

Indexes
Index
PK
Unique
Keys
PK_CRTSP
     ✓
ID
FK_CRTSP_WFNTR_ID
ENTRY_ID
Description

The OS_CURRENTSTEP table holds all of the steps for a workflow that is in progress. This table references the OS_WFENTRY table's ID column using ENTRY_ID as foreign key to establish the association.

Primary Keys

PK_CRTSP - primary key on column ID.

Foreign Keys

FK_CRTSP_WFNTR_ID - foreign key on column ENTRY_ID refers to ID column of OS_WFENTRY table.

Indexes

None

OS_HISTORYSTEP Table

Structure
OS_HISTORYSTEP
PK
ID
FK1
ENTRY_ID

STEP_ID

ACTION_ID

OWNER

START_DATE

FINISH_DATE

DUE_DATE

STATUS

CALLER

Indexes
Index
PK
Unique
Keys
PK_HTRSP
     ✓
ID
FK_HSTSTP_FENTR_ID
ENTRY_ID
Description

The OS_HISTORYSTEP table saves the historical steps taken duing a workflow instance. This table references the OS_WFENTRY table's ID column using ENTRY_ID as the foreign key to establish the association.

Primary Keys

PK_HTRSP - primary key on column ID.

Foreign Keys

FK_HSTSTP_FENTR_ID - foreign key on column ENTRY_ID refers to ID column of OS_WFENTRY table.

Indexes

None

OS_CURRENTSTEP_PREV Table

Structure
OS_CURRENTSTEP_PREV
PK,FK1

PK,FK2

ID

PREVIOUS_ID

Indexes
Index
PK
Unique
Keys
PK_CRTSP_PRV
     ✓
ID, PREVIOUS_ID
FK_CRTSP_PRV_HTRSP_ID
PREVIOUS_ID
Description

The OS_CURRENTSTEP_PREV table saves the previous steps taken for a workflow instance that is in progress. It refers to both the OS_CURRENTSTEP and the OS_HISTORYSTEP tables via foreign keys.

Primary Keys

PK_CRTSP_PRV - composite primary key on column ID, PREVIOUS_ID

Foreign Keys

FK_CRSTP_PRV_CRTSP_ID - foreign key on column ID refers to ID column of OS_CURRENTSTEP table.

FK_CRSTP_PRV_HTRSP_ID - foreign key on column PREVIOUS_ID refers to ID column of OS_HISTORYSTEP table.

Indexes

None

OS_HISTORYSTEP_PREV Table

Structure
OS_HISTORYSTEP_PREV
PK,FK1

PK,FK2

ID

PREVIOUS_ID

Indexes
Index
PK
Unique
Keys
PK_HTRSP_PREV
     ✓
ID, PREVIOUS_ID
FK_HTRSP_PREV_ID_HTRSP_ID
PREVIOUS_ID
Description

The OS_HISTORYSTEP_PREV table saves the previous steps trail that is recorded in the OS_HISTORYSTEPS table. It refers to the OS_HISTORYSTEP tables via foreign keys.

Primary Keys

PK_HTRSP_PREV - composite primary key on column ID, PREVIOUS_ID.

Foreign Keys

FK_HTRSP_PREV_HTRSP_ID - foreign key on column ID refers to ID column of OS_HISTORYSTEP table.

FK_HTRSP_PREV_ID_HTRSP_ID - foreign key on column PREVIOUS_ID refers to ID column of OS_HISTORYSTEP table.

Indexes

None

OS_PROPERTYENTRY Table

Structure
OS_PROPERTYENTRY
PK

PK

ITEM_KEY

ENTITY_ID

ENTITY_NAME

ITEM_TYPE

STRING_VALUE

DATE_VALUE

DATA_VALUE

FLOAT_VALUE

NUMBER_VALUE

INTEGER_VALUE

LONG_VALUE

BOOLEAN_VALUE

OBJECT_VALUE

Indexes
Index
PK
Unique
Keys
PK_OS_PROPERTYENTRY
     ✓
ITEM_KEY, ENTITY_ID
Description

The Oracle Identity Analytics workflow engine stores values such as role ID and role version ID in the OS_PROPERTYENTRY table.

Primary Keys

PK_OS_PROPERTYENTRY - Composite primary key on column ITEM_KEY, ENTITY_ID.

Foreign Keys

None

Indexes

None

APPROVAL_REQUESTS Table

Structure
APPROVAL_REQUESTS
PK
ID
REQUESTED_BY

REQUEST_DATE

REQUEST_STATUS

REQUEST_TYPE

WORKFLOW_ID

OBJECT_ID

VERSION_ID

VERSION_NUMBER

OBJECT_NAME

OBJECT_TYPE

Indexes
Index
PK
Unique
Keys
PK_APPROVAL_REQUESTS
     ✓
ID
Description

The APPROVAL_REQUESTS table holds information used during a role approval process. An approval process is initiated when a policy is either added to a role or removed from a role, or a user changes their role membership. An approval process is associated by a role versioning process that maintains a trail of modifications made to a role. The columns VERSION_ID and VERSION_NUMBER refer to the versioning of roles.

Primary Keys

PK_APPROVAL_REQUESTS - composite primary key on columns ID.

Foreign Keys

None

Indexes

None

APPROVAL_REQUEST_HISTORY Table

Structure
APPROVAL_REQUEST_HISTORY
REQUEST_ID

STEP_ID

OBJECT_ID

OBJECT_NAME

OBJECT_TYPE

ACTION

ACTION_DATE

APPROVER

APPROVER_COMMENTS

Indexes
Index
PK
Unique
Keys
IX_APPROVAL_REQUEST_HISTORY
No
REQUEST_ID
Description

The APPROVAL_REQUEST_HISTORY table maintains the history of actions taken during each step of the role versioning and membership approval processes.

Primary Keys

None

Foreign Keys

None

Indexes

IX_APPROVAL_REQUEST_HISTORY - non-unique index on column REQUEST_ID.

ROLE_MATCHING_ANALYSIS Table

Structure
ROLE_MATCHING_ANALYSIS
PK
APPROVAL_REQUEST_ID
RESULTXML
Indexes
Index
PK
Unique
Keys
PK_ROLE_MATCHING_ANALYSIS
     ✓
APPROVAL_REQUEST_ID
Description

When a role is modified in Oracle Identity Analytics, either because a policy was added or removed, or because there was a change in role membership, the modified role is compared with the existing roles in the system. The APPROVAL_REQUEST_ID column associates the ROLE_MATCHING_ANALYSIS table with the APPROVAL_REQUESTS table while the analysis result is saved in the resultXml column in XML format.

Primary Keys

PK_ROLE_MATCHING_ANALYSIS - primary key on columns APPROVAL_REQUEST_ID.

Foreign Keys

None

Indexes

None