Oracle® Warehouse Builder User's Guide 10g Release 1 (10.1) Part Number B12146-02 |
|
|
View PDF |
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
Warehouse Builder Runtime 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.
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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.
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. |
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. |