Skip Headers
Oracle® Warehouse Builder API and Scripting Reference
11g Release 1 (11.1)

Part Number B31279-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

2 Public Views for the Design Environment

The Warehouse Builder provides a set of pre-built views for both the design and runtime environments. These views are called the Warehouse Builder public views and are the API alternative to using the Repository Browser described in the Oracle Warehouse Builder User's Guide .

Use these views to access to metadata and data stored in Warehouse Builder repositories. This chapter contains a catalog of the public views to the design environment.

Warehouse Builder Design Repository Public Views

The design repository contains all of the design metadata. Use these public views to access data about the design of your system. These views are used by Warehouse Builder Browser to provide metadata reporting.

General Model Views

Data Model Views

Flat Files Views

Collections Views

Function Model Views

Configuration Model Views

Deployment Model Views

Mapping Model Views

Process Flow Model Views

Data Profiling Views

Data Rules Views

User Defined Object Views

Expert Views

Business Intelligence Views

Real Time Views

Scheduling Views

Security Views

Others

Note:

In addition to the listed views, Warehouse Builder also contains the public view ALL_IV_TABLE_FUNC_PROPERTIES, which is now obsolete.

General Model Views

Table 2-1 ALL_IV_ALL_OBJECTS

Column Name Data Type Description

OBJECT_ID

NUMBER(9)

ID of the object

OBJECT_UOID

VARCHAR2(255)

UOID of the object

OBJECT_TYPE

VARCHAR2(4000)

Type of the object

OBJECT_NAME

VARCHAR2(4000)

Physical name of the object

BUSINESS_NAME

VARCHAR2(4000)

Business name of the object

CONTEXT_NAME

VARCHAR2(4000)

Name of the object, prefixed with its module's name, and project's name if it existed

DESCRIPTION

VARCHAR2(4000)

Description of the object

PARENT_OBJECT_ID

NUMBER(9)

Container object ID for the object. Container object could be a module, for example, for a dimension, or a table for a column

PARENT_OBJECT_TYPE

VARCHAR2(4000)

Type of the parent object

PARENT_OBJECT_NAME

VARCHAR2(4000)

Name of the parent object

IS_VALID

VARCHAR2(13)

Is the object valid? Applicable for only those objects that can be validated

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-2 ALL_IV_OBJECTS

Column Name Data Type Description

OBJECT_ID

NUMBER(9)

ID of the object (the difference between this view and ALL_IV_ALL_OBJECTS is that it includes all objects in this view, PLUS all archived snapshot objects (for MCM service))

OBJECT_TYPE

VARCHAR2(4000)

Type of the object

OBJECT_NAME

VARCHAR2(4000)

Physical name of the object

BUSINESS_NAME

VARCHAR2(4000)

Business name of the object

DESCRIPTION

VARCHAR2(4000)

Description of the object

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-3 ALL_IV_OBJECT_PROPERTIES

Column Name Data Type Description

OBJECT_ID

NUMBER(9)

ID of the object

OBJECT_TYPE

VARCHAR2(4000)

Type of the object

OBJECT_NAME

VARCHAR2(255)

Physical name of the object

PROPERTY_ID

NUMBER(9)

ID of the object's property

PROPERTY_NAME

VARCHAR2(255)

ID of the property name

PROPERTY_VALUE

VARCHAR2(4000)

Value of the property


Table 2-4 ALL_IV_MLS_OBJECTS

Column Name Data Type Description

OBJECT_ID

NUMBER(9)

ID of the object (covers the same set as ALL_IV_OBJECTS)

LANGUAGE_ID

VARCHAR2(255)

ID of the language (predefined internally by Warehouse Builder). To get language name, join this view with ALL_IV_SUPPORTED_LANGUAGES

BUSINESS_NAME

VARCHAR2(4000)

Business name of the object

DESCRIPTION

VARCHAR2(4000)

Description of the object


Table 2-5 ALL_IV_SUPPORTED_LANGUAGES

Column Name Data Type Description

LANGUAGE_ID

VARCHAR2(255)

ID of the language

LANGUAGE_NAME

VARCHAR2(64)

Name of the language

ISBASELANGUAGE

VARCHAR2(1)

Is it a base language (for example, EN or FR)


Table 2-6 ALL_IV_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project that this module belongs to

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the module

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of the module

SCHEMA_ID

NUMBER(9)

ID of the module (repeated column, just to keep backward compatibility)

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

BUSINESS_NAME

VARCHAR2(4000)

Business name of the module

DESCRIPTION

VARCHAR2(4000)

Description of the module

STATUS

VARCHAR2(40)

Module status (dev, QA, prod)

IS_VALID

VARCHAR2(13)

Is this module valid

LOCATION_ID

NUMBER(9)

ID of the associated location for this module

LOCATION_NAME

VARCHAR2(255)

Name of associated location for this module

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-7 ALL_IV_PROJECTS

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

BUSINESS_NAME

VARCHAR2(4000)

Business name of the project

DESCRIPTION

VARCHAR2(4000)

Description of the project

VERSION_LABEL

VARCHAR2(255)

Version of the project

IS_VALID

VARCHAR2(13)

Is this project valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-8 ALL_IV_INFORMATION_SYSTEMS

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project that this module belongs to

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the module

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of the module

INFORMATION_SYSTEM_TYPE

VARCHAR2(4000)

Type of the module

BUSINESS_NAME

VARCHAR2(4000)

Business name of the module

DESCRIPTION

VARCHAR2(4000)

Description of the module

PRODUCT_TYPE

VARCHAR2(255)

Application type of the module (for example, Oracle apps, or File based apps)

SYSTEM_TYPE

VARCHAR2(255)

Type of system that holds this application (shown by PRODUCT_TYPE)

VERSION_LABEL

NUMBER(9)

Version of the module

VENDOR

VARCHAR2(40)

Vendor name

DATABASE_LINK

VARCHAR2(40)

Name of the database link that physical points to data storage of this module. It is meaningful only for database applications

INTEGRATOR_NAME

VARCHAR2(255)

The name of Warehouse Builder integrator component that is used to access external data source for the module

IS_VALID

VARCHAR2(13)

Is this module valid

LOCATION_ID

NUMBER(9)

ID of the associated location for this module

LOCATION_NAME

VARCHAR2(255)

Physical name of the associated location

STATUS

VARCHAR2(17)

Status (dev, QA, or prod)

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-9 ALL_IV_INSTALLATIONS

Column Name Data Type Description

INSTALLATION_ID

NUMBER(9)

ID of the Warehouse Builder repository

INSTALLATION_NAME

VARCHAR2(255)

Physical name of the Warehouse Builder repository

BUSINESS_NAME

VARCHAR2(4000)

Business name of the Warehouse Builder repository

DESCRIPTION

VARCHAR2(4000)

Description of the Warehouse Builder repository

INSTALLED_VERSION

VARCHAR2(40)

Version of the Warehouse Builder repository

RELEASE

VARCHAR2(40)

Version of the Warehouse Builder Client

REPOSITORY_MODEL_VERSION

NUMBER(9)

Version of the Warehouse Builder model

PUBLIC_VIEW_VERSION

CHAR(5)

Version of the Warehouse Builder public views

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-10 ALL_IV_FILE_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project that this module belongs to

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of this file module

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of this file module

BUSINESS_NAME

VARCHAR2(4000)

Business name of this file module

DESCRIPTION

VARCHAR2(4000)

Description of this file module

PRODUCT_TYPE

VARCHAR2(255)

Application type of the module (for example, Oracle apps, or File based apps)

SYSTEM_TYPE

VARCHAR2(255)

Type of system that holds this application (represented by PRODUCT_TYPE)

VERSION_LABEL

NUMBER(9)

Version of the module

VENDOR

VARCHAR2(40)

Vendor name

DATABASE_LINK

VARCHAR2(40)

Name of the database link that physical points to data storage of this module. It is meaningful only for database applications

DIRECTORY

VARCHAR2(4000)

Name of the directory this file module connects to

INTEGRATOR_NAME

VARCHAR2(255)

The name of Warehouse Builder integrator component that is used to access external file system for the module

IS_VALID

VARCHAR2(13)

Is this module valid

LOCATION_ID

NUMBER(9)

ID of the associated location for this module

LOCATION_NAME

VARCHAR2(255)

Physical name of the associated location

STATUS

VARCHAR2(17)

Status (dev, QA, or prod)

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-11 ALL_IV_GATEWAY_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project that this module belongs to

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of this module

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of this module

BUSINESS_NAME

VARCHAR2(4000)

Business name of this module

DESCRIPTION

VARCHAR2(4000)

Description of this module

PRODUCT_TYPE

VARCHAR2(255)

Application type of the module (for example, Oracle apps or File based apps)

SYSTEM_TYPE

VARCHAR2(255)

Type of system that holds this application (represented by PRODUCT_TYPE)

VERSION_LABEL

NUMBER(9)

Version of the module

VENDOR

VARCHAR2(40)

Vendor name

DATABASE_LINK

VARCHAR2(40)

Name of the database link that physical points to data storage of this module. It is meaningful only for database applications

INTEGRATOR_NAME

VARCHAR2(255)

The name of Warehouse Builder integrator component that is used to access external data system for the module

STRONG_TYPE_NAME

VARCHAR2(255)

Used to differentiate which gateway component being employed, for example, Informix or Sybase

IS_VALID

VARCHAR2(13)

Is this module valid

LOCATION_ID

NUMBER(9)

ID of the associated location for this module

LOCATION_NAME

VARCHAR2(255)

Physical name of the associated location

STATUS

VARCHAR2(17)

Status (dev, QA, or prod)

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-12 ALL_IV_PACKAGED_APPS_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project that this module belongs to

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of this module (basically, the views wraps Oracle Applications, SAP)

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of this module

BUSINESS_NAME

VARCHAR2(4000)

Business name of this module

DESCRIPTION

VARCHAR2(4000)

Description of this module

PRODUCT_TYPE

VARCHAR2(255)

Application type of the module (for example, Oracle apps ,or File based apps)

SYSTEM_TYPE

VARCHAR2(255)

Type of system that holds this application (represented by PRODUCT_TYPE)

VERSION_LABEL

NUMBER(9)

Version of the module

VENDOR

VARCHAR2(40)

Vendor name

DATABASE_LINK

VARCHAR2(40)

Name of the database link that physical points to data storage of this module. It is meaningful only for database applications.

INTEGRATOR_NAME

VARCHAR2(255)

The name of Warehouse Builder integrator component that is used to access external data system for the module

IS_VALID

VARCHAR2(13)

Is this module valid

LOCATION_ID

NUMBER(9)

ID of the associated location for this module

LOCATION_NAME

VARCHAR2(255)

Physical name of the associated location

STATUS

VARCHAR2(17)

Status (dev, QA, or prod)

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-13 ALL_IV_PREDEFINED_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project that this module belongs to

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of this module (basically, the views wraps Oracle Pre-defined Transformations and Public Transformations)

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of this module

BUSINESS_NAME

VARCHAR2(4000)

Business name of this module

DESCRIPTION

VARCHAR2(4000)

Description of this module

PRODUCT_TYPE

VARCHAR2(255)

Application type of the module (for example, Oracle apps or File based apps)

SYSTEM_TYPE

VARCHAR2(255)

Type of system that holds this application (represented by PRODUCT_TYPE)

VERSION_LABEL

NUMBER(9)

Version of the module

VENDOR

VARCHAR2(40)

Vendor name

DATABASE_LINK

VARCHAR2(40)

Name of the database link that physical points to data storage of this module. It is meaningful only for database applications

INTEGRATOR_NAME

VARCHAR2(255)

The name of Warehouse Builder integrator component that is used to access external data system for the module

IS_VALID

VARCHAR2(13)

Is this module valid

STATUS

VARCHAR2(17)

Status (dev, QA, or prod)

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-14 ALL_IV_PROCESS_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project to which this module belongs

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of this module (basically, the views wraps Oracle Process Flow Module)

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of this module

BUSINESS_NAME

VARCHAR2(4000)

Business name of this module

DESCRIPTION

VARCHAR2(4000)

Description of this module

PRODUCT_TYPE

VARCHAR2(255)

Application type of the module (for example, Oracle apps or File based apps)

SYSTEM_TYPE

VARCHAR2(255)

Type of system that holds this application (represented by PRODUCT_TYPE)

VERSION_LABEL

NUMBER(9)

Version of the module

VENDOR

VARCHAR2(40)

Vendor name

DATABASE_LINK

VARCHAR2(40)

Name of the database link that physical points to data storage of this module. It is meaningful only for database applications.

INTEGRATOR_NAME

VARCHAR2(255)

The name of Warehouse Builder integrator component that is used to access external data system for the module

IS_VALID

VARCHAR2(13)

Is this module valid

LOCATION_ID

NUMBER(9)

ID of the associated location for this module

LOCATION_NAME

VARCHAR2(255)

Physical name of the associated location

STATUS

VARCHAR2(17)

Status (dev, QA, or prod)

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-15 ALL_IV_WAREHOUSE_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project that this module belongs to

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of this module (basically, the views wraps Oracle Warehouse Module)

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of this module

BUSINESS_NAME

VARCHAR2(4000)

Business name of this module

DESCRIPTION

VARCHAR2(4000)

Description of this module

PRODUCT_TYPE

VARCHAR2(255)

Application type of the module (for example, Oracle apps or File based apps)

SYSTEM_TYPE

VARCHAR2(255)

Type of system that holds this application (represented by PRODUCT_TYPE)

VERSION_LABEL

NUMBER(9)

Version of the module

VENDOR

VARCHAR2(40)

Vendor name

DATABASE_LINK

VARCHAR2(40)

Name of the database link that physical points to data storage of this module

INTEGRATOR_NAME

VARCHAR2(255)

The name of Warehouse Builder integrator component that is used to access external data system for the module

IS_VALID

VARCHAR2(13)

Is this module valid

LOCATION_ID

NUMBER(9)

ID of the associated location for this module

LOCATION_NAME

VARCHAR2(255)

Physical name of the associated location

STATUS

VARCHAR2(17)

Status (dev, QA, or prod)

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-16 ALL_IV_BUSINESS_DEF_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

BUSINESS_NAME

VARCHAR2(1000)

Business name of the business definition module

DESCRIPTION

VARCHAR2(4000)

Description of the business definition module

PRODUCT_TYPE

VARCHAR2(255)

Type of product (Oracle Discoverer Application)

SYSTEM_TYPE

VARCHAR2(255)

Internal

VERSION_LABEL

NUMBER(9)

Internal

VENDOR

VARCHAR2(40)

Name of the vendor (Currently, the vendor name is Oracle)

DATABASE_LINK

VARCHAR2(40)

Not applicable

INTEGRATOR_NAME

VARCHAR2(255)

Internal

IS_VALID

VARCHAR2(13)

Validation status of the module

STATUS

VARCHAR2(40)

The module status (Development, Quality Assurance, or Production)

LOCATION_ID

NUMBER(9)

ID of the Location associated with the business definition module

LOCATION_NAME

VARCHAR2(255)

Name of the Location associated with the business definition module

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-17 ALL_IV_BUSINESS_PRES_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

MODULE_ID

NUMBER(9)

ID of the business presentation module

MODULE_NAME

VARCHAR2(255)

Name of the business presentation module

BUSINESS_NAME

VARCHAR2(1000)

Business name of the business presentation module

DESCRIPTION

VARCHAR2(4000)

Description of the business presentation module

PRODUCT_TYPE

VARCHAR2(255)

Type of product (Oracle BI Beans Application)

SYSTEM_TYPE

VARCHAR2(255)

Internal

VERSION_LABEL

NUMBER(9)

Internal

VENDOR

VARCHAR2(40)

Name of the vendor (Currently the vendor name is Oracle)

DATABASE_LINK

VARCHAR2(40)

Not applicable

INTEGRATOR_NAME

VARCHAR2(255)

Internal

IS_VALID

VARCHAR2(13)

Validation status of the module

STATUS

VARCHAR2(40)

The module status (Development, Quality Assurance, or Production)

LOCATION_ID

NUMBER(9)

Id of the location with which the business presentation module is associated

LOCATION_NAME

VARCHAR2(255)

Name of the location with which the business presentation module is associated

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-18 ALL_IV_CALENDAR_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

CALENDAR_MODULE_ID

NUMBER(9)

ID of the calendar module

CALENDAR_MODULE_NAME

VARCHAR2(255)

Name of the calendar module

BUSINESS_NAME

VARCHAR2(1000)

Business name of the calendar module

DESCRIPTION

VARCHAR2(4000)

Description of the calendar module

IS_VALID

VARCHAR2(13)

Is the calendar module valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-19 ALL_IV_CMIV_DEFINITIONS

Column Name Data Type Description

CMIV_ID

NUMBER(9)

ID of the CMI definition

NAME

VARCHAR2(255)

Name of the CMI definition

BUSINESS_NAME

VARCHAR2(1000)

Business name

MIVMODE

VARCHAR2(40)

Mode of CMI (SQL or XML File)

TYPE

VARCHAR2(40)

Type

TABLE_FILTER_SUPPORTED

VARCHAR2(1)

Flag on supporting table filter

VIEW_FILTER_SUPPORTED

VARCHAR2(1)

Flag on supporting view filter

SEQUENCE_FILTER_SUPPORTED

VARCHAR2(1)

Flag on supporting sequence filter

TABLE_FKLEVEL_SUPPORTED

VARCHAR2(1)

Flag on supporting table foreign key level dependency

MULTI_TREE_SUPPORTED

VARCHAR2(1)

Flag on supporting multiple tree in business component navigation

REIMPORT_SUPPORTED

VARCHAR2(1)

Flag on supporting reimport

TEST_DB_LINK

VARCHAR2(255)

DB link used for testing the CMI definition

TESTDIRECTORY

VARCHAR2(255)

File directory used for testing the CMI definition

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-20 ALL_IV_CMIV_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the information system

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Name of the information system

BUSINESS_NAME

VARCHAR2(1000)

Business name of the module

DESCRIPTION

VARCHAR2(4000)

Description of the module

PRODUCT_TYPE

VARCHAR2(255)

Product type

SYSTEM_TYPE

VARCHAR2(255)

System type

VERSION_LABEL

NUMBER(9)

Version label

VENDOR

VARCHAR2(40)

Vendor

DATABASE_LINK

VARCHAR2(40)

Database link

INTEGRATOR_NAME

VARCHAR2(255)

Name of the integrator

IS_VALID

VARCHAR2(13)

Flag on valid module

STATUS

VARCHAR2(40)

Status

LOCATION_ID

NUMBER(9)

ID of the location to access data

LOCATION_NAME

VARCHAR2(255)

Name of the data location

METADATA_LOCATION_ID

NUMBER(9)

ID of the location to access metadata

METADATA_LOCATION_NAME

