D Warehouse Builder Public Views

The Warehouse Builder provides a set of pre-built views for both the Design and Runtime Repositories. These views are called the Warehouse Builder Public Views. Use these views to access to data stored in these repositories. This appendix contains a catalog of the Public Views and their descriptions.

Warehouse Builder Design Repository Public Views

• General Model Views

• Data Model Views

• Implementation Model Views

• Flat Files Views

• Collections Views

• Function Model Views

• Configuration Model Views

• Deployment Model Views

• Mapping Model Views

• Process Flow Model Views

Warehouse Builder Runtime Repository Public Views

• Deployment Auditing Views

• Execution Auditing Views

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

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

Implementation Model Views

• ALL_IV_CUBE_IMPLS

• ALL_IV_DIM_IMPLS

• ALL_IV_DIM_LEVEL_IMPLS

• ALL_IV_FUNCTION_IMPLS

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

Configuration Model Views

• ALL_IV_OBJECT_CONFIGURATIONS

Deployment Model Views

• ALL_IV_CONNECTORS

• ALL_IV_LOCATIONS

• ALL_IV_RUNTIME_REPOSITORIES

Mapping Model Views

• ALL_IV_XFORM_MAPS

• ALL_IV_XFORM_MAP_COMPONENT

• ALL_IV_XFORM_MAP_PARAMETERS

• ALL_IV_XFORM_MAP_PARAMETERS

• ALL_IV_XFORM_MAP_MAP_PROPERTIES

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

General Model Views

Table D-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 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? It only makes sense for the objects that can be validated.
UPDATED_ON	DATE	Update timestamp
CREATED_ON	DATE	Creation timestamp
UPDATED_BY	VARCHAR2(255)	Updated by who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-2 ALL_IV_OBJECTS

Column Name	Data Type	Description
OBJECT_ID	NUMBER(9)	ID of the object (the difference between this view and 2.1 view is that 2.1 view 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-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 D-4 ALL_IV_MLS_OBJECTS

Column Name	Data Type	Description
OBJECT_ID	NUMBER(9)	ID of the object (covers the same set as 2.2 view)
LANGUAGE_ID	VARCHAR2(255)	ID of the language (predefined internally by OWB). To get language name, please join with 2.5 view.
BUSINESS_NAME	VARCHAR2(4000)	Business name of the object
DESCRIPTION	VARCHAR2(4000)	Description of the object

Table D-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 D-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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-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 OWB 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-9 ALL_IV_INSTALLATIONS

Column Name	Data Type	Description
INSTALLATION_ID	NUMBER(9)	ID of the OWB repository
INSTALLATION_NAME	VARCHAR2(255)	Physical name of the OWB repository
BUSINESS_NAME	VARCHAR2(4000)	Business name of the OWB repository
DESCRIPTION	VARCHAR2(4000)	Description of the OWB repository
INSTALLED_VERSION	VARCHAR2(40)	Version of the OWB repository
RELEASE	VARCHAR2(40)	Version of the OWB Client
REPOSITORY_MODEL_VERSION	NUMBER(9)	Version of the OWB model
PUBLIC_VIEW_VERSION	CHAR(5)	Version of the OWB Public Views
UPDATED_ON	DATE	Update timestamp
CREATED_ON	DATE	Creation timestamp
UPDATED_BY	VARCHAR2(255)	Updated by who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-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 OWB 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-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 OWB 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-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, etc)
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 OWB 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-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 OWB 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-14 ALL_IV_PROCESS_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 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 OWB 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-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 OWB 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Data Model Views

Table D-16 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-17 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-18 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 D-19 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-20 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-21 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-22 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-23 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

Table D-24 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		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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-25 ALL_IV_CUBE_MEASURE_DIM_USES

