Skip Navigation Links | |
Exit Print View | |
Oracle Identity Analytics 11gR1 Database Administrator's Guide |
3. Resource Types Metadata Module
This chapter describes the tables that make up the Oracle Identity Analytics Business Structure module.
|
|
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.
PK_ BUSINESSUNITS - primary key on column BUSINESSUNITKEY
None
None
|
|
The association between a user and Business Unit is shown in a derived table, BU_GLOBALUSERS. This table carries the BUSINESSUNITKEY and GLOBALUSERKEY.
PK_BU_GLOBALUSERS - composite primary key on columns BUSINESSUNITKEY and GLOBALUSERKEY
None
IX_BU_GLOBALUSERS_BUID - non-unique index on column BUSINESSUNITKEY
IX_BU_GLOBALUSERS_GUID - non-unique index on column GLOBALUSERKEY
|
|
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.
PK_BU_ROLES - composite primary key on columns BUSINESSUNITKEY and ROLEKEY
None
None
|
|
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.
PK_BU_POLICIES - composite primary key on columns BUSINESSUNITKEY, POLICYKEY, and POLICY_VERSION_ID
None
None
|
|
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.
PK_BUHIERARCHY - composite primary key on columns BUSINESSUNITKEY and PARENTBUSINESSUNITKEY
None
None
|
|
A Business Unit in Oracle Identity Analytics can be listed as Active / Inactive and these statuses are listed under the BUSINESSUNITSTATUSES table.
PK_BUSINESSUNITSTATUSES - primary key on column STATUSKEY
None
None