VARCHAR2(255)

Name of the metadata location

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-21 ALL_IV_DATA_RULE_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project to which the data rule module belongs

PROJECT_NAME

VARCHAR2(255)

Name of the project to which the data rule module belongs

SCHEMA_ID

NUMBER(9)

ID of the data rule module

SCHEMA_NAME

VARCHAR2(255)

Name of the data rule module

BUSINESS_NAME

VARCHAR2(1000)

Business name of the data rule module

DESCRIPTION

VARCHAR2(4000)

Description of the data rule module

STATUS

VARCHAR2(40)

Not used

IS_VALID

VARCHAR2(13)

Not used

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-22 ALL_IV_EXPERT_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the information system

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Name of the information system

BUSINESS_NAME

VARCHAR2(1000)

The business name of the expert module

DESCRIPTION

VARCHAR2(4000)

Description of the module

VERSION_LABEL

NUMBER(9)

The version for this module

IS_VALID

VARCHAR2(13)

Is this module valid

STATUS

VARCHAR2(40)

The status for this module

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-23 ALL_IV_PF_CORRECTED_MODULES

Column Name Data Type Description

PROFILE_ID

NUMBER(9)

ID of the profile

PROFILE_NAME

VARCHAR2(255)

Name of the profile

CORRECTED_MODULE_ID

NUMBER(9)

ID of the corrected module

CORRECTED_MODULE_NAME

VARCHAR2(255)

Name of the corrected module

BUSINESS_NAME

VARCHAR2(1000)

Business name of the corrected module

DESCRIPTION

VARCHAR2(4000)

Description of the corrected module

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-24 ALL_IV_SAP_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the information system

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Name of the information system

BUSINESS_NAME

VARCHAR2(1000)

Business name of the SAP module

DESCRIPTION

VARCHAR2(4000)

Description of the SAP module

PRODUCT_TYPE

VARCHAR2(255)

Product type

SYSTEM_TYPE

VARCHAR2(255)

System type

VERSION_LABEL

NUMBER(9)

Version label

VENDOR

VARCHAR2(40)

Vendor

INTEGRATOR_NAME

VARCHAR2(255)

Integrator name

IS_VALID

VARCHAR2(13)

Flag if the module is valid

STATUS

VARCHAR2(40)

Status

LOCATION_ID

NUMBER(9)

Data location ID

LOCATION_NAME

VARCHAR2(255)

Data location name

METADATA_LOCATION_ID

NUMBER(9)

Metadata location ID

METADATA_LOCATION_NAME

VARCHAR2(255)

Metadata location name

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-25 ALL_IV_TM_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

TM_ID

NUMBER(9)

ID of the transportable module

TM_NAME

VARCHAR2(255)

Name of the transportable module

BUSINESS_NAME

VARCHAR2(1000)

Business name of the transportable module

DESCRIPTION

VARCHAR2(4000)

Description of the transportable module

IS_VALID

VARCHAR2(13)

Whether the transportable module is valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user

CHARSET

VARCHAR2(40)

Not used

ORACLEHOME

VARCHAR2(40)

Not used

HOST

VARCHAR2(40)

The source database host name

DEFAULTPORT

NUMBER(9)

The access port of source database

SERVICE

VARCHAR2(40)

The database service name of source database

SID

VARCHAR2(40)

Not used


Table 2-26 ALL_IV_UDO_MODULES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the information system

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Name of the information system

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

MODULE_TYPE

VARCHAR2(255)

Type of the module

BUSINESS_NAME

VARCHAR2(1000)

Business name of the module

DESCRIPTION

VARCHAR2(4000)

Description of the module

STATUS

VARCHAR2(40)

Status of the module

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-27 ALL_IV_CMIV_VIEWS

Column Name Data Type Description

MIV_DEFINITION_ID

NUMBER(9)

ID of the CMI definition

MIV_DEFINITION

VARCHAR2(255)

Name of the CMI definition

MIV_VIEW_ID

NUMBER(9)

ID of the CMI View

MIV_VIEW

VARCHAR2(255)

Name of the CMI View

BUSINESS_NAME

VARCHAR2(1000)

Business name of the CMI view

VIEW_TYPE

VARCHAR2(40)

Type of the CMI view

IS_DEFAULT

VARCHAR2(1)

Flag if the view definition is the default

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-28 ALL_IV_FIRSTCLASS_OBJECTS

Column Name Data Type Description

OBJECT_ID

NUMBER(9)

ID of the object

OBJECT_NAME

VARCHAR2(255)

Name of the object

BUSINESS_NAME

VARCHAR2(1000)

Business name of the object

DESCRIPTION

VARCHAR2(4000)

Description of the object

CLASSNAME

VARCHAR2(255)

Internal type of the object

OBJECT_TYPE

VARCHAR2(4000)

Type of object

SCRIPTING_TYPE

VARCHAR2(4000)

Type of object exposed in scripting

OBJECT_UOID

VARCHAR2(255)

UOID of the object

OWNINGFOLDER

NUMBER

Folder that owns the object

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-29 ALL_IV_DB_FUNCTIONS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

FUNCTION_LIBRARY_ID

NUMBER(9)

ID of the function library

FUNCTION_LIBRARY_NAME

VARCHAR2(255)

Name of the function library

FUNCTION_ID

NUMBER(9)

ID of the function

FUNCTION_NAME

VARCHAR2(255)

Name of the function

BUSINESS_NAME

VARCHAR2(1000)

Business name of the function

DESCRIPTION

VARCHAR2(4000)

Description of the function

SIGNATURE

VARCHAR2(4000)

Signature of the function

FUNCTION_TYPE

CHAR(8)

Function or procedure

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-30 ALL_IV_EXT_OBJECT_PROPERTIES

Column Name Data Type Description

OBJECT_ID

NUMBER(9)

ID of the object

OBJECT_TYPE

VARCHAR2(4000)

Type of the object

OBJECT_NAME

VARCHAR2(255)

Name of the object

CONFIGURATION_ID

NUMBER

ID of the configuration

CONFIGURATION_NAME

VARCHAR2(255)

Name of the configuration

PROPERTY_GROUP_ID

NUMBER(9)

ID of the property group (UI folder)

PROPERTY_GROUP_NAME

VARCHAR2(255)

Name of the property group

PROPERTY_GROUP_NLS_KEY

VARCHAR2(255)

Key for NLS translation lookup of property group name

PROPERTY_SET_ID

NUMBER(9)

ID for property set

PROPERTY_SET_CLASS_NAME

VARCHAR2(255)

Name of defining class (may be superclass of OBJECT_TYPE)

PROPERTY_SET_NAME

VARCHAR2(255)

Name of property set (Typically 'Default' unless property set visibility is dynamically controlled in the clients)

PROPERTY_USAGE_ID

NUMBER(9)

ID of property usage (join between property set and property)

PROPERTY_STORAGE_TYPE

VARCHAR2(7)

Storage type for property. One of CORE, LOGICAL, CONFIG, USERDEF. (Describes how property was initially defined)

PROPERTY_USAGE_TYPE

VARCHAR2(7)

Usage type for property. One of CORE, LOGICAL, CONFIG, USERDEF. (Describes how property is used in this context)

PROPERTY_NAME

VARCHAR2(255)

Name of property

PROPERTY_NLS_KEY

VARCHAR2(255)

Key for NLS translation lookup of property name

PROPERTY_DATATYPE_ID

NUMBER

ID of property data type

PROPERTY_DATATYPE_NAME

VARCHAR2(255)

Name of property data type

PROPERTY_AFFECTS_SIGNATURE

VARCHAR2(4000)

Do changes to the value of this property affect the semantic signature of the owning object (true, false)

PROPERTY_DYNAMIC_DEFAULT

VARCHAR2(4000)

Fully qualified name of java class providing the default value for this property

PROPERTY_IS_HIDDEN

VARCHAR2(4000)

Is this property hidden from the GUI (true, false)

PROPERTY_PUBLISH_TO_PUBLIC_API

VARCHAR2(4000)

Is information on this property published in OMBPlus help/documentation (true, false)

PROPERTY_DEFAULT_VALUE

VARCHAR2(4000)

Default value for property (may not be correct if dynamic default is defined)

PROPERTY_VALUE_OWNER_ID

NUMBER(9)

ID of the direct property owner

PROPERTY_VALUE_ID

NUMBER(9)

ID of the property value

PROPERTY_VALUE_INDEX

NUMBER(9)

Ordinal position of the property (If property type is an array)

PROPERTY_VALUE_NAME

VARCHAR2(255)

Name of property value (For properties that are objects, such as SQL loader data files)

PROPERTY_VALUE

VARCHAR2(4000)

Current value of property

DESCRIPTION

VARCHAR2(4000)

Developer description of property (In English)

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Data Model Views

Table 2-31 ALL_IV_ADVANCED_QUEUES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this queue belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

QUEUE_ID

NUMBER(9)

ID of this queue

QUEUE_NAME

VARCHAR2(255)

Physical name of this queue

BUSINESS_NAME

VARCHAR2(4000)

Business name of this queue

DESCRIPTION

VARCHAR2(4000)

Description of this queue

LOAD_TYPE_ID

NUMBER(9)

ID of the load type

LOAD_TYPE_NAME

VARCHAR2(255)

Name of the load type

QUEUE_TABLE_NAME

VARCHAR2(40)

Name of the queue table

IS_VALID

VARCHAR2(13)

Is this queue valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-32 ALL_IV_ATTR_GROUPS

Column Name Data Type Description

DATA_ENTITY_ID

NUMBER(9)

ID of the data entity this attribute group belongs to

DATA_ENTITY_TYPE

VARCHAR2(4000)

Type of the data entity

DATA_ENTITY_NAME

VARCHAR2(255)

Physical name of the data entity

ATTRIBUTE_GROUP_NAME

VARCHAR2(255)

Physical name of this attribute group

ATTRIBUTE_GROUP_ID

NUMBER(9)

ID of this attribute group

BUSINESS_NAME

VARCHAR2(4000)

Business name of this attribute group

DESCRIPTION

VARCHAR2(4000)

Description of this attribute group

ATTRIBUTE_GROUP_TYPE

VARCHAR2(40)

Type of attribute group

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-33 ALL_IV_ATTR_GROUP_ITEM_USES

Column Name Data Type Description

ATTRIBUTE_GROUP_ID

NUMBER(9)

ID of the attribute group that this data item belongs to

ATTRIBUTE_GROUP_NAME

VARCHAR2(255)

Name of the attribute group

DATA_ITEM_ID

NUMBER(9)

ID of this data item

DATA_ITEM_TYPE

VARCHAR2(4000)

Type of this data item

DATA_ITEM_NAME

VARCHAR2(255)

Physical name of this data item

POSITION

NUMBER(9)

Position of this data item in the attribute group


Table 2-34 ALL_IV_CHECK_CONSTRAINTS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this check constraint belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

RELATION_ID

NUMBER(9)

ID of the relation entity this check constraint belongs to

RELATION_NAME

VARCHAR2(255)

Physical name of the relation entity

CONSTRAINT_ID

NUMBER(9)

ID of this check constraint

CONSTRAINT_NAME

VARCHAR2(255)

Physical name of this check constraint

BUSINESS_NAME

VARCHAR2(4000)

Business name of this check constraint

DESCRIPTION

VARCHAR2(4000)

Description of this check constraint

CONSTRAINT_TEXT

VARCHAR2(255)

Textual expression of this check constraint

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-35 ALL_IV_COLUMNS

Column Name Data Type Description

ENTITY_ID

NUMBER(9)

ID of the data entity this column belongs to

ENTITY_TYPE

VARCHAR2(4000)

Type of the data entity

ENTITY_NAME

VARCHAR2(255)

Physical name of the data entity

COLUMN_ID

NUMBER(9)

ID of this column

COLUMN_NAME

VARCHAR2(255)

Physical name of this column

BUSINESS_NAME

VARCHAR2(4000)

Business name of this column

DESCRIPTION

VARCHAR2(4000)

Description of this column

POSITION

NUMBER(9)

Position of this column in the data entity

DATA_TYPE

VARCHAR2(255)

Data type of this column

LENGTH

NUMBER(9)

Data length of this column

PRECISION

NUMBER(9)

Data precision of this column

SCALE

NUMBER(9)

Data scale of this column

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-36 ALL_IV_CONSTRAINTS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this constraint belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

RELATION_ID

NUMBER(9)

ID of the relational entity this constraint belongs to

RELATION_NAME

VARCHAR2(255)

Physical name of the relational entity

CONSTRAINT_ID

NUMBER(9)

ID of this constraint

CONSTRAINT_NAME

VARCHAR2(255)

Physical name of this constraint

CONSTRAINT_TYPE

VARCHAR2(21)

Type of this constraint (check, primary, foreign key)

BUSINESS_NAME

VARCHAR2(4000)

Business name of this constraint

DESCRIPTION

VARCHAR2(4000)

Description of this constraint

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-37 ALL_IV_CUBES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this cube belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

CUBE_ID

NUMBER(9)

ID of this cube

CUBE_NAME

VARCHAR2(255)

Physical name of this cube

BUSINESS_NAME

VARCHAR2(4000)

Business name of this cube

DESCRIPTION

VARCHAR2(4000)

Description of this cube

IS_VALID

VARCHAR2(13)

Is this cube valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user

AUTOSOLVE

CHAR(1)

Sets the flag to say whether to measure is Auto Solve

AWNAME

VARCHAR2(255)

The analytical workspace name where the cube is implemented

AWOBJECTNAME

VARCHAR2(4000)

The analytical workspace object name

AWTABLESPACENAME

VARCHAR2(255)

The analytical workspace tablespace name

COMPRESSED

CHAR(1)

Flag to check whether the cube is compressed

CREATEBITMAPS

CHAR(1)

Flag to check whether to create a bitmap for the cube

CREATECONSTRAINTS

CHAR(1)

Flag to check whether to create a constraint for the cube

IMPLEMENTATION

VARCHAR2(255)

Whether the storage of a cube is AW or Relational

LOADPOLICY

VARCHAR2(255)

Not applicable for the current release

OLAPUSERVISIBLE

CHAR(1)

Flag to check whether the Cube is visible to OLAP end user

STORAGEPROPERTYTYPE

VARCHAR2(255)

The storage of a cube can be AW or Relational

USEGLOBALINDEX

CHAR(1)

Whether to generate a composite for measure partition combination

PARTITIONHIERARCHY

NUMBER(9)

The hierarchy by which one should partition the cube

INSTALLEDMODULE

NUMBER(9)

The Oracle module to which the cube belongs

PARTITIONLEVEL

NUMBER(9)

The level by which one should partition the cube

BINDINGFACT

NUMBER(9)

The element ID for binding fact table to the cube


Table 2-38 ALL_IV_CUBE_DIMENSIONS

Column Name Data Type Description

CUBE_ID

NUMBER(9)

ID of the cube this dimension has associated with

CUBE_NAME

VARCHAR2(255)

Physical name of the cube

DIMENSION_ID

NUMBER(9)

ID of this dimension

DIMENSION_NAME

VARCHAR2(255)

Physical name of this dimension

DIMENSION_ALIAS

VARCHAR2(255)

Alias of this dimension


Table 2-39 ALL_IV_CUBE_MEASURES

Column Name Data Type Description

CUBE_ID

NUMBER(9)

ID of the cube this measure belongs to

CUBE_NAME

VARCHAR2(255)

Physical name of the cube

MEASURE_ID

NUMBER(9)

ID of this measure

MEASURE_NAME

VARCHAR2(255)

Physical name of this measure

BUSINESS_NAME

VARCHAR2(4000)

Business name of this measure

DESCRIPTION

VARCHAR2(4000)

Description of this measure

POSITION

NUMBER(9)

Position of this measure within the cube

DATA_TYPE

VARCHAR2(255)

Data type of this measure

LENGTH

NUMBER(9)

Data length of this measure

PRECISION

NUMBER(9)

Data precision of this measure

SCALE

NUMBER(9)

Data scale of this measure

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user

TABLE_ID

NUMBER(9)

ID of the table

TABLE_NAME

VARCHAR2(255)

Name of the table


Note:

The view ALL_IV_CUBE_MEASURE_DIM_USES is redundant. It can be created by joining ALL_IV_PF_CORRECTED_MODULES and ALL_IV_SAP_MODULES. It is scheduled for obsolescence.

Table 2-40 ALL_IV_CUBE_MEASURE_DIM_USES

Column Name Data Type Description

CUBE_ID

NUMBER(9)

ID of the cube

CUBE_NAME

VARCHAR2(255)

Physical name of the cube

MEASURE_ID

NUMBER(9)

ID of the measure belonging to this cube

MEASURE_NAME

VARCHAR2(255)

Physical name of the measure

DIMENSION_ID

NUMBER

ID of the dimension associated with this cube

DIMENSION_NAME

VARCHAR2(255)

Physical name of the dimension

DIMENSION_ALIAS

VARCHAR2(255)

Alias of the dimension


Table 2-41 ALL_IV_DIMENSIONS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this dimension belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

DIMENSION_ID

NUMBER(9)

ID of this dimension

DIMENSION_NAME

VARCHAR2(255)

Physical name of this dimension

BUSINESS_NAME

VARCHAR2(4000)

Business name of this dimension

DESCRIPTION

VARCHAR2(4000)

Description of this dimension

IS_VALID

VARCHAR2(13)

Is this dimension valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user

AWNAME

VARCHAR2(255)

The analytical workspace name where the dimension is implemented

AWOBJECTNAME

VARCHAR2(4000)

The analytical workspace object name

AWTABLESPACENAME

VARCHAR2(255)

The analytical workspace tablespace name

CREATECONSTRAINTS

CHAR(1)

Flag to check whether to create a constraint for the dimension

IMPLEMENTATION

VARCHAR2(255)

Type of implementation of the dimension (The storage of a dimension can be AW or Relational)

LOADPOLICY

VARCHAR2(255)

Data policy for loading dimension where Warehouse Builder mapping code relies on database constraints to detect the orphans (level records without parent)

OLAPPRIMARYSORTORDER

VARCHAR2(255)

The primary sorting order for dimension data in OLAP service

OLAPSECONDARYSORTORDER

VARCHAR2(255)

The secondary sorting order for dimension data in OLAP service

OLAPTYPE

VARCHAR2(255)

Type of OLAP Dimension Normal or Time

OLAPUSERVISIBLE

CHAR(1)

Whether the dimension is visible to OLAP end user

OWBTYPE

VARCHAR2(255)

Type of Dimension Normal or Time

REMOVEPOLICY

VARCHAR2(255)

Orphan Management (not applicable for the current release)

SLOWLYCHANGINGTYPE

NUMBER(9)

Slowly changing policy to be applied on the dimension

STORAGEPROPERTYTYPE

VARCHAR2(255)