Column Name	Data Type	Description
CUBE_ID	NUMBER(9)	ID of the cube (Note, this view is redundant, it can be achieved by joining 2.23, 2.24 views. It will be removed in the future)
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(9)	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 D-26 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
PLURAL_NAME	VARCHAR2(40)	Plural name of this dimension
DIMENSION_PREFIX	VARCHAR2(40)	The prefix for 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-27 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
HIERARCHY_PREFIX	VARCHAR2(40)	Prefix for this hierarchy
BUSINESS_NAME	VARCHAR2(4000)	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(255)	Updated by who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-28 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
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 D-29 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
LEVEL_PREFIX	VARCHAR2(40)	Prefix for 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-30 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
BUSINESS_NAME	VARCHAR2(4000)	Business name of this attribute
DESCRIPTION	VARCHAR2(4000)	Description of this attribute
POSITION		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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-31 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-32 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-33 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-34 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-35 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 D-36 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-37 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-38 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-39 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-40 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
SEQUENCE_ID	NUMBER(9)	ID of this sequence
SEQUENCE_NAME	VARCHAR2(255)	Physical name of this sequence
BUSINESS_NAME	VARCHAR2(4000)	Business name of this sequence
DESCRIPTION	VARCHAR2(4000)	Description of this 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-41 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-42 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Implementation Model Views

Table D-43 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)	Two kinds of type: cube measures and foreign keys pointing to dimension (called: cube dimension use)
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)	Current value set to NULL, will be updated in future

Table D-44 ALL_IV_DIM_IMPLS

Column Name	Data Type	Description
IMPLEMENTATION_ID	NUMBER(9)	ID of the item belonging to this dimension (this column will be updated in future)
ITEM_ID	NUMBER(9)	ID of the item belonging to this dimension
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
COLUMN_ID	NUMBER(9)	ID of the implementing column for the item
COLUMN_NAME	VARCHAR2(255)	Physical name of the implementing column
POSITION	NUMBER	Position of the column
TABLE_ID	NUMBER(9)	ID of the implementation table for this dimension
TABLE_NAME	VARCHAR2(255)	Physical name of the implementation table for this dimension

Table D-45 ALL_IV_DIM_LEVEL_IMPLS

Column Name	Data Type	Description
IMPLEMENTATION_ID	NUMBER(9)	ID of the item belonging to this level (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
POSITION	NUMBER	Position of the 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 D-46 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Flat Files Views

Table D-47 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-48 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-49 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Collections Views

Table D-50 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-51 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Function Model Views

Table D-52 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-53 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-54 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-55 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Configuration Model Views

Table D-56 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

Deployment Model Views

Table D-57 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-58 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-59 ALL_IV_RUNTIME_REPOSITORIES

Column Name	Data Type	Description
PROJECT_ID	NUMBER(9)	ID of the project this runtime 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Mapping Model Views

Table D-60 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)	ID of this map (this column is redundant, will be removed in future)
COMPOSITE_MAP_COMPONENT_NAME	VARCHAR2(255)	Physical name of this map (this column is redundant, will be removed in future)
IS_VALID	VARCHAR2(13)	Is this map valid?
UPDATED_ON	DATE	Update timestamp
CREATED_ON	DATE	Creation timestamp
UPDATED_BY	VARCHAR2(255)	Updated by who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-61 ALL_IV_XFORM_MAP_COMPONENT

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)	ID of the map (this column is redundant, will be removed in future)
COMPOSITE_MAP_COMPONENT_NAME	VARCHAR2(255)	Physical name of the map (this column is redundant, will be removed in future)
DATA_ENTITY_ID	NUMBER(9)	ID of the data entity this map component reconciled 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-62 ALL_IV_XFORM_MAP_DETAILS

Column Name	Data Type	Description
MAP_COMPONENT_ID	NUMBER(9)	ID of the map component
PARAMETER_ID	NUMBER(9)	ID of the parameter owned by this map component
POSITION	NUMBER(9)	Position of the parameter
BUSINESS_NAME	VARCHAR2(4000)	Business name of the parameter
PARAMETER_NAME	VARCHAR2(255)	Physical name of the parameter
TRANSFORMATION_EXPRESSION	VARCHAR2(4000)	Textual expression of the transformation of this parameter
DESCRIPTION	VARCHAR2(4000)	Description of this parameter
SOURCE_EXPRESSION	VARCHAR2(4000)	Data source expression of this parameter

Table D-63 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 reconciled 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-64 ALL_IV_XFORM_MAP_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

Process Flow Model Views

Table D-65 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-66 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-67 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-68 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-69 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Table D-70 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 who
CREATED_BY	VARCHAR2(255)	Created by who

Warehouse Builder Runtime Repository Public Views

The Runtime Repository contains all of the deployment and execution audit data. Use these Public Views to access this data. These views are used by Runtime Audit Browser to provide audit reporting.

