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.

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
Others

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

ALL_IV_ALL_OBJECTS
ALL_IV_OBJECTS
ALL_IV_OBJECT_PROPERTIES
ALL_IV_MLS_OBJECTS
ALL_IV_SUPPORTED_LANGUAGES
ALL_IV_MODULES
ALL_IV_PROJECTS
ALL_IV_INFORMATION_SYSTEMS
ALL_IV_INSTALLATIONS
ALL_IV_FILE_MODULES
ALL_IV_GATEWAY_MODULES
ALL_IV_PACKAGED_APPS_MODULES
ALL_IV_PREDEFINED_MODULES
ALL_IV_PROCESS_MODULES
ALL_IV_WAREHOUSE_MODULES
ALL_IV_BUSINESS_DEF_MODULES
ALL_IV_BUSINESS_PRES_MODULES
ALL_IV_CALENDAR_MODULES
ALL_IV_CMIV_DEFINITIONS
ALL_IV_CMIV_MODULES
ALL_IV_DATA_RULE_MODULES
ALL_IV_EXPERT_MODULES
ALL_IV_PF_CORRECTED_MODULES
ALL_IV_SAP_MODULES
ALL_IV_TM_MODULES
ALL_IV_UDO_MODULES
ALL_IV_CMIV_VIEWS
ALL_IV_FIRSTCLASS_OBJECTS
ALL_IV_DB_FUNCTIONS
ALL_IV_EXT_OBJECT_PROPERTIES

Data Model Views

ALL_IV_ADVANCED_QUEUES
ALL_IV_ATTR_GROUPS
ALL_IV_ATTR_GROUP_ITEM_USES
ALL_IV_CHECK_CONSTRAINTS
ALL_IV_COLUMNS
ALL_IV_CONSTRAINTS
ALL_IV_CUBES
ALL_IV_CUBE_DIMENSIONS
ALL_IV_CUBE_MEASURES
ALL_IV_CUBE_MEASURE_DIM_USES
ALL_IV_DIMENSIONS
ALL_IV_DIM_HIERARCHIES
ALL_IV_DIM_HIERARCHY_LEVELS
ALL_IV_DIM_LEVELS
ALL_IV_DIM_LEVEL_ATTRIBUTES
ALL_IV_EXTERNAL_COLUMNS
ALL_IV_EXTERNAL_TABLES
ALL_IV_FOREIGN_KEYS
ALL_IV_KEYS
ALL_IV_KEY_COLUMN_USES
ALL_IV_MATERIALIZED_VIEWS
ALL_IV_OBJECT_TYPES
ALL_IV_RECORD_FIELDS
ALL_IV_RELATIONS
ALL_IV_SEQUENCES
ALL_IV_VIEWS
ALL_IV_TABLES
ALL_IV_CALENDARS
ALL_IV_VARRAYS
ALL_IV_SCHEMAS
ALL_IV_PROCEDURES
ALL_IV_REF_CURSORS
ALL_IV_DIM_ATTRIBUTES
ALL_IV_DIM_ROLES
ALL_IV_TM_SCHEMAS
ALL_IV_TM_TABLESPACES
ALL_IV_CUBE_IMPLS
ALL_IV_DIM_IMPLS
ALL_IV_DIM_LEVEL_IMPLS
ALL_IV_NESTED_TABLES

Flat Files Views

ALL_IV_FIELDS
ALL_IV_FILES
ALL_IV_RECORDS

Collections Views

ALL_IV_COLLECTIONS
ALL_IV_COLLECTION_REFERENCES

Function Model Views

ALL_IV_FUNCTIONS
ALL_IV_FUNCTION_LIBRARIES
ALL_IV_FUNCTION_PARAMETERS
ALL_IV_TABLE_FUNCTIONS
ALL_IV_FUNCTION_IMPLS

Configuration Model Views

ALL_IV_OBJECT_CONFIGURATIONS
ALL_IV_CONFIGURATIONS
ALL_IV_CONTROL_CENTERS

Deployment Model Views

ALL_IV_CONNECTORS
ALL_IV_LOCATIONS
ALL_IV_RUNTIME_REPOSITORIES

Mapping Model Views