The storage of a cube can be AW or Relational

VALUEBASED

CHAR(1)

The flag to define a value based hierarchy, applicable for AW only

DEFAULTDISPLAYHIERARCHY

NUMBER(9)

The hierarchy is set as default display hierarchy

INSTALLEDMODULE

NUMBER(9)

The Oracle module to which the cube belongs

TIMEDIMPOPULATIONMAP

NUMBER(9)

The element ID of map for a time dimension

DIMENSIONKEYSEQUENCE

NUMBER(9)

Element ID for sequence to generate the dimension key


Table 2-42 ALL_IV_DIM_HIERARCHIES

Column Name Data Type Description

DIMENSION_ID

NUMBER(9)

ID of the dimension this hierarchy belongs to

DIMENSION_NAME

VARCHAR2(255)

Physical name of this dimension

HIERARCHY_ID

NUMBER(9)

ID of this hierarchy

HIERARCHY_NAME

VARCHAR2(255)

Physical name of this hierarchy

BUSINESS_NAME

VARCHAR2(1000)

Business name of this hierarchy

DESCRIPTION

VARCHAR2(4000)

Description of this hierarchy

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-43 ALL_IV_DIM_HIERARCHY_LEVELS

Column Name Data Type Description

LEVEL_USE_ID

NUMBER(9)

ID of the level relationship that this level and this parent level participates in

LEVEL_USE_NAME

VARCHAR2(255)

Level name used on Hierarchy

HIERARCHY_ID

NUMBER(9)

ID of the hierarchy that this level and this parent level belongs to

HIERARCHY_NAME

VARCHAR2(255)

Physical name of the hierarchy

LEVEL_ID

NUMBER(9)

ID of this level

LEVEL_NAME

VARCHAR2(255)

Physical name of this level

LEVEL_DESCRIPTION

VARCHAR2(4000)

Description of this level

PARENT_LEVEL_ID

NUMBER(9)

ID of this parent level

PARENT_LEVEL_NAME

VARCHAR2(255)

Physical name of this parent level

POSITION

NUMBER(9)

Position of this level


Table 2-44 ALL_IV_DIM_LEVELS

Column Name Data Type Description

DIMENSION_ID

NUMBER(9)

ID of the dimension this level belongs to

DIMENSION_NAME

VARCHAR2(255)

Physical name of the dimension

LEVEL_ID

NUMBER(9)

ID of this level

LEVEL_NAME

VARCHAR2(255)

Physical name of this level

BUSINESS_NAME

VARCHAR2(4000)

Business name of this level

DESCRIPTION

VARCHAR2(4000)

Description of this level

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-45 ALL_IV_DIM_LEVEL_ATTRIBUTES

Column Name Data Type Description

LEVEL_ID

NUMBER(9)

ID of the level this attribute belongs to

LEVEL_NAME

VARCHAR2(255)

Physical name of the level

ATTRIBUTE_ID

NUMBER(9)

ID of this attribute

ATTRIBUTE_NAME

VARCHAR2(255)

Physical name of this attribute

DIMENSION_ATTRIBUTE

VARCHAR2(255)

Name of the dimension attribute that the level attribute implements

BUSINESS_NAME

VARCHAR2(1000)

Business name of this attribute

DESCRIPTION

VARCHAR2(4000)

Description of this attribute

POSITION

NUMBER(9)

Position of this attribute within the level

DATA_TYPE

VARCHAR2(255)

Data type of this attribute

LENGTH

NUMBER(9)

Data length of this attribute

PRECISION

NUMBER(9)

Data precision of this attribute

SCALE

NUMBER(9)

Data scale of this attribute

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-46 ALL_IV_EXTERNAL_COLUMNS

Column Name Data Type Description

ENTITY_ID

NUMBER(9)

ID of the external table that this column belongs to

ENTITY_NAME

VARCHAR2(255)

Name of the external table

COLUMN_ID

NUMBER(9)

ID of this column

COLUMN_NAME

VARCHAR2(255)

Physical name of this column

BUSINESS_NAME

VARCHAR2(4000)

Business name of this column

DESCRIPTION

VARCHAR2(4000)

Description of this column

POSITION

NUMBER(9)

Position of this column within the external table

DATA_TYPE

VARCHAR2(255)

Data type of this column

LENGTH

NUMBER(9)

Data length of this column

PRECISION

NUMBER(9)

Data precision of this column

SCALE

NUMBER(9)

Data scale of this column

SOURCE_FIELD_ID

NUMBER(9)

ID of the field that this column maps to

SOURCE_FIELD_NAME

VARCHAR2(255)

Physical name of the source field

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-47 ALL_IV_EXTERNAL_TABLES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this external table belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

LOCATION_ID

NUMBER(9)

ID of the location where the module is deployed to

LOCATION_NAME

VARCHAR2(255)

Physical name of the location

TABLE_ID

NUMBER(9)

ID of the external table

TABLE_NAME

VARCHAR2(255)

Physical name of the external table

BUSINESS_NAME

VARCHAR2(4000)

Business name of the external table

DESCRIPTION

VARCHAR2(4000)

Description of the external table

SOURCE_RECORD_ID

NUMBER(9)

ID of the record that this external table maps to

SOURCE_RECORD_NAME

VARCHAR2(255)

Physical name of the source record

SOURCE_FILE_NAME

VARCHAR2(255)

Physical name of the file that this source record belongs to

ACCESS_PARAMETERS

VARCHAR2(4000)

Expression for parameters that are used to access the source record

IS_VALID

VARCHAR2(13)

Is this external table valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-48 ALL_IV_FOREIGN_KEYS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module that this foreign key belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

ENTITY_ID

NUMBER(9)

ID of the data entity this foreign key belongs to

ENTITY_NAME

VARCHAR2(255)

Physical name of the data entity

ENTITY_TYPE

VARCHAR2(4000)

Type of the data type (for example, table, view)

FOREIGN_KEY_ID

NUMBER(9)

ID of this foreign key

FOREIGN_KEY_NAME

VARCHAR2(255)

Physical name of this foreign key

BUSINESS_NAME

VARCHAR2(4000)

Business name of this foreign key

DESCRIPTION

VARCHAR2(4000)

Description of this foreign key

KEY_ID

NUMBER(9)

ID of the associated key for this foreign key

KEY_NAME

VARCHAR2(255)

Physical name of the key

IS_DISABLED

CHAR(1)

Is this foreign key disabled

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-49 ALL_IV_KEYS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this key belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of this module

ENTITY_ID

NUMBER(9)

ID of the data entity this key belongs to

ENTITY_NAME

VARCHAR2(255)

Physical name of the data entity

ENTITY_TYPE

VARCHAR2(4000)

Type of the data entity (for example, table, view)

KEY_ID

NUMBER(9)

ID of this key

KEY_NAME

VARCHAR2(255)

Physical name of this key

BUSINESS_NAME

VARCHAR2(4000)

Business of this key

DESCRIPTION

VARCHAR2(4000)

Description of this key

IS_PRIMARY

VARCHAR2(9)

Is this key primary key

IS_DISABLED

CHAR(1)

Is this key disabled

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-50 ALL_IV_KEY_COLUMN_USES

Column Name Data Type Description

KEY_ID

NUMBER(9)

ID of the key that this column is associated with

KEY_NAME

VARCHAR2(255)

Physical name of the key

KEY_TYPE

VARCHAR2(11)

Type of the key (primary, unique, foreign)

COLUMN_ID

NUMBER(9)

ID of this column

COLUMN_NAME

VARCHAR2(255)

Physical name of this column

POSITION

NUMBER(9)

Position of this column with the key


Table 2-51 ALL_IV_MATERIALIZED_VIEWS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this materialized view belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

VIEW_ID

NUMBER(9)

ID of this materialized view

VIEW_NAME

VARCHAR2(255)

Physical name of this materialized view

BUSINESS_NAME

VARCHAR2(4000)

Business name of this materialized view

DESCRIPTION

VARCHAR2(4000)

Description of this materialized view

QUERY_TEXT

VARCHAR2(4000)

Textual expression of query statement for this materialized view

IS_VALID

VARCHAR2(13)

Is this materialized view valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-52 ALL_IV_OBJECT_TYPES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this object type belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

FOLDER_ID

NUMBER(9)

ID of the folder this object type belongs to

FOLDER_NAME

VARCHAR2(255)

Physical name of the folder

OBJECT_TYPE_ID

NUMBER(9)

ID of this object type

OBJECT_TYPE_NAME

VARCHAR2(255)

Physical name of this object type

BUSINESS_NAME

VARCHAR2(4000)

Business name of this object

DESCRIPTION

VARCHAR2(4000)

Description of this object type

TYPE

VARCHAR2(40)

Type of this object type

IS_VALID

VARCHAR2(13)

Is this object type valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-53 ALL_IV_RECORD_FIELDS

Column Name Data Type Description

FIRSTCLASS_OBJECT_ID

NUMBER(9)

ID of the first class object that this record field belongs to (normally, this ID will be the same as the following relational ID)

FRISTCLASS_OBJECT_NAME

VARCHAR2(255)

Physical name of the first class object

RELATION_ID

NUMBER(9)

ID of the relational entity this record field belongs to

RELATION_NAME

VARCHAR2(255)

Physical name of the relational entity

RECORDFIELD_ID

NUMBER(9)

ID of this record field

RECORDFIELD_NAME

VARCHAR2(255)

Physical name of this record field

BUSINESS_NAME

VARCHAR2(4000)

Business name of this record field

DESCRIPTION

VARCHAR2(4000)

Description of this record field

POSITION

NUMBER(9)

Position of this record field

DATA_TYPE

VARCHAR2(255)

Data type of this record field

LENGTH

NUMBER(9)

Data length of this record field

PRECISION

NUMBER(9)

Data precision of this record field

SCALE

NUMBER(9)

Data scale of this record field

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-54 ALL_IV_RELATIONS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this relational entity belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

RELATION_ID

NUMBER(9)

ID of this relational entity

RELATION_NAME

VARCHAR2(255)

Physical name of this relational entity

RELATION_TYPE

VARCHAR2(16)

Type of this relational entity (such as table, view, sequence and materialized view)

BUSINESS_NAME

VARCHAR2(4000)

Business name of this relational entity

DESCRIPTION

VARCHAR2(4000)

Description of this relational entity

IS_VALID

VARCHAR2(13)

Is this relational entity valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-55 ALL_IV_SEQUENCES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this sequence belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module the sequence belongs to

SEQUENCE_ID

NUMBER(9)

ID of the sequence

SEQUENCE_NAME

VARCHAR2(255)

Physical name of the sequence

BUSINESS_NAME

VARCHAR2(4000)

Business name of the sequence

DESCRIPTION

VARCHAR2(4000)

Description of the sequence

IS_VALID

VARCHAR2(13)

Is this sequence valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-56 ALL_IV_VIEWS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this view belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

VIEW_ID

NUMBER(9)

ID of this view

VIEW_NAME

VARCHAR2(255)

Physical name of this view

QUERY_TEXT

VARCHAR2(4000)

Textual expression of the query for this view

BUSINESS_NAME

VARCHAR2(4000)

Business name of this view

DESCRIPTION

VARCHAR2(4000)

Description of this view

IS_VALID

VARCHAR2(13)

Is this view valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-57 ALL_IV_TABLES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this table belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

TABLE_ID

NUMBER(9)

ID of this table

TABLE_NAME

VARCHAR2(255)

Physical name of this table

BUSINESS_NAME

VARCHAR2(4000)

Business name of this table

DESCRIPTION

VARCHAR2(4000)

Description of this table

IS_VALID

VARCHAR2(13)

Is this table valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-58 ALL_IV_CALENDARS

Column Name Data Type Description

CALENDAR_MODULE_ID

NUMBER(9)

ID of the owning calendar module

CALENDAR_MODULE_NAME

VARCHAR2(255)

Name of the owning calendar module

CALENDAR_ID

NUMBER(9)

ID of the calendar

CALENDAR_NAME

VARCHAR2(255)

Name of the calendar

BUSINESS_NAME

VARCHAR2(1000)

Business name of the calendar

DESCRIPTION

VARCHAR2(4000)

Description of the calendar

IS_VALID

VARCHAR2(13)

Is the calendar valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-59 ALL_IV_VARRAYS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

VARRAY_ID

NUMBER(9)

ID of the varray

VARRAY_NAME

VARCHAR2(255)

Name of the varray

BUSINESS_NAME

VARCHAR2(1000)

Business name of the varray

DESCRIPTION

VARCHAR2(4000)

Description of the varray

IS_VALID

VARCHAR2(13)

Is the varray valid

BASE_ELEMENT_NAME

VARCHAR2(767)

Name of the base element

BASE_ELEMENT_PRECISION

NUMBER

Precision of the base element

BASE_ELEMENT_SCALE

NUMBER

Scale of the base element

BASE_ELEMENT_LENGTH

NUMBER

Length of the base element

ARRAY_LENGTH

NUMBER(9)

Number of elements in the varray

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-60 ALL_IV_SCHEMAS

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

BUSINESS_NAME

VARCHAR2(1000)

Business name of the schema

DESCRIPTION

VARCHAR2(4000)

Description of the schema

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the information system

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Name of the information system

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Create timestamp


Table 2-61 ALL_IV_PROCEDURES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

FUNCTION_LIBRARY_ID

NUMBER(9)

ID of the function library

FUNCTION_LIBRARY_NAME

VARCHAR2(255)

Name of the function library

FUNCTION_ID

NUMBER(9)

ID of the procedure

FUNCTION_NAME

VARCHAR2(255)

Physical name of the procedure

BUSINESS_NAME

VARCHAR2(1000)

Business name of the procedure

DESCRIPTION

VARCHAR2(4000)

Description of the procedure

SIGNATURE

VARCHAR2(4000)

Signature of procedure

FUNCTION_TYPE

CHAR(9)

Type of the function

IS_VALID

VARCHAR2(13)

Is procedure valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-62 ALL_IV_REF_CURSORS

Column Name Data Type Description

LIBRARY_ID

NUMBER(9)

ID of the library

LIBRARY_NAME

VARCHAR2(255)

Name of the library

CURSOR_ID

NUMBER(9)

ID of the cursor

CURSOR_NAME

VARCHAR2(255)

Name of the cursor

BUSINESS_NAME

VARCHAR2(1000)

Business name of the cursor

DESCRIPTION

VARCHAR2(4000)

Description of the cursor

CURSOR_TYPE

VARCHAR2(40)

Type of the cursor

RETURN_RECORD_ID

NUMBER(9)

Ref Cursor Row Type Id

RETURN_RECORD_NAME

VARCHAR2(255)

Ref Cursor Row Type Name

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-63 ALL_IV_DIM_ATTRIBUTES

Column Name Data Type Description

DIMENSION_ID

NUMBER(9)

ID of the dimension

DIMENSION_NAME

VARCHAR2(255)

Name of the dimension

ATTRIBUTE_ID

NUMBER(9)

ID of the attribute

ATTRIBUTE_NAME

VARCHAR2(255)

Name of the attribute

BUSINESS_NAME

VARCHAR2(1000)

Business name of the attribute

DESCRIPTION

VARCHAR2(4000)

Description of the attribute

POSITION

NUMBER(9)

Position of the dimension attribute

DATA_TYPE

VARCHAR2(255)

Data type of the dimension attribute

LENGTH

NUMBER(9)

Length for data types of the dimension attribute

PRECISION

NUMBER(9)

Precision for data types of the dimension attribute

SCALE

NUMBER(9)

Scale for data types of the dimension attribute

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-64 ALL_IV_DIM_ROLES

Column Name Data Type Description

DIMENSION_ID

NUMBER(9)

ID of the dimension

DIMENSION_NAME

VARCHAR2(255)

Name of the dimension

ROLE_ID

NUMBER(9)

ID of the role

ROLE_NAME

VARCHAR2(255)

Name of the role

BUSINESS_NAME

VARCHAR2(1000)

Business name of the role

DESCRIPTION

VARCHAR2(4000)

Description of the role

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-65 ALL_IV_TM_SCHEMAS

Column Name Data Type Description

TM_TABLESPACE_ID

NUMBER(9)

ID of the owning tablespace

TM_TABLESPACE_NAME

VARCHAR2(255)

Internal name of the owning tablespace

TM_SCHEMA_ID

NUMBER(9)

ID of the schema

TM_SCHEMA_NAME

VARCHAR2(255)

Internal unique name for the schema

TM_SCHEMA_UI_NAME

VARCHAR2(1002)

Schema name of the schema in source database. This may not be unique

BUSINESS_NAME

VARCHAR2(1000)

Business name of the schema

DESCRIPTION

VARCHAR2(4000)

Description of the schema

IS_VALID

VARCHAR2(13)

Not used

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-66 ALL_IV_TM_TABLESPACES

Column Name Data Type Description

TM_ID

NUMBER(9)

ID of the transportable module

TM_NAME

VARCHAR2(255)

Name of the transportable module

TM_TABLESPACE_ID

NUMBER(9)

Internal ID assigned to tablespace within the transportable module

TM_TABLESPACE_NAME

VARCHAR2(255)

Internal name assigned to tablespace within the transportable module. The internal tablespace name is unique

BUSINESS_NAME

VARCHAR2(1000)

The full specification of the tablespace. The format of this value is <Internal tablespace name>:<Source Host>:<Source Port>:<Source Service>:<Source Tablespace Name>

TM_TABLESPACE_UI_NAME

VARCHAR2(1000)

The source tablespace name that this tablespace represent. The tablespace UI name is not guaranteed to be unique

DESCRIPTION

VARCHAR2(4000)

Description of the tablespace

IS_VALID

VARCHAR2(13)

Not used

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user

EXPANDABLE

CHAR(1)

Not used

BLOCKSIZE

NUMBER(9)

Not used


Table 2-67 ALL_IV_CUBE_IMPLS

Column Name Data Type Description

IMPLEMENTATION_ID

NUMBER(9)

ID of this cube (this column will be updated in future)

ITEM_ID

NUMBER(9)

ID of the item belonging to this cube

ITEM_TYPE

VARCHAR2(18)

Type of item, either cube measures or cube dimension use (foreign keys pointing to dimension)

ITEM_NAME

VARCHAR2(255)

Physical name of the item

CUBE_ID

NUMBER(9)

ID of this cube

CUBE_NAME

VARCHAR2(255)

Physical name of this cube

DIMENSION_ID

NUMBER(9)

ID of the associated dimension

DIMENSION_NAME

VARCHAR2(255)

Physical name of the associated name

DIMENSION_ALIAS

VARCHAR2(255)

Alias of the associated dimension (name of the foreign key in the cube)

COLUMN_ID

NUMBER(9)

ID of the implementing column for the item

COLUMN_NAME

VARCHAR2(255)

Physical name of the implementing column for the item