Deployment Auditing Views

• ALL_RT_AUDIT_LOCATIONS

• ALL_RT_AUDIT_LOCATION_MESSAGES

• ALL_RT_AUDIT_LOCATION_FILES

• ALL_RT_AUDIT_OBJECTS

• ALL_RT_AUDIT_SCRIPT_RUNS

• ALL_RT_AUDIT_SCRIPT_MESSAGES

• ALL_RT_AUDIT_SCRIPT_FILES

Execution Auditing Views

• ALL_RT_AUDIT_EXECUTIONS

• ALL_RT_AUDIT_EXECUTION_PARAMS

• ALL_RT_AUDIT_EXEC_MESSAGES

• ALL_RT_AUDIT_EXEC_FILES

• ALL_RT_AUDIT_MAP_RUNS

• ALL_RT_AUDIT_MAP_RUN_SOURCES

• ALL_RT_AUDIT_MAP_RUN_TARGETS

• ALL_RT_AUDIT_STEP_RUNS

• ALL_RT_AUDIT_STEP_RUN_SOURCES

• ALL_RT_AUDIT_STEP_RUN_TARGETS

• ALL_RT_AUDIT_MAP_RUN_ERRORS

• ALL_RT_AUDIT_MAP_RUN_TRACE

Deployment Auditing Views

Table D-71 ALL_RT_AUDIT_LOCATIONS

Column Name	Type	Description
location_audit_id	Number (22)	Internal primary key to audit_location.
runtime_version	Varchar2 (64)	Runtime version number.
client_version	Varchar2 (64)	Design client version number.
client_repository	Varchar2 (30)	Name of the client repository.
client_repository_version	Varchar2 (64)	Client repository version number.
repository_user	Varchar2 (30)	Username of the design repository.
generation_time	Date	When the deployment was generated.
deployment_audit_id	Number (22)	Internal audit ID of the deployment.
deployment_sequence_number	Number (10)	Sequence number of this location in the deployment.
deployment_audit_name	Varchar2 (64)	Audit name of the location.
deployment_audit_status	Varchar2	INACTIVE, READY, or COMLETE.
location_audit_status	Varchar2	INACTIVE, READY, BUSY_PREPARE, BUSY_UNPREPARE, BUSY_DEPLOY, BUSY_UNDO, BUSY_FINALIZE, or COMPLETE.
location_uoid	Varchar2 (32)	Client UOID of the location.
location_name	Varchar2 (64)	Name of the location.
location_type	Varchar2 (64)	Type of the location. (ODB, OWF, OEM)
location_type_version	Varchar2 (64)	Version of the target.
number_script_run_errors	Number (10)	Number of errors detected.
number_script_run_warnings	Number (10)	Number of warnings detected.
created_on	Date	The time audit data was created.
created_by	Varchar2 (30)	Database username.
updated_on	Date	The time audit data was updated.
updated_by	Varchar2 (30)	Database username.

Table D-72 ALL_RT_AUDIT_LOCATION_MESSAGES

Column Name	Type	Description
message_audit_id	Number (22)	Internal key to audit_location_message. Primary when used with message_line_number.
location_audit_id	Number (22)	Internal key to audit_location.
message_severity	Varchar2	INFORMATIONAL, WARNING, ERROR, or RECOVERY.
message_line_number	Number (10)	1 for single line messages. >0 for multiple line messages. (Forms primary key when used with message_audit_id)
message_text	Varchar2 (4000)	plain_text or nls_key
created_on	Date	The time audit data was created.
created_by	Varchar2 (30)	Database username.

Table D-73 ALL_RT_AUDIT_LOCATION_FILES

Column Name	Type	Description
file_audit_id	Number (22)	Internal primary key to audit_location_file.
location_audit_id	Number (22)	Internal key to audit_location.
file_type	Varchar2 (64)	SQLLoaderLogFile, ShellOutputStream, ShellErrorStream, FTPOutputStream, or FTPErrorStream.
file_text	CLOB	Contents of the file.
format	Varchar2	TEXT or HTML.
created_on	Date	The time audit data was created.
created_by	Varchar2 (30)	Database username.

Table D-74 ALL_RT_AUDIT_OBJECTS