ALL_IV_XFORM_MAPS
ALL_IV_XFORM_MAP_COMPONENTS
ALL_IV_XFORM_MAP_PARAMETERS
ALL_IV_XFORM_MAP_PROPERTIES
ALL_IV_XFORM_MAP_DETAILS
ALL_IV_PLUGGABLE_MAPS
ALL_IV_PLUGGABLE_MAP_LIBRARIES
ALL_IV_PLUG_MAP_PARAMETERS
ALL_IV_PLUG_MAP_COMPONENTS

Process Flow Model Views

ALL_IV_PACKAGES
ALL_IV_PROCESSES
ALL_IV_PROCESS_ACTIVITIES
ALL_IV_PROCESS_PARAMETERS
ALL_IV_PROCESS_TRANSITIONS
ALL_IV_PROCESS_VARIABLES
ALL_IV_SUB_PROCESSES

Data Profiling Views

ALL_IV_PROFILES
ALL_IV_PROFILE_COLUMNS
ALL_IV_PROFILE_DOMAIN_VALUES
ALL_IV_FUNCTIONAL_DEPENDENCIES
ALL_IV_PROFILE_FOREIGN_KEYS
ALL_IV_PROFILE_KEY_COLUMN_USES
ALL_IV_PROFILE_OBJECTS
ALL_IV_PROFILE_PATTERN_VALUES
ALL_IV_PROFILE_RULES
ALL_IV_PROFILE_UNIQUE_KEYS

Data Rules Views

ALL_IV_DATA_RULES
ALL_IV_DATA_RULE_ATTRIBUTES
ALL_IV_DATA_RULE_ATTR_USAGES
ALL_IV_DATA_RULE_DOMAINS
ALL_IV_DATA_RULE_GROUPS
ALL_IV_DATA_RULE_GROUP_USAGES
ALL_IV_DATA_RULE_PROPERTIES
ALL_IV_DATA_RULE_USAGES

User Defined Object Views

ALL_IV_UDO_FCOS
ALL_IV_UDO_FOLDERS
ALL_IV_UDO_SCOS
ALL_IV_UDO_ASSOCIATIONS

Expert Views

ALL_IV_EXPERTS
ALL_IV_EXPERT_PARAMETERS
ALL_IV_EXPERT_TASKS
ALL_IV_EXPERT_TRANSITIONS
ALL_IV_EXPERT_VARIABLES
ALL_IV_NESTED_EXPERTS

Business Intelligence Views

ALL_IV_ALTERNATIVE_SORT_ORDERS
ALL_IV_BUSINESS_AREAS
ALL_IV_BUSINESS_AREA_FOLDERS
ALL_IV_PRESENTATION_TEMPLATES
ALL_IV_DRILLS_TO_DETAIL
ALL_IV_DRILL_LEVELS
ALL_IV_ITEM_FOLDERS
ALL_IV_ITEM_FOLDER_JOIN_USAGES
ALL_IV_ITEMS
ALL_IV_ITEM_FORMULA_REFS
ALL_IV_DATA_ITEMS
ALL_IV_EDGE_ITEMS
ALL_IV_DRILL_PATHS
ALL_IV_DRILL_LEVEL_ITEMS
ALL_IV_DRILL_PATH_JOIN_USAGES
ALL_IV_LISTS_OF_VALUES
ALL_IV_REGISTERED_FUNCTIONS
ALL_IV_CONDITION_FORMULA_REFS
ALL_IV_JOIN_COMPONENTS
ALL_IV_JOINS
ALL_IV_CONDITIONS

Real Time Views

ALL_IV_STREAMS_QUEUES
ALL_IV_QUEUES
ALL_IV_QUEUE_PROPAGATIONS
ALL_IV_QUEUE_TABLES
ALL_IV_STREAMS_CAPTURE
ALL_IV_CAPTURE_RELATIONS

Scheduling Views

ALL_IV_SCHEDULABLE
ALL_IV_CALENDAR_SCHEDULES

Security Views

WBA_IV_OBJ_PRIVS
WBA_IV_ROLE_PRIVS
WBA_IV_SYS_PRIVS
WBA_IV_ROLES
WBA_IV_USERS

Others

ALL_IV_ACTIVITY_FOLDERS
ALL_IV_ACTIVITY_TEMPLATES
ALL_IV_PLS_COLLECTIONS
ALL_IV_PLS_RECORDS
ALL_IV_ROW_RELATIONSHIPS

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