POSITION

NUMBER

Position of the implementing column

TABLE_ID

NUMBER(9)

ID of the implementing table for this cube

TABLE_NAME

VARCHAR2(255)

Physical name of the implementing table

FOREIGN_KEY_ID

NUMBER(9)

ID of the foreign key pointing to the dimension

FOREIGN_KEY_NAME

VARCHAR2(255)

Physical name of the foreign key

DIM_IMPLEMENTATION_ID

NUMBER(9)

Not used (Value is set to NULL)


Table 2-68 ALL_IV_DIM_IMPLS

Column Name Data Type Description

IMPLEMENTATION_ID

NUMBER(9)

ID of the table in the case of STAR implementtion (this column will be updated in future)

LEVEL_ID

NUMBER(9)

ID of the level

DIMENSION_ID

NUMBER(9)

ID of the dimension

DIMENSION_NAME

VARCHAR2(255)

Physical name of the dimension

LEVEL_NAME

VARCHAR2(255)

Name of the level

TABLE_NAME

VARCHAR2(255)

Name of the table


Table 2-69 ALL_IV_DIM_LEVEL_IMPLS

Column Name Data Type Description

IMPLEMENTATION_ID

NUMBER(9)

ID of the level attribute (this column will be updated in future)

ITEM_ID

NUMBER(9)

ID of the item belonging to this level

ITEM_TYPE

VARCHAR2(18)

Type of the item (constant value: Level Attribute)

ITEM_NAME

VARCHAR2(255)

Physical name of the item

DIMENSION_ID

NUMBER(9)

ID of the dimension

DIMENSION_NAME

VARCHAR2(255)

Physical name of the dimension

LEVEL_ID

NUMBER(9)

ID of this level

LEVEL_NAME

VARCHAR2(255)

Physical name of this level

COLUMN_ID

NUMBER(9)

ID of the implementation column

COLUMN_NAME

VARCHAR2(255)

Physical name of the implementation column

TABLE_ID

NUMBER(9)

ID of the implementation table for this level

TABLE_NAME

VARCHAR2(255)

Physical name of the implementation table for this level


Table 2-70 ALL_IV_NESTED_TABLES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

NESTED_TABLE_ID

NUMBER(9)

ID of the nested table

NESTED_TABLE_NAME

VARCHAR2(255)

Name of the nested table

BUSINESS_NAME

VARCHAR2(1000)

Business name of the nested table

DESCRIPTION

VARCHAR2(4000)

Description of the nested table

IS_VALID

VARCHAR2(13)

Is the nested table valid

BASE_ELEMENT_NAME

VARCHAR2(767)

Name of the base element

BASE_ELEMENT_PRECISION

NUMBER

Precision of the base element

BASE_ELEMENT_SCALE

NUMBER

Scale of the base element

BASE_ELEMENT_LENGTH

NUMBER

Length of the base element

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Flat Files Views

Table 2-71 ALL_IV_FIELDS

Column Name Data Type Description

RECORD_ID

NUMBER(9)

ID of the record this field belongs to

RECORD_NAME

VARCHAR2(255)

Physical name of the record

FIELD_ID

NUMBER(9)

ID of this field

FIELD_NAME

VARCHAR2(255)

Physical name of this field

BUSINESS_NAME

VARCHAR2(4000)

Business name of this field

DESCRIPTION

VARCHAR2(4000)

Description of this field

POSITION

NUMBER(9)

Position of this field

DATA_TYPE

VARCHAR2(255)

Data type of this field

LENGTH

NUMBER(9)

Data length of this field

PRECISION

NUMBER(9)

Data precision of this field

SCALE

NUMBER(9)

Data scale of this field

PICTURE

VARCHAR2(40)

Picture of the field

SIGN_TYPE

NUMBER(9)

Sign type of the field

USAGE

VARCHAR2(40)

Usage of the field

MASK

VARCHAR2(255)

Mask of the field

NULLIF

VARCHAR2(40)

Nullif value of the field

DEFAULTIF

VARCHAR2(40)

Defaultif value of the field

SQL_DATA_TYPE

VARCHAR2(40)

SQL data type of the field

SQL_LENGTH

NUMBER(9)

SQL data length of the field

SQL_PRECISION

NUMBER(9)

SQL precision of the field

SQL_SCALE

NUMBER(9)

SQL data scale of the field

START_POSITION

VARCHAR2(40)

Start position of the field

OCCURS

NUMBER(9)

Occurs of the attribute array within the structure (identified by next column)

STRUCTURE_ID

NUMBER(9)

ID of the structure containing field

STRUCTURE_NAME

VARCHAR2(255)

Physical name of the structure

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-72 ALL_IV_FILES

Column Name Data Type Description

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the module this file belongs to

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of the module

FILE_ID

NUMBER(9)

ID of this file

FILE_NAME

VARCHAR2(255)

Physical name of this file

BUSINESS_NAME

VARCHAR2(4000)

Business name of this file

DESCRIPTION

VARCHAR2(4000)

Description of the file

FILE_FORMAT

VARCHAR2(10)

Format of this file

IS_VALID

VARCHAR2(13)

Is this file valid

RECORD_CLASSIFIER_POSITION

NUMBER(9)

Record classifier position of this file

RECORD_CLASSIFIER_LENGTH

NUMBER(9)

Record classifier length of this file

RECORD_SIZE

VARCHAR2(40)

Record size of this file

N_PHYSICAL_RECORDS_IN_LOGICAL

NUMBER(9)

Number of physical records for each logical record

CONTINUATION_AT_END

CHAR(1)

Continuation at end or not

CONTINUATION_DELIMITER

VARCHAR2(40)

Continuation delimiter symbol

RECORD_DELIMITER

VARCHAR2(40)

Record delimiter symbol

FIELD_DELIMITER

VARCHAR2(40)

Field delimiter symbol

TEXT_START_DELIMITER

VARCHAR2(1)

Text start delimiter symbol

TEXT_END_DELIMITER

VARCHAR2(1)

Text end delimiter symbol

SOURCE_FROM

VARCHAR2(4000)

Directory path of this file

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-73 ALL_IV_RECORDS

Column Name Data Type Description

FILE_ID

NUMBER(9)

ID of the file this record belongs to

FILE_NAME

VARCHAR2(255)

Physical name of the file

RECORD_ID

NUMBER(9)

ID of this record

RECORD_NAME

VARCHAR2(255)

Physical name of this record

BUSINESS_NAME

VARCHAR2(4000)

Business name of this record

DESCRIPTION

VARCHAR2(4000)

Description of this record

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Collections Views

Note:

The view ALL_IV_COLLECTIONS replaces the CLASSIFICATION view.

Table 2-74 ALL_IV_COLLECTIONS

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project this collection belongs to (this view replaces old classification view)

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

COLLECTION_ID

NUMBER(9)

ID of this collection

COLLECTION_NAME

VARCHAR2(255)

Physical name of this collection

BUSINESS_NAME

VARCHAR2(4000)

Business name of this collection

DESCRIPTION

VARCHAR2(4000)

Description of this collection

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-75 ALL_IV_COLLECTION_REFERENCES

Column Name Data Type Description

COLLECTION_ID

NUMBER(9)

ID of the collection this reference belongs to (this view replaces old classification_item view)

COLLECTION_NAME

VARCHAR2(255)

Physical name of the collection

COLLECTION_REFERENCE_ID

NUMBER(9)

ID of this collection reference

COLLECTION_REFERENCE_TYPE

VARCHAR2(4000)

Type of this collection reference

COLLECTION_REFERENCE_NAME

VARCHAR2(255)

Physical name of the collection reference

BUSINESS_NAME

VARCHAR2(4000)

Business name of this collection reference

DESCRIPTION

VARCHAR2(4000)

Description of this collection reference

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Function Model Views

Table 2-76 ALL_IV_FUNCTIONS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this function belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

FUNCTION_LIBRARY_ID

NUMBER(9)

ID of the function library this function belongs to

FUNCTION_LIBRARY_NAME

VARCHAR2(255)

Physical name of the function library

FUNCTION_ID

NUMBER(9)

ID of this function

FUNCTION_NAME

VARCHAR2(255)

Physical name of this function

FUNCTION_TYPE

VARCHAR2(13)

Type of this function (function, procedure, table function)

SIGNATURE

VARCHAR2(4000)

Signature of this function

IS_VALID

VARCHAR2(13)

Is this function valid

BUSINESS_NAME

VARCHAR2(4000)

Business name of this function

DESCRIPTION

VARCHAR2(4000)

Description of this function

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-77 ALL_IV_FUNCTION_LIBRARIES

Column Name Data Type Description

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the module this function library belongs to

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of the module

FUNCTION_LIBRARY_ID

NUMBER(9)

ID of this function library

FUNCTION_LIBRARY_NAME

VARCHAR2(255)

Physical name of this function library

FUNCTION_LIBRARY_TYPE

VARCHAR2(40)

Type of this function library

IS_VALID

VARCHAR2(13)

Is this function library valid

BUSINESS_NAME

VARCHAR2(4000)

Business name of this function library

DESCRIPTION

VARCHAR2(4000)

Description of this function library

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-78 ALL_IV_FUNCTION_PARAMETERS

Column Name Data Type Description

FUNCTION_ID

NUMBER(9)

ID of the function this parameter belongs to

FUNCTION_NAME

VARCHAR2(255)

Physical name of the function

PARAMETER_ID

NUMBER(9)

ID of this parameter

PARAMETER_NAME

VARCHAR2(255)

Physical name of this parameter

PARAMETER_TYPE

VARCHAR2(40)

Type of this parameter

BUSINESS_NAME

VARCHAR2(4000)

Business name of this parameter

DESCRIPTION

VARCHAR2(4000)

Description of this parameter

POSITION

NUMBER(9)

Position of this parameter within the function

DATA_TYPE

VARCHAR2(255)

Data type of this parameter

LENGTH

NUMBER(9)

Data length of this parameter

PRECISION

NUMBER(9)

Data precision of this parameter

SCALE

NUMBER(9)

Data scale of this parameter

DEFAULT_VALUE

VARCHAR2(4000)

Default value of this parameter

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-79 ALL_IV_TABLE_FUNCTIONS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this table function belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

FUNCTION_LIBRARY_ID

NUMBER(9)

ID of the function library this table function belongs to

FUNCTION_LIBRARY_NAME

VARCHAR2(255)

Physical name of the function library

FUNCTION_ID

NUMBER(9)

ID of this table function

FUNCTION_NAME

VARCHAR2(255)

Physical name of this table function

FUNCTION_TYPE

VARCHAR2(13)

Type of this table function (constant value: Table Function)

SIGNATURE

VARCHAR2(4000)

Signature of this table function

IS_VALID

VARCHAR2(13)

Is this table function valid

BUSINESS_NAME

VARCHAR2(4000)

Business name of this table function

DESCRIPTION

VARCHAR2(4000)

Description of this table function

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-80 ALL_IV_FUNCTION_IMPLS

Column Name Data Type Description

FUNCTION_ID

NUMBER(9)

ID of the function

FUNCTION_NAME

VARCHAR2(255)

Physical name of the function

FUNCTION_IMPLEMENTATION_ID

NUMBER(9)

ID of the function implementation for this function

FUNCTION_IMPLEMENTATION_NAME

VARCHAR2(255)

Physical name of the function implementation

LANGUAGE

VARCHAR2(255)

Name of the language being used in the implementation

SCRIPT

VARCHAR2(4000)

Implementation script for this function

BUSINESS_NAME

VARCHAR2(4000)

Business name for this implementation

DESCRIPTION

VARCHAR2(4000)

Description for this implementation

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Configuration Model Views

Table 2-81 ALL_IV_OBJECT_CONFIGURATIONS

Column Name Data Type Description

CONFIGURED_OBJECT_ID

NUMBER(9)

ID of the object being configured

CONFIGURED_OBJECT_NAME

VARCHAR2(255)

Physical name of the object

CONFIGURED_OBJECT_TYPE

VARCHAR2(4000)

Type of the object

CONFIGURATION_PARAMETER_KEY

VARCHAR2(128)

Key of configuration parameter

CONFIGURATION_PARAMETER_NAME

VARCHAR2(64)

Name of configuration parameter

PARAMETER_NLSKEY

VARCHAR2(64)

National Language Support (NLS) key of the parameter

CONFIGURATION_PARAMETER_TYPE

CHAR(23)

Type of the configuration parameter

ARGUMENT

VARCHAR2(128)

Value of the configuration parameter

GROUP_NAME

VARCHAR2(322)

Name of the configuration group

GROUP_NLSKEY

VARCHAR2(64)

National Language Support (NLS) key of the configuration group

LANGUAGE

VARCHAR2(64)

Name of the language being used for this configuration


Table 2-82 ALL_IV_CONFIGURATIONS

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

CONFIGURATION_ID

NUMBER(9)

ID of the configuration

CONFIGURATION_NAME

VARCHAR2(255)

Name of the configuration

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-83 ALL_IV_CONTROL_CENTERS

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

CONTROL_CENTER_ID

NUMBER(9)

ID of the control center

CONTROL_CENTER_NAME

VARCHAR2(255)

Name of the control center

BUSINESS_NAME

VARCHAR2(1000)

Business name of the control center

DESCRIPTION

VARCHAR2(4000)

Description of the control center

HOST

VARCHAR2(255)

Host of the control center

SERVICE_NAME

VARCHAR2(4000)

Service name of the control center

PORT

NUMBER

Port of the control center

USERNAME

VARCHAR2(4000)

User name who will connect to the control center

SCHEMA

VARCHAR2(40)

Schema for the control center

IS_VALID

VARCHAR2(13)

The result of the last validation performed against the control center

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Deployment Model Views

Table 2-84 ALL_IV_CONNECTORS

Column Name Data Type Description

LOCATION_ID

NUMBER(9)

ID of the location owning this connector

LOCATION_NAME

VARCHAR2(255)

Physical name of the location

CONNECTOR_ID

NUMBER(9)

ID of this connector

CONNECTOR_NAME

VARCHAR2(255)

Physical name of this connector

BUSINESS_NAME

VARCHAR2(4000)

Business name of this connector

DESCRIPTION

VARCHAR2(4000)

Description of this connector

REFERENCED_LOCATION_ID

NUMBER(9)

ID of the location this connector references to

REFERENCED_LOCATION_NAME

VARCHAR2(255)

Physical name of the location this connector references to

IS_VALID

VARCHAR2(13)

Is this connector valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-85 ALL_IV_LOCATIONS

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project this location belongs to

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

LOCATION_ID

NUMBER(9)

ID of this location

LOCATION_NAME

VARCHAR2(255)

Physical name of this location

LOCATION_TARGET_TYPE

VARCHAR2(40)

Target type of this location

LOCATION_TARGET_VERSION

VARCHAR2(40)

Target version of this location

APPLICATION_TYPE

VARCHAR2(255)

Application type of the location connected to

SYSTEM_TYPE

VARCHAR2(255)

System type of this location connected to

IS_VALID

VARCHAR2(13)

Is this location valid

BUSINESS_NAME

VARCHAR2(4000)

Business name of this location

DESCRIPTION

VARCHAR2(4000)

Description of this location

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-86 ALL_IV_RUNTIME_REPOSITORIES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project this repository belongs to (also called runtime location, or simply, location)

PROJECT_NAME

VARCHAR2(255)

Physical name of the project

LOCATION_ID

NUMBER(9)

ID of this runtime location

LOCATION_NAME

VARCHAR2(255)

Physical name of this runtime location

LOCATION_TYPE

VARCHAR2(255)

Type of this runtime location

APPLICATION_TYPE

VARCHAR2(255)

Type of the application this location connected to

SYSTEM_TYPE

VARCHAR2(255)

Type of the system this location connected to

BUSINESS_NAME

VARCHAR2(4000)

Business name of this runtime location

DESCRIPTION

VARCHAR2(4000)

Description of this runtime location

HOST

VARCHAR2(40)

Host name of the connection for this location

SERVICE_NAME

VARCHAR2(40)

Service name of the connection for this location

PORT

NUMBER(9)

Port of the connection for this location

USERNAME

VARCHAR2(40)

User name of the connection for this location

SCHEMA

VARCHAR2(40)

Schema name of the connection for this location

IS_VALID

VARCHAR2(13)

Is this runtime location valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Mapping Model Views

Table 2-87 ALL_IV_XFORM_MAPS

Column Name Data Type Description

INFORMATION_SYSTEM_ID

NUMBER(9)

ID of the module this map belongs to

INFORMATION_SYSTEM_NAME

VARCHAR2(255)

Physical name of the module

MAP_ID

NUMBER(9)

ID of this map

MAP_NAME

VARCHAR2(255)

Physical name of this map

BUSINESS_NAME

VARCHAR2(4000)

Business name of this map

DESCRIPTION

VARCHAR2(4000)

Description of this map

COMPOSITE_MAP_COMPONENT_ID

NUMBER(9)

Same as MAP_ID

COMPOSITE_MAP_COMPONENT_NAME

VARCHAR2(255)

Same as MAP_NAME

IS_VALID

VARCHAR2(13)

Is this map valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-88 ALL_IV_XFORM_MAP_COMPONENTS

Column Name Data Type Description

MAP_ID

NUMBER(9)

ID of the map this map component belongs to

MAP_NAME

VARCHAR2(255)

Physical name of the map

MAP_COMPONENT_ID

NUMBER(9)

ID of this map component (also called map operator)

MAP_COMPONENT_NAME

VARCHAR2(255)

Physical name of this map component

BUSINESS_NAME

VARCHAR2(4000)

Business name of this map component

DESCRIPTION

VARCHAR2(4000)

Description of this map component

OPERATOR_TYPE

VARCHAR2(4000)

Type of this map component (for example, Filter, Joiner, Table)

COMPOSITE_MAP_COMPONENT_ID

NUMBER(9)

Same as MAP_COMPONENT_ID

COMPOSITE_MAP_COMPONENT_NAME

VARCHAR2(255)

Same as MAP_COMPONENT_NAME

DATA_ENTITY_ID

NUMBER(9)

ID of the data entity this map component synchronized to

DATA_ENTITY_NAME

VARCHAR2(255)

Physical name of the data entity

DATA_ENTITY_TYPE

VARCHAR2(4000)

Type of the data entity

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-89 ALL_IV_XFORM_MAP_PARAMETERS

Column Name Data Type Description

MAP_COMPONENT_ID

NUMBER(9)

ID of the map component this parameter belongs to

MAP_COMPONENT_NAME

VARCHAR2(255)

Physical name of the map component

PARAMETER_ID

NUMBER(9)

ID of this parameter

PARAMETER_NAME

VARCHAR2(255)

Physical name of this parameter

BUSINESS_NAME

VARCHAR2(4000)

Business name of this parameter

DESCRIPTION

VARCHAR2(4000)