Column Name	Type	Description
object_audit_id	Number (22)	Internal primary key to audit_object.
parent_object_audit_id	Number (22)	Internal key to parent audit_script_run.
location_audit_id	Number (22)	Internal key to audit_location.
location_sequence_number	Number (10)	Sequence number of this object in the location.
object_uoid	Varchar2 (32)	UOID of the deployed object.
object_name	Varchar2 (64)	Name of the deployed object.
object_type	Varchar2 (64)	Type of deployed object. (PLSQLMap, Table, Dimension, SQLLoaderControlFile)
client_version_tag	Varchar2 (80)	Client version identifier of this object.
number_script_run_errors	Number (10)	Number of errors detected.
number_script_run_warnings	Number (10)	Number of warnings detected.
status_when_deployed	Varchar2	VALID, INVALID, REMOVED, or UNCERTAIN.
created_on	Date	The time audit data was created.
created_by	Varchar2 (30)	Database username.
update_on	Date	The time audit data was updated.
updated_by	Varchar2 (30)	Database username.

Table D-75 ALL_RT_AUDIT_SCRIPT_RUNS

Column Name	Type	Description
script_run_audit_id	Number (22)	Internal primary key to audit_script_run.
location_audit_id	Number (22)	Internal key to audit_location.
object_audit_id	Number (22)	Internal key to audit_object.
script_run_audit_status	Varchar2	BUSY, COMPLETE, UNCERTAIN, FAILED or INACTIVE.
operation	Varchar2	DEPLOY, or UNDO.
script_action	Varchar2	CREATE, DROP, UPGRADE or REPORT.
script	CLOB	Script used to perform the action.
script_format	Varchar2	TEXT or HTML.
script_generation_time	Date	The time the script was created.
number_script_run_errors	Number	The number of errors detected.
number_script_run_warnings	Number	The number of warnings detected.
elapse_time	Number (10)	The number of seconds that elapsed.
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.
updated_on	Date	The time the audit data updated.
updated_by	Varchar2 (30)	Database username.

Table D-76 ALL_RT_AUDIT_SCRIPT_MESSAGES

Column Name	Type	Description
message_audit_id	Number (22)	Internal primary key to audit_script_file.
script_run_audit_id	Number (22)	Internal key to audit_script_run.
message_severity	Varchar2	INFORMATIONAL, WARNING, ERROR, or RECOVERY.
message_line_number	Number (10)	1 for single line messages. >0 for multiple line messages. (Forms primary key when used with message_audit_id)
message_text	Varchar2 (4000)	plain_text or nls_key
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.

Table D-77 ALL_RT_AUDIT_SCRIPT_FILES

Column Name	Type	Description
file_audit_id	Number (22)	Internal primary key to audit_script_file.
script_run_audit_id	Number (22)	Internal key to audit_script_run.
file_type	Varchar2 (64)	SQLLoaderLogFile, ShellOutputStream, ShellErrorStream, FTPOutputStream, or FTPErrorStream.
file_text	CLOB	Contents of the file.
format	Varchar2	TEXT or HTML.
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.

Execution Auditing Views

Table D-78 ALL_RT_AUDIT_EXECUTIONS

Column Name	Type	Description
execution_audit_id	Number (22)	Internal primary key to audit_execution.
parent_execution_audit_id	Number (22)	Internal key to parent audit_execution.
top_level_execution_audit_id	Number (22)	Internal key to top-level audit_execution.
execution_name	Varchar2 (64)	Name of the execution run.
task_name	Varchar2 (64)	Name of the task executed.
task_type	Varchar2 (64)	Type of task executed. ( PL/SQL, ProcessFlow)
task_input	CLOB	Input stream for the task.
exec_location_uoid	Varchar2 (32)	UOID of the location where execution is performed.
exec_location_name	Varchar2 (64)	Name of the location where execution is performed.
exec_location_type	Varchar2 (64)	Type of the location where execution is performed. (Runtime Platform, OEM)
exec_location_type_version	Varchar2 (64)	Version of the location where execution is performed.
object_uoid	Varchar2 (32)	Client UOID of mapping executed.
object_name	Varchar2 (64)	Name of mapping executed.
object_type	Varchar2 (64)	Type of mapping executed.
object_location_uoid	Varchar2 (32)	Location UOID where mapping deployed.
object_location_name	Varchar2 (64)	Location name where mapping deployed.
object_location_type	Varchar2 (64)	Location type where mapping deployed.
object_location_type_version	Varchar2 (64)	Location version where mapping deployed.
return_result	Varchar2 (64)	FAILURE, OK, OK_WITH_WARNINGS, or OK_WITH_ERRORS.
return_code	Number (10)	<0 : Failure >= 0 : Success
execution_audit_status	Varchar2	INACTIVE, BUSY, READY or COMPLETE.
elapse_time	Number (10)	Number of seconds elapsed.
number_task_errors	Number (10)	Number of errors detected.
number_task_warnings	Number (10)	Number of warnings detected.
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.
updated_on	Date	The time the audit data was updated.
updated_by	Varchar2 (30)	Database username.

