Skip Navigation Links | |
Exit Print View | |
Oracle Identity Analytics 11gR1 Database Administrator's Guide |
This chapter describes the tables that make up the Oracle Identity Analytics Workflow module.
|
|
The OS_WFENTRY table stores workflow instances, along with the NAME, STATE, CALLER, and START_DATE information for each instance.
ID - primary key on column ID
None
None
|
|
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.
PK_CRTSP - primary key on column ID.
FK_CRTSP_WFNTR_ID - foreign key on column ENTRY_ID refers to ID column of OS_WFENTRY table.
None
|
|
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.
PK_HTRSP - primary key on column ID.
FK_HSTSTP_FENTR_ID - foreign key on column ENTRY_ID refers to ID column of OS_WFENTRY table.
None
|
|
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.
PK_CRTSP_PRV - composite primary key on column ID, PREVIOUS_ID
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.
None
|
|
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.
PK_HTRSP_PREV - composite primary key on column ID, PREVIOUS_ID.
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.
None
|
|
The Oracle Identity Analytics workflow engine stores values such as role ID and role version ID in the OS_PROPERTYENTRY table.
PK_OS_PROPERTYENTRY - Composite primary key on column ITEM_KEY, ENTITY_ID.
None
None
|
|
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.
PK_APPROVAL_REQUESTS - composite primary key on columns ID.
None
None
|
|
The APPROVAL_REQUEST_HISTORY table maintains the history of actions taken during each step of the role versioning and membership approval processes.
None
None
IX_APPROVAL_REQUEST_HISTORY - non-unique index on column REQUEST_ID.
|
|
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.
PK_ROLE_MATCHING_ANALYSIS - primary key on columns APPROVAL_REQUEST_ID.
None
None