Description of this parameter

MAP_ID

NUMBER(9)

ID of the map containing the map component

MAP_NAME

VARCHAR2(255)

Physical name of the map

PARAMETER_GROUP_NAME

VARCHAR2(255)

Physical name of the parameter group name

PARAMETER_GROUP_ID

NUMBER(9)

ID of the parameter group

PARAMETER_TYPE

VARCHAR2(5)

Type of the parameter (IN, OUT, INOUT)

POSITION

NUMBER(9)

Position of the parameter within the group

DATA_TYPE

VARCHAR2(40)

Data type of the parameter

TRANSFORMATION_EXPRESSION

VARCHAR2(4000)

Textual expression of the transformation for this parameter

DATA_ITEM_ID

NUMBER(9)

ID of the data item this parameter synchronized to

DATA_ITEM_TYPE

VARCHAR2(40)

Type of the data item

DATA_ITEM_NAME

VARCHAR2(255)

Physical name of the data item

SOURCE_PARAMETER_ID

NUMBER(9)

ID of the source parameter (where this parameter connected from)

SOURCE_PARAMETER_NAME

VARCHAR2(255)

Physical name of the source parameter

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-90 ALL_IV_XFORM_MAP_PROPERTIES

Column Name Data Type Description

MAP_COMPONENT_ID

NUMBER(9)

ID of the map component this property belongs to

MAP_COMPONENT_NAME

VARCHAR2(255)

Physical name of the map component

PROPERTY_ID

NUMBER(9)

ID of this property

PROPERTY_NAME

VARCHAR2(255)

Physical name of this property

BUSINESS_NAME

VARCHAR2(4000)

Business name of this property

DESCRIPTION

VARCHAR2(4000)

Description of this property

PROPERTY_GROUP_NAME

VARCHAR2(255)

Physical name of this property group

PROPERTY_VALUE

VARCHAR2(4000)

Value of this property


Table 2-91 ALL_IV_XFORM_MAP_DETAILS

Column Name Data Type Description

MAP_COMPONENT_ID

NUMBER(9)

ID of the map component

MAP_COMPONENT_NAME

VARCHAR2(255)

Name of the map component

PARAMETER_NAME

VARCHAR2(255)

Name of the parameter

PARAMETER_ID

NUMBER(9)

ID of the parameter

POSITION

NUMBER(9)

Position

BUSINESS_NAME

VARCHAR2(1000)

Business name of map component

TRANSFORMATION_EXPRESSION

VARCHAR2(4000)

Transformation expression

DESCRIPTION

VARCHAR2(4000)

Description of map component

SOURCE_EXPRESSION

VARCHAR2(4000)

Source expression


Table 2-92 ALL_IV_PLUGGABLE_MAPS

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

MAP_LIBRARY_ID

NUMBER

ID of the map library

MAP_LIBRARY_NAME

VARCHAR2(255)

Name of the map library

MAP_ID

NUMBER(9)

ID of the map

MAP_NAME

VARCHAR2(255)

Name of the map

BUSINESS_NAME

VARCHAR2(1000)

Business name of the map

DESCRIPTION

VARCHAR2(4000)

Description of the map

IS_VALID

VARCHAR2(13)

Is the map valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-93 ALL_IV_PLUGGABLE_MAP_LIBRARIES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

MAP_LIBRARY_ID

NUMBER(9)

ID of the map library

MAP_LIBRARY_NAME

VARCHAR2(255)

Name of the map library

BUSINESS_NAME

VARCHAR2(1000)

Business name of the map library

DESCRIPTION

VARCHAR2(4000)

Description of the map library

IS_VALID

VARCHAR2(13)

Is the library valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-94 ALL_IV_PLUG_MAP_PARAMETERS

Column Name Data Type Description

MAP_COMPONENT_ID

NUMBER(9)

ID of the map component

MAP_COMPONENT_NAME

VARCHAR2(255)

Name of the map component

PARAMETER_ID

NUMBER(9)

ID of the parameter

PARAMETER_NAME

VARCHAR2(255)

Name of the parameter

BUSINESS_NAME

VARCHAR2(1000)

Business name of the parameter

DESCRIPTION

VARCHAR2(4000)

Description of the parameter

MAP_ID

NUMBER(9)

ID of the map

MAP_NAME

VARCHAR2(255)

Name of the map

PARAMETER_GROUP_NAME

VARCHAR2(255)

Name of the parameter group

PARAMETER_GROUP_ID

NUMBER(9)

ID of the parameter group

PARAMETER_TYPE

VARCHAR2(5)

Type of the parameter

POSITION

NUMBER(9)

The position of the parameter

DATA_TYPE

VARCHAR2(4000)

The data type of the parameter

TRANSFORMATION_EXPRESSION

VARCHAR2(4000)

The expression of the parameter

DATA_ITEM_ID

NUMBER(9)

ID of the data item

DATA_ITEM_TYPE

VARCHAR2

Type of the data item

DATA_ITEM_NAME

VARCHAR2(255)

Name of the data item

SOURCE_PARAMETER_ID

NUMBER(9)

The ID of the parameter where this parameter is connected from

SOURCE_PARAMETER_NAME

VARCHAR2(255)

The name of the parameter where this parameter is connected from

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-95 ALL_IV_PLUG_MAP_COMPONENTS

Column Name Data Type Description

MAP_ID

NUMBER(9)

ID of the map

MAP_NAME

VARCHAR2(255)

Name of the map

MAP_COMPONENT_ID

NUMBER(9)

ID of the map component

MAP_COMPONENT_NAME

VARCHAR2(255)

Name of the map component

BUSINESS_NAME

VARCHAR2(1000)

Business name of the map component

DESCRIPTION

VARCHAR2(4000)

Description of the map component

OPERATOR_TYPE

VARCHAR2(4000)

The operator type of the map component

COMPOSITE_COMPONENT_ID

NUMBER(9)

ID of the map component

COMPOSITE_COMPONENT_NAME

VARCHAR2(255)

Name of the map component

DATA_ENTITY_ID

NUMBER(9)

ID of the data entity

DATA_ENTITY_TYPE

VARCHAR2(4000)

Type of data entity

DATA_ENTITY_NAME

VARCHAR2(255)

Name of the data entity

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Process Flow Model Views

Table 2-96 ALL_IV_PACKAGES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the module this process package belongs to

SCHEMA_NAME

VARCHAR2(255)

Physical name of the module

PACKAGE_ID

NUMBER(9)

ID of this process package

PACKAGE_NAME

VARCHAR2(255)

Physical name of this process package

BUSINESS_NAME

VARCHAR2(4000)

Business name of this process package

DESCRIPTION

VARCHAR2(4000)

Description of this process package

IS_VALID

VARCHAR2(13)

Is this process package valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-97 ALL_IV_PROCESSES

Column Name Data Type Description

PACKAGE_ID

NUMBER(9)

ID of the process package this process belongs to

PACKAGE_NAME

VARCHAR2(255)

Physical name of the process package

PARENT_PROCESS_ID

NUMBER(9)

ID of the parent process for this process

PARENT_PROCESS_NAME

VARCHAR2(255)

Physical name of the parent process for this process

PROCESS_ID

NUMBER(9)

ID of this process

PROCESS_NAME

VARCHAR2(255)

Physical name of this process

BUSINESS_NAME

VARCHAR2(4000)

Business name of this process

DESCRIPTION

VARCHAR2(4000)

Description of this process

BOUND_OBJECT_ID

NUMBER(9)

ID of the bound object

BOUND_OBJECT_NAME

VARCHAR2(255)

Name of the bound object

IS_VALID

VARCHAR2(13)

Is this process valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-98 ALL_IV_PROCESS_ACTIVITIES

Column Name Data Type Description

PROCESS_ID

NUMBER(9)

ID of the process this activity belongs to

PROCESS_NAME

VARCHAR2(255)

Physical name of the process

ACTIVITY_ID

NUMBER(9)

ID of this process activity

ACTIVITY_NAME

VARCHAR2(255)

Physical name of this activity

ACTIVITY_TYPE

VARCHAR2(4000)

Type of this activity

BOUND_OBJECT_ID

NUMBER(9)

ID of the bound object

BOUND_OBJECT_NAME

VARCHAR2(255)

Name of the bound object

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-99 ALL_IV_PROCESS_PARAMETERS

Column Name Data Type Description

PARAMETER_OWNER_ID

NUMBER(9)

ID of the owning object for this parameter

PARAMETER_OWNER_NAME

VARCHAR2(255)

Physical name of the owning object for this parameter

PARAMETER_OWNER_TYPE

CHAR(14)

Type of the owning object

PARAMETER_ID

NUMBER(9)

ID of this parameter

PARAMETER_NAME

VARCHAR2(255)

Physical name of this parameter

BUSINESS_NAME

VARCHAR2(4000)

Business name of this parameter

DESCRIPTION

VARCHAR2(4000)

Description of this parameter

POSITION

NUMBER(9)

Position of this parameter

DATA_TYPE

VARCHAR2(40)

Data type of this parameter

DEFAULT_VALUE

VARCHAR2(4000)

Default value for this parameter

DIRECTION

VARCHAR2(3)

Direction of this parameter (IN, OUT)

IS_FINAL

CHAR(1)

Is process final

BOUNDDATA_ID

NUMBER(9)

ID of the bound data for this parameter

BOUNDDATA_NAME

VARCHAR2(255)

Physical name of the bound data

BOUNDDATA_TYPE

VARCHAR2(40)

Type of the bound data

BOUNDDATA_VALUE

VARCHAR2(4000)

Value of the bound data

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-100 ALL_IV_PROCESS_TRANSITIONS

Column Name Data Type Description

PROCESS_ID

NUMBER(9)

ID of the process this transition belongs to

PROCESS_NAME

VARCHAR2(255)

Physical name of the process

TRANSITION_ID

NUMBER(9)

ID of this transition

TRANSITION_NAME

VARCHAR2(255)

Physical name of this transition

BUSINESS_NAME

VARCHAR2(4000)

Business name of this transition

DESCRIPTION

VARCHAR2(4000)

Description of this transition

CONDITION

VARCHAR2(255)

Condition of this transition

TRANSITION_ORDER

NUMBER(9)

Order of this transition

SOURCE_ACTIVITY_ID

NUMBER(9)

ID of the source activity for this transition

SOURCE_ACTIVITY_NAME

VARCHAR2(255)

Physical name of the source activity

TARGET_ACTIVITY_ID

NUMBER(9)

ID of the target activity for this transition

TARGET_ACTIVITY_NAME

VARCHAR2(255)

Physical name of the target activity

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-101 ALL_IV_PROCESS_VARIABLES

Column Name Data Type Description

PROCESS_ID

NUMBER(9)

ID of the process this variable belongs to

PROCESS_NAME

VARCHAR2(255)

Physical name of the process

VARIABLE_ID

NUMBER(9)

ID of this process variable

VARIABLE_NAME

VARCHAR2(255)

Physical name of this process variable

BUSINESS_NAME

VARCHAR2(4000)

Business name of this process variable

DESCRIPTION

VARCHAR2(4000)

Description of this process variable

POSITION

NUMBER(9)

Position of this variable

DATA_TYPE

VARCHAR2(40)

Data type of this variable

DEFAULT_VALUE

VARCHAR2(4000)

Default value of this variable

IS_FINAL

CHAR(1)

Is process final

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(255)

Updated by user

CREATED_BY

VARCHAR2(255)

Created by user


Table 2-102 ALL_IV_SUB_PROCESSES

Column Name Data Type Description

PACKAGE_ID

NUMBER(9)

ID of the package

PACKAGE_NAME

VARCHAR2(255)

Name of the package

PARENT_PROCESS_ID

NUMBER(9)

ID of the parent process

PARENT_PROCESS_NAME

VARCHAR2(255)

Name of the parent process

PROCESS_ID

NUMBER(9)

ID of the process

PROCESS_NAME

VARCHAR2(255)

Name of the process

BUSINESS_NAME

VARCHAR2(1000)

Business name of the condition

DESCRIPTION

VARCHAR2(4000)

Description of the condition

BOUND_OBJECT_ID

NUMBER(9)

ID of the bound object

BOUND_OBJECT_NAME

VARCHAR2(40)

Name of the bound object

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Data Profiling Views

Table 2-103 ALL_IV_PROFILES

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

PROFILE_ID

NUMBER(9)

ID of the profile

PROFILE_NAME

VARCHAR2(255)

Name of the profile

BUSINESS_NAME

VARCHAR2(1000)

Business name of the profile

DESCRIPTION

VARCHAR2(4000)

Description of the profile

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-104 ALL_IV_PROFILE_COLUMNS

Column Name Data Type Description

PROFILE_ID

NUMBER(9)

ID of the profile

PROFILE_NAME

VARCHAR2(255)

Name of the profile

PROFILE_OBJECT_ID

NUMBER(9)

ID of the profile object

ENTITY_ID

NUMBER(9)

ID of the entity

ENTITY_NAME

VARCHAR2(255)

Name of the entity

PROFILE_COLUMN_ID

NUMBER(9)

ID of the profile column

COLUMN_ID

NUMBER(9)

ID of the column

COLUMN_NAME

VARCHAR2(255)

Name of the column

BUSINESS_NAME

VARCHAR2(1000)

Business name of column

AVG_VALUE

VARCHAR2(40)

Average value of column if column has a numeric data type

MAX_VALUE

VARCHAR2(4000)

Maximum value stored in the column

MIN_VALUE

VARCHAR2(4000)

Minimum value stored in the column

MEDIAN_VALUE

VARCHAR2(4000)

Median value of column if column has a numeric data type

STDDEV_VALUE

VARCHAR2(40)

Standard deviation of column if column has a numeric data type

NUM_NULLS

NUMBER

Number of null values stored in the column

NUM_DISTINCT

NUMBER

Number of distinct values stored in the column

CONSENSUS_DATATYPE

VARCHAR2(40)

The discovered data type for the column

CONSENSUS_DATATYPE_CNT

VARCHAR2(40)

The number of rows that have the consensus data type

CONSENSUS_LENGTH

NUMBER

The predominant length of the column

CONSENSUS_LENGTH_CNT

NUMBER

The number of rows with the predominant length

CONSENSUS_PRECISION

NUMBER

The predominant precision of the column

CONSENSUS_PRECISION_CNT

NUMBER

The number of rows with the predominant precision

CONSENSUS_SCALE

NUMBER

The predominant scale of the column

CONSENSUS_SCALE_CNT

NUMBER

The number of rows with the predominant scale

COMMON_FORMAT

VARCHAR2(40)

The discovered common format

COMMON_FORMAT_CNT

VARCHAR2(40)

The number of rows that have this discovered common format

DOMINANT_CHARACTER_PATTERN

VARCHAR2(4000)

The discovered pattern at the character level of the column

DOMINANT_CHARACTER_PATTERN_CNT

VARCHAR2(40)

The number of rows that satisfy the character level pattern

DOMINANT_WORD_PATTERN

VARCHAR2(4000)

The discovered pattern at the word level of the column

DOMINANT_WORD_PATTERN_CNT

VARCHAR2(40)

The number of rows that satisfy the word level pattern

MAX_LENGTH

NUMBER

Maximum length of the values stored in the column

MIN_LENGTH

NUMBER

Minimum length of the values stored in the column

MAX_PRECISION

NUMBER

Maximum precision of the values stored in the column

MIN_PRECISION

NUMBER

Minimum precision of the values stored in the column

MAX_SCALE

NUMBER

Maximum scale of the values stored in the column

MIN_SCALE

NUMBER

Minimum scale of the values stored in the column

CFORMAT_COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that satisfy the discovered common format

CFORMAT_DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row satisfies the discovered common format and which does not

CFORMAT_NONCOMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy the discovered common format

DATATYPE_COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that satisfy the discovered data type

DATATYPE_DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row satisfies the discovered data type and which does not

DATATYPE_NONCOMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy the discovered data type

DOMAIN_COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that contain the discovered domain values

DOMAIN_DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row contains the discovered domain values and which does not

DOMAIN_NONCOMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not contain the discovered domain values

NULL_COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that are null based on the configured null value

NULL_DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row is null and which isn't based on the configured null value

NULL_NONCOMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy the discovered common format

CHAR_PATTERN_COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that satisfy the discovered character pattern

CHAR_PATTERN_DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row satisfies the discovered character pattern and which does not

CHAR_PATTERN_NONCOM_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy the discovered character pattern

WORD_PATTERN_COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that satisfy the discovered word pattern

WORD_PATTERN_DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row satisfies the discovered word pattern and which does not

WORD_PATTERN_NONCOM_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy the discovered word pattern

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-105 ALL_IV_PROFILE_DOMAIN_VALUES

Column Name Data Type Description

PROFILE_OBJECT_ID

NUMBER(9)

ID of the profile object

PROFILE_COLUMN_ID

NUMBER(9)

ID of the profile column

COLUMN_NAME

VARCHAR2(255)

Name of the column

VALUE

VARCHAR2(4000)

Domain value

VALUE_COUNT

VARCHAR2(4000)

Number of rows that have this domain value

COMPLIANT

VARCHAR2(1)

Whether this domain value satisfies the domain value configuration


Table 2-106 ALL_IV_FUNCTIONAL_DEPENDENCIES

Column Name Data Type Description

PROFILE_ID

NUMBER(9)

ID of the profile

PROFILE_NAME

VARCHAR2(255)

Name of the profile

ENTITY_ID

NUMBER(9)

ID of the entity

ENTITY_NAME

VARCHAR2(255)

Name of the entity

FUNCTIONAL_DEPENDENCY_ID

NUMBER(9)

ID of the functional dependency

FUNCTIONAL_DEPENDENCY_NAME

VARCHAR2(255)

Name of the functional dependency

BUSINESS_NAME

VARCHAR2(1000)

Business name of the functional dependency

TYPE

VARCHAR2(15)

Type of functional dependency

DEPENDENT_COLUMN_ID

NUMBER(9)

ID of the dependent column in the functional dependency

FD_ERROR

NUMBER

The number of rows that do not satisfy this functional dependency

COMPLIANT_QUERY

VARCHAR2(4000)

The query that is used to retrieve the rows that satisfy this functional dependency

COMPLIANT_CNT_QUERY

VARCHAR2(4000)

Not used

NONCOMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy this functional dependency

NONCOMPLIANT_CNT_QUERY

VARCHAR2(4000)

Not used

DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row satisfies this functional dependency and which does not

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-107 ALL_IV_PROFILE_FOREIGN_KEYS

Column Name Data Type Description

PROFILE_ID

NUMBER(9)

ID of the profile

PROFILE_NAME

VARCHAR2(255)

Name of the profile

ENTITY_ID

NUMBER(9)

ID of the entity

ENTITY_NAME

VARCHAR2(255)

Name of the entity