Table D-79 ALL_RT_AUDIT_EXECUTION_PARAMS

Column Name	Type	Description
parameter_audit_id	Number (22)	Internal primary key to audit_execution_param.
execution_audit_id	Number (22)	Internal key to audit_execution.
custom_parameter_uoid	Varchar2 (32)	UOID of custom parameter.
parameter_name	Varchar2 (64)	Name of parameter.
parameter_type	Varchar2	BOOLEAN, CHAR, DATE, FLOAT, NUMBER, VARCHAR, VARCHAR2, OPERATING_MODE or AUDIT_LEVEL.
parameter_kind	Varchar2	SYSTEM or CUSTOM.
parameter_mode	Varchar2	IN, OUT or INOUT.
value_kind	Varchar2 (12)	INPUT VALUE or OUTPUT VALUE.
value	Varchar2 (4000)	Character representation of parameter value.

Table D-80 ALL_RT_AUDIT_EXEC_MESSAGES

Column Name	Type	Description
message_audit_id	Number (22)	Internal key to audit_exec_message. Primary key when used with message_line_number.
execution_audit_id	Number (22)	Internal key to audit_execution.
message_severity	Varchar2	INFORMATIONAL, WARNING, ERROR or RECOVERY.
message_line_number	Number (10)	1 for single line messages. >0 for multiple line messages. (Forms primary key when used with message_audit_id))
message_text	Varchar2 (4000)	Plain_text or nls_key.
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.

Table D-81 ALL_RT_AUDIT_EXEC_FILES

Column Name	Type	Description
file_audit_id	Number (22)	Internal primary key to audit_exec_file.
execution_audit_id	Number (22)	Internal key to audit_execution.
file_type	Varchar2 (64)	Type of the file.
file_text	Clob	Content of the file.
format	Varchar2	TEXT or HTML.
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.

Table D-82 ALL_RT_AUDIT_MAP_RUNS

Column Name	Type	Description
map_run_id	Number (22)	Internal primary key to audit_map_run
execution_audit_id	Number (22)	Internal key to audit_execution
map_uoid	Varchar2 (255)	UOID of the mapping.
map_name	Varchar2 (80)	Name of the mapping.
map_type	Varchar2 (30)	PLSQLMap or SQLLoaderControlFile.
start_time	Date	The time the mapping started.
end_time	Date	The time the mapping ended.
elapse_time	Number (10)	Number of seconds elapsed.
run_status	Varchar2 (8)	RUNNING, FAILURE or COMPLETE.
physical_name	Varchar2 (80)	Full hierarchic name of .dat file for a SQL*Loader run.
load_date	Varchar2 (30)	Load date for a SQL*Loader run.
load_time	Varchar2 (30)	Load time for a SQL*Loader run.
number_errors	Number (10)	Number of errors detected.
number_records_selected	Number (10)	Number of records selected from source tables.
number_records_inserted	Number (10)	Number of records inserted into target tables.
number_records_updated	Number (10)	Number of records updated in target tables.
number_records_deleted	Number (10)	Number of records deleted in target tables.
number_records_discarded	Number (10)	Number of records discarded in SQL*Loader run.
number_records_merged	Number (10)	Number of records merged in target tables.
number_records_corrected	Number (10)	Number of records corrected in target tables.
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.
updated_on	Date	The time the audit data was updated.
updated_by	Varchar2 (30)	Database username.

Table D-83 ALL_RT_AUDIT_MAP_RUN_SOURCES

Column Name	Type	Description
map_run_id	Number (22)	Internal key to audit_map_run.
source_name	Varchar2 (2000)	Name of mapping operator representing source table.
source_dblink	Varchar2 (2000)	Name of database link for mapping operator representing source table.

