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

Tables in the Event Listener Module

EVENT_LISTENERS Table

Structure

Index

Description

Primary Keys

Foreign Keys

Indexes

EVENT_TRIGGER_DATA Table

Structure

Index

Description

Primary Keys

Foreign Keys

Indexes

OBJECT_MODIFICATIONS Table

Structure

Index

Description

Primary Keys

Foreign Keys

Indexes

10.  Identity Certification Module

11.  Identity Audit Module

12.  Rule Engine Module

13.  Workflow Module

14.  Scheduling Module

15.  Reporting Module

16.  Security Module

17.  Miscellaneous Tables

Tables in the Event Listener Module

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

EVENT_LISTENERS Table

Structure
REPORTS
PK
ID
LISTENERNAME

LISTENER_DESCRIPTION

LISTENER_STATUS_ID

LISTENER_CONDITION

DATA_XML

Index
Index
PK
Unique
Keys
PK_EVENT_LISTENERS
     ✓
Yes
ID
Description

The EVENT_LISTENERS table is the primary table for the event listener module. It stores event listener data defined in Oracle Identity Analytics and identified by a unique ID. In addition, condition and action information is saved in the LISTENER_CONDITION and DATA_XML fields respectively.

Primary Keys

PK_EVENT_LISTENERS - primary key on column ID

Foreign Keys

None

Indexes

None

EVENT_TRIGGER_DATA Table

Structure
REPORT_DEFINITIONS
PK

PK

PK

PK

EVENTLISTENER_ID

ACTION_TYPE

OBJECTMODIFICATION_ID

OBJECT_TYPE

Index
Index
PK
Unique
Keys
PK_EVENT_TRIGGER_DATA
     ✓
Yes
EVENTLISTENER_ID, ACTION_TYPE,

OBJECTMODIFICATION_ID, OBJECT_TYPE

Description

The EVENT_TRIGGER_DATA table stores data about each action that is configured with a listener and defined in the EVENT_LISTENERS table. Details about the type of action and the object to be modified are stored in this table.

Primary Keys

PK_EVENT_TRIGGER_DATA - composite primary key on columns EVENTLISTENER_ID, ACTION_TYPE, OBJECTMODIFICATION_ID, OBJECT_TYPE

Foreign Keys

None

Indexes

None

OBJECT_MODIFICATIONS Table

Structure
REPORT_DESIGNS
PK
ID
OBJECT_ID

OBJECT_TYPE

DATA_XML

Index
Index
PK
Unique
Keys
PK_OBJECT_MODIFICATIONS
     ✓
ID
Description

The OBJECT_MODIFICATIONS table stores objects that have been modified in the system. Every object under modification is identified by a unique ID. Additional information about the object is stored in the DATA_XML column.

Primary Keys

PK_OBJECT_MODIFICATIONS - primary key on column ID

Foreign Keys

None

Indexes

None