FOREIGN_KEY_ID

NUMBER(9)

ID of the row relationship

FOREIGN_KEY_NAME

VARCHAR2(255)

Name of the row relationship

BUSINESS_NAME

VARCHAR2(1000)

Business name of the foreign key

UNIQUE_KEY_ID

NUMBER(9)

ID of the unique key

IS_DISCOVERED

VARCHAR2(3)

Should a foreign key be created on the column

IS_DOCUMENTED

VARCHAR2(3)

Indicates if a foreign key exists in the data dictionary for the column

LOCAL_MAX_CARDINALITY

VARCHAR2(40)

Maximum number of values found on the local side

LOCAL_MIN_CARDINALITY

VARCHAR2(40)

Minimum number of values found on the local side

REMOTE_MAX_CARDINALITY

VARCHAR2(40)

Maximum number of values found on the remote side

REMOTE_MIN_CARDINALITY

VARCHAR2(40)

Minimum number of values found on the remote side

NUM_ORPHANS

VARCHAR2(40)

Number of distinct values found in the local column but not in the remote column

COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that satisfy the discovered row relationship

COMPLIANT_CNT_QUERY

VARCHAR2(4000)

Not used

NONCOMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy the discovered common format

NONCOMPLIANT_CNT_QUERY

VARCHAR2(4000)

Not used

DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row satisfies the discovered row relationship and which does not

CHILDLESS_QUERY

VARCHAR2(4000)

Not used

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-108 ALL_IV_PROFILE_KEY_COLUMN_USES

Column Name Data Type Description

KEY_ID

NUMBER(9)

ID of the key

KEY_TYPE

VARCHAR2(4000)

Type of the key

KEY_NAME

VARCHAR2(255)

Name of the key

COLUMN_ID

NUMBER(9)

ID of the column

COLUMN_NAME

VARCHAR2(255)

Physical name of the column

BUSINESS_NAME

VARCHAR2(1000)

Business name of the column

POSITION

NUMBER(9)

Position of the column in the set


Table 2-109 ALL_IV_PROFILE_OBJECTS

Column Name Data Type Description

PROFILE_ID

NUMBER(9)

ID of the profile

PROFILE_NAME

VARCHAR2(255)

Name of the profile

PROFILE_OBJECT_ID

NUMBER(9)

ID of the profile object

OBJECT_ID

NUMBER(9)

ID of the object

PROFILE_OBJECT_NAME

VARCHAR2(255)

Name of the profile object

OBJECT_NAME

VARCHAR2(255)

Physical name of the object

OBJECT_TYPE

VARCHAR2(4000)

Type of the object

BUSINESS_NAME

VARCHAR2(1000)

Business name of the object

DESCRIPTION

VARCHAR2(4000)

Description of the profile object

IS_VALID

VARCHAR2(13)

Is the profile object valid

ROW_COUNT

NUMBER

Number of rows in the object

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-110 ALL_IV_PROFILE_PATTERN_VALUES

Column Name Data Type Description

PROFILE_OBJECT_ID

NUMBER(9)

ID of the profile object

PROFILE_COLUMN_ID

NUMBER(9)

ID of the profile column

COLUMN_NAME

VARCHAR2(255)

Name of the column

VALUE

VARCHAR2(4000)

Pattern value

VALUE_COUNT

VARCHAR2(4000)

The number of rows that satisfy this discovered pattern value

TYPE

VARCHAR2(9)

0 for Word Pattern, 1 for Character Pattern

COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy this pattern value

NONCOMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy this pattern value

DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row satisfies this pattern value and which does not


Table 2-111 ALL_IV_PROFILE_RULES

Column Name Data Type Description

PROFILE_OBJECT_ID

NUMBER(9)

ID of the profile object

DATA_RULE_USAGE_ID

NUMBER(9)

ID of the data rule usage

DATA_RULE_USAGE_NAME

VARCHAR2(255)

Name of the data rule usage

COMPLIANT_ROW_COUNT

VARCHAR2(4000)

The number of rows that comply with the data rule


Table 2-112 ALL_IV_PROFILE_UNIQUE_KEYS

Column Name Data Type Description

PROFILE_ID

NUMBER(9)

ID of the profile

PROFILE_NAME

VARCHAR2(255)

Name of the profile

ENTITY_ID

NUMBER(9)

ID of the entity

ENTITY_NAME

VARCHAR2(255)

Name of the entity

UNIQUE_KEY_ID

NUMBER(9)

ID of the unique key

UNIQUE_KEY_NAME

VARCHAR2(255)

Name of the unique key

BUSINESS_NAME

VARCHAR2(1000)

Business name of the unique key

IS_DISCOVERED

VARCHAR2(3)

Should a unique key be created on the column

IS_DOCUMENTED

VARCHAR2(3)

Indicates if a unique key exists on the column in the data dictionary

UK_ERROR

VARCHAR2(40)

Number of rows that do not satisfy this unique key

UK_PARTITION

VARCHAR2(40)

Not used

COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that satisfy this unique key

COMPLIANT_CNT_QUERY

VARCHAR2(4000)

Not used

NONCOMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy this unique key

NONCOMPLIANT_CNT_QUERY

VARCHAR2(4000)

Not used

DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row satisfies this unique key and which does not

CHILDLESS_QUERY

VARCHAR2(4000)

Not used

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Data Rules Views

Table 2-113 ALL_IV_DATA_RULES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

DATARULE_ID

NUMBER(9)

ID of the data rule

DATARULE_NAME

VARCHAR2(255)

Physical name of the data rule

BUSINESS_NAME

VARCHAR2(1000)

Business name of the data rule

DATARULE_TYPE

VARCHAR2(4000)

Type of data rule

DESCRIPTION

VARCHAR2(4000)

Description of the data rule

IS_VALID

VARCHAR2(13)

Not used

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-114 ALL_IV_DATA_RULE_ATTRIBUTES

Column Name Data Type Description

DATARULE_ID

NUMBER(9)

ID of the data rule

DATARULE_NAME

VARCHAR2(255)

Name of the data rule

DATARULEGROUP_ID

NUMBER(9)

ID of the owning data rule group

DATARULEGROUP_NAME

VARCHAR2(255)

Name of the owning data rule group

DATARULEATTR_ID

NUMBER(9)

ID of the data rule attribute

NAME

VARCHAR2(255)

Name of the data rule attribute

BUSINESS_NAME

VARCHAR2(1000)

Business name of data rule attribute

DESCRIPTION

VARCHAR2(4000)

Description of data rule attribute

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-115 ALL_IV_DATA_RULE_ATTR_USAGES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

RELATION_ID

NUMBER(9)

ID of owning relation

RELATION_NAME

VARCHAR2(255)

Name of owning relation

DATARULE_USAGE_ID

NUMBER(9)

ID of owning data rule usage

DATARULE_USAGE_NAME

VARCHAR2(255)

Name of owning data rule usage

DATARULE_GROUP_USAGE_ID

NUMBER(9)

ID of owning data rule usage group

DATARULE_GROUP_USAGE_NAME

VARCHAR2(255)

Name of owning data rule usage group

DATARULE_ATTR_USAGE_ID

NUMBER(9)

ID of data rule attribute usage

NAME

VARCHAR2(255)

Name of data rule attribute usage

BUSINESS_NAME

VARCHAR2(1000)

Business name of data rule attribute usage

DESCRIPTION

VARCHAR2(4000)

Description of data rule attribute usage

DATARULE_SCHEMA_ID

NUMBER(9)

ID of data rule folder

DATARULE_SCHEMA_NAME

VARCHAR2(255)

Name of data rule folder

DATARULE_ID

NUMBER(9)

ID of data rule

DATARULE_NAME

VARCHAR2(255)

Name of data rule

DATARULE_GROUP_ID

NUMBER(9)

ID of data rule group

DATARULE_GROUP_NAME

VARCHAR2(255)

Name of data rule group

DATARULE_ATTR_ID

NUMBER(9)

ID of data rule attribute

DATARULE_ATTR_NAME

VARCHAR2(255)

Name of data rule attribute

REFERENCED_SCHEMA

NUMBER(9)

ID of referenced schema of date rule usage group

REFERENCE_SCHEMA_NAME

VARCHAR2(255)

Name of referenced schema of data rule usage group

REFERENCED_RELATION_ID

NUMBER(9)

ID if referenced relation of data rule usage group

REFERENCE_RELATION_NAME

VARCHAR2(255)

Name of referenced relation of data rule usage group

ATTRIBUTE_ID

NUMBER(9)

ID of the attribute

ATTRIBUTE_NAME

VARCHAR2(255)

Name of the attribute

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-116 ALL_IV_DATA_RULE_DOMAINS

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

DATARULE_ID

NUMBER(9)

ID of the data rule

DATARULE_NAME

VARCHAR2(255)

Name of the data rule

PROPERTY_ID

NUMBER(9)

ID of domain property

NAME

VARCHAR2(255)

Value of domain property

BUSINESS_NAME

VARCHAR2(1000)

Not used

DESCRIPTION

VARCHAR2(4000)

Description of the data rule

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-117 ALL_IV_DATA_RULE_GROUPS

Column Name Data Type Description

DATARULE_ID

NUMBER(9)

ID of the data rule

DATARULE_NAME

VARCHAR2(255)

Physical name of the data rule

DATARULEGROUP_ID

NUMBER(9)

ID of data rule group

DATARULEGROUP_NAME

VARCHAR2(255)

Name of data rule group

BUSINESS_NAME

VARCHAR2(1000)

Business name of data rule group

DESCRIPTION

VARCHAR2(4000)

Description of the data rule group

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-118 ALL_IV_DATA_RULE_GROUP_USAGES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

RELATION_ID

NUMBER(9)

ID of owning relation

RELATION_NAME

VARCHAR2(255)

Name of owning relation

DATARULE_USAGE_ID

NUMBER(9)

ID of data rule usage

DATARULE_USAGE_NAME

VARCHAR2(255)

Name of data rule usage

DATARULE_GROUP_USAGE_ID

NUMBER(9)

ID of data rule usage group

NAME

VARCHAR2(255)

Name of data rule usage group

BUSINESS_NAME

VARCHAR2(1000)

Business name of data rule usage group

DESCRIPTION

VARCHAR2(4000)

Description of data rule usage group

DATARULE_SCHEMA_ID

NUMBER(9)

ID of referenced data rule folder

DATARULE_SCHEMA_NAME

VARCHAR2(255)

Name of referenced data rule folder

DATARULE_ID

NUMBER(9)

ID of referenced data rule

DATARULE_NAME

VARCHAR2(255)

Name of referenced data rule

DATARULE_GROUP_ID

NUMBER(9)

ID of referenced data rule group

DATARULE_GROUP_NAME

VARCHAR2(255)

Name of referenced data rule group

REFERENCED_SCHEMA

NUMBER(9)

ID of referenced schema

REFERENCE_SCHEMA_NAME

VARCHAR2(255)

Name of referenced schema

REFERENCED_RELATION_ID

NUMBER(9)

ID of referenced relation

REFERENCE_RELATION_NAME

VARCHAR2(255)

Name of referenced relation

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-119 ALL_IV_DATA_RULE_PROPERTIES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

DATARULE_ID

NUMBER(9)

ID of the data rule

DATARULE_NAME

VARCHAR2(255)

Physical name of the data rule

PROPERTY_ID

NUMBER(9)

ID of data rule property

NAME

VARCHAR2(255)

Name of data rule property

BUSINESS_NAME

VARCHAR2(1000)

Business name of the data rule property

VALUE

VARCHAR2(4000)

Value of data rule property

DESCRIPTION

VARCHAR2(4000)

Description of the data rule property

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-120 ALL_IV_DATA_RULE_USAGES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the owning schema

SCHEMA_NAME

VARCHAR2(255)

Name of the owning schema

RELATION_ID

NUMBER(9)

Owning relation of data rule usage

RELATION_NAME

VARCHAR2(255)

Name of owning relation of data rule usage

DATARULE_USAGE_ID

NUMBER(9)

ID of data rule usage

NAME

VARCHAR2(255)

Name of data rule usage

BUSINESS_NAME

VARCHAR2(1000)

Business name of data rule usage

DESCRIPTION

VARCHAR2(4000)

Description of data rule usage

DATARULE_SCHEMA_ID

NUMBER(9)

Referenced data rule folder ID

DATARULE_SCHEMA_NAME

VARCHAR2(255)

Referenced data rule folder name

DATARULE_ID

NUMBER(9)

Referenced data rule ID

DATARULE_NAME

VARCHAR2(255)

Referenced data rule name

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


User Defined Object Views

Table 2-121 ALL_IV_UDO_FCOS

Column Name Data Type Description

OWNER_ID

NUMBER(9)

ID of the owner

OWNER_NAME

VARCHAR2(255)

Name of the owner

FIRST_CLASS_OBJECT_ID

NUMBER(9)

ID of the First Class Object

FIRST_CLASS_OBJECT_NAME

VARCHAR2(255)

Name of the First Class Object

FIRST_CLASS_OBJECT_TYPE

VARCHAR2(255)

Type of the First Class Object

BUSINESS_NAME

VARCHAR2(1000)

Business name of the First Class Object

DESCRIPTION

VARCHAR2(4000)

Description of the First Class Object

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-122 ALL_IV_UDO_FOLDERS

Column Name Data Type Description

OWNER_ID

NUMBER(9)

ID of the owner

OWNER_NAME

VARCHAR2(255)

Name of the owner

FOLDER_ID

NUMBER(9)

ID of the folder

FOLDER_NAME

VARCHAR2(255)

Name of the folder

FOLDER_TYPE

VARCHAR2(255)

Type of folder

BUSINESS_NAME

VARCHAR2(1000)

Business name of the folder

DESCRIPTION

VARCHAR2(4000)

Description of the folder

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-123 ALL_IV_UDO_SCOS

Column Name Data Type Description

OWNER_ID

NUMBER(9)

ID of the owner

OWNER_NAME

VARCHAR2(255)

Name of the owner

SECOND_CLASS_OBJECT_ID

NUMBER(9)

ID of the Second Class Object

SECOND_CLASS_OBJECT_NAME

VARCHAR2(255)

Name of the Second Class Object

SECOND_CLASS_OBJECT_TYPE

VARCHAR2(255)

Type of Second Class Object

BUSINESS_NAME

VARCHAR2(1000)

Business name of the Second Class Object

DESCRIPTION

VARCHAR2(4000)

Description of the Second Class Object

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-124 ALL_IV_UDO_ASSOCIATIONS

Column Name Data Type Description

OWNER_ID

NUMBER(9)

ID of the owner

OWNER_NAME

VARCHAR2(255)

Name of the owner

OWNER_TYPE

VARCHAR2(255)

Type of the owner

ASSOCIATION_ID

NUMBER(9)

ID of the association

SOURCE_ROLE

VARCHAR2(255)

Role of the owner

TARGET_ROLE

VARCHAR2(255)

Role of the associated object

TARGET_ID

NUMBER(9)

ID of the target

TARGET_NAME

VARCHAR2(255)

Name of the target

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Expert Views

Table 2-125 ALL_IV_EXPERTS

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

EXPERT_ID

NUMBER(9)

ID of the expert

EXPERT_NAME

VARCHAR2(255)

Name of the expert

BUSINESS_NAME

VARCHAR2(1000)

Business name of the expert

DESCRIPTION

VARCHAR2(4000)

Description of the expert

BOUND_OBJECT_ID

NUMBER(9)

ID of the bound object

BOUND_OBJECT_NAME

VARCHAR2(40)

Name of the bound object

IS_VALID

VARCHAR2(13)

Is this expert valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-126 ALL_IV_EXPERT_PARAMETERS

Column Name Data Type Description

PARAMETER_OWNER_ID

NUMBER(9)

ID of the parameter owner

PARAMETER_OWNER_NAME

VARCHAR2(255)

Name of the parameter owner

PARAMETER_OWNER_TYPE

VARCHAR2(6)

Type of the parameter owner

PARAMETER_ID

NUMBER(9)

ID of the parameter

PARAMETER_NAME

VARCHAR2(255)

Name of the parameter

BUSINESS_NAME

VARCHAR2(1000)

Business name of the parameter

DESCRIPTION

VARCHAR2(4000)

Description of the parameter

POSITION

NUMBER(9)

The position of the parameter

DATA_TYPE

VARCHAR2(40)

Data type for this parameter

DEFAULT_VALUE

VARCHAR2(4000)

Default value

DIRECTION

VARCHAR2(5)

Direction of this parameter

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-127 ALL_IV_EXPERT_TASKS

Column Name Data Type Description

EXPERT_ID

NUMBER(9)

ID of the expert

EXPERT_NAME

VARCHAR2(255)

Name of the expert

TASK_ID

NUMBER(9)

ID of the task

TASK_NAME

VARCHAR2(255)

Name of the task

BUSINESS_NAME

VARCHAR2(1000)

Business name of the task

DESCRIPTION

VARCHAR2(4000)

Description of the task

TASK_TYPE

VARCHAR2(4000)

Type of the task

BOUND_OBJECT_ID

NUMBER(9)

ID of the bound object

BOUND_OBJECT_NAME

VARCHAR2(40)

Name of the bound object

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user

MAIN

VARCHAR2(4000)

The main processing script of the task

PREPROCESSING

VARCHAR2(4000)

The pre-processing script of the task

POSTPROCESSING

VARCHAR2(4000)

The post-processing script of the task

INSTRUCTION

VARCHAR2(4000)

Instruction for running the task


Table 2-128 ALL_IV_EXPERT_TRANSITIONS

Column Name Data Type Description

EXPERT_ID

NUMBER(9)

ID of the expert

EXPERT_NAME

VARCHAR2(255)

Name of the expert

TRANSITION_ID

NUMBER(9)

ID of the transition

TRANSITION_NAME

VARCHAR2(255)

Name of the transition

BUSINESS_NAME

VARCHAR2(1000)

Business name of the transition

DESCRIPTION

VARCHAR2(4000)

Description of the transition

CONDITION

VARCHAR2(4000)

Transition condition

TRANSITION_ORDER

NUMBER(9)

Transition order

SOURCE_ACTIVITY_ID

NUMBER(9)

ID of the source task

SOURCE_ACTIVITY_NAME

VARCHAR2(255)

Name of the source task

TARGET_ACTIVITY_ID

NUMBER(9)

ID of the target task

TARGET_ACTIVITY_NAME

VARCHAR2(255)

Name of the target task

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-129 ALL_IV_EXPERT_VARIABLES

Column Name Data Type Description

EXPERT_ID

NUMBER(9)

ID of the expert

EXPERT_NAME

VARCHAR2(255)

Name of the expert

VARIABLE_ID

NUMBER(9)

ID of the variable

VARIABLE_NAME

VARCHAR2(255)

Name of the variable

BUSINESS_NAME