Table D-84 ALL_RT_AUDIT_MAP_RUN_TARGETS

Column Name	Type	Description
map_run_id	Number (22)	Internal key to audit_map_run.
target_name	Varchar2 (2000)	Name of mapping operator representing target table.

Table D-85 ALL_RT_AUDIT_STEP_RUNS

Column Name	Type	Description
step_id	Number (22)	Internal primary key to audit_step_run.
map_run_id	Number (22)	Internal key to audit_map_run.
map_step	Number (22)	Step number 0 or 1. For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run.
step_name	Varchar2 (80)	Name of the mapping for a set-based run, or the name of a mapping object for a set-based or set-based-target run.
step_type	Varchar2 (18)	Set-based, Row-based or Row-based target.
start_time	Date	The time the mapping step started.
end_time	Date	The time the mapping step ended.
elapse_time	Number (10)	Number of seconds taken.
run_status	Varchar2 (8)	RUNNING or COMPLETE.
number_errors	Number (10)	Number of errors detected.
number_records_selected	Number (10)	Number of records selected from source tables.
number_records_inserted	Number (10)	Number of records inserted into target tables.
number_records_updated	Number (10)	Number of records updated in target tables.
number_records_deleted	Number (10)	Number of records deleted in target tables.
number_records_discarded	Number (10)	Number of records discarded in a SQL*Loader run.
number_records_merged	Number (10)	Number of records merged in target tables.
number_records_corrected	Number (10)	Number of records corrected in target tables.
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.
updated_on	Date	The time the audit data was updated.
updated_by	Varchar2 (30)	Database username.

Table D-86 ALL_RT_AUDIT_STEP_RUN_SOURCES

Column Name	Type	Description
step_id	Number (22)	Internal key to audit_step_run.
map_run_id	Number (22)	Internal key to audit_map_run.
map_step	Number (22)	Step number 0 or 1. For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run.
source_name	Varchar2 (2000)	Name of mapping operator representing source table.
source_dblink	Varchar2 (2000)	Name of database link for mapping operator representing source table.

Table D-87 ALL_RT_AUDIT_STEP_RUN_TARGETS

Column Name	Type	Description
step_id	Number (22)	Internal key to audit_step_run.
map_run_id	Number (22)	Internal key to audit_map_run.
map_step	Number (22)	Step number 0 or 1. For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run.
target_name	Varchar2 (2000)	Name of mapping operator representing target table.

Table D-88 ALL_RT_AUDIT_MAP_RUN_ERRORS

Column Name	Type	Description
run_error_id	Number (22)	Internal primary key for map_run_error.
step_id	Number (22)	Internal key to audit_step_run.
map_run_id	Number (22)	Internal key to audit_map_run.
map_step	Number (22)	Step number 0 or 1. For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run.
cursor_rowkey	Number (22)	Value identifying row returned by cursor. This is 0 for errors in a set-based run.
run_error_number	Number (10)	Message number.
run_error_message	Varchar2 (2000)	Message text.
target_name	Varchar2 (80)	Name of mapping operator representing target table.
target_column	Varchar2 (80)	Column name, or '*' if not known or not applicable.
statement	Varchar2 (2000)	Value such as INSERT or BATCH INSERT, or a PL/SQL statement.
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.
updated_on	Date	The time the audit data was updated.
updated_by	Varchar2 (30)	Database username.

Table D-89 ALL_RT_AUDIT_MAP_RUN_TRACE

Column Name	Type	Description
trace_id	Number (22)	Internal primary key for map_run_trace.
map_run_id	Number (22)	Internal key to audit_map_run.
map_step	Number (22)	Step number 0 or 1. For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run.
cursor_rowkey	Number (22)	Value identifying error row returned by cursor. This is 0 for set-based run.
type	Varchar2 (30)	NEW for trace or ERROR for error.
role	Varchar2 (30)	S for source or T for target.
action	Varchar2 (30)	Value such as SELECT or a PL/SQL statement.
table_name	Varchar2 (80)	Name of mapping operator representing source/target table.
created_on	Date	The time the audit data was created.
created_by	Varchar2 (30)	Database username.
updated_on	Date	The time the audit data was updated.
updated_by	Varchar2 (30)	Database username.