Tables in the Business Structure Module

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

BUSINESSUNITS Table

Structure

BUSINESSUNITS PK BUSINESSUNITKEY BUSINESSUNITNAME MAINPHONE OTHERPHONE FAX EMAIL WEBSITE STREET1 STREET2 STREET3 CITY STATEORPROVINCE ZIPORPOSTALCODE COUNTRYORREGION DIVISION CREATEUSER UPDATEUSER CREATEDATE UPDATEDATE BUSINESSUNITTYPE BUSINESSUNITOWNER BUSINESSUNITADMINISTRATOR BUSINESSUNITCODE BUSINESSUNITDESCRIPTION MAILCODE SERVICEDESKTICKETNUMBER STATUSKEY BUSINESSUNITMANAGERS

Indexes

Index PK Unique Keys PK_BUSINESSUNITS      ✓ Yes BUSINESSUNITKEY

Description

The various departments in an organization are listed as Business Units in Oracle Identity Analytics. Each Business Unit has users associated with it, similar to users listed in a department. The BUSINESSUNITS table in Oracle Identity Analytics carries the information for the various departments in an organization. A unique BUSINESSUNITKEY identifies each business unit.

The various fields listed under the table provide more information on the business units such as the BUSINESSUNITNAME, PHONE, EMAIL, WEBSITE, CITY, STATE, and ZIP. For audit purposes, the Business Unit's creation time, the user who created the business unit, the update time, and the user who updated the Business unit are noted. Each Business unit is assigned an owner and this information is stored in the BUSINESSUNITOWNER field. In addition, there are various business unit managers who are assigned to each business unit and they are entered in the BUSINESSUNITMANAGERS field. These managers can be stored in a comma-separated format. If a Business Unit has an Administrator, the Administrator can be assigned in the BUSINESSUNITADMINISTRATOR field.

Primary Keys

PK_ BUSINESSUNITS - primary key on column BUSINESSUNITKEY

Foreign Keys

None

Indexes

None

BU_GLOBALUSERS Table

Structure

BU_GLOBALUSERS PK PK BUSINESSUNITKEY GLOBALUSERKEY

Indexes

Index PK Unique Keys PK_BU_GLOBALUSERS      ✓ Yes BUSINESSUNITKEY, GLOBALUSERKEY IX_BU_GLOBALUSERS_BUID No BUSINESSUNITKEY IX_BU_GLOBALUSERS_GUID No GLOBALUSERKEY

Description

The association between a user and Business Unit is shown in a derived table, BU_GLOBALUSERS. This table carries the BUSINESSUNITKEY and GLOBALUSERKEY.

Primary Keys

PK_BU_GLOBALUSERS - composite primary key on columns BUSINESSUNITKEY and GLOBALUSERKEY

Foreign Keys

None

Indexes

IX_BU_GLOBALUSERS_BUID - non-unique index on column BUSINESSUNITKEY

IX_BU_GLOBALUSERS_GUID - non-unique index on column GLOBALUSERKEY

BU_ROLES Table

Structure

BU_ROLES PK PK PK BUSINESSUNITKEY ROLEKEY ROLE_VERSION_ID

Indexes

Index PK Unique Keys PK_BU_ROLES      ✓ Yes BUSINESSUNITKEY, ROLEKEY, ROLE_VERSION_ID

Description

The association between a role and the Business Unit is shown in a derived table, BU_ROLES. The fields BUSINESSUNITKEY and ROLEKEY are used to reference the BUSINESSUNITS and ROLES tables respectively.

Primary Keys

PK_BU_ROLES - composite primary key on columns BUSINESSUNITKEY and ROLEKEY

Foreign Keys

None

Indexes

None

BU_POLICIES Table

Structure

BU_POLICIES PK PK PK BUSINESSUNITKEY POLICYKEY POLICY_VERSION_ID

Indexes

Index PK Unique Keys PK_BU_POLICIES      ✓ Yes BUSINESSUNITKEY, POLICYKEY, POLICY_VERSION_ID

Description

The association between a policy and the Business Unit is shown in a derived table, BU_POLICIES. The fields BUSINESSUNITKEY and POLICYKEY are used to reference the BUSINESSUNITS and POLICIES tables respectively.

Primary Keys

PK_BU_POLICIES - composite primary key on columns BUSINESSUNITKEY, POLICYKEY, and POLICY_VERSION_ID

Foreign Keys

None

Indexes

None

BUHIERARCHY Table

Structure

BUHIERARCHY PK PK BUSINESSUNITKEY PARENTBUSINESSUNITKEY

Indexes

Index PK Unique Keys PK_BUHIERARCHY      ✓ Yes BUSINESSUNITKEY, PARENTBUSINESSUNITKEY

Description

The various Business Units in Oracle Identity Analytics can be represented in a hierarchical format and the hierarchy is represented in the BUHIERACHY table. Each Business Unit has a Parent Business Unit associated with it and this is represented in the PARENTBUSINESSUNITKEY column.

Primary Keys

PK_BUHIERARCHY - composite primary key on columns BUSINESSUNITKEY and PARENTBUSINESSUNITKEY

Foreign Keys

None

Indexes

None

BUSINESSUNITSTATUSES Table

Structure

BUSINESSUNITSTATUSES PK STATUSKEY LABEL

Indexes

Index PK Unique Keys PK_BUSINESSUNITSTATUSES      ✓ Yes STATUSKEY

Description

A Business Unit in Oracle Identity Analytics can be listed as Active / Inactive and these statuses are listed under the BUSINESSUNITSTATUSES table.

Primary Keys

PK_BUSINESSUNITSTATUSES - primary key on column STATUSKEY

Foreign Keys

None

Indexes

None