VARCHAR2(1000)

Business name of the variable

DESCRIPTION

VARCHAR2(4000)

Description of the variable

POSITION

NUMBER(9)

Position of the variable

DATA_TYPE

VARCHAR2(40)

Data type of the variable

DEFAULT_VALUE

VARCHAR2(4000)

Default value of the variable

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-130 ALL_IV_NESTED_EXPERTS

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

PARENT_EXPERT_ID

NUMBER(9)

ID of the parent expert

PARENT_EXPERT_NAME

VARCHAR2(255)

Name of the parent expert

EXPERT_ID

NUMBER(9)

ID of the expert

EXPERT_NAME

VARCHAR2(255)

Name of the expert

BUSINESS_NAME

VARCHAR2(1000)

Business name of the expert

DESCRIPTION

VARCHAR2(4000)

Description of the expert

BOUND_OBJECT_ID

NUMBER(9)

ID of the bound object

BOUND_OBJECT_NAME

VARCHAR2(40)

Name of the bound object

IS_VALID

VARCHAR2(13)

Is this nested expert valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Business Intelligence Views

Table 2-131 ALL_IV_ALTERNATIVE_SORT_ORDERS

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

ALT_SORT_ORDER_ID

NUMBER(9)

ID of the alternative sort order

ALT_SORT_ORDER_NAME

VARCHAR2(255)

Name of the alternative sort order

BUSINESS_NAME

VARCHAR2(1000)

Business name of the alternative sort order

DESCRIPTION

VARCHAR2(4000)

Description of the alternative sort order

IS_DRILL_TO_DETAIL

CHAR(1)

Whether it acts as a Drill to Detail when deployed to Discoverer

IS_CACHE_VALUES

CHAR(1)

Indicates whether Discoverer should cache the list of values in memory for the current session, once it has been displayed for the first time

IS_REQUIRE_SEARCH

CHAR(1)

Causes Discoverer to request the end user to enter search criteria to reduce the list of values to a subset of the whole list

IS_SHOW_IN_NAVIGATOR

CHAR(1)

Indicates that Discoverer should show the values in the "Select Items" page of the Worksheet Wizard (the item navigator).

IS_SORTED_DISTINCT

CHAR(1)

Indicates that the values should be displayed alphabetically sorted and with duplicates hidden

RETRIEVE_VALUE_GROUP_SIZE

NUMBER(9)

The maximum number of rows to be fetched from the database at a time

VALUES_ITEM_ID

NUMBER(9)

The ID of the item that contains the values to be sorted

VALUES_ITEM_NAME

VARCHAR2(255)

The name of the item that contains the values to be sorted

ORDER_ITEM_ID

NUMBER(9)

The identifier of the item that defines the order in which the values in the VALUES_ITEM_ID field are to be sorted

ORDER_ITEM_NAME

VARCHAR2(255)

The name of the item that defines the order in which the values in the VALUES_ITEM_ID field are to be sorted

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-132 ALL_IV_BUSINESS_AREAS

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

BUSINESS_AREA_ID

NUMBER(9)

Id of the business area

BUSINESS_AREA_NAME

VARCHAR2(255)

Name of the business area

BUSINESS_NAME

VARCHAR2(1000)

Business name of the business area

DESCRIPTION

VARCHAR2(4000)

Description of the business area

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-133 ALL_IV_BUSINESS_AREA_FOLDERS

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

BUSINESS_AREA_ID

NUMBER(9)

ID of the business area

BUSINESS_AREA_NAME

VARCHAR2(255)

Name of the business area

ITEM_FOLDER_ID

NUMBER(9)

Identifier of the Item Folder present in the Business Area

ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the item folder present in the business area

BUSINESS_NAME

VARCHAR2(1000)

Business name of the item folder present in the business area

DESCRIPTION

VARCHAR2(4000)

Description of the item folder present in the business area

FOLDER_TYPE

VARCHAR2(40)

The item folder type (simple or complex) of the item folder present in the business area

IS_VISIBLE

NUMBER

The visibility of the item folder to the end-user

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-134 ALL_IV_PRESENTATION_TEMPLATES

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

TEMPLATE_ID

NUMBER(9)

ID of the template

TEMPLATE_NAME

VARCHAR2(255)

Name of the template

BUSINESS_NAME

VARCHAR2(1000)

Business name of the presentation template

DESCRIPTION

VARCHAR2(4000)

Description of the presentation template

PRESENTATION_TYPE

VARCHAR2(40)

The presentation type (CROSSTAB, PIE, BAR_VERT_CLUST)

CUBE_ID

NUMBER(9)

ID of the cube that is referenced in the presentation template

CUBE_NAME

VARCHAR2(255)

Name of the cube that is referenced in the presentation template

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-135 ALL_IV_DRILLS_TO_DETAIL

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

DRILL_TO_DETAIL_ID

NUMBER(9)

ID of the drill to detail

DRILL_TO_DETAIL_NAME

VARCHAR2(255)

Name of the drill to detail

BUSINESS_NAME

VARCHAR2(1000)

Business name of the drill to detail

DESCRIPTION

VARCHAR2(4000)

Description of the drill to detail

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-136 ALL_IV_DRILL_LEVELS

Column Name Data Type Description

DRILL_PATH_ID

NUMBER(9)

The identifier of the owning drill path

DRILL_PATH_NAME

VARCHAR2(255)

The name of the owning drill path

DRILL_LEVEL_ID

NUMBER(9)

The identifier of the drill level

DRILL_LEVEL_NAME

VARCHAR2(255)

The name of the drill level

BUSINESS_NAME

VARCHAR2(1000)

The business name of the drill level

DESCRIPTION

VARCHAR2(4000)

The description of the drill level

PARENT_DRILL_LEVEL_ID

NUMBER(9)

The identifier of the parent level in the drill path hierarchy

PARENT_DRILL_LEVEL_NAME

VARCHAR2(255)

The name of the parent level in the drill path hierarchy

RELATED_LEVEL_ID

NUMBER(9)

The identifier of the hierarchy level that the drill level was derived from

RELATED_LEVEL_NAME

VARCHAR2(255)

The name of the hierarchy level that the drill level was derived from

ITEM_FOLDER_ID

NUMBER(9)

The identifier of the item folder that the drill level is based on

ITEM_FOLDER_NAME

VARCHAR2(255)

The name of the item folder that the drill level is based on

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-137 ALL_IV_ITEM_FOLDERS

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

ITEM_FOLDER_ID

NUMBER(9)

ID of the item folder

ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the item folder

BUSINESS_NAME

VARCHAR2(1000)

Business name of the item folder

DESCRIPTION

VARCHAR2(4000)

Description of the item folder

FOLDER_TYPE

VARCHAR2(40)

Type of item folder (simple or complex)

IS_VISIBLE

NUMBER

Whether the item folder is visible to the end user

SOURCE_OBJECT_ID

NUMBER(9)

ID of the source object

SOURCE_OBJECT_TYPE

VARCHAR2(4000)

Type of the source object (Table, Cube, Dimension)

SOURCE_OBJECT_NAME

VARCHAR2(255)

Name of the source object

DIMENSION_ROLE_ID

NUMBER(9)

If this item folder was derived for a dimension role, then this returns the identifier of that dimension role

DIMENSION_ROLE_NAME

VARCHAR2(255)

If this item folder was derived for a dimension role, then this returns the name of that dimension role

RELATED_LEVEL_ID

NUMBER(9)

If this item folder was derived for a level, then this returns the identifier of the level

RELATED_LEVEL_NAME

VARCHAR2(255)

If this item folder was derived for a level then this returns the name of the level

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-138 ALL_IV_ITEM_FOLDER_JOIN_USAGES

Column Name Data Type Description

ITEM_FOLDER_ID

NUMBER(9)

ID of the complex item folder

ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the complex item folder

JOIN_ID

NUMBER(9)

ID of the join between two base item folders of the complex item folder

JOIN_NAME

VARCHAR2(255)

Name of the join between two base item folders of the complex item folder


Table 2-139 ALL_IV_ITEMS

Column Name Data Type Description

ITEM_FOLDER_ID

NUMBER(9)

ID of the item folder

ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the item folder

ITEM_ID

NUMBER(9)

ID of the item

ITEM_NAME

VARCHAR2(255)

Name of the item

BUSINESS_NAME

VARCHAR2(1000)

Business name of the item

DESCRIPTION

VARCHAR2(4000)

Description of the item

IS_COLUMN_ITEM

CHAR(1)

Whether this item is based on a column

DATATYPE

VARCHAR2(40)

The data type of the item

ALIGNMENT

VARCHAR2(40)

Alignment for display (Default, Left, Center, Right)

CASE_STORAGE

VARCHAR2(40)

How alphabetic characters are stored in the database (Unknown, Lower, Upper, Mixed)

CONTENT_TYPE

VARCHAR2(40)

Specifies whether the item can be used to launch an external application

DEFAULT_AGGREGATE

VARCHAR2(255)

Name of default rollup function

DEFAULT_POSITION

VARCHAR2(40)

Default placement for query item (Unknown, Measure, Axis, X-axis, Y-axis, Z-axis)

DEFAULT_WIDTH

NUMBER(9)

Default number of characters in display

DISPLAY_CASE

VARCHAR2(40)

How alphabetic characters should be displayed (Unchanged, Lower, Upper, InitCapped)

FORMAT_MASK

VARCHAR2(255)

The format of the way that the item is displayed

FORMULA

CLOB

The item's expression

HEADING

VARCHAR2(255)

The value of the default heading in a report

IS_VISIBLE

NUMBER

Whether the item is visible to the end user

IS_WORD_WRAP

CHAR(1)

Whether word wrap is allowed when displaying values in a report

MAX_CHAR_FETCHED

NUMBER(9)

Maximum number of characters retrieved from the database

REPLACE_NULL_WITH

VARCHAR2(255)

Value to be displayed for null values

RELATED_ATTRIBUTE_ID

NUMBER(9)

If this item was derived, then the identifier of the attribute it was derived from

RELATED_ATTRIBUTE_TYPE

VARCHAR2(4000)

If this item was derived, then the type of the attribute it was derived from

RELATED_ATTRIBUTE_NAME

VARCHAR2(255)

If this item was derived, then the name of the attribute it was derived from

LIST_OF_VALUES_ID

NUMBER

If this item has a list of values, then the list of values identifier

LIST_OF_VALUES_NAME

VARCHAR2(255)

If this item has a list of values, then the list of values name

ALTERNATIVE_SORT_ORDER_ID

NUMBER

If this item has an alternative sort order then the ID of the alternative sort order

ALTERNATIVE_SORT_ORDER_NAME

VARCHAR2(255)

If this item has an alternative sort order then the name of the alternative sort order

DRILL_TO_DETAIL_ID

NUMBER

If this item has a drill to detail then the ID of the drill to detail

DRILL_TO_DETAIL_NAME

VARCHAR2(255)

If this item has a drill to detail then the name of the drill to detail

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-140 ALL_IV_ITEM_FORMULA_REFS

Column Name Data Type Description

ITEM_FOLDER_ID

NUMBER(9)

ID of the item folder

ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the item folder

ITEM_ID

NUMBER(9)

ID of the item

ITEM_NAME

VARCHAR2(255)

Name of the item

TAG

NUMBER(9)

Refers to the tag value used in the formula of the item

REFERENCED_FUNCTION_ID

NUMBER(9)

ID of the referenced function

REFERENCED_FUNCTION_TYPE

VARCHAR2(4000)

Type of the referenced function

REFERENCED_FUNCTION_NAME

VARCHAR2(255)

Name of the referenced function

REFERENCED_ITEM_FOLDER_ID

NUMBER(9)

ID of the referenced item folder

REFERENCED_ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the referenced item folder

REFERENCED_ITEM_ID

NUMBER(9)

ID of the referenced item

REFERENCED_ITEM_NAME

VARCHAR2(255)

Name of the referenced item


Table 2-141 ALL_IV_DATA_ITEMS

Column Name Data Type Description

TEMPLATE_ID

NUMBER(9)

ID of the presentation template

TEMPLATE_NAME

VARCHAR2(255)

Name of the presentation template

DATA_ITEM_ID

NUMBER(9)

ID of the data item

DATA_ITEM_NAME

VARCHAR2(255)

Name of the data item

BUSINESS_NAME

VARCHAR2(1000)

Business name of the data item

DESCRIPTION

VARCHAR2(4000)

Description of the data item

MEASURE_ID

NUMBER(9)

The identifier of the measure used as the data item

MEASURE_NAME

VARCHAR2(255)

The name of the measure used as the data item

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-142 ALL_IV_EDGE_ITEMS

Column Name Data Type Description

TEMPLATE_ID

NUMBER(9)

ID of the presentation template

TEMPLATE_NAME

VARCHAR2(255)

Name of the presentation template

EDGE_ITEM_ID

NUMBER(9)

Identifier of the edge item

EDGE_ITEM_NAME

VARCHAR2(255)

Name of the edge item

BUSINESS_NAME

VARCHAR2(1000)

Business name of the edge item

DESCRIPTION

VARCHAR2(4000)

Description of the edge item

PLACEMENT

VARCHAR2(40)

The axis the edge item is on

DIMENSION_ROLE_ID

NUMBER(9)

ID of the dimension role

DIMENSION_ROLE_NAME

VARCHAR2(255)

Name of the dimension role

DIMENSION_ID

NUMBER(9)

ID of the dimension

DIMENSION_NAME

VARCHAR2(255)

Name of the dimension

HIERARCHY_ID

NUMBER(9)

Not used

HIERARCHY_NAME

VARCHAR2(255)

Not used

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-143 ALL_IV_DRILL_PATHS

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

DRILL_PATH_ID

NUMBER(9)

ID of the drill path

DRILL_PATH_NAME

VARCHAR2(255)

Name of the drill path

BUSINESS_NAME

VARCHAR2(1000)

Business name of the drill path

DESCRIPTION

VARCHAR2(4000)

Description of the drill path

DIMENSION_ID

NUMBER(9)

If the drill path was derived from a dimension hierarchy, then the ID of the dimension

DIMENSION_NAME

VARCHAR2(255)

If the drill path was derived from a dimension hierarchy then the name of the dimension

DIMENSION_ROLE_ID

NUMBER(9)

If the drill path was derived from a dimension role's hierarchy then its identifier

DIMENSION_ROLE_NAME

VARCHAR2(255)

If the drill path was derived from a dimension role's hierarchy then its name

HIERARCHY_ID

NUMBER(9)

The identifier of the hierarchy the drill path was derived from

HIERARCHY_NAME

VARCHAR2(255)

The name of the hierarchy the drill path was derived from

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-144 ALL_IV_DRILL_LEVEL_ITEMS

Column Name Data Type Description

DRILL_PATH_ID

NUMBER(9)

Owning drill path identifier

DRILL_PATH_NAME

VARCHAR2(255)

Owning drill path name

DRILL_LEVEL_ID

NUMBER(9)

ID of the drill level

DRILL_LEVEL_NAME

VARCHAR2(255)

Name of the drill level

ITEM_FOLDER_ID

NUMBER(9)

Item folder ID

ITEM_FOLDER_NAME

VARCHAR2(255)

Item folder name

ITEM_ID

NUMBER(9)

ID of the item

ITEM_NAME

VARCHAR2(255)

Name of the item


Table 2-145 ALL_IV_DRILL_PATH_JOIN_USAGES

Column Name Data Type Description

DRILL_PATH_ID

NUMBER(9)

ID of the drill path

DRILL_PATH_NAME

VARCHAR2(255)

Name of the drill path

PARENT_DRILL_LEVEL_ID

NUMBER(9)

ID of the parent drill level

PARENT_DRILL_LEVEL_NAME

VARCHAR2(255)

Name of the parent drill level

CHILD_DRILL_LEVEL_ID

NUMBER(9)

ID of the child drill level

CHILD_DRILL_LEVEL_NAME

VARCHAR2(255)

Name of the child drill level

JOIN_ID

NUMBER(9)

ID of the join

JOIN_NAME

VARCHAR2(255)

Name of the join


Table 2-146 ALL_IV_LISTS_OF_VALUES

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

LIST_OF_VALUES_ID

NUMBER(9)

ID of the list of values

LIST_OF_VALUES_NAME

VARCHAR2(255)

Name of the list of values

BUSINESS_NAME

VARCHAR2(1000)

Business name of the list of values

DESCRIPTION

VARCHAR2(4000)

Description of the list of values

IS_DRILL_TO_DETAIL

CHAR(1)

Whether it acts as a drill to detail when deployed to Discoverer

IS_CACHE_VALUES

CHAR(1)

Indicates whether Discoverer should cache the list of values in memory for the current session, once it has been displayed for the first time

IS_REQUIRE_SEARCH

CHAR(1)

Value 1 causes Discoverer to request the end user to enter search criteria to reduce the list of values to a subset of the whole list

IS_SHOW_IN_NAVIGATOR

CHAR(1)

Indicates whether Discoverer should show the values in the "Select Items" page of the Worksheet Wizard (the item navigator)

IS_SORTED_DISTINCT

CHAR(1)

Value 1 indicates that the values should be displayed alphabetically sorted and with duplicates hidden

RETRIEVE_VALUE_GROUP_SIZE

NUMBER(9)

The maximum number of rows to be fetched from the database at a time

VALUES_ITEM_ID

NUMBER(9)

The identifier of the item that supplies the values

VALUES_ITEM_NAME

VARCHAR2(255)

The name of the item that supplies the values

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-147 ALL_IV_REGISTERED_FUNCTIONS

Column Name Data Type Description

MODULE_ID

NUMBER(9)

ID of the module

MODULE_NAME

VARCHAR2(255)

Name of the module

REGISTERED_FUNCTION_ID

NUMBER(9)

ID of the registered function

REGISTERED_FUNCTION_NAME

VARCHAR2(255)

Name of the registered function

BUSINESS_NAME

VARCHAR2(1000)

Business name of the registered function

DESCRIPTION

VARCHAR2(4000)

Description of the registered function

SIGNATURE

VARCHAR2(4000)

The signature of the registered function

IS_AVAILABLE

CHAR(1)

Whether a Discoverer end user may use this function in calculations

SOURCE_FUNCTION_ID

NUMBER(9)

The identifier of the function it was derived from

SOURCE_FUNCTION_NAME

VARCHAR2(255)

The name of the function it was derived from

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-148 ALL_IV_CONDITION_FORMULA_REFS

Column Name Data Type Description

ITEM_FOLDER_ID

NUMBER(9)

ID of the item folder

ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the item folder

ITEM_ID

NUMBER(9)

ID of the condition

ITEM_NAME

VARCHAR2(255)

Name of the condition

TAG

NUMBER(9)

Refers to the tag value used in the condition's formula

REFERENCED_FUNCTION_ID

NUMBER(9)

ID of the referenced function

REFERENCED_FUNCTION_TYPE

VARCHAR2(4000)

Type of the referenced function

REFERENCED_ITEM_ID

NUMBER(9)

ID of the referenced item

REFERENCED_ITEM_NAME

VARCHAR2(255)

Name of the referenced item

REFERENCED_CONDITION_ID

NUMBER(9)

ID of the referenced condition

REFERENCED_CONDITION_NAME

VARCHAR2(255)

Name of the referenced condition


Table 2-149 ALL_IV_JOIN_COMPONENTS

Column Name Data Type Description

ITEM_FOLDER_ID

NUMBER(9)

ID of the item folder

ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the item folder

JOIN_ID

NUMBER(9)

ID of the join

JOIN_NAME

VARCHAR2(255)

Name of the join

JOIN_COMPONENT_ID

NUMBER(9)

Identifier of the join component

JOIN_COMPONENT_NAME

VARCHAR2(255)

Name of the join component

BUSINESS_NAME

VARCHAR2(1000)

Business Name of the join component

DESCRIPTION

VARCHAR2(4000)

Description of the join component

JOIN_OPERATOR

VARCHAR2(40)

The operator for the join component

DETAIL_ITEM_ID

NUMBER(9)

The identifier of the item referenced in the detail item folder

DETAIL_ITEM_NAME

VARCHAR2(255)

The name of the item referenced in the detail item folder

MASTER_ITEM_ID

NUMBER(9)

The identifier of the item referenced in the master item folder

MASTER_ITEM_NAME

VARCHAR2(255)

The name of the item referenced in the master item folder

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-150 ALL_IV_JOINS

Column Name Data Type Description

ITEM_FOLDER_ID

NUMBER(9)

ID of the detail item folder

ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the detail item folder

JOIN_ID

NUMBER(9)

ID of the join

JOIN_NAME

VARCHAR2(255)

Name of the join

BUSINESS_NAME

VARCHAR2(1000)

Business name of the join

DESCRIPTION

VARCHAR2(4000)

Description of the join

IS_OUTER_JOIN_ON_MASTER

CHAR(1)

Indicates whether to perform an outer join on the master item folder. If this is set, any detail rows that have no related master row will be included in the results of the join

IS_OUTER_JOIN_ON_DETAIL

CHAR(1)

Indicates whether to perform an outer join on the detail item folder. If this is set, any master rows that have no related detail rows will be included in the results of the join

IS_DETAIL_EXISTS_ON_MASTER

CHAR(1)

Indicates whether every detail row must refer to a valid master row

IS_ONE_TO_ONE

CHAR(1)

Indicates whether each master row only ever has a single detail row

REFERENCED_ITEM_FOLDER_ID

NUMBER(9)

The identifier of the master item folder referenced from the join

REFERENCED_ITEM_FOLDER_NAME

VARCHAR2(255)

The name of the master item folder referenced from the join

RELATED_FOREIGN_KEY_ID

NUMBER(9)

The identifier of the foreign key that this join was derived from

RELATED_FOREIGN_KEY_NAME

VARCHAR2(255)

The name of the foreign key that this join was derived from

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-151 ALL_IV_CONDITIONS

Column Name Data Type Description

ITEM_FOLDER_ID

NUMBER(9)

ID of the item folder

ITEM_FOLDER_NAME

VARCHAR2(255)

Name of the item folder

CONDITION_ID

NUMBER(9)

ID of the condition

CONDITION_NAME

VARCHAR2(255)

Name of the condition

BUSINESS_NAME

VARCHAR2(1000)

Business name of the condition

DESCRIPTION

VARCHAR2(4000)

Description of the condition

IS_MANDATORY

CHAR(1)

Whether the condition is mandatory

FORMULA

CLOB

Formula of the condition

IS_MATCH_CASE

CHAR(1)

Whether the alphabetic character case must match exactly

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Real Time Views

Table 2-152 ALL_IV_STREAMS_QUEUES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

QUEUE_ID

NUMBER(9)

ID of the queue

QUEUE_NAME

VARCHAR2(255)

Name of the queue

BUSINESS_NAME

VARCHAR2(1000)

Business name of the queue

DESCRIPTION

VARCHAR2(4000)

Description of the queue

QUEUE_TABLE

VARCHAR2(255)

Physical name of the queue table

QUEUE_TABLE_ID

NUMBER(9)

ID of the queue table

PAYLOAD_TYPE

CHAR(11)

Type of payload

IS_VALID

VARCHAR2(13)

Is the queue valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-153 ALL_IV_QUEUES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

QUEUE_ID

NUMBER(9)

ID of the queue

QUEUE_NAME

VARCHAR2(255)

Name of the queue

BUSINESS_NAME

VARCHAR2(1000)

Business name of the queue

DESCRIPTION

VARCHAR2(4000)

Description of the queue

QUEUE_TABLE

VARCHAR2(255)

Physical name of the queue table

QUEUE_TABLE_ID

NUMBER(9)

ID of the queue table

PAYLOAD_TYPE

VARCHAR2(255)

Type of payload for the queue

PAYLOAD_TYPE_ID

NUMBER

ID of the payload type

IS_VALID

VARCHAR2(13)

Is the queue valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-154 ALL_IV_QUEUE_PROPAGATIONS

Column Name Data Type Description

QUEUEPROPAGATION_ID

NUMBER(9)

ID of the queue propagation

QUEUETABLE_NAME

VARCHAR2(255)

Physical name of the queue table

BUSINESS_NAME

VARCHAR2(1000)

Business name of the queue table

DESCRIPTION

VARCHAR2(4000)

Description of the queue table

SOURCE_QUEUE

VARCHAR2(255)

Name of the source queue

SOURCE_QUEUE_ID

NUMBER(9)

ID of the source queue

TARGET_QUEUE

VARCHAR2(255)

Name of the target queue

TARGET_QUEUE_ID

NUMBER(9)

ID of the target queue

IS_VALID

VARCHAR2(13)

Is the queue table valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-155 ALL_IV_QUEUE_TABLES

Column Name Data Type Description

SCHEMA_ID

NUMBER(9)

ID of the schema

SCHEMA_NAME

VARCHAR2(255)

Name of the schema

QUEUETABLE_ID

NUMBER(9)

ID of the queue table

QUEUETABLE_NAME

VARCHAR2(255)

Name of the queue table

BUSINESS_NAME

VARCHAR2(1000)

Business name of the queue table

DESCRIPTION

VARCHAR2(4000)

Description of the queue table

PAYLOAD_TYPE

VARCHAR2(767)

Type of payload

PAYLOAD_TYPE_ID

NUMBER(9)

ID of payload type

IS_VALID

VARCHAR2(13)

Is queue table valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-156 ALL_IV_STREAMS_CAPTURE

Column Name Data Type Description

STREAMSCAPTURE_ID

NUMBER(9)

ID of the streams capture

STREAMSCAPTURE_NAME

VARCHAR2(255)

Name of the streams capture

BUSINESS_NAME

VARCHAR2(1000)

Business name of the streams capture

DESCRIPTION

VARCHAR2(4000)

Description of the streams capture

STREAMS_QUEUE

VARCHAR2(255)

Streams queue

STREAMS_QUEUE_ID

NUMBER(9)

ID of the streams queue

IS_VALID

VARCHAR2(13)

Validation status

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-157 ALL_IV_CAPTURE_RELATIONS

Column Name Data Type Description

STREAMS_CAPTURE_ID

NUMBER(9)

ID of the streams capture

STREAMS_CAPTURE_NAME

VARCHAR2(255)

Name of the streams capture

TABLE_ID

NUMBER(9)

ID of the table

TABLE_NAME

VARCHAR2(255)

Name of the table

CAPTURERELATION_ID

NUMBER(9)

ID of the capture relation

CAPTUREREALTION_NAME

VARCHAR2(255)

Name of the capture relation

BUSINESS_NAME

VARCHAR2(1000)

Business name of the capture relation

DESCRIPTION

VARCHAR2(4000)

Description of the capture relation

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Scheduling Views

Table 2-158 ALL_IV_SCHEDULABLE

Column Name Data Type Description

OBJECT_ID

NUMBER(9)

ID of the object

OBJECT_TYPE

VARCHAR2(4000)

Type of the object

OBJECT_NAME

VARCHAR2(255)

Name of the object

CONFIGURATION_ID

NUMBER(9)

ID of the configuration

CONFIGURATION_NAME

VARCHAR2(255)

Name of the configuration

SCHEDULE_ID

NUMBER(9)

ID of the applied schedule

SCHEDULE_NAME

VARCHAR2(255)

Name of the applied schedule


Table 2-159 ALL_IV_CALENDAR_SCHEDULES

Column Name Data Type Description

CALENDAR_ID

NUMBER(9)

ID of the calendar

CALENDAR_NAME

VARCHAR2(255)

Name of the calendar

SCHEDULE_ID

NUMBER(9)

ID of the schedule

SCHEDULE_NAME

VARCHAR2(255)

Name of the schedule

BUSINESS_NAME

VARCHAR2(1000)

Business name of the schedule

DESCRIPTION

VARCHAR2(4000)

Description of the schedule

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user

STARTTIME

DATE

Start time of the schedule

ENDTIME

DATE

End time of the schedule

REPEATEXPRESSION

VARCHAR2(4000)

Expression defining how often the schedule is active

TIMEZONE

VARCHAR2(255)

Time zone that the start and end time refer to


Security Views

Table 2-160 WBA_IV_OBJ_PRIVS

Column Name Data Type Description

GRANTEE

VARCHAR2(255)

Grantee name, user, or role receiving the grant

OBJECT_ID

NUMBER(9)

ID of the object

OBJECT_NAME

VARCHAR2(255)

Name of the object

OBJECT_TYPE

VARCHAR2(4000)

Type of object

PRIVILEGE

VARCHAR2(100)

Object privilege granted to the grantee


Table 2-161 WBA_IV_ROLE_PRIVS

Column Name Data Type Description

GRANTEE

VARCHAR2(255)

Grantee name, user, or role receiving the grant

GRANTED_ROLE

VARCHAR2(255)

The granted role


Table 2-162 WBA_IV_SYS_PRIVS

Column Name Data Type Description

GRANTEE

VARCHAR2(255)

Grantee name, user, or role receiving the grant

PRIVILEGE

VARCHAR2(100)

System privilege name granted to the grantee


Table 2-163 WBA_IV_ROLES

Column Name Data Type Description

ROLE_ID

NUMBER(9)

ID of the role

ROLE_NAME

VARCHAR2(255)

Name of the role

BUSINESS_NAME

VARCHAR2(1000)

Business name of the role

DESCRIPTION

VARCHAR2(4000)

Description of the role

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-164 WBA_IV_USERS

Column Name Data Type Description

USER_ID

NUMBER(9)

ID of the user

USER_NAME

VARCHAR2(255)

Name of the user

BUSINESS_NAME

VARCHAR2(1000)

Business name of the user

DESCRIPTION

VARCHAR2(4000)

Description of the user

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Others

Table 2-165 ALL_IV_ACTIVITY_FOLDERS

Column Name Data Type Description

PROJECT_ID

NUMBER(9)

ID of the project

PROJECT_NAME

VARCHAR2(255)

Name of the project

ACTIVITY_FOLDER_ID

NUMBER(9)

ID of the activity folder

ACTIVITY_FOLDER_NAME

VARCHAR2(255)

Name of the activity folder

BUSINESS_NAME

VARCHAR2(1000)

Business name of the activity folder

DESCRIPTION

VARCHAR2(4000)

Description of the activity folder

IS_VALID

VARCHAR2(13)

Is the activity folder valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-166 ALL_IV_ACTIVITY_TEMPLATES

Column Name Data Type Description

ACTIVITY_FOLDER_ID

NUMBER(9)

ID of the activity folder

ACTIVITY_FOLDER_NAME

VARCHAR2(255)

Name of the activity folder

ACTIVITY_TEMPLATE_ID

NUMBER(9)

ID of the activity template

ACTIVITY_TEMPLATE_NAME

VARCHAR2(255)

Name of the activity template

BUSINESS_NAME

VARCHAR2(1000)

Business name of the activity template

DESCRIPTION

VARCHAR2(4000)

Description of the activity template

IS_VALID

VARCHAR2(13)

Is the activity template valid

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-167 ALL_IV_PLS_COLLECTIONS

Column Name Data Type Description

LIBRARY_ID

NUMBER(9)

ID of the library

LIBRARY_NAME

VARCHAR2(255)

Name of the library

COLLECTION_ID

NUMBER(9)

ID of the collection

COLLECTION_NAME

VARCHAR2(255)

Name of the collection

BUSINESS_NAME

VARCHAR2(1000)

Business name of the collection

DESCRIPTION

VARCHAR2(4000)

Description of the collection

COLLECTION_TYPE

VARCHAR2(255)

Type of the collection

RELATED_RECORD_ID

NUMBER(9)

ID of the related PLS record

RELATED_RECORD_NAME

VARCHAR2(255)

Name of the related PLS record

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-168 ALL_IV_PLS_RECORDS

Column Name Data Type Description

LIBRARY_ID

NUMBER(9)

ID of the library

LIBRARY_NAME

VARCHAR2(255)

Name of the library

RECORD_ID

NUMBER(9)

ID of the record

RECORD_NAME

VARCHAR2(255)

Name of the record

BUSINESS_NAME

VARCHAR2(1000)

Business name of the record

DESCRIPTION

VARCHAR2(4000)

Description of the record

RECORD_TYPE

VARCHAR2(40)

Type of the record

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-169 ALL_IV_ROW_RELATIONSHIPS

Column Name Data Type Description

PROFILE_ID

NUMBER(9)

ID of the profile

PROFILE_NAME

VARCHAR2(255)

Name of the profile

ENTITY_ID

NUMBER(9)

ID of the entity

ENTITY_NAME

VARCHAR2(255)

Name of the entity

ROW_RELATIONSHIP_ID

NUMBER(9)

ID of the row relationship

ROW_RELATIONSHIP_NAME

VARCHAR2(255)

Name of the row relationship

BUSINESS_NAME

VARCHAR2(1000)

Business name of the row relationship

REMOTE_KEY_ID

NUMBER(9)

ID of the other row relationship

IS_DISCOVERED

CHAR(3)

If this row relationship was discovered

IS_DOCUMENTED

CHAR(2)

If this row relationship is documented

LOCAL_MAX_CARDINALITY

VARCHAR2(40)

Maximum number of values found on the local side

LOCAL_MIN_CARDINALITY

VARCHAR2(40)

Minimum number of values found on the local side

REMOTE_MAX_CARDINALITY

VARCHAR2(40)

Maximum number of values found on the remote side

REMOTE_MIN_CARDINALITY

VARCHAR2(40)

Minimum number of values found on the remote side

NUM_ORPHANS

VARCHAR2(40)

Number of distinct values found in the local column but not in the remote column

COMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that satisfy the discovered row relationship

COMPLIANT_CNT_QUERY

VARCHAR2(4000)

Not used

NONCOMPLIANT_QUERY

VARCHAR2(4000)

The query used to get the rows that do not satisfy the discovered common format

NONCOMPLIANT_CNT_QUERY

VARCHAR2(4000)

Not used

DRILLDOWN_QUERY

VARCHAR2(4000)

The query used to get all the rows of the table but distinguishes which row satisfies the discovered row relationship and which does not

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 2-170 SUB_FQ_PUSAGE_DEF

Column Name Data Type Description

CLASSTYPENAME

VARCHAR2(255)

Object type name

PUSAGEID

NUMBER(9)

ID of the usage definition of the property. (The attributes of a property may be context specific. For example, columns of an external table may have different properties, or the properties may have different constraints.)

PDEFID

NUMBER(9)

ID of the property definition

PROPNAME

VARCHAR2(255)

The name of the property as used in OMBPlus

PUSAGETYPE

VARCHAR2(7)

Property type for this usage, which determines where it is automatically displayed in the UI:

CORE: Not displayed

LOGICAL: Editor Property Inspector

CONFIG: Configuration Property Inspector

USERDEF: User Defined Properties tab

STORAGETYPE

VARCHAR2(7)

Storage type for this property, which determines how it is physically stored:

CORE: Column of object row

LOGICAL: Child row of object

CONFIG: Child row of configuration of object

USERDEF: Child row of object

DATATYPE

NUMBER

ID for the data type of this usage

TYPENAME

VARCHAR2(255)

Data type name of this usage

HIDDEN

VARCHAR2(4000)

Is this usage shown in the UI (PropertyInspector)? Value is true or false

PUBLISHTOPUBLICAPI

VARCHAR2(4000)

Is this usage included in OMBPlus scripting documentation? Value is true or false

CONTRIBUTETOSIGNATURE

VARCHAR2(4000)

Do changes in this property affect the semantic value of the owning object with respect to mapping or deployment? That is, would a change in the value of this property require the owning object to be regenerated before being deployed. Value is true or false

DYNAMICDEFAULT

VARCHAR2(4000)

Fully qualified name of the Java class providing the value for this property if it has not been set. This is called each time the property value is requested. (If this value is defined, then the value shown in the DEFAULTVALUE column should be considered invalid.)

DEFAULTVALUE

VARCHAR2(4000)

The static, default value for the usage. The primary default value of usage, property, domain, and primitive type, in that order. DYNAMIC DEFAULT takes precedence if defined. (Note that Null is not used as an indicator for this because Null is a potential legitimate value, and is specifically the default for any reference property)

PSETID

NUMBER(9)

The ID of the property set containing this usage. (Property sets are the context grouping mechanism for usage definitions. Usage type is actually defined at the property set level.)

PSETNAME

VARCHAR2(255)

The name of the property set containing this usage. (Also referred to as the selector key – generally gives indication of the context in which this property set is active. For example, maps have different sets based on generation language with the names SQLLOADER, PLSQL, ABAP, and so on. The value DEFAULT indicates the name selector mechanism is not used for this property set.)

PSETCLASSNAME

VARCHAR2(255)

Type name of the parent context for this property set. If defined, this property set is only active when the owning object is a child of an object of this type. For example, Index has different configuration property sets for the child object of Table or Materialized View

NLSKEY

VARCHAR2(255)

NLS lookup key base for localized property name, description

DESCRIPTION

VARCHAR2(4000)

Description of the usage from the definition file. Usually the same as the default <NLSKEY>:DESCRIPTION (English) shown in the UI/OMBPlus.

GROUPID

NUMBER(9)

The ID of the display group for this property. Used only in the UI (Property Inspector category)

GROUPNAME

VARCHAR2(255)

Name of the group from the definition file. Usually in uppercase, with the spaces converted to underscore. Version of the default <GROUPDEFINITIONKEY>:NAME (English) shown in the property inspector

GROUPDEFINITIONKEY

VARCHAR2(255)

The NLS lookup key base for localized group name

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user