The Warehouse Builder provides a set of pre-built views for both the design and runtime environments. These views are called the Warehouse Builder public views and are the API alternative to using the Repository Browser described in the Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.
Use these views to access to metadata and data stored in Warehouse Builder repositories.
You can access public views by logging in to SQL*Plus with default workspace@set
. When you login to SQL*Plus, you can access public views (design-time public views or runtime public views) from your default workspace.If you try to access public views from any workspace other than the default, then you must call: WB_workspace_management.set_workspace
(<wksp_name>, <wksp_owner>). If you want to switch to a workspace other than the default one, then you can call the WB_workspace_management.set_workspace
procedure. You must have the ACCESS_PUBLICVIEW_BROWSER
system privilege to retrieve useful information from the public views. Otherwise, you will get "0 rows returned." You may need to ask the workspace owner or workspace admin to grant the system privilege ACCESS_PUBLICVIEW_BROWSER
.
This chapter contains a catalog of the public views to the design environment.
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.
Note:
In addition to the listed views, Warehouse Builder also contains the public view ALL_IV_TABLE_FUNC_PROPERTIES, which is now obsolete.Column Name | Data Type | Description |
---|---|---|
OBJECT_ID |
NUMBER(9) |
ID of the object |
OBJECT_UOID |
VARCHAR2(255) |
UOID of the object |
OBJECT_TYPE |
VARCHAR2(4000) |
Type of the object |
OBJECT_NAME |
VARCHAR2(4000) |
Physical name of the object |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of the object |
CONTEXT_NAME |
VARCHAR2(4000) |
Name of the object, prefixed with its module's name, and project's name if it existed |
DESCRIPTION |
VARCHAR2(4000) |
Description of the object |
PARENT_OBJECT_ID |
NUMBER(9) |
Container object ID for the object. Container object could be a module, for example, for a dimension, or a table for a column |
PARENT_OBJECT_TYPE |
VARCHAR2(4000) |
Type of the parent object |
PARENT_OBJECT_NAME |
VARCHAR2(4000) |
Name of the parent object |
IS_VALID |
VARCHAR2(13) |
Is the object valid? Applicable for only those objects that can be validated |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
OBJECT_ID |
NUMBER(9) |
ID of the object (the difference between this view and ALL_IV_ALL_OBJECTS is that it includes all objects in this view, PLUS all archived snapshot objects (for MCM service)) |
OBJECT_TYPE |
VARCHAR2(4000) |
Type of the object |
OBJECT_NAME |
VARCHAR2(4000) |
Physical name of the object |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of the object |
DESCRIPTION |
VARCHAR2(4000) |
Description of the object |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-3 ALL_IV_OBJECT_PROPERTIES
Column Name | Data Type | Description |
---|---|---|
OBJECT_ID |
NUMBER(9) |
ID of the object |
OBJECT_TYPE |
VARCHAR2(4000) |
Type of the object |
OBJECT_NAME |
VARCHAR2(255) |
Physical name of the object |
PROPERTY_ID |
NUMBER(9) |
ID of the object's property |
PROPERTY_NAME |
VARCHAR2(255) |
ID of the property name |
PROPERTY_VALUE |
VARCHAR2(4000) |
Value of the property |
Column Name | Data Type | Description |
---|---|---|
OBJECT_ID |
NUMBER(9) |
ID of the object (covers the same set as ALL_IV_OBJECTS) |
LANGUAGE_ID |
VARCHAR2(255) |
ID of the language (predefined internally by Warehouse Builder). To get language name, join this view with ALL_IV_SUPPORTED_LANGUAGES |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of the object |
DESCRIPTION |
VARCHAR2(4000) |
Description of the object |
Table 2-5 ALL_IV_SUPPORTED_LANGUAGES
Column Name | Data Type | Description |
---|---|---|
LANGUAGE_ID |
VARCHAR2(255) |
ID of the language |
LANGUAGE_NAME |
VARCHAR2(64) |
Name of the language |
ISBASELANGUAGE |
VARCHAR2(1) |
Is it a base language (for example, EN or FR) |
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project that this module belongs to |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the module |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of the module |
SCHEMA_ID |
NUMBER(9) |
ID of the module (repeated column, just to keep backward compatibility) |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of the module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the module |
STATUS |
VARCHAR2(40) |
Module status (dev, QA, prod) |
IS_VALID |
VARCHAR2(13) |
Is this module valid |
LOCATION_ID |
NUMBER(9) |
ID of the associated location for this module |
LOCATION_NAME |
VARCHAR2(255) |
Name of associated location for this module |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of the project |
DESCRIPTION |
VARCHAR2(4000) |
Description of the project |
VERSION_LABEL |
VARCHAR2(255) |
Version of the project |
IS_VALID |
VARCHAR2(13) |
Is this project valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-8 ALL_IV_INFORMATION_SYSTEMS
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project that this module belongs to |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the module |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of the module |
INFORMATION_SYSTEM_TYPE |
VARCHAR2(4000) |
Type of the module |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of the module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the module |
PRODUCT_TYPE |
VARCHAR2(255) |
Application type of the module (for example, Oracle apps, or File based apps) |
SYSTEM_TYPE |
VARCHAR2(255) |
Type of system that holds this application (shown by PRODUCT_TYPE) |
VERSION_LABEL |
NUMBER(9) |
Version of the module |
VENDOR |
VARCHAR2(40) |
Vendor name |
DATABASE_LINK |
VARCHAR2(40) |
Name of the database link that physical points to data storage of this module. It is meaningful only for database applications |
INTEGRATOR_NAME |
VARCHAR2(255) |
The name of Warehouse Builder integrator component that is used to access external data source for the module |
IS_VALID |
VARCHAR2(13) |
Is this module valid |
LOCATION_ID |
NUMBER(9) |
ID of the associated location for this module |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of the associated location |
STATUS |
VARCHAR2(17) |
Status (dev, QA, or prod) |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-9 ALL_IV_INSTALLATIONS
Column Name | Data Type | Description |
---|---|---|
INSTALLATION_ID |
NUMBER(9) |
ID of the Warehouse Builder repository |
INSTALLATION_NAME |
VARCHAR2(255) |
Physical name of the Warehouse Builder repository |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of the Warehouse Builder repository |
DESCRIPTION |
VARCHAR2(4000) |
Description of the Warehouse Builder repository |
INSTALLED_VERSION |
VARCHAR2(40) |
Version of the Warehouse Builder repository |
RELEASE |
VARCHAR2(40) |
Version of the Warehouse Builder Client |
REPOSITORY_MODEL_VERSION |
NUMBER(9) |
Version of the Warehouse Builder model |
PUBLIC_VIEW_VERSION |
CHAR(5) |
Version of the Warehouse Builder public views |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-10 ALL_IV_FILE_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project that this module belongs to |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of this file module |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of this file module |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this file module |
DESCRIPTION |
VARCHAR2(4000) |
Description of this file module |
PRODUCT_TYPE |
VARCHAR2(255) |
Application type of the module (for example, Oracle apps, or File based apps) |
SYSTEM_TYPE |
VARCHAR2(255) |
Type of system that holds this application (represented by PRODUCT_TYPE) |
VERSION_LABEL |
NUMBER(9) |
Version of the module |
VENDOR |
VARCHAR2(40) |
Vendor name |
DATABASE_LINK |
VARCHAR2(40) |
Name of the database link that physical points to data storage of this module. It is meaningful only for database applications |
DIRECTORY |
VARCHAR2(4000) |
Name of the directory this file module connects to |
INTEGRATOR_NAME |
VARCHAR2(255) |
The name of Warehouse Builder integrator component that is used to access external file system for the module |
IS_VALID |
VARCHAR2(13) |
Is this module valid |
LOCATION_ID |
NUMBER(9) |
ID of the associated location for this module |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of the associated location |
STATUS |
VARCHAR2(17) |
Status (dev, QA, or prod) |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-11 ALL_IV_GATEWAY_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project that this module belongs to |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of this module |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of this module |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this module |
DESCRIPTION |
VARCHAR2(4000) |
Description of this module |
PRODUCT_TYPE |
VARCHAR2(255) |
Application type of the module (for example, Oracle apps or File based apps) |
SYSTEM_TYPE |
VARCHAR2(255) |
Type of system that holds this application (represented by PRODUCT_TYPE) |
VERSION_LABEL |
NUMBER(9) |
Version of the module |
VENDOR |
VARCHAR2(40) |
Vendor name |
DATABASE_LINK |
VARCHAR2(40) |
Name of the database link that physical points to data storage of this module. It is meaningful only for database applications |
INTEGRATOR_NAME |
VARCHAR2(255) |
The name of Warehouse Builder integrator component that is used to access external data system for the module |
STRONG_TYPE_NAME |
VARCHAR2(255) |
Used to differentiate which gateway component being employed, for example, Informix or Sybase |
IS_VALID |
VARCHAR2(13) |
Is this module valid |
LOCATION_ID |
NUMBER(9) |
ID of the associated location for this module |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of the associated location |
STATUS |
VARCHAR2(17) |
Status (dev, QA, or prod) |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-12 ALL_IV_PACKAGED_APPS_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project that this module belongs to |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of this module (basically, the views wraps Oracle Applications, SAP) |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of this module |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this module |
DESCRIPTION |
VARCHAR2(4000) |
Description of this module |
PRODUCT_TYPE |
VARCHAR2(255) |
Application type of the module (for example, Oracle apps ,or File based apps) |
SYSTEM_TYPE |
VARCHAR2(255) |
Type of system that holds this application (represented by PRODUCT_TYPE) |
VERSION_LABEL |
NUMBER(9) |
Version of the module |
VENDOR |
VARCHAR2(40) |
Vendor name |
DATABASE_LINK |
VARCHAR2(40) |
Name of the database link that physical points to data storage of this module. It is meaningful only for database applications. |
INTEGRATOR_NAME |
VARCHAR2(255) |
The name of Warehouse Builder integrator component that is used to access external data system for the module |
IS_VALID |
VARCHAR2(13) |
Is this module valid |
LOCATION_ID |
NUMBER(9) |
ID of the associated location for this module |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of the associated location |
STATUS |
VARCHAR2(17) |
Status (dev, QA, or prod) |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-13 ALL_IV_PREDEFINED_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project that this module belongs to |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of this module (basically, the views wraps Oracle Pre-defined Transformations and Public Transformations) |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of this module |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this module |
DESCRIPTION |
VARCHAR2(4000) |
Description of this module |
PRODUCT_TYPE |
VARCHAR2(255) |
Application type of the module (for example, Oracle apps or File based apps) |
SYSTEM_TYPE |
VARCHAR2(255) |
Type of system that holds this application (represented by PRODUCT_TYPE) |
VERSION_LABEL |
NUMBER(9) |
Version of the module |
VENDOR |
VARCHAR2(40) |
Vendor name |
DATABASE_LINK |
VARCHAR2(40) |
Name of the database link that physical points to data storage of this module. It is meaningful only for database applications |
INTEGRATOR_NAME |
VARCHAR2(255) |
The name of Warehouse Builder integrator component that is used to access external data system for the module |
IS_VALID |
VARCHAR2(13) |
Is this module valid |
STATUS |
VARCHAR2(17) |
Status (dev, QA, or prod) |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-14 ALL_IV_PROCESS_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project to which this module belongs |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of this module (basically, the views wraps Oracle Process Flow Module) |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of this module |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this module |
DESCRIPTION |
VARCHAR2(4000) |
Description of this module |
PRODUCT_TYPE |
VARCHAR2(255) |
Application type of the module (for example, Oracle apps or File based apps) |
SYSTEM_TYPE |
VARCHAR2(255) |
Type of system that holds this application (represented by PRODUCT_TYPE) |
VERSION_LABEL |
NUMBER(9) |
Version of the module |
VENDOR |
VARCHAR2(40) |
Vendor name |
DATABASE_LINK |
VARCHAR2(40) |
Name of the database link that physical points to data storage of this module. It is meaningful only for database applications. |
INTEGRATOR_NAME |
VARCHAR2(255) |
The name of Warehouse Builder integrator component that is used to access external data system for the module |
IS_VALID |
VARCHAR2(13) |
Is this module valid |
LOCATION_ID |
NUMBER(9) |
ID of the associated location for this module |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of the associated location |
STATUS |
VARCHAR2(17) |
Status (dev, QA, or prod) |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-15 ALL_IV_WAREHOUSE_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project that this module belongs to |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of this module (basically, the views wraps Oracle Warehouse Module) |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of this module |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this module |
DESCRIPTION |
VARCHAR2(4000) |
Description of this module |
PRODUCT_TYPE |
VARCHAR2(255) |
Application type of the module (for example, Oracle apps or File based apps) |
SYSTEM_TYPE |
VARCHAR2(255) |
Type of system that holds this application (represented by PRODUCT_TYPE) |
VERSION_LABEL |
NUMBER(9) |
Version of the module |
VENDOR |
VARCHAR2(40) |
Vendor name |
DATABASE_LINK |
VARCHAR2(40) |
Name of the database link that physical points to data storage of this module |
INTEGRATOR_NAME |
VARCHAR2(255) |
The name of Warehouse Builder integrator component that is used to access external data system for the module |
IS_VALID |
VARCHAR2(13) |
Is this module valid |
LOCATION_ID |
NUMBER(9) |
ID of the associated location for this module |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of the associated location |
STATUS |
VARCHAR2(17) |
Status (dev, QA, or prod) |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-16 ALL_IV_BUSINESS_DEF_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the business definition module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the business definition module |
FOR DISCOVERER |
NUMBER |
A value of 1 indicates a business definition module for Oracle Discoverer. |
FOR_OBI |
NUMBER |
A value of 1 indicates a business definition module for Oracle Business Intelligence. |
DATABASE_LINK |
VARCHAR2(40) |
Not applicable. |
VALID |
CHAR(1) |
Validation result of the business definition module. |
IS_VALID |
VARCHAR2(13) |
Validation status of the module. |
STATUS |
VARCHAR2(40) |
The module status (Development, Quality Assurance, or Production) |
LOCATION_ID |
NUMBER(9) |
ID of the Location associated with the business definition module |
LOCATION_NAME |
VARCHAR2(255) |
Name of the Location associated with the business definition module |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-17 ALL_IV_BUSINESS_PRES_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
MODULE_ID |
NUMBER(9) |
ID of the business presentation module |
MODULE_NAME |
VARCHAR2(255) |
Name of the business presentation module |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the business presentation module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the business presentation module |
PRODUCT_TYPE |
VARCHAR2(255) |
Type of product (Oracle BI Beans Application) |
SYSTEM_TYPE |
VARCHAR2(255) |
Internal |
VERSION_LABEL |
NUMBER(9) |
Internal |
VENDOR |
VARCHAR2(40) |
Name of the vendor (Currently the vendor name is Oracle) |
DATABASE_LINK |
VARCHAR2(40) |
Not applicable |
INTEGRATOR_NAME |
VARCHAR2(255) |
Internal |
IS_VALID |
VARCHAR2(13) |
Validation status of the module |
STATUS |
VARCHAR2(40) |
The module status (Development, Quality Assurance, or Production) |
LOCATION_ID |
NUMBER(9) |
Id of the location with which the business presentation module is associated |
LOCATION_NAME |
VARCHAR2(255) |
Name of the location with which the business presentation module is associated |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-18 ALL_IV_CALENDAR_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
CALENDAR_MODULE_ID |
NUMBER(9) |
ID of the calendar module |
CALENDAR_MODULE_NAME |
VARCHAR2(255) |
Name of the calendar module |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the calendar module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the calendar module |
IS_VALID |
VARCHAR2(13) |
Is the calendar module valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-19 ALL_IV_CMIV_DEFINITIONS
Column Name | Data Type | Description |
---|---|---|
CMIV_ID |
NUMBER(9) |
ID of the CMI definition |
NAME |
VARCHAR2(255) |
Name of the CMI definition |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name |
MIVMODE |
VARCHAR2(40) |
Mode of CMI (SQL or XML File) |
TYPE |
VARCHAR2(40) |
Type |
TABLE_FILTER_SUPPORTED |
VARCHAR2(1) |
Flag on supporting table filter |
VIEW_FILTER_SUPPORTED |
VARCHAR2(1) |
Flag on supporting view filter |
SEQUENCE_FILTER_SUPPORTED |
VARCHAR2(1) |
Flag on supporting sequence filter |
TABLE_FKLEVEL_SUPPORTED |
VARCHAR2(1) |
Flag on supporting table foreign key level dependency |
MULTI_TREE_SUPPORTED |
VARCHAR2(1) |
Flag on supporting multiple tree in business component navigation |
REIMPORT_SUPPORTED |
VARCHAR2(1) |
Flag on supporting reimport |
TEST_DB_LINK |
VARCHAR2(255) |
DB link used for testing the CMI definition |
TESTDIRECTORY |
VARCHAR2(255) |
File directory used for testing the CMI definition |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-20 ALL_IV_CMIV_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the information system |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Name of the information system |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the module |
PRODUCT_TYPE |
VARCHAR2(255) |
Product type |
SYSTEM_TYPE |
VARCHAR2(255) |
System type |
VERSION_LABEL |
NUMBER(9) |
Version label |
VENDOR |
VARCHAR2(40) |
Vendor |
DATABASE_LINK |
VARCHAR2(40) |
Database link |
INTEGRATOR_NAME |
VARCHAR2(255) |
Name of the integrator |
IS_VALID |
VARCHAR2(13) |
Flag on valid module |
STATUS |
VARCHAR2(40) |
Status |
LOCATION_ID |
NUMBER(9) |
ID of the location to access data |
LOCATION_NAME |
VARCHAR2(255) |
Name of the data location |
METADATA_LOCATION_ID |
NUMBER(9) |
ID of the location to access metadata |
METADATA_LOCATION_NAME |
VARCHAR2(255) |
Name of the metadata location |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-21 ALL_IV_DATA_RULE_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project to which the data rule module belongs |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project to which the data rule module belongs |
SCHEMA_ID |
NUMBER(9) |
ID of the data rule module |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the data rule module |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the data rule module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the data rule module |
STATUS |
VARCHAR2(40) |
Not used |
IS_VALID |
VARCHAR2(13) |
Not used |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-22 ALL_IV_EXPERT_MODULES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the information system |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Name of the information system |
BUSINESS_NAME |
VARCHAR2(1000) |
The business name of the expert module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the module |
VERSION_LABEL |
NUMBER(9) |
The version for this module |
IS_VALID |
VARCHAR2(13) |
Is this module valid |
STATUS |
VARCHAR2(40) |
The status for this module |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-23 ALL_IV_PF_CORRECTED_MODULES
Column Name | Data Type | Description |
---|---|---|
PROFILE_ID |
NUMBER(9) |
ID of the profile |
PROFILE_NAME |
VARCHAR2(255) |
Name of the profile |
CORRECTED_MODULE_ID |
NUMBER(9) |
ID of the corrected module |
CORRECTED_MODULE_NAME |
VARCHAR2(255) |
Name of the corrected module |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the corrected module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the corrected module |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the information system |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Name of the information system |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the SAP module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the SAP module |
PRODUCT_TYPE |
VARCHAR2(255) |
Product type |
SYSTEM_TYPE |
VARCHAR2(255) |
System type |
VERSION_LABEL |
NUMBER(9) |
Version label |
VENDOR |
VARCHAR2(40) |
Vendor |
INTEGRATOR_NAME |
VARCHAR2(255) |
Integrator name |
IS_VALID |
VARCHAR2(13) |
Flag if the module is valid |
STATUS |
VARCHAR2(40) |
Status |
LOCATION_ID |
NUMBER(9) |
Data location ID |
LOCATION_NAME |
VARCHAR2(255) |
Data location name |
METADATA_LOCATION_ID |
NUMBER(9) |
Metadata location ID |
METADATA_LOCATION_NAME |
VARCHAR2(255) |
Metadata location name |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
TM_ID |
NUMBER(9) |
ID of the transportable module |
TM_NAME |
VARCHAR2(255) |
Name of the transportable module |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the transportable module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the transportable module |
IS_VALID |
VARCHAR2(13) |
Whether the transportable module is valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
CHARSET |
VARCHAR2(40) |
Not used |
ORACLEHOME |
VARCHAR2(40) |
Not used |
HOST |
VARCHAR2(40) |
The source database host name |
DEFAULTPORT |
NUMBER(9) |
The access port of source database |
SERVICE |
VARCHAR2(40) |
The database service name of source database |
SID |
VARCHAR2(40) |
Not used |
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the information system |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Name of the information system |
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
MODULE_TYPE |
VARCHAR2(255) |
Type of the module |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the module |
DESCRIPTION |
VARCHAR2(4000) |
Description of the module |
STATUS |
VARCHAR2(40) |
Status of the module |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
MIV_DEFINITION_ID |
NUMBER(9) |
ID of the CMI definition |
MIV_DEFINITION |
VARCHAR2(255) |
Name of the CMI definition |
MIV_VIEW_ID |
NUMBER(9) |
ID of the CMI View |
MIV_VIEW |
VARCHAR2(255) |
Name of the CMI View |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the CMI view |
VIEW_TYPE |
VARCHAR2(40) |
Type of the CMI view |
IS_DEFAULT |
VARCHAR2(1) |
Flag if the view definition is the default |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-28 ALL_IV_FIRSTCLASS_OBJECTS
Column Name | Data Type | Description |
---|---|---|
OBJECT_ID |
NUMBER(9) |
ID of the object |
OBJECT_NAME |
VARCHAR2(255) |
Name of the object |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the object |
DESCRIPTION |
VARCHAR2(4000) |
Description of the object |
CLASSNAME |
VARCHAR2(255) |
Internal type of the object |
OBJECT_TYPE |
VARCHAR2(4000) |
Type of object |
SCRIPTING_TYPE |
VARCHAR2(4000) |
Type of object exposed in scripting |
OBJECT_UOID |
VARCHAR2(255) |
UOID of the object |
OWNINGFOLDER |
NUMBER |
Folder that owns the object |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-29 ALL_IV_DB_FUNCTIONS
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
FUNCTION_LIBRARY_ID |
NUMBER(9) |
ID of the function library |
FUNCTION_LIBRARY_NAME |
VARCHAR2(255) |
Name of the function library |
FUNCTION_ID |
NUMBER(9) |
ID of the function |
FUNCTION_NAME |
VARCHAR2(255) |
Name of the function |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the function |
DESCRIPTION |
VARCHAR2(4000) |
Description of the function |
SIGNATURE |
VARCHAR2(4000) |
Signature of the function |
FUNCTION_TYPE |
CHAR(8) |
Function or procedure |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-30 ALL_IV_EXT_OBJECT_PROPERTIES
Column Name | Data Type | Description |
---|---|---|
OBJECT_ID |
NUMBER(9) |
ID of the object |
OBJECT_TYPE |
VARCHAR2(4000) |
Type of the object |
OBJECT_NAME |
VARCHAR2(255) |
Name of the object |
CONFIGURATION_ID |
NUMBER |
ID of the configuration |
CONFIGURATION_NAME |
VARCHAR2(255) |
Name of the configuration |
PROPERTY_GROUP_ID |
NUMBER(9) |
ID of the property group (UI folder) |
PROPERTY_GROUP_NAME |
VARCHAR2(255) |
Name of the property group |
PROPERTY_GROUP_NLS_KEY |
VARCHAR2(255) |
Key for NLS translation lookup of property group name |
PROPERTY_SET_ID |
NUMBER(9) |
ID for property set |
PROPERTY_SET_CLASS_NAME |
VARCHAR2(255) |
Name of defining class (may be superclass of OBJECT_TYPE) |
PROPERTY_SET_NAME |
VARCHAR2(255) |
Name of property set (Typically 'Default' unless property set visibility is dynamically controlled in the clients) |
PROPERTY_USAGE_ID |
NUMBER(9) |
ID of property usage (join between property set and property) |
PROPERTY_STORAGE_TYPE |
VARCHAR2(7) |
Storage type for property. One of CORE, LOGICAL, CONFIG, USERDEF. (Describes how property was initially defined) |
PROPERTY_USAGE_TYPE |
VARCHAR2(7) |
Usage type for property. One of CORE, LOGICAL, CONFIG, USERDEF. (Describes how property is used in this context) |
PROPERTY_NAME |
VARCHAR2(255) |
Name of property |
PROPERTY_NLS_KEY |
VARCHAR2(255) |
Key for NLS translation lookup of property name |
PROPERTY_DATATYPE_ID |
NUMBER |
ID of property data type |
PROPERTY_DATATYPE_NAME |
VARCHAR2(255) |
Name of property data type |
PROPERTY_AFFECTS_SIGNATURE |
VARCHAR2(4000) |
Do changes to the value of this property affect the semantic signature of the owning object (true, false) |
PROPERTY_DYNAMIC_DEFAULT |
VARCHAR2(4000) |
Fully qualified name of java class providing the default value for this property |
PROPERTY_IS_HIDDEN |
VARCHAR2(4000) |
Is this property hidden from the GUI (true, false) |
PROPERTY_PUBLISH_TO_PUBLIC_API |
VARCHAR2(4000) |
Is information on this property published in OMB*Plus help/documentation (true, false) |
PROPERTY_DEFAULT_VALUE |
VARCHAR2(4000) |
Default value for property (may not be correct if dynamic default is defined) |
PROPERTY_VALUE_OWNER_ID |
NUMBER(9) |
ID of the direct property owner |
PROPERTY_VALUE_ID |
NUMBER(9) |
ID of the property value |
PROPERTY_VALUE_INDEX |
NUMBER(9) |
Ordinal position of the property (If property type is an array) |
PROPERTY_VALUE_NAME |
VARCHAR2(255) |
Name of property value (For properties that are objects, such as SQL loader data files) |
PROPERTY_VALUE |
VARCHAR2(4000) |
Current value of property |
DESCRIPTION |
VARCHAR2(4000) |
Developer description of property (In English) |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-31 ALL_IV_ADVANCED_QUEUES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this queue belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
QUEUE_ID |
NUMBER(9) |
ID of this queue |
QUEUE_NAME |
VARCHAR2(255) |
Physical name of this queue |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this queue |
DESCRIPTION |
VARCHAR2(4000) |
Description of this queue |
LOAD_TYPE_ID |
NUMBER(9) |
ID of the load type |
LOAD_TYPE_NAME |
VARCHAR2(255) |
Name of the load type |
QUEUE_TABLE_NAME |
VARCHAR2(40) |
Name of the queue table |
IS_VALID |
VARCHAR2(13) |
Is this queue valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
DATA_ENTITY_ID |
NUMBER(9) |
ID of the data entity this attribute group belongs to |
DATA_ENTITY_TYPE |
VARCHAR2(4000) |
Type of the data entity |
DATA_ENTITY_NAME |
VARCHAR2(255) |
Physical name of the data entity |
ATTRIBUTE_GROUP_NAME |
VARCHAR2(255) |
Physical name of this attribute group |
ATTRIBUTE_GROUP_ID |
NUMBER(9) |
ID of this attribute group |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this attribute group |
DESCRIPTION |
VARCHAR2(4000) |
Description of this attribute group |
ATTRIBUTE_GROUP_TYPE |
VARCHAR2(40) |
Type of attribute group |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-33 ALL_IV_ATTR_GROUP_ITEM_USES
Column Name | Data Type | Description |
---|---|---|
ATTRIBUTE_GROUP_ID |
NUMBER(9) |
ID of the attribute group that this data item belongs to |
ATTRIBUTE_GROUP_NAME |
VARCHAR2(255) |
Name of the attribute group |
DATA_ITEM_ID |
NUMBER(9) |
ID of this data item |
DATA_ITEM_TYPE |
VARCHAR2(4000) |
Type of this data item |
DATA_ITEM_NAME |
VARCHAR2(255) |
Physical name of this data item |
POSITION |
NUMBER(9) |
Position of this data item in the attribute group |
Table 2-34 ALL_IV_CHECK_CONSTRAINTS
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this check constraint belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
RELATION_ID |
NUMBER(9) |
ID of the relation entity this check constraint belongs to |
RELATION_NAME |
VARCHAR2(255) |
Physical name of the relation entity |
CONSTRAINT_ID |
NUMBER(9) |
ID of this check constraint |
CONSTRAINT_NAME |
VARCHAR2(255) |
Physical name of this check constraint |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this check constraint |
DESCRIPTION |
VARCHAR2(4000) |
Description of this check constraint |
CONSTRAINT_TEXT |
VARCHAR2(255) |
Textual expression of this check constraint |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
ENTITY_ID |
NUMBER(9) |
ID of the data entity this column belongs to |
ENTITY_TYPE |
VARCHAR2(4000) |
Type of the data entity |
ENTITY_NAME |
VARCHAR2(255) |
Physical name of the data entity |
COLUMN_ID |
NUMBER(9) |
ID of this column |
COLUMN_NAME |
VARCHAR2(255) |
Physical name of this column |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this column |
DESCRIPTION |
VARCHAR2(4000) |
Description of this column |
POSITION |
NUMBER(9) |
Position of this column in the data entity |
DATA_TYPE |
VARCHAR2(255) |
Data type of this column |
LENGTH |
NUMBER(9) |
Data length of this column |
PRECISION |
NUMBER(9) |
Data precision of this column |
SCALE |
NUMBER(9) |
Data scale of this column |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this constraint belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
RELATION_ID |
NUMBER(9) |
ID of the relational entity this constraint belongs to |
RELATION_NAME |
VARCHAR2(255) |
Physical name of the relational entity |
CONSTRAINT_ID |
NUMBER(9) |
ID of this constraint |
CONSTRAINT_NAME |
VARCHAR2(255) |
Physical name of this constraint |
CONSTRAINT_TYPE |
VARCHAR2(21) |
Type of this constraint (check, primary, foreign key) |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this constraint |
DESCRIPTION |
VARCHAR2(4000) |
Description of this constraint |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this cube belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
CUBE_ID |
NUMBER(9) |
ID of this cube |
CUBE_NAME |
VARCHAR2(255) |
Physical name of this cube |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this cube |
DESCRIPTION |
VARCHAR2(4000) |
Description of this cube |
IS_VALID |
VARCHAR2(13) |
Is this cube valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
AUTOSOLVE |
CHAR(1) |
Sets the flag to say whether to measure is Auto Solve |
AWNAME |
VARCHAR2(255) |
The analytical workspace name where the cube is implemented |
AWOBJECTNAME |
VARCHAR2(4000) |
The analytical workspace object name |
AWTABLESPACENAME |
VARCHAR2(255) |
The analytical workspace tablespace name |
COMPRESSED |
CHAR(1) |
Flag to check whether the cube is compressed |
CREATEBITMAPS |
CHAR(1) |
Flag to check whether to create a bitmap for the cube |
CREATECONSTRAINTS |
CHAR(1) |
Flag to check whether to create a constraint for the cube |
IMPLEMENTATION |
VARCHAR2(255) |
Whether the storage of a cube is AW or Relational |
LOADPOLICY |
VARCHAR2(255) |
Not applicable for the current release |
OLAPUSERVISIBLE |
CHAR(1) |
Flag to check whether the Cube is visible to OLAP end user |
STORAGEPROPERTYTYPE |
VARCHAR2(255) |
The storage of a cube can be AW or Relational |
USEGLOBALINDEX |
CHAR(1) |
Whether to generate a composite for measure partition combination |
PARTITIONHIERARCHY |
NUMBER(9) |
The hierarchy by which one should partition the cube |
INSTALLEDMODULE |
NUMBER(9) |
The Oracle module to which the cube belongs |
PARTITIONLEVEL |
NUMBER(9) |
The level by which one should partition the cube |
BINDINGFACT |
NUMBER(9) |
The element ID for binding fact table to the cube |
Table 2-38 ALL_IV_CUBE_DIMENSIONS
Column Name | Data Type | Description |
---|---|---|
CUBE_ID |
NUMBER(9) |
ID of the cube this dimension has associated with |
CUBE_NAME |
VARCHAR2(255) |
Physical name of the cube |
DIMENSION_ID |
NUMBER(9) |
ID of this dimension |
DIMENSION_NAME |
VARCHAR2(255) |
Physical name of this dimension |
DIMENSION_ALIAS |
VARCHAR2(255) |
Alias of this dimension |
Table 2-39 ALL_IV_CUBE_MEASURES
Column Name | Data Type | Description |
---|---|---|
CUBE_ID |
NUMBER(9) |
ID of the cube this measure belongs to |
CUBE_NAME |
VARCHAR2(255) |
Physical name of the cube |
MEASURE_ID |
NUMBER(9) |
ID of this measure |
MEASURE_NAME |
VARCHAR2(255) |
Physical name of this measure |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this measure |
DESCRIPTION |
VARCHAR2(4000) |
Description of this measure |
POSITION |
NUMBER(9) |
Position of this measure within the cube |
DATA_TYPE |
VARCHAR2(255) |
Data type of this measure |
LENGTH |
NUMBER(9) |
Data length of this measure |
PRECISION |
NUMBER(9) |
Data precision of this measure |
SCALE |
NUMBER(9) |
Data scale of this measure |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
TABLE_ID |
NUMBER(9) |
ID of the table |
TABLE_NAME |
VARCHAR2(255) |
Name of the table |
Note:
The view ALL_IV_CUBE_MEASURE_DIM_USES is redundant. It can be created by joining ALL_IV_PF_CORRECTED_MODULES and ALL_IV_SAP_MODULES. It is scheduled for obsolescence.Table 2-40 ALL_IV_CUBE_MEASURE_DIM_USES
Column Name | Data Type | Description |
---|---|---|
CUBE_ID |
NUMBER(9) |
ID of the cube |
CUBE_NAME |
VARCHAR2(255) |
Physical name of the cube |
MEASURE_ID |
NUMBER(9) |
ID of the measure belonging to this cube |
MEASURE_NAME |
VARCHAR2(255) |
Physical name of the measure |
DIMENSION_ID |
NUMBER |
ID of the dimension associated with this cube |
DIMENSION_NAME |
VARCHAR2(255) |
Physical name of the dimension |
DIMENSION_ALIAS |
VARCHAR2(255) |
Alias of the dimension |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this dimension belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
DIMENSION_ID |
NUMBER(9) |
ID of this dimension |
DIMENSION_NAME |
VARCHAR2(255) |
Physical name of this dimension |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this dimension |
DESCRIPTION |
VARCHAR2(4000) |
Description of this dimension |
IS_VALID |
VARCHAR2(13) |
Is this dimension valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
AWNAME |
VARCHAR2(255) |
The analytical workspace name where the dimension is implemented |
AWOBJECTNAME |
VARCHAR2(4000) |
The analytical workspace object name |
AWTABLESPACENAME |
VARCHAR2(255) |
The analytical workspace tablespace name |
CREATECONSTRAINTS |
CHAR(1) |
Flag to check whether to create a constraint for the dimension |
IMPLEMENTATION |
VARCHAR2(255) |
Type of implementation of the dimension (The storage of a dimension can be AW or Relational) |
LOADPOLICY |
VARCHAR2(255) |
Data policy for loading dimension where Warehouse Builder mapping code relies on database constraints to detect the orphans (level records without parent) |
OLAPPRIMARYSORTORDER |
VARCHAR2(255) |
The primary sorting order for dimension data in OLAP service |
OLAPSECONDARYSORTORDER |
VARCHAR2(255) |
The secondary sorting order for dimension data in OLAP service |
OLAPTYPE |
VARCHAR2(255) |
Type of OLAP Dimension Normal or Time |
OLAPUSERVISIBLE |
CHAR(1) |
Whether the dimension is visible to OLAP end user |
OWBTYPE |
VARCHAR2(255) |
Type of Dimension Normal or Time |
REMOVEPOLICY |
VARCHAR2(255) |
Orphan Management (not applicable for the current release) |
SLOWLYCHANGINGTYPE |
NUMBER(9) |
Slowly changing policy to be applied on the dimension |
STORAGEPROPERTYTYPE |
VARCHAR2(255) |
The storage of a cube can be AW or Relational |
VALUEBASED |
CHAR(1) |
The flag to define a value based hierarchy, applicable for AW only |
DEFAULTDISPLAYHIERARCHY |
NUMBER(9) |
The hierarchy is set as default display hierarchy |
INSTALLEDMODULE |
NUMBER(9) |
The Oracle module to which the cube belongs |
TIMEDIMPOPULATIONMAP |
NUMBER(9) |
The element ID of map for a time dimension |
DIMENSIONKEYSEQUENCE |
NUMBER(9) |
Element ID for sequence to generate the dimension key |
Table 2-42 ALL_IV_DIM_HIERARCHIES
Column Name | Data Type | Description |
---|---|---|
DIMENSION_ID |
NUMBER(9) |
ID of the dimension this hierarchy belongs to |
DIMENSION_NAME |
VARCHAR2(255) |
Physical name of this dimension |
HIERARCHY_ID |
NUMBER(9) |
ID of this hierarchy |
HIERARCHY_NAME |
VARCHAR2(255) |
Physical name of this hierarchy |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of this hierarchy |
DESCRIPTION |
VARCHAR2(4000) |
Description of this hierarchy |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-43 ALL_IV_DIM_HIERARCHY_LEVELS
Column Name | Data Type | Description |
---|---|---|
LEVEL_USE_ID |
NUMBER(9) |
ID of the level relationship that this level and this parent level participates in |
LEVEL_USE_NAME |
VARCHAR2(255) |
Level name used on Hierarchy |
HIERARCHY_ID |
NUMBER(9) |
ID of the hierarchy that this level and this parent level belongs to |
HIERARCHY_NAME |
VARCHAR2(255) |
Physical name of the hierarchy |
LEVEL_ID |
NUMBER(9) |
ID of this level |
LEVEL_NAME |
VARCHAR2(255) |
Physical name of this level |
LEVEL_DESCRIPTION |
VARCHAR2(4000) |
Description of this level |
PARENT_LEVEL_ID |
NUMBER(9) |
ID of this parent level |
PARENT_LEVEL_NAME |
VARCHAR2(255) |
Physical name of this parent level |
POSITION |
NUMBER(9) |
Position of this level |
Column Name | Data Type | Description |
---|---|---|
DIMENSION_ID |
NUMBER(9) |
ID of the dimension this level belongs to |
DIMENSION_NAME |
VARCHAR2(255) |
Physical name of the dimension |
LEVEL_ID |
NUMBER(9) |
ID of this level |
LEVEL_NAME |
VARCHAR2(255) |
Physical name of this level |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this level |
DESCRIPTION |
VARCHAR2(4000) |
Description of this level |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-45 ALL_IV_DIM_LEVEL_ATTRIBUTES
Column Name | Data Type | Description |
---|---|---|
LEVEL_ID |
NUMBER(9) |
ID of the level this attribute belongs to |
LEVEL_NAME |
VARCHAR2(255) |
Physical name of the level |
ATTRIBUTE_ID |
NUMBER(9) |
ID of this attribute |
ATTRIBUTE_NAME |
VARCHAR2(255) |
Physical name of this attribute |
DIMENSION_ATTRIBUTE |
VARCHAR2(255) |
Name of the dimension attribute that the level attribute implements |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of this attribute |
DESCRIPTION |
VARCHAR2(4000) |
Description of this attribute |
POSITION |
NUMBER(9) |
Position of this attribute within the level |
DATA_TYPE |
VARCHAR2(255) |
Data type of this attribute |
LENGTH |
NUMBER(9) |
Data length of this attribute |
PRECISION |
NUMBER(9) |
Data precision of this attribute |
SCALE |
NUMBER(9) |
Data scale of this attribute |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-46 ALL_IV_EXTERNAL_COLUMNS
Column Name | Data Type | Description |
---|---|---|
ENTITY_ID |
NUMBER(9) |
ID of the external table that this column belongs to |
ENTITY_NAME |
VARCHAR2(255) |
Name of the external table |
COLUMN_ID |
NUMBER(9) |
ID of this column |
COLUMN_NAME |
VARCHAR2(255) |
Physical name of this column |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this column |
DESCRIPTION |
VARCHAR2(4000) |
Description of this column |
POSITION |
NUMBER(9) |
Position of this column within the external table |
DATA_TYPE |
VARCHAR2(255) |
Data type of this column |
LENGTH |
NUMBER(9) |
Data length of this column |
PRECISION |
NUMBER(9) |
Data precision of this column |
SCALE |
NUMBER(9) |
Data scale of this column |
SOURCE_FIELD_ID |
NUMBER(9) |
ID of the field that this column maps to |
SOURCE_FIELD_NAME |
VARCHAR2(255) |
Physical name of the source field |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-47 ALL_IV_EXTERNAL_TABLES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this external table belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
LOCATION_ID |
NUMBER(9) |
ID of the location where the module is deployed to |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of the location |
TABLE_ID |
NUMBER(9) |
ID of the external table |
TABLE_NAME |
VARCHAR2(255) |
Physical name of the external table |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of the external table |
DESCRIPTION |
VARCHAR2(4000) |
Description of the external table |
SOURCE_RECORD_ID |
NUMBER(9) |
ID of the record that this external table maps to |
SOURCE_RECORD_NAME |
VARCHAR2(255) |
Physical name of the source record |
SOURCE_FILE_NAME |
VARCHAR2(255) |
Physical name of the file that this source record belongs to |
ACCESS_PARAMETERS |
VARCHAR2(4000) |
Expression for parameters that are used to access the source record |
IS_VALID |
VARCHAR2(13) |
Is this external table valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-48 ALL_IV_FOREIGN_KEYS
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module that this foreign key belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
ENTITY_ID |
NUMBER(9) |
ID of the data entity this foreign key belongs to |
ENTITY_NAME |
VARCHAR2(255) |
Physical name of the data entity |
ENTITY_TYPE |
VARCHAR2(4000) |
Type of the data type (for example, table, view) |
FOREIGN_KEY_ID |
NUMBER(9) |
ID of this foreign key |
FOREIGN_KEY_NAME |
VARCHAR2(255) |
Physical name of this foreign key |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this foreign key |
DESCRIPTION |
VARCHAR2(4000) |
Description of this foreign key |
KEY_ID |
NUMBER(9) |
ID of the associated key for this foreign key |
KEY_NAME |
VARCHAR2(255) |
Physical name of the key |
IS_DISABLED |
CHAR(1) |
Is this foreign key disabled |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this key belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of this module |
ENTITY_ID |
NUMBER(9) |
ID of the data entity this key belongs to |
ENTITY_NAME |
VARCHAR2(255) |
Physical name of the data entity |
ENTITY_TYPE |
VARCHAR2(4000) |
Type of the data entity (for example, table, view) |
KEY_ID |
NUMBER(9) |
ID of this key |
KEY_NAME |
VARCHAR2(255) |
Physical name of this key |
BUSINESS_NAME |
VARCHAR2(4000) |
Business of this key |
DESCRIPTION |
VARCHAR2(4000) |
Description of this key |
IS_PRIMARY |
VARCHAR2(9) |
Is this key primary key |
IS_DISABLED |
CHAR(1) |
Is this key disabled |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-50 ALL_IV_KEY_COLUMN_USES
Column Name | Data Type | Description |
---|---|---|
KEY_ID |
NUMBER(9) |
ID of the key that this column is associated with |
KEY_NAME |
VARCHAR2(255) |
Physical name of the key |
KEY_TYPE |
VARCHAR2(11) |
Type of the key (primary, unique, foreign) |
COLUMN_ID |
NUMBER(9) |
ID of this column |
COLUMN_NAME |
VARCHAR2(255) |
Physical name of this column |
POSITION |
NUMBER(9) |
Position of this column with the key |
Table 2-51 ALL_IV_MATERIALIZED_VIEWS
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this materialized view belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
VIEW_ID |
NUMBER(9) |
ID of this materialized view |
VIEW_NAME |
VARCHAR2(255) |
Physical name of this materialized view |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this materialized view |
DESCRIPTION |
VARCHAR2(4000) |
Description of this materialized view |
QUERY_TEXT |
VARCHAR2(4000) |
Textual expression of query statement for this materialized view |
IS_VALID |
VARCHAR2(13) |
Is this materialized view valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-52 ALL_IV_OBJECT_TYPES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this object type belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
FOLDER_ID |
NUMBER(9) |
ID of the folder this object type belongs to |
FOLDER_NAME |
VARCHAR2(255) |
Physical name of the folder |
OBJECT_TYPE_ID |
NUMBER(9) |
ID of this object type |
OBJECT_TYPE_NAME |
VARCHAR2(255) |
Physical name of this object type |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this object |
DESCRIPTION |
VARCHAR2(4000) |
Description of this object type |
TYPE |
VARCHAR2(40) |
Type of this object type |
IS_VALID |
VARCHAR2(13) |
Is this object type valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-53 ALL_IV_RECORD_FIELDS
Column Name | Data Type | Description |
---|---|---|
FIRSTCLASS_OBJECT_ID |
NUMBER(9) |
ID of the first class object that this record field belongs to (normally, this ID will be the same as the following relational ID) |
FRISTCLASS_OBJECT_NAME |
VARCHAR2(255) |
Physical name of the first class object |
RELATION_ID |
NUMBER(9) |
ID of the relational entity this record field belongs to |
RELATION_NAME |
VARCHAR2(255) |
Physical name of the relational entity |
RECORDFIELD_ID |
NUMBER(9) |
ID of this record field |
RECORDFIELD_NAME |
VARCHAR2(255) |
Physical name of this record field |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this record field |
DESCRIPTION |
VARCHAR2(4000) |
Description of this record field |
POSITION |
NUMBER(9) |
Position of this record field |
DATA_TYPE |
VARCHAR2(255) |
Data type of this record field |
LENGTH |
NUMBER(9) |
Data length of this record field |
PRECISION |
NUMBER(9) |
Data precision of this record field |
SCALE |
NUMBER(9) |
Data scale of this record field |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this relational entity belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
RELATION_ID |
NUMBER(9) |
ID of this relational entity |
RELATION_NAME |
VARCHAR2(255) |
Physical name of this relational entity |
RELATION_TYPE |
VARCHAR2(16) |
Type of this relational entity (such as table, view, sequence and materialized view) |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this relational entity |
DESCRIPTION |
VARCHAR2(4000) |
Description of this relational entity |
IS_VALID |
VARCHAR2(13) |
Is this relational entity valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this sequence belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module the sequence belongs to |
SEQUENCE_ID |
NUMBER(9) |
ID of the sequence |
SEQUENCE_NAME |
VARCHAR2(255) |
Physical name of the sequence |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of the sequence |
DESCRIPTION |
VARCHAR2(4000) |
Description of the sequence |
IS_VALID |
VARCHAR2(13) |
Is this sequence valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this view belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
VIEW_ID |
NUMBER(9) |
ID of this view |
VIEW_NAME |
VARCHAR2(255) |
Physical name of this view |
QUERY_TEXT |
VARCHAR2(4000) |
Textual expression of the query for this view |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this view |
DESCRIPTION |
VARCHAR2(4000) |
Description of this view |
IS_VALID |
VARCHAR2(13) |
Is this view valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this table belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
TABLE_ID |
NUMBER(9) |
ID of this table |
TABLE_NAME |
VARCHAR2(255) |
Physical name of this table |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this table |
DESCRIPTION |
VARCHAR2(4000) |
Description of this table |
IS_VALID |
VARCHAR2(13) |
Is this table valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
CALENDAR_MODULE_ID |
NUMBER(9) |
ID of the owning calendar module |
CALENDAR_MODULE_NAME |
VARCHAR2(255) |
Name of the owning calendar module |
CALENDAR_ID |
NUMBER(9) |
ID of the calendar |
CALENDAR_NAME |
VARCHAR2(255) |
Name of the calendar |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the calendar |
DESCRIPTION |
VARCHAR2(4000) |
Description of the calendar |
IS_VALID |
VARCHAR2(13) |
Is the calendar valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
VARRAY_ID |
NUMBER(9) |
ID of the varray |
VARRAY_NAME |
VARCHAR2(255) |
Name of the varray |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the varray |
DESCRIPTION |
VARCHAR2(4000) |
Description of the varray |
IS_VALID |
VARCHAR2(13) |
Is the varray valid |
BASE_ELEMENT_NAME |
VARCHAR2(767) |
Name of the base element |
BASE_ELEMENT_PRECISION |
NUMBER |
Precision of the base element |
BASE_ELEMENT_SCALE |
NUMBER |
Scale of the base element |
BASE_ELEMENT_LENGTH |
NUMBER |
Length of the base element |
ARRAY_LENGTH |
NUMBER(9) |
Number of elements in the varray |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the schema |
DESCRIPTION |
VARCHAR2(4000) |
Description of the schema |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the information system |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Name of the information system |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Create timestamp |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
FUNCTION_LIBRARY_ID |
NUMBER(9) |
ID of the function library |
FUNCTION_LIBRARY_NAME |
VARCHAR2(255) |
Name of the function library |
FUNCTION_ID |
NUMBER(9) |
ID of the procedure |
FUNCTION_NAME |
VARCHAR2(255) |
Physical name of the procedure |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the procedure |
DESCRIPTION |
VARCHAR2(4000) |
Description of the procedure |
SIGNATURE |
VARCHAR2(4000) |
Signature of procedure |
FUNCTION_TYPE |
CHAR(9) |
Type of the function |
IS_VALID |
VARCHAR2(13) |
Is procedure valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
LIBRARY_ID |
NUMBER(9) |
ID of the library |
LIBRARY_NAME |
VARCHAR2(255) |
Name of the library |
CURSOR_ID |
NUMBER(9) |
ID of the cursor |
CURSOR_NAME |
VARCHAR2(255) |
Name of the cursor |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the cursor |
DESCRIPTION |
VARCHAR2(4000) |
Description of the cursor |
CURSOR_TYPE |
VARCHAR2(40) |
Type of the cursor |
RETURN_RECORD_ID |
NUMBER(9) |
Ref Cursor Row Type Id |
RETURN_RECORD_NAME |
VARCHAR2(255) |
Ref Cursor Row Type Name |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-63 ALL_IV_DIM_ATTRIBUTES
Column Name | Data Type | Description |
---|---|---|
DIMENSION_ID |
NUMBER(9) |
ID of the dimension |
DIMENSION_NAME |
VARCHAR2(255) |
Name of the dimension |
ATTRIBUTE_ID |
NUMBER(9) |
ID of the attribute |
ATTRIBUTE_NAME |
VARCHAR2(255) |
Name of the attribute |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the attribute |
DESCRIPTION |
VARCHAR2(4000) |
Description of the attribute |
POSITION |
NUMBER(9) |
Position of the dimension attribute |
DATA_TYPE |
VARCHAR2(255) |
Data type of the dimension attribute |
LENGTH |
NUMBER(9) |
Length for data types of the dimension attribute |
PRECISION |
NUMBER(9) |
Precision for data types of the dimension attribute |
SCALE |
NUMBER(9) |
Scale for data types of the dimension attribute |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
DIMENSION_ID |
NUMBER(9) |
ID of the dimension |
DIMENSION_NAME |
VARCHAR2(255) |
Name of the dimension |
ROLE_ID |
NUMBER(9) |
ID of the role |
ROLE_NAME |
VARCHAR2(255) |
Name of the role |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the role |
DESCRIPTION |
VARCHAR2(4000) |
Description of the role |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
TM_TABLESPACE_ID |
NUMBER(9) |
ID of the owning tablespace |
TM_TABLESPACE_NAME |
VARCHAR2(255) |
Internal name of the owning tablespace |
TM_SCHEMA_ID |
NUMBER(9) |
ID of the schema |
TM_SCHEMA_NAME |
VARCHAR2(255) |
Internal unique name for the schema |
TM_SCHEMA_UI_NAME |
VARCHAR2(1002) |
Schema name of the schema in source database. This may not be unique |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the schema |
DESCRIPTION |
VARCHAR2(4000) |
Description of the schema |
IS_VALID |
VARCHAR2(13) |
Not used |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-66 ALL_IV_TM_TABLESPACES
Column Name | Data Type | Description |
---|---|---|
TM_ID |
NUMBER(9) |
ID of the transportable module |
TM_NAME |
VARCHAR2(255) |
Name of the transportable module |
TM_TABLESPACE_ID |
NUMBER(9) |
Internal ID assigned to tablespace within the transportable module |
TM_TABLESPACE_NAME |
VARCHAR2(255) |
Internal name assigned to tablespace within the transportable module. The internal tablespace name is unique |
BUSINESS_NAME |
VARCHAR2(1000) |
The full specification of the tablespace. The format of this value is <Internal tablespace name>:<Source Host>:<Source Port>:<Source Service>:<Source Tablespace Name> |
TM_TABLESPACE_UI_NAME |
VARCHAR2(1000) |
The source tablespace name that this tablespace represent. The tablespace UI name is not guaranteed to be unique |
DESCRIPTION |
VARCHAR2(4000) |
Description of the tablespace |
IS_VALID |
VARCHAR2(13) |
Not used |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
EXPANDABLE |
CHAR(1) |
Not used |
BLOCKSIZE |
NUMBER(9) |
Not used |
Column Name | Data Type | Description |
---|---|---|
IMPLEMENTATION_ID |
NUMBER(9) |
ID of this cube (this column will be updated in future) |
ITEM_ID |
NUMBER(9) |
ID of the item belonging to this cube |
ITEM_TYPE |
VARCHAR2(18) |
Type of item, either cube measures or cube dimension use (foreign keys pointing to dimension) |
ITEM_NAME |
VARCHAR2(255) |
Physical name of the item |
CUBE_ID |
NUMBER(9) |
ID of this cube |
CUBE_NAME |
VARCHAR2(255) |
Physical name of this cube |
DIMENSION_ID |
NUMBER(9) |
ID of the associated dimension |
DIMENSION_NAME |
VARCHAR2(255) |
Physical name of the associated name |
DIMENSION_ALIAS |
VARCHAR2(255) |
Alias of the associated dimension (name of the foreign key in the cube) |
COLUMN_ID |
NUMBER(9) |
ID of the implementing column for the item |
COLUMN_NAME |
VARCHAR2(255) |
Physical name of the implementing column for the item |
POSITION |
NUMBER |
Position of the implementing column |
TABLE_ID |
NUMBER(9) |
ID of the implementing table for this cube |
TABLE_NAME |
VARCHAR2(255) |
Physical name of the implementing table |
FOREIGN_KEY_ID |
NUMBER(9) |
ID of the foreign key pointing to the dimension |
FOREIGN_KEY_NAME |
VARCHAR2(255) |
Physical name of the foreign key |
DIM_IMPLEMENTATION_ID |
NUMBER(9) |
Not used (Value is set to NULL) |
Column Name | Data Type | Description |
---|---|---|
IMPLEMENTATION_ID |
NUMBER(9) |
ID of the table in the case of STAR implementtion (this column will be updated in future) |
LEVEL_ID |
NUMBER(9) |
ID of the level |
DIMENSION_ID |
NUMBER(9) |
ID of the dimension |
DIMENSION_NAME |
VARCHAR2(255) |
Physical name of the dimension |
LEVEL_NAME |
VARCHAR2(255) |
Name of the level |
TABLE_NAME |
VARCHAR2(255) |
Name of the table |
Table 2-69 ALL_IV_DIM_LEVEL_IMPLS
Column Name | Data Type | Description |
---|---|---|
IMPLEMENTATION_ID |
NUMBER(9) |
ID of the level attribute (this column will be updated in future) |
ITEM_ID |
NUMBER(9) |
ID of the item belonging to this level |
ITEM_TYPE |
VARCHAR2(18) |
Type of the item (constant value: Level Attribute) |
ITEM_NAME |
VARCHAR2(255) |
Physical name of the item |
DIMENSION_ID |
NUMBER(9) |
ID of the dimension |
DIMENSION_NAME |
VARCHAR2(255) |
Physical name of the dimension |
LEVEL_ID |
NUMBER(9) |
ID of this level |
LEVEL_NAME |
VARCHAR2(255) |
Physical name of this level |
COLUMN_ID |
NUMBER(9) |
ID of the implementation column |
COLUMN_NAME |
VARCHAR2(255) |
Physical name of the implementation column |
TABLE_ID |
NUMBER(9) |
ID of the implementation table for this level |
TABLE_NAME |
VARCHAR2(255) |
Physical name of the implementation table for this level |
Table 2-70 ALL_IV_NESTED_TABLES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
NESTED_TABLE_ID |
NUMBER(9) |
ID of the nested table |
NESTED_TABLE_NAME |
VARCHAR2(255) |
Name of the nested table |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the nested table |
DESCRIPTION |
VARCHAR2(4000) |
Description of the nested table |
IS_VALID |
VARCHAR2(13) |
Is the nested table valid |
BASE_ELEMENT_NAME |
VARCHAR2(767) |
Name of the base element |
BASE_ELEMENT_PRECISION |
NUMBER |
Precision of the base element |
BASE_ELEMENT_SCALE |
NUMBER |
Scale of the base element |
BASE_ELEMENT_LENGTH |
NUMBER |
Length of the base element |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
RECORD_ID |
NUMBER(9) |
ID of the record this field belongs to |
RECORD_NAME |
VARCHAR2(255) |
Physical name of the record |
FIELD_ID |
NUMBER(9) |
ID of this field |
FIELD_NAME |
VARCHAR2(255) |
Physical name of this field |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this field |
DESCRIPTION |
VARCHAR2(4000) |
Description of this field |
POSITION |
NUMBER(9) |
Position of this field |
DATA_TYPE |
VARCHAR2(255) |
Data type of this field |
LENGTH |
NUMBER(9) |
Data length of this field |
PRECISION |
NUMBER(9) |
Data precision of this field |
SCALE |
NUMBER(9) |
Data scale of this field |
PICTURE |
VARCHAR2(40) |
Picture of the field |
SIGN_TYPE |
NUMBER(9) |
Sign type of the field |
USAGE |
VARCHAR2(40) |
Usage of the field |
MASK |
VARCHAR2(255) |
Mask of the field |
NULLIF |
VARCHAR2(40) |
Nullif value of the field |
DEFAULTIF |
VARCHAR2(40) |
Defaultif value of the field |
SQL_DATA_TYPE |
VARCHAR2(40) |
SQL data type of the field |
SQL_LENGTH |
NUMBER(9) |
SQL data length of the field |
SQL_PRECISION |
NUMBER(9) |
SQL precision of the field |
SQL_SCALE |
NUMBER(9) |
SQL data scale of the field |
START_POSITION |
VARCHAR2(40) |
Start position of the field |
OCCURS |
NUMBER(9) |
Occurs of the attribute array within the structure (identified by next column) |
STRUCTURE_ID |
NUMBER(9) |
ID of the structure containing field |
STRUCTURE_NAME |
VARCHAR2(255) |
Physical name of the structure |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the module this file belongs to |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of the module |
FILE_ID |
NUMBER(9) |
ID of this file |
FILE_NAME |
VARCHAR2(255) |
Physical name of this file |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this file |
DESCRIPTION |
VARCHAR2(4000) |
Description of the file |
FILE_FORMAT |
VARCHAR2(10) |
Format of this file |
IS_VALID |
VARCHAR2(13) |
Is this file valid |
RECORD_CLASSIFIER_POSITION |
NUMBER(9) |
Record classifier position of this file |
RECORD_CLASSIFIER_LENGTH |
NUMBER(9) |
Record classifier length of this file |
RECORD_SIZE |
VARCHAR2(40) |
Record size of this file |
N_PHYSICAL_RECORDS_IN_LOGICAL |
NUMBER(9) |
Number of physical records for each logical record |
CONTINUATION_AT_END |
CHAR(1) |
Continuation at end or not |
CONTINUATION_DELIMITER |
VARCHAR2(40) |
Continuation delimiter symbol |
RECORD_DELIMITER |
VARCHAR2(40) |
Record delimiter symbol |
FIELD_DELIMITER |
VARCHAR2(40) |
Field delimiter symbol |
TEXT_START_DELIMITER |
VARCHAR2(1) |
Text start delimiter symbol |
TEXT_END_DELIMITER |
VARCHAR2(1) |
Text end delimiter symbol |
SOURCE_FROM |
VARCHAR2(4000) |
Directory path of this file |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
FILE_ID |
NUMBER(9) |
ID of the file this record belongs to |
FILE_NAME |
VARCHAR2(255) |
Physical name of the file |
RECORD_ID |
NUMBER(9) |
ID of this record |
RECORD_NAME |
VARCHAR2(255) |
Physical name of this record |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this record |
DESCRIPTION |
VARCHAR2(4000) |
Description of this record |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Note:
The view ALL_IV_COLLECTIONS replaces the CLASSIFICATION view.Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project this collection belongs to (this view replaces old classification view) |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
COLLECTION_ID |
NUMBER(9) |
ID of this collection |
COLLECTION_NAME |
VARCHAR2(255) |
Physical name of this collection |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this collection |
DESCRIPTION |
VARCHAR2(4000) |
Description of this collection |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-75 ALL_IV_COLLECTION_REFERENCES
Column Name | Data Type | Description |
---|---|---|
COLLECTION_ID |
NUMBER(9) |
ID of the collection this reference belongs to (this view replaces old classification_item view) |
COLLECTION_NAME |
VARCHAR2(255) |
Physical name of the collection |
COLLECTION_REFERENCE_ID |
NUMBER(9) |
ID of this collection reference |
COLLECTION_REFERENCE_TYPE |
VARCHAR2(4000) |
Type of this collection reference |
COLLECTION_REFERENCE_NAME |
VARCHAR2(255) |
Physical name of the collection reference |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this collection reference |
DESCRIPTION |
VARCHAR2(4000) |
Description of this collection reference |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this function belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
FUNCTION_LIBRARY_ID |
NUMBER(9) |
ID of the function library this function belongs to |
FUNCTION_LIBRARY_NAME |
VARCHAR2(255) |
Physical name of the function library |
FUNCTION_ID |
NUMBER(9) |
ID of this function |
FUNCTION_NAME |
VARCHAR2(255) |
Physical name of this function |
FUNCTION_TYPE |
VARCHAR2(13) |
Type of this function (function, procedure, table function) |
SIGNATURE |
VARCHAR2(4000) |
Signature of this function |
IS_VALID |
VARCHAR2(13) |
Is this function valid |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this function |
DESCRIPTION |
VARCHAR2(4000) |
Description of this function |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-77 ALL_IV_FUNCTION_LIBRARIES
Column Name | Data Type | Description |
---|---|---|
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the module this function library belongs to |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of the module |
FUNCTION_LIBRARY_ID |
NUMBER(9) |
ID of this function library |
FUNCTION_LIBRARY_NAME |
VARCHAR2(255) |
Physical name of this function library |
FUNCTION_LIBRARY_TYPE |
VARCHAR2(40) |
Type of this function library |
IS_VALID |
VARCHAR2(13) |
Is this function library valid |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this function library |
DESCRIPTION |
VARCHAR2(4000) |
Description of this function library |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-78 ALL_IV_FUNCTION_PARAMETERS
Column Name | Data Type | Description |
---|---|---|
FUNCTION_ID |
NUMBER(9) |
ID of the function this parameter belongs to |
FUNCTION_NAME |
VARCHAR2(255) |
Physical name of the function |
PARAMETER_ID |
NUMBER(9) |
ID of this parameter |
PARAMETER_NAME |
VARCHAR2(255) |
Physical name of this parameter |
PARAMETER_TYPE |
VARCHAR2(40) |
Type of this parameter |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this parameter |
DESCRIPTION |
VARCHAR2(4000) |
Description of this parameter |
POSITION |
NUMBER(9) |
Position of this parameter within the function |
DATA_TYPE |
VARCHAR2(255) |
Data type of this parameter |
LENGTH |
NUMBER(9) |
Data length of this parameter |
PRECISION |
NUMBER(9) |
Data precision of this parameter |
SCALE |
NUMBER(9) |
Data scale of this parameter |
DEFAULT_VALUE |
VARCHAR2(4000) |
Default value of this parameter |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-79 ALL_IV_TABLE_FUNCTIONS
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this table function belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
FUNCTION_LIBRARY_ID |
NUMBER(9) |
ID of the function library this table function belongs to |
FUNCTION_LIBRARY_NAME |
VARCHAR2(255) |
Physical name of the function library |
FUNCTION_ID |
NUMBER(9) |
ID of this table function |
FUNCTION_NAME |
VARCHAR2(255) |
Physical name of this table function |
FUNCTION_TYPE |
VARCHAR2(13) |
Type of this table function (constant value: Table Function) |
SIGNATURE |
VARCHAR2(4000) |
Signature of this table function |
IS_VALID |
VARCHAR2(13) |
Is this table function valid |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this table function |
DESCRIPTION |
VARCHAR2(4000) |
Description of this table function |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-80 ALL_IV_FUNCTION_IMPLS
Column Name | Data Type | Description |
---|---|---|
FUNCTION_ID |
NUMBER(9) |
ID of the function |
FUNCTION_NAME |
VARCHAR2(255) |
Physical name of the function |
FUNCTION_IMPLEMENTATION_ID |
NUMBER(9) |
ID of the function implementation for this function |
FUNCTION_IMPLEMENTATION_NAME |
VARCHAR2(255) |
Physical name of the function implementation |
LANGUAGE |
VARCHAR2(255) |
Name of the language being used in the implementation |
SCRIPT |
VARCHAR2(4000) |
Implementation script for this function |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name for this implementation |
DESCRIPTION |
VARCHAR2(4000) |
Description for this implementation |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-81 ALL_IV_OBJECT_CONFIGURATIONS
Column Name | Data Type | Description |
---|---|---|
CONFIGURED_OBJECT_ID |
NUMBER(9) |
ID of the object being configured |
CONFIGURED_OBJECT_NAME |
VARCHAR2(255) |
Physical name of the object |
CONFIGURED_OBJECT_TYPE |
VARCHAR2(4000) |
Type of the object |
CONFIGURATION_PARAMETER_KEY |
VARCHAR2(128) |
Key of configuration parameter |
CONFIGURATION_PARAMETER_NAME |
VARCHAR2(64) |
Name of configuration parameter |
PARAMETER_NLSKEY |
VARCHAR2(64) |
National Language Support (NLS) key of the parameter |
CONFIGURATION_PARAMETER_TYPE |
CHAR(23) |
Type of the configuration parameter |
ARGUMENT |
VARCHAR2(128) |
Value of the configuration parameter |
GROUP_NAME |
VARCHAR2(322) |
Name of the configuration group |
GROUP_NLSKEY |
VARCHAR2(64) |
National Language Support (NLS) key of the configuration group |
LANGUAGE |
VARCHAR2(64) |
Name of the language being used for this configuration |
Table 2-82 ALL_IV_CONFIGURATIONS
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
CONFIGURATION_ID |
NUMBER(9) |
ID of the configuration |
CONFIGURATION_NAME |
VARCHAR2(255) |
Name of the configuration |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-83 ALL_IV_CONFIG_TEMPLATES
Column Name | Datatype | Description |
---|---|---|
CONFIG_TEMPLATE_ID |
NUMBER (9) |
ID of the configuration template |
CONFIG_TEMPLATE_NAME |
VARCHAR2 (1000) |
Name of the configuration template |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the configuration template |
DESCRIPTION |
VARCHAR2(4000) |
Description of the configuration template |
OVERRIDE_MODEL |
VARCHAR2(40) |
Override model |
OVERRIDE_MODEL_ID |
NUMBER(9) |
Override model ID |
CONFIG_TEMPLATE_SET |
VARCHAR2(1000) |
Config template set |
CONFIG_TEMPLATE_SET_ID |
NUMBER(9) |
Config template set ID |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-84 ALL_IV_CONFIG_TEMPLATE_SETS
Column Name | Datatype | Description |
---|---|---|
CONFIG_TEMPLATE_SET_ID |
NUMBER (9) |
ID of the configuration template set |
CONFIG_TEMPLATE_SET_NAME |
VARCHAR2 (1000) |
Name of the configuration template set |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the configuration template set |
DESCRIPTION |
VARCHAR2 (4000) |
Description |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-85 ALL_IV_CONTROL_CENTERS
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
CONTROL_CENTER_ID |
NUMBER(9) |
ID of the control center |
CONTROL_CENTER_NAME |
VARCHAR2(255) |
Name of the control center |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the control center |
DESCRIPTION |
VARCHAR2(4000) |
Description of the control center |
HOST |
VARCHAR2(255) |
Host of the control center |
SERVICE_NAME |
VARCHAR2(4000) |
Service name of the control center |
PORT |
NUMBER |
Port of the control center |
USERNAME |
VARCHAR2(4000) |
User name who will connect to the control center |
SCHEMA |
VARCHAR2(40) |
Schema for the control center |
IS_VALID |
VARCHAR2(13) |
The result of the last validation performed against the control center |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
LOCATION_ID |
NUMBER(9) |
ID of the location owning this connector |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of the location |
CONNECTOR_ID |
NUMBER(9) |
ID of this connector |
CONNECTOR_NAME |
VARCHAR2(255) |
Physical name of this connector |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this connector |
DESCRIPTION |
VARCHAR2(4000) |
Description of this connector |
REFERENCED_LOCATION_ID |
NUMBER(9) |
ID of the location this connector references to |
REFERENCED_LOCATION_NAME |
VARCHAR2(255) |
Physical name of the location this connector references to |
IS_VALID |
VARCHAR2(13) |
Is this connector valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project this location belongs to |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
LOCATION_ID |
NUMBER(9) |
ID of this location |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of this location |
LOCATION_TARGET_TYPE |
VARCHAR2(40) |
Target type of this location |
LOCATION_TARGET_VERSION |
VARCHAR2(40) |
Target version of this location |
APPLICATION_TYPE |
VARCHAR2(255) |
Application type of the location connected to |
SYSTEM_TYPE |
VARCHAR2(255) |
System type of this location connected to |
IS_VALID |
VARCHAR2(13) |
Is this location valid |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this location |
DESCRIPTION |
VARCHAR2(4000) |
Description of this location |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-88 ALL_IV_RUNTIME_REPOSITORIES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project this repository belongs to (also called runtime location, or simply, location) |
PROJECT_NAME |
VARCHAR2(255) |
Physical name of the project |
LOCATION_ID |
NUMBER(9) |
ID of this runtime location |
LOCATION_NAME |
VARCHAR2(255) |
Physical name of this runtime location |
LOCATION_TYPE |
VARCHAR2(255) |
Type of this runtime location |
APPLICATION_TYPE |
VARCHAR2(255) |
Type of the application this location connected to |
SYSTEM_TYPE |
VARCHAR2(255) |
Type of the system this location connected to |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this runtime location |
DESCRIPTION |
VARCHAR2(4000) |
Description of this runtime location |
HOST |
VARCHAR2(40) |
Host name of the connection for this location |
SERVICE_NAME |
VARCHAR2(40) |
Service name of the connection for this location |
PORT |
NUMBER(9) |
Port of the connection for this location |
USERNAME |
VARCHAR2(40) |
User name of the connection for this location |
SCHEMA |
VARCHAR2(40) |
Schema name of the connection for this location |
IS_VALID |
VARCHAR2(13) |
Is this runtime location valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the module this map belongs to |
INFORMATION_SYSTEM_NAME |
VARCHAR2(255) |
Physical name of the module |
MAP_ID |
NUMBER(9) |
ID of this map |
MAP_NAME |
VARCHAR2(255) |
Physical name of this map |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this map |
DESCRIPTION |
VARCHAR2(4000) |
Description of this map |
COMPOSITE_MAP_COMPONENT_ID |
NUMBER(9) |
Same as MAP_ID |
COMPOSITE_MAP_COMPONENT_NAME |
VARCHAR2(255) |
Same as MAP_NAME |
IS_VALID |
VARCHAR2(13) |
Is this map valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-90 ALL_IV_XFORM_MAP_COMPONENTS
Column Name | Data Type | Description |
---|---|---|
MAP_ID |
NUMBER(9) |
ID of the map this map component belongs to |
MAP_NAME |
VARCHAR2(255) |
Physical name of the map |
MAP_COMPONENT_ID |
NUMBER(9) |
ID of this map component (also called map operator) |
MAP_COMPONENT_NAME |
VARCHAR2(255) |
Physical name of this map component |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this map component |
DESCRIPTION |
VARCHAR2(4000) |
Description of this map component |
OPERATOR_TYPE |
VARCHAR2(4000) |
Type of this map component (for example, Filter, Joiner, Table) |
COMPOSITE_MAP_COMPONENT_ID |
NUMBER(9) |
Same as MAP_COMPONENT_ID |
COMPOSITE_MAP_COMPONENT_NAME |
VARCHAR2(255) |
Same as MAP_COMPONENT_NAME |
DATA_ENTITY_ID |
NUMBER(9) |
ID of the data entity this map component synchronized to |
DATA_ENTITY_NAME |
VARCHAR2(255) |
Physical name of the data entity |
DATA_ENTITY_TYPE |
VARCHAR2(4000) |
Type of the data entity |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-91 ALL_IV_XFORM_MAP_PARAMETERS
Column Name | Data Type | Description |
---|---|---|
MAP_COMPONENT_ID |
NUMBER(9) |
ID of the map component this parameter belongs to |
MAP_COMPONENT_NAME |
VARCHAR2(255) |
Physical name of the map component |
PARAMETER_ID |
NUMBER(9) |
ID of this parameter |
PARAMETER_NAME |
VARCHAR2(255) |
Physical name of this parameter |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this parameter |
DESCRIPTION |
VARCHAR2(4000) |
Description of this parameter |
MAP_ID |
NUMBER(9) |
ID of the map containing the map component |
MAP_NAME |
VARCHAR2(255) |
Physical name of the map |
PARAMETER_GROUP_NAME |
VARCHAR2(255) |
Physical name of the parameter group name |
PARAMETER_GROUP_ID |
NUMBER(9) |
ID of the parameter group |
PARAMETER_TYPE |
VARCHAR2(5) |
Type of the parameter (IN, OUT, INOUT) |
POSITION |
NUMBER(9) |
Position of the parameter within the group |
DATA_TYPE |
VARCHAR2(40) |
Data type of the parameter |
TRANSFORMATION_EXPRESSION |
VARCHAR2(4000) |
Textual expression of the transformation for this parameter |
DATA_ITEM_ID |
NUMBER(9) |
ID of the data item this parameter synchronized to |
DATA_ITEM_TYPE |
VARCHAR2(40) |
Type of the data item |
DATA_ITEM_NAME |
VARCHAR2(255) |
Physical name of the data item |
SOURCE_PARAMETER_ID |
NUMBER(9) |
ID of the source parameter (where this parameter connected from) |
SOURCE_PARAMETER_NAME |
VARCHAR2(255) |
Physical name of the source parameter |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-92 ALL_IV_XFORM_MAP_PROPERTIES
Column Name | Data Type | Description |
---|---|---|
MAP_COMPONENT_ID |
NUMBER(9) |
ID of the map component this property belongs to |
MAP_COMPONENT_NAME |
VARCHAR2(255) |
Physical name of the map component |
PROPERTY_ID |
NUMBER(9) |
ID of this property |
PROPERTY_NAME |
VARCHAR2(255) |
Physical name of this property |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this property |
DESCRIPTION |
VARCHAR2(4000) |
Description of this property |
PROPERTY_GROUP_NAME |
VARCHAR2(255) |
Physical name of this property group |
PROPERTY_VALUE |
VARCHAR2(4000) |
Value of this property |
Table 2-93 ALL_IV_XFORM_MAP_DETAILS
Column Name | Data Type | Description |
---|---|---|
MAP_COMPONENT_ID |
NUMBER(9) |
ID of the map component |
MAP_COMPONENT_NAME |
VARCHAR2(255) |
Name of the map component |
PARAMETER_NAME |
VARCHAR2(255) |
Name of the parameter |
PARAMETER_ID |
NUMBER(9) |
ID of the parameter |
POSITION |
NUMBER(9) |
Position |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of map component |
TRANSFORMATION_EXPRESSION |
VARCHAR2(4000) |
Transformation expression |
DESCRIPTION |
VARCHAR2(4000) |
Description of map component |
SOURCE_EXPRESSION |
VARCHAR2(4000) |
Source expression |
Table 2-94 ALL_IV_PLUGGABLE_MAPS
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
MAP_LIBRARY_ID |
NUMBER |
ID of the map library |
MAP_LIBRARY_NAME |
VARCHAR2(255) |
Name of the map library |
MAP_ID |
NUMBER(9) |
ID of the map |
MAP_NAME |
VARCHAR2(255) |
Name of the map |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the map |
DESCRIPTION |
VARCHAR2(4000) |
Description of the map |
IS_VALID |
VARCHAR2(13) |
Is the map valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-95 ALL_IV_PLUGGABLE_MAP_LIBRARIES
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
MAP_LIBRARY_ID |
NUMBER(9) |
ID of the map library |
MAP_LIBRARY_NAME |
VARCHAR2(255) |
Name of the map library |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the map library |
DESCRIPTION |
VARCHAR2(4000) |
Description of the map library |
IS_VALID |
VARCHAR2(13) |
Is the library valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-96 ALL_IV_PLUG_MAP_PARAMETERS
Column Name | Data Type | Description |
---|---|---|
MAP_COMPONENT_ID |
NUMBER(9) |
ID of the map component |
MAP_COMPONENT_NAME |
VARCHAR2(255) |
Name of the map component |
PARAMETER_ID |
NUMBER(9) |
ID of the parameter |
PARAMETER_NAME |
VARCHAR2(255) |
Name of the parameter |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the parameter |
DESCRIPTION |
VARCHAR2(4000) |
Description of the parameter |
MAP_ID |
NUMBER(9) |
ID of the map |
MAP_NAME |
VARCHAR2(255) |
Name of the map |
PARAMETER_GROUP_NAME |
VARCHAR2(255) |
Name of the parameter group |
PARAMETER_GROUP_ID |
NUMBER(9) |
ID of the parameter group |
PARAMETER_TYPE |
VARCHAR2(5) |
Type of the parameter |
POSITION |
NUMBER(9) |
The position of the parameter |
DATA_TYPE |
VARCHAR2(4000) |
The data type of the parameter |
TRANSFORMATION_EXPRESSION |
VARCHAR2(4000) |
The expression of the parameter |
DATA_ITEM_ID |
NUMBER(9) |
ID of the data item |
DATA_ITEM_TYPE |
VARCHAR2 |
Type of the data item |
DATA_ITEM_NAME |
VARCHAR2(255) |
Name of the data item |
SOURCE_PARAMETER_ID |
NUMBER(9) |
The ID of the parameter where this parameter is connected from |
SOURCE_PARAMETER_NAME |
VARCHAR2(255) |
The name of the parameter where this parameter is connected from |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-97 ALL_IV_PLUG_MAP_COMPONENTS
Column Name | Data Type | Description |
---|---|---|
MAP_ID |
NUMBER(9) |
ID of the map |
MAP_NAME |
VARCHAR2(255) |
Name of the map |
MAP_COMPONENT_ID |
NUMBER(9) |
ID of the map component |
MAP_COMPONENT_NAME |
VARCHAR2(255) |
Name of the map component |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the map component |
DESCRIPTION |
VARCHAR2(4000) |
Description of the map component |
OPERATOR_TYPE |
VARCHAR2(4000) |
The operator type of the map component |
COMPOSITE_COMPONENT_ID |
NUMBER(9) |
ID of the map component |
COMPOSITE_COMPONENT_NAME |
VARCHAR2(255) |
Name of the map component |
DATA_ENTITY_ID |
NUMBER(9) |
ID of the data entity |
DATA_ENTITY_TYPE |
VARCHAR2(4000) |
Type of data entity |
DATA_ENTITY_NAME |
VARCHAR2(255) |
Name of the data entity |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the module this process package belongs to |
SCHEMA_NAME |
VARCHAR2(255) |
Physical name of the module |
PACKAGE_ID |
NUMBER(9) |
ID of this process package |
PACKAGE_NAME |
VARCHAR2(255) |
Physical name of this process package |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this process package |
DESCRIPTION |
VARCHAR2(4000) |
Description of this process package |
IS_VALID |
VARCHAR2(13) |
Is this process package valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
PACKAGE_ID |
NUMBER(9) |
ID of the process package this process belongs to |
PACKAGE_NAME |
VARCHAR2(255) |
Physical name of the process package |
PARENT_PROCESS_ID |
NUMBER(9) |
ID of the parent process for this process |
PARENT_PROCESS_NAME |
VARCHAR2(255) |
Physical name of the parent process for this process |
PROCESS_ID |
NUMBER(9) |
ID of this process |
PROCESS_NAME |
VARCHAR2(255) |
Physical name of this process |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this process |
DESCRIPTION |
VARCHAR2(4000) |
Description of this process |
BOUND_OBJECT_ID |
NUMBER(9) |
ID of the bound object |
BOUND_OBJECT_NAME |
VARCHAR2(255) |
Name of the bound object |
IS_VALID |
VARCHAR2(13) |
Is this process valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-100 ALL_IV_PROCESS_ACTIVITIES
Column Name | Data Type | Description |
---|---|---|
PROCESS_ID |
NUMBER(9) |
ID of the process this activity belongs to |
PROCESS_NAME |
VARCHAR2(255) |
Physical name of the process |
ACTIVITY_ID |
NUMBER(9) |
ID of this process activity |
ACTIVITY_NAME |
VARCHAR2(255) |
Physical name of this activity |
ACTIVITY_TYPE |
VARCHAR2(4000) |
Type of this activity |
BOUND_OBJECT_ID |
NUMBER(9) |
ID of the bound object |
BOUND_OBJECT_NAME |
VARCHAR2(255) |
Name of the bound object |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-101 ALL_IV_PROCESS_PARAMETERS
Column Name | Data Type | Description |
---|---|---|
PARAMETER_OWNER_ID |
NUMBER(9) |
ID of the owning object for this parameter |
PARAMETER_OWNER_NAME |
VARCHAR2(255) |
Physical name of the owning object for this parameter |
PARAMETER_OWNER_TYPE |
CHAR(14) |
Type of the owning object |
PARAMETER_ID |
NUMBER(9) |
ID of this parameter |
PARAMETER_NAME |
VARCHAR2(255) |
Physical name of this parameter |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this parameter |
DESCRIPTION |
VARCHAR2(4000) |
Description of this parameter |
POSITION |
NUMBER(9) |
Position of this parameter |
DATA_TYPE |
VARCHAR2(40) |
Data type of this parameter |
DEFAULT_VALUE |
VARCHAR2(4000) |
Default value for this parameter |
DIRECTION |
VARCHAR2(3) |
Direction of this parameter (IN, OUT) |
IS_FINAL |
CHAR(1) |
Is process final |
BOUNDDATA_ID |
NUMBER(9) |
ID of the bound data for this parameter |
BOUNDDATA_NAME |
VARCHAR2(255) |
Physical name of the bound data |
BOUNDDATA_TYPE |
VARCHAR2(40) |
Type of the bound data |
BOUNDDATA_VALUE |
VARCHAR2(4000) |
Value of the bound data |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-102 ALL_IV_PROCESS_TRANSITIONS
Column Name | Data Type | Description |
---|---|---|
PROCESS_ID |
NUMBER(9) |
ID of the process this transition belongs to |
PROCESS_NAME |
VARCHAR2(255) |
Physical name of the process |
TRANSITION_ID |
NUMBER(9) |
ID of this transition |
TRANSITION_NAME |
VARCHAR2(255) |
Physical name of this transition |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this transition |
DESCRIPTION |
VARCHAR2(4000) |
Description of this transition |
CONDITION |
VARCHAR2(255) |
Condition of this transition |
TRANSITION_ORDER |
NUMBER(9) |
Order of this transition |
SOURCE_ACTIVITY_ID |
NUMBER(9) |
ID of the source activity for this transition |
SOURCE_ACTIVITY_NAME |
VARCHAR2(255) |
Physical name of the source activity |
TARGET_ACTIVITY_ID |
NUMBER(9) |
ID of the target activity for this transition |
TARGET_ACTIVITY_NAME |
VARCHAR2(255) |
Physical name of the target activity |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-103 ALL_IV_PROCESS_VARIABLES
Column Name | Data Type | Description |
---|---|---|
PROCESS_ID |
NUMBER(9) |
ID of the process this variable belongs to |
PROCESS_NAME |
VARCHAR2(255) |
Physical name of the process |
VARIABLE_ID |
NUMBER(9) |
ID of this process variable |
VARIABLE_NAME |
VARCHAR2(255) |
Physical name of this process variable |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name of this process variable |
DESCRIPTION |
VARCHAR2(4000) |
Description of this process variable |
POSITION |
NUMBER(9) |
Position of this variable |
DATA_TYPE |
VARCHAR2(40) |
Data type of this variable |
DEFAULT_VALUE |
VARCHAR2(4000) |
Default value of this variable |
IS_FINAL |
CHAR(1) |
Is process final |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(255) |
Updated by user |
CREATED_BY |
VARCHAR2(255) |
Created by user |
Table 2-104 ALL_IV_SUB_PROCESSES
Column Name | Data Type | Description |
---|---|---|
PACKAGE_ID |
NUMBER(9) |
ID of the package |
PACKAGE_NAME |
VARCHAR2(255) |
Name of the package |
PARENT_PROCESS_ID |
NUMBER(9) |
ID of the parent process |
PARENT_PROCESS_NAME |
VARCHAR2(255) |
Name of the parent process |
PROCESS_ID |
NUMBER(9) |
ID of the process |
PROCESS_NAME |
VARCHAR2(255) |
Name of the process |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the condition |
DESCRIPTION |
VARCHAR2(4000) |
Description of the condition |
BOUND_OBJECT_ID |
NUMBER(9) |
ID of the bound object |
BOUND_OBJECT_NAME |
VARCHAR2(40) |
Name of the bound object |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
PROFILE_ID |
NUMBER(9) |
ID of the profile |
PROFILE_NAME |
VARCHAR2(255) |
Name of the profile |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the profile |
DESCRIPTION |
VARCHAR2(4000) |
Description of the profile |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-106 ALL_IV_PROFILE_COLUMNS
Column Name | Data Type | Description |
---|---|---|
PROFILE_ID |
NUMBER(9) |
ID of the profile |
PROFILE_NAME |
VARCHAR2(255) |
Name of the profile |
PROFILE_OBJECT_ID |
NUMBER(9) |
ID of the profile object |
ENTITY_ID |
NUMBER(9) |
ID of the entity |
ENTITY_NAME |
VARCHAR2(255) |
Name of the entity |
PROFILE_COLUMN_ID |
NUMBER(9) |
ID of the profile column |
COLUMN_ID |
NUMBER(9) |
ID of the column |
COLUMN_NAME |
VARCHAR2(255) |
Name of the column |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of column |
AVG_VALUE |
VARCHAR2(40) |
Average value of column if column has a numeric data type |
MAX_VALUE |
VARCHAR2(4000) |
Maximum value stored in the column |
MIN_VALUE |
VARCHAR2(4000) |
Minimum value stored in the column |
MEDIAN_VALUE |
VARCHAR2(4000) |
Median value of column if column has a numeric data type |
STDDEV_VALUE |
VARCHAR2(40) |
Standard deviation of column if column has a numeric data type |
NUM_NULLS |
NUMBER |
Number of null values stored in the column |
NUM_DISTINCT |
NUMBER |
Number of distinct values stored in the column |
CONSENSUS_DATATYPE |
VARCHAR2(40) |
The discovered data type for the column |
CONSENSUS_DATATYPE_CNT |
VARCHAR2(40) |
The number of rows that have the consensus data type |
CONSENSUS_LENGTH |
NUMBER |
The predominant length of the column |
CONSENSUS_LENGTH_CNT |
NUMBER |
The number of rows with the predominant length |
CONSENSUS_PRECISION |
NUMBER |
The predominant precision of the column |
CONSENSUS_PRECISION_CNT |
NUMBER |
The number of rows with the predominant precision |
CONSENSUS_SCALE |
NUMBER |
The predominant scale of the column |
CONSENSUS_SCALE_CNT |
NUMBER |
The number of rows with the predominant scale |
COMMON_FORMAT |
VARCHAR2(40) |
The discovered common format |
COMMON_FORMAT_CNT |
VARCHAR2(40) |
The number of rows that have this discovered common format |
DOMINANT_CHARACTER_PATTERN |
VARCHAR2(4000) |
The discovered pattern at the character level of the column |
DOMINANT_CHARACTER_PATTERN_CNT |
VARCHAR2(40) |
The number of rows that satisfy the character level pattern |
DOMINANT_WORD_PATTERN |
VARCHAR2(4000) |
The discovered pattern at the word level of the column |
DOMINANT_WORD_PATTERN_CNT |
VARCHAR2(40) |
The number of rows that satisfy the word level pattern |
MAX_LENGTH |
NUMBER |
Maximum length of the values stored in the column |
MIN_LENGTH |
NUMBER |
Minimum length of the values stored in the column |
MAX_PRECISION |
NUMBER |
Maximum precision of the values stored in the column |
MIN_PRECISION |
NUMBER |
Minimum precision of the values stored in the column |
MAX_SCALE |
NUMBER |
Maximum scale of the values stored in the column |
MIN_SCALE |
NUMBER |
Minimum scale of the values stored in the column |
CFORMAT_COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that satisfy the discovered common format |
CFORMAT_DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row satisfies the discovered common format and which does not |
CFORMAT_NONCOMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy the discovered common format |
DATATYPE_COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that satisfy the discovered data type |
DATATYPE_DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row satisfies the discovered data type and which does not |
DATATYPE_NONCOMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy the discovered data type |
DOMAIN_COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that contain the discovered domain values |
DOMAIN_DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row contains the discovered domain values and which does not |
DOMAIN_NONCOMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not contain the discovered domain values |
NULL_COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that are null based on the configured null value |
NULL_DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row is null and which isn't based on the configured null value |
NULL_NONCOMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy the discovered common format |
CHAR_PATTERN_COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that satisfy the discovered character pattern |
CHAR_PATTERN_DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row satisfies the discovered character pattern and which does not |
CHAR_PATTERN_NONCOM_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy the discovered character pattern |
WORD_PATTERN_COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that satisfy the discovered word pattern |
WORD_PATTERN_DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row satisfies the discovered word pattern and which does not |
WORD_PATTERN_NONCOM_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy the discovered word pattern |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-107 ALL_IV_PROFILE_DOMAIN_VALUES
Column Name | Data Type | Description |
---|---|---|
PROFILE_OBJECT_ID |
NUMBER(9) |
ID of the profile object |
PROFILE_COLUMN_ID |
NUMBER(9) |
ID of the profile column |
COLUMN_NAME |
VARCHAR2(255) |
Name of the column |
VALUE |
VARCHAR2(4000) |
Domain value |
VALUE_COUNT |
VARCHAR2(4000) |
Number of rows that have this domain value |
COMPLIANT |
VARCHAR2(1) |
Whether this domain value satisfies the domain value configuration |
Table 2-108 ALL_IV_FUNCTIONAL_DEPENDENCIES
Column Name | Data Type | Description |
---|---|---|
PROFILE_ID |
NUMBER(9) |
ID of the profile |
PROFILE_NAME |
VARCHAR2(255) |
Name of the profile |
ENTITY_ID |
NUMBER(9) |
ID of the entity |
ENTITY_NAME |
VARCHAR2(255) |
Name of the entity |
FUNCTIONAL_DEPENDENCY_ID |
NUMBER(9) |
ID of the functional dependency |
FUNCTIONAL_DEPENDENCY_NAME |
VARCHAR2(255) |
Name of the functional dependency |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the functional dependency |
TYPE |
VARCHAR2(15) |
Type of functional dependency |
DEPENDENT_COLUMN_ID |
NUMBER(9) |
ID of the dependent column in the functional dependency |
FD_ERROR |
NUMBER |
The number of rows that do not satisfy this functional dependency |
COMPLIANT_QUERY |
VARCHAR2(4000) |
The query that is used to retrieve the rows that satisfy this functional dependency |
COMPLIANT_CNT_QUERY |
VARCHAR2(4000) |
Not used |
NONCOMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy this functional dependency |
NONCOMPLIANT_CNT_QUERY |
VARCHAR2(4000) |
Not used |
DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row satisfies this functional dependency and which does not |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-109 ALL_IV_PROFILE_FOREIGN_KEYS
Column Name | Data Type | Description |
---|---|---|
PROFILE_ID |
NUMBER(9) |
ID of the profile |
PROFILE_NAME |
VARCHAR2(255) |
Name of the profile |
ENTITY_ID |
NUMBER(9) |
ID of the entity |
ENTITY_NAME |
VARCHAR2(255) |
Name of the entity |
FOREIGN_KEY_ID |
NUMBER(9) |
ID of the row relationship |
FOREIGN_KEY_NAME |
VARCHAR2(255) |
Name of the row relationship |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the foreign key |
UNIQUE_KEY_ID |
NUMBER(9) |
ID of the unique key |
IS_DISCOVERED |
VARCHAR2(3) |
Should a foreign key be created on the column |
IS_DOCUMENTED |
VARCHAR2(3) |
Indicates if a foreign key exists in the data dictionary for the column |
LOCAL_MAX_CARDINALITY |
VARCHAR2(40) |
Maximum number of values found on the local side |
LOCAL_MIN_CARDINALITY |
VARCHAR2(40) |
Minimum number of values found on the local side |
REMOTE_MAX_CARDINALITY |
VARCHAR2(40) |
Maximum number of values found on the remote side |
REMOTE_MIN_CARDINALITY |
VARCHAR2(40) |
Minimum number of values found on the remote side |
NUM_ORPHANS |
VARCHAR2(40) |
Number of distinct values found in the local column but not in the remote column |
COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that satisfy the discovered row relationship |
COMPLIANT_CNT_QUERY |
VARCHAR2(4000) |
Not used |
NONCOMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy the discovered common format |
NONCOMPLIANT_CNT_QUERY |
VARCHAR2(4000) |
Not used |
DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row satisfies the discovered row relationship and which does not |
CHILDLESS_QUERY |
VARCHAR2(4000) |
Not used |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-110 ALL_IV_PROFILE_KEY_COLUMN_USES
Column Name | Data Type | Description |
---|---|---|
KEY_ID |
NUMBER(9) |
ID of the key |
KEY_TYPE |
VARCHAR2(4000) |
Type of the key |
KEY_NAME |
VARCHAR2(255) |
Name of the key |
COLUMN_ID |
NUMBER(9) |
ID of the column |
COLUMN_NAME |
VARCHAR2(255) |
Physical name of the column |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the column |
POSITION |
NUMBER(9) |
Position of the column in the set |
Table 2-111 ALL_IV_PROFILE_OBJECTS
Column Name | Data Type | Description |
---|---|---|
PROFILE_ID |
NUMBER(9) |
ID of the profile |
PROFILE_NAME |
VARCHAR2(255) |
Name of the profile |
PROFILE_OBJECT_ID |
NUMBER(9) |
ID of the profile object |
OBJECT_ID |
NUMBER(9) |
ID of the object |
PROFILE_OBJECT_NAME |
VARCHAR2(255) |
Name of the profile object |
OBJECT_NAME |
VARCHAR2(255) |
Physical name of the object |
OBJECT_TYPE |
VARCHAR2(4000) |
Type of the object |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the object |
DESCRIPTION |
VARCHAR2(4000) |
Description of the profile object |
IS_VALID |
VARCHAR2(13) |
Is the profile object valid |
ROW_COUNT |
NUMBER |
Number of rows in the object |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-112 ALL_IV_PROFILE_PATTERN_VALUES
Column Name | Data Type | Description |
---|---|---|
PROFILE_OBJECT_ID |
NUMBER(9) |
ID of the profile object |
PROFILE_COLUMN_ID |
NUMBER(9) |
ID of the profile column |
COLUMN_NAME |
VARCHAR2(255) |
Name of the column |
VALUE |
VARCHAR2(4000) |
Pattern value |
VALUE_COUNT |
VARCHAR2(4000) |
The number of rows that satisfy this discovered pattern value |
TYPE |
VARCHAR2(9) |
0 for Word Pattern, 1 for Character Pattern |
COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy this pattern value |
NONCOMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy this pattern value |
DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row satisfies this pattern value and which does not |
Table 2-113 ALL_IV_PROFILE_RULES
Column Name | Data Type | Description |
---|---|---|
PROFILE_OBJECT_ID |
NUMBER(9) |
ID of the profile object |
DATA_RULE_USAGE_ID |
NUMBER(9) |
ID of the data rule usage |
DATA_RULE_USAGE_NAME |
VARCHAR2(255) |
Name of the data rule usage |
COMPLIANT_ROW_COUNT |
VARCHAR2(4000) |
The number of rows that comply with the data rule |
Table 2-114 ALL_IV_PROFILE_UNIQUE_KEYS
Column Name | Data Type | Description |
---|---|---|
PROFILE_ID |
NUMBER(9) |
ID of the profile |
PROFILE_NAME |
VARCHAR2(255) |
Name of the profile |
ENTITY_ID |
NUMBER(9) |
ID of the entity |
ENTITY_NAME |
VARCHAR2(255) |
Name of the entity |
UNIQUE_KEY_ID |
NUMBER(9) |
ID of the unique key |
UNIQUE_KEY_NAME |
VARCHAR2(255) |
Name of the unique key |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the unique key |
IS_DISCOVERED |
VARCHAR2(3) |
Should a unique key be created on the column |
IS_DOCUMENTED |
VARCHAR2(3) |
Indicates if a unique key exists on the column in the data dictionary |
UK_ERROR |
VARCHAR2(40) |
Number of rows that do not satisfy this unique key |
UK_PARTITION |
VARCHAR2(40) |
Not used |
COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that satisfy this unique key |
COMPLIANT_CNT_QUERY |
VARCHAR2(4000) |
Not used |
NONCOMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy this unique key |
NONCOMPLIANT_CNT_QUERY |
VARCHAR2(4000) |
Not used |
DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row satisfies this unique key and which does not |
CHILDLESS_QUERY |
VARCHAR2(4000) |
Not used |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
DATARULE_ID |
NUMBER(9) |
ID of the data rule |
DATARULE_NAME |
VARCHAR2(255) |
Physical name of the data rule |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the data rule |
DATARULE_TYPE |
VARCHAR2(4000) |
Type of data rule |
DESCRIPTION |
VARCHAR2(4000) |
Description of the data rule |
IS_VALID |
VARCHAR2(13) |
Not used |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-116 ALL_IV_DATA_RULE_ATTRIBUTES
Column Name | Data Type | Description |
---|---|---|
DATARULE_ID |
NUMBER(9) |
ID of the data rule |
DATARULE_NAME |
VARCHAR2(255) |
Name of the data rule |
DATARULEGROUP_ID |
NUMBER(9) |
ID of the owning data rule group |
DATARULEGROUP_NAME |
VARCHAR2(255) |
Name of the owning data rule group |
DATARULEATTR_ID |
NUMBER(9) |
ID of the data rule attribute |
NAME |
VARCHAR2(255) |
Name of the data rule attribute |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of data rule attribute |
DESCRIPTION |
VARCHAR2(4000) |
Description of data rule attribute |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-117 ALL_IV_DATA_RULE_ATTR_USAGES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
RELATION_ID |
NUMBER(9) |
ID of owning relation |
RELATION_NAME |
VARCHAR2(255) |
Name of owning relation |
DATARULE_USAGE_ID |
NUMBER(9) |
ID of owning data rule usage |
DATARULE_USAGE_NAME |
VARCHAR2(255) |
Name of owning data rule usage |
DATARULE_GROUP_USAGE_ID |
NUMBER(9) |
ID of owning data rule usage group |
DATARULE_GROUP_USAGE_NAME |
VARCHAR2(255) |
Name of owning data rule usage group |
DATARULE_ATTR_USAGE_ID |
NUMBER(9) |
ID of data rule attribute usage |
NAME |
VARCHAR2(255) |
Name of data rule attribute usage |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of data rule attribute usage |
DESCRIPTION |
VARCHAR2(4000) |
Description of data rule attribute usage |
DATARULE_SCHEMA_ID |
NUMBER(9) |
ID of data rule folder |
DATARULE_SCHEMA_NAME |
VARCHAR2(255) |
Name of data rule folder |
DATARULE_ID |
NUMBER(9) |
ID of data rule |
DATARULE_NAME |
VARCHAR2(255) |
Name of data rule |
DATARULE_GROUP_ID |
NUMBER(9) |
ID of data rule group |
DATARULE_GROUP_NAME |
VARCHAR2(255) |
Name of data rule group |
DATARULE_ATTR_ID |
NUMBER(9) |
ID of data rule attribute |
DATARULE_ATTR_NAME |
VARCHAR2(255) |
Name of data rule attribute |
REFERENCED_SCHEMA |
NUMBER(9) |
ID of referenced schema of date rule usage group |
REFERENCE_SCHEMA_NAME |
VARCHAR2(255) |
Name of referenced schema of data rule usage group |
REFERENCED_RELATION_ID |
NUMBER(9) |
ID if referenced relation of data rule usage group |
REFERENCE_RELATION_NAME |
VARCHAR2(255) |
Name of referenced relation of data rule usage group |
ATTRIBUTE_ID |
NUMBER(9) |
ID of the attribute |
ATTRIBUTE_NAME |
VARCHAR2(255) |
Name of the attribute |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-118 ALL_IV_DATA_RULE_DOMAINS
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
DATARULE_ID |
NUMBER(9) |
ID of the data rule |
DATARULE_NAME |
VARCHAR2(255) |
Name of the data rule |
PROPERTY_ID |
NUMBER(9) |
ID of domain property |
NAME |
VARCHAR2(255) |
Value of domain property |
BUSINESS_NAME |
VARCHAR2(1000) |
Not used |
DESCRIPTION |
VARCHAR2(4000) |
Description of the data rule |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-119 ALL_IV_DATA_RULE_GROUPS
Column Name | Data Type | Description |
---|---|---|
DATARULE_ID |
NUMBER(9) |
ID of the data rule |
DATARULE_NAME |
VARCHAR2(255) |
Physical name of the data rule |
DATARULEGROUP_ID |
NUMBER(9) |
ID of data rule group |
DATARULEGROUP_NAME |
VARCHAR2(255) |
Name of data rule group |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of data rule group |
DESCRIPTION |
VARCHAR2(4000) |
Description of the data rule group |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-120 ALL_IV_DATA_RULE_GROUP_USAGES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
RELATION_ID |
NUMBER(9) |
ID of owning relation |
RELATION_NAME |
VARCHAR2(255) |
Name of owning relation |
DATARULE_USAGE_ID |
NUMBER(9) |
ID of data rule usage |
DATARULE_USAGE_NAME |
VARCHAR2(255) |
Name of data rule usage |
DATARULE_GROUP_USAGE_ID |
NUMBER(9) |
ID of data rule usage group |
NAME |
VARCHAR2(255) |
Name of data rule usage group |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of data rule usage group |
DESCRIPTION |
VARCHAR2(4000) |
Description of data rule usage group |
DATARULE_SCHEMA_ID |
NUMBER(9) |
ID of referenced data rule folder |
DATARULE_SCHEMA_NAME |
VARCHAR2(255) |
Name of referenced data rule folder |
DATARULE_ID |
NUMBER(9) |
ID of referenced data rule |
DATARULE_NAME |
VARCHAR2(255) |
Name of referenced data rule |
DATARULE_GROUP_ID |
NUMBER(9) |
ID of referenced data rule group |
DATARULE_GROUP_NAME |
VARCHAR2(255) |
Name of referenced data rule group |
REFERENCED_SCHEMA |
NUMBER(9) |
ID of referenced schema |
REFERENCE_SCHEMA_NAME |
VARCHAR2(255) |
Name of referenced schema |
REFERENCED_RELATION_ID |
NUMBER(9) |
ID of referenced relation |
REFERENCE_RELATION_NAME |
VARCHAR2(255) |
Name of referenced relation |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-121 ALL_IV_DATA_RULE_PROPERTIES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
DATARULE_ID |
NUMBER(9) |
ID of the data rule |
DATARULE_NAME |
VARCHAR2(255) |
Physical name of the data rule |
PROPERTY_ID |
NUMBER(9) |
ID of data rule property |
NAME |
VARCHAR2(255) |
Name of data rule property |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the data rule property |
VALUE |
VARCHAR2(4000) |
Value of data rule property |
DESCRIPTION |
VARCHAR2(4000) |
Description of the data rule property |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-122 ALL_IV_DATA_RULE_USAGES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the owning schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the owning schema |
RELATION_ID |
NUMBER(9) |
Owning relation of data rule usage |
RELATION_NAME |
VARCHAR2(255) |
Name of owning relation of data rule usage |
DATARULE_USAGE_ID |
NUMBER(9) |
ID of data rule usage |
NAME |
VARCHAR2(255) |
Name of data rule usage |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of data rule usage |
DESCRIPTION |
VARCHAR2(4000) |
Description of data rule usage |
DATARULE_SCHEMA_ID |
NUMBER(9) |
Referenced data rule folder ID |
DATARULE_SCHEMA_NAME |
VARCHAR2(255) |
Referenced data rule folder name |
DATARULE_ID |
NUMBER(9) |
Referenced data rule ID |
DATARULE_NAME |
VARCHAR2(255) |
Referenced data rule name |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
OWNER_ID |
NUMBER(9) |
ID of the owner |
OWNER_NAME |
VARCHAR2(255) |
Name of the owner |
FIRST_CLASS_OBJECT_ID |
NUMBER(9) |
ID of the First Class Object |
FIRST_CLASS_OBJECT_NAME |
VARCHAR2(255) |
Name of the First Class Object |
FIRST_CLASS_OBJECT_TYPE |
VARCHAR2(255) |
Type of the First Class Object |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the First Class Object |
DESCRIPTION |
VARCHAR2(4000) |
Description of the First Class Object |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-124 ALL_IV_UDO_FOLDERS
Column Name | Data Type | Description |
---|---|---|
OWNER_ID |
NUMBER(9) |
ID of the owner |
OWNER_NAME |
VARCHAR2(255) |
Name of the owner |
FOLDER_ID |
NUMBER(9) |
ID of the folder |
FOLDER_NAME |
VARCHAR2(255) |
Name of the folder |
FOLDER_TYPE |
VARCHAR2(255) |
Type of folder |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the folder |
DESCRIPTION |
VARCHAR2(4000) |
Description of the folder |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
OWNER_ID |
NUMBER(9) |
ID of the owner |
OWNER_NAME |
VARCHAR2(255) |
Name of the owner |
SECOND_CLASS_OBJECT_ID |
NUMBER(9) |
ID of the Second Class Object |
SECOND_CLASS_OBJECT_NAME |
VARCHAR2(255) |
Name of the Second Class Object |
SECOND_CLASS_OBJECT_TYPE |
VARCHAR2(255) |
Type of Second Class Object |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the Second Class Object |
DESCRIPTION |
VARCHAR2(4000) |
Description of the Second Class Object |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-126 ALL_IV_UDO_ASSOCIATIONS
Column Name | Data Type | Description |
---|---|---|
OWNER_ID |
NUMBER(9) |
ID of the owner |
OWNER_NAME |
VARCHAR2(255) |
Name of the owner |
OWNER_TYPE |
VARCHAR2(255) |
Type of the owner |
ASSOCIATION_ID |
NUMBER(9) |
ID of the association |
SOURCE_ROLE |
VARCHAR2(255) |
Role of the owner |
TARGET_ROLE |
VARCHAR2(255) |
Role of the associated object |
TARGET_ID |
NUMBER(9) |
ID of the target |
TARGET_NAME |
VARCHAR2(255) |
Name of the target |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
EXPERT_ID |
NUMBER(9) |
ID of the expert |
EXPERT_NAME |
VARCHAR2(255) |
Name of the expert |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the expert |
DESCRIPTION |
VARCHAR2(4000) |
Description of the expert |
BOUND_OBJECT_ID |
NUMBER(9) |
ID of the bound object |
BOUND_OBJECT_NAME |
VARCHAR2(40) |
Name of the bound object |
IS_VALID |
VARCHAR2(13) |
Is this expert valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-128 ALL_IV_EXPERT_PARAMETERS
Column Name | Data Type | Description |
---|---|---|
PARAMETER_OWNER_ID |
NUMBER(9) |
ID of the parameter owner |
PARAMETER_OWNER_NAME |
VARCHAR2(255) |
Name of the parameter owner |
PARAMETER_OWNER_TYPE |
VARCHAR2(6) |
Type of the parameter owner |
PARAMETER_ID |
NUMBER(9) |
ID of the parameter |
PARAMETER_NAME |
VARCHAR2(255) |
Name of the parameter |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the parameter |
DESCRIPTION |
VARCHAR2(4000) |
Description of the parameter |
POSITION |
NUMBER(9) |
The position of the parameter |
DATA_TYPE |
VARCHAR2(40) |
Data type for this parameter |
DEFAULT_VALUE |
VARCHAR2(4000) |
Default value |
DIRECTION |
VARCHAR2(5) |
Direction of this parameter |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-129 ALL_IV_EXPERT_TASKS
Column Name | Data Type | Description |
---|---|---|
EXPERT_ID |
NUMBER(9) |
ID of the expert |
EXPERT_NAME |
VARCHAR2(255) |
Name of the expert |
TASK_ID |
NUMBER(9) |
ID of the task |
TASK_NAME |
VARCHAR2(255) |
Name of the task |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the task |
DESCRIPTION |
VARCHAR2(4000) |
Description of the task |
TASK_TYPE |
VARCHAR2(4000) |
Type of the task |
BOUND_OBJECT_ID |
NUMBER(9) |
ID of the bound object |
BOUND_OBJECT_NAME |
VARCHAR2(40) |
Name of the bound object |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
MAIN |
VARCHAR2(4000) |
The main processing script of the task |
PREPROCESSING |
VARCHAR2(4000) |
The pre-processing script of the task |
POSTPROCESSING |
VARCHAR2(4000) |
The post-processing script of the task |
INSTRUCTION |
VARCHAR2(4000) |
Instruction for running the task |
Table 2-130 ALL_IV_EXPERT_TRANSITIONS
Column Name | Data Type | Description |
---|---|---|
EXPERT_ID |
NUMBER(9) |
ID of the expert |
EXPERT_NAME |
VARCHAR2(255) |
Name of the expert |
TRANSITION_ID |
NUMBER(9) |
ID of the transition |
TRANSITION_NAME |
VARCHAR2(255) |
Name of the transition |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the transition |
DESCRIPTION |
VARCHAR2(4000) |
Description of the transition |
CONDITION |
VARCHAR2(4000) |
Transition condition |
TRANSITION_ORDER |
NUMBER(9) |
Transition order |
SOURCE_ACTIVITY_ID |
NUMBER(9) |
ID of the source task |
SOURCE_ACTIVITY_NAME |
VARCHAR2(255) |
Name of the source task |
TARGET_ACTIVITY_ID |
NUMBER(9) |
ID of the target task |
TARGET_ACTIVITY_NAME |
VARCHAR2(255) |
Name of the target task |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-131 ALL_IV_EXPERT_VARIABLES
Column Name | Data Type | Description |
---|---|---|
EXPERT_ID |
NUMBER(9) |
ID of the expert |
EXPERT_NAME |
VARCHAR2(255) |
Name of the expert |
VARIABLE_ID |
NUMBER(9) |
ID of the variable |
VARIABLE_NAME |
VARCHAR2(255) |
Name of the variable |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the variable |
DESCRIPTION |
VARCHAR2(4000) |
Description of the variable |
POSITION |
NUMBER(9) |
Position of the variable |
DATA_TYPE |
VARCHAR2(40) |
Data type of the variable |
DEFAULT_VALUE |
VARCHAR2(4000) |
Default value of the variable |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-132 ALL_IV_NESTED_EXPERTS
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
PARENT_EXPERT_ID |
NUMBER(9) |
ID of the parent expert |
PARENT_EXPERT_NAME |
VARCHAR2(255) |
Name of the parent expert |
EXPERT_ID |
NUMBER(9) |
ID of the expert |
EXPERT_NAME |
VARCHAR2(255) |
Name of the expert |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the expert |
DESCRIPTION |
VARCHAR2(4000) |
Description of the expert |
BOUND_OBJECT_ID |
NUMBER(9) |
ID of the bound object |
BOUND_OBJECT_NAME |
VARCHAR2(40) |
Name of the bound object |
IS_VALID |
VARCHAR2(13) |
Is this nested expert valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-133 ALL_IV_ALTERNATIVE_SORT_ORDERS
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
ALT_SORT_ORDER_ID |
NUMBER(9) |
ID of the alternative sort order |
ALT_SORT_ORDER_NAME |
VARCHAR2(255) |
Name of the alternative sort order |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the alternative sort order |
DESCRIPTION |
VARCHAR2(4000) |
Description of the alternative sort order |
IS_DRILL_TO_DETAIL |
CHAR(1) |
Whether it acts as a Drill to Detail when deployed to Discoverer |
IS_CACHE_VALUES |
CHAR(1) |
Indicates whether Discoverer should cache the list of values in memory for the current session, once it has been displayed for the first time |
IS_REQUIRE_SEARCH |
CHAR(1) |
Causes Discoverer to request the end user to enter search criteria to reduce the list of values to a subset of the whole list |
IS_SHOW_IN_NAVIGATOR |
CHAR(1) |
Indicates that Discoverer should show the values in the "Select Items" page of the Worksheet Wizard (the item navigator). |
IS_SORTED_DISTINCT |
CHAR(1) |
Indicates that the values should be displayed alphabetically sorted and with duplicates hidden |
RETRIEVE_VALUE_GROUP_SIZE |
NUMBER(9) |
The maximum number of rows to be fetched from the database at a time |
VALUES_ITEM_ID |
NUMBER(9) |
The ID of the item that contains the values to be sorted |
VALUES_ITEM_NAME |
VARCHAR2(255) |
The name of the item that contains the values to be sorted |
ORDER_ITEM_ID |
NUMBER(9) |
The identifier of the item that defines the order in which the values in the VALUES_ITEM_ID field are to be sorted |
ORDER_ITEM_NAME |
VARCHAR2(255) |
The name of the item that defines the order in which the values in the VALUES_ITEM_ID field are to be sorted |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-134 ALL_IV_BUSINESS_AREAS
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
BUSINESS_AREA_ID |
NUMBER(9) |
Id of the business area |
BUSINESS_AREA_NAME |
VARCHAR2(255) |
Name of the business area |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the business area |
DESCRIPTION |
VARCHAR2(4000) |
Description of the business area |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-135 ALL_IV_BUSINESS_AREA_FOLDERS
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
BUSINESS_AREA_ID |
NUMBER(9) |
ID of the business area |
BUSINESS_AREA_NAME |
VARCHAR2(255) |
Name of the business area |
ITEM_FOLDER_ID |
NUMBER(9) |
Identifier of the Item Folder present in the Business Area |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the item folder present in the business area |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the item folder present in the business area |
DESCRIPTION |
VARCHAR2(4000) |
Description of the item folder present in the business area |
FOLDER_TYPE |
VARCHAR2(40) |
The item folder type (simple or complex) of the item folder present in the business area |
IS_VISIBLE |
NUMBER |
The visibility of the item folder to the end-user |
VALID |
CHAR(1) |
Flag to indicate if it is valid |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-136 ALL_IV_PRESENTATION_TEMPLATES
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
TEMPLATE_ID |
NUMBER(9) |
ID of the template |
TEMPLATE_NAME |
VARCHAR2(255) |
Name of the template |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the presentation template |
DESCRIPTION |
VARCHAR2(4000) |
Description of the presentation template |
PRESENTATION_TYPE |
VARCHAR2(40) |
The presentation type (CROSSTAB, PIE, BAR_VERT_CLUST) |
CUBE_ID |
NUMBER(9) |
ID of the cube that is referenced in the presentation template |
CUBE_NAME |
VARCHAR2(255) |
Name of the cube that is referenced in the presentation template |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-137 ALL_IV_DRILLS_TO_DETAIL
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
DRILL_TO_DETAIL_ID |
NUMBER(9) |
ID of the drill to detail |
DRILL_TO_DETAIL_NAME |
VARCHAR2(255) |
Name of the drill to detail |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the drill to detail |
DESCRIPTION |
VARCHAR2(4000) |
Description of the drill to detail |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-138 ALL_IV_DRILL_LEVELS
Column Name | Data Type | Description |
---|---|---|
DRILL_PATH_ID |
NUMBER(9) |
The identifier of the owning drill path |
DRILL_PATH_NAME |
VARCHAR2(255) |
The name of the owning drill path |
DRILL_LEVEL_ID |
NUMBER(9) |
The identifier of the drill level |
DRILL_LEVEL_NAME |
VARCHAR2(255) |
The name of the drill level |
BUSINESS_NAME |
VARCHAR2(1000) |
The business name of the drill level |
DESCRIPTION |
VARCHAR2(4000) |
The description of the drill level |
IS_DEFAULT_ROOT_LEVEL |
VARCHAR2(1) |
Is it the default root level |
IS_GRAND_TOTAL_LEVEL |
VARCHAR2(1) |
Is it the grand total level |
SUPPORTS_ROLLUP |
VARCHAR2(1) |
Flag to indicate if it supports rollup |
PARENT_DRILL_LEVEL_ID |
NUMBER(9) |
The identifier of the parent level in the drill path hierarchy |
PARENT_DRILL_LEVEL_NAME |
VARCHAR2(255) |
The name of the parent level in the drill path hierarchy |
RELATED_LEVEL_ID |
NUMBER(9) |
The identifier of the hierarchy level that the drill level was derived from |
RELATED_LEVEL_NAME |
VARCHAR2(255) |
The name of the hierarchy level that the drill level was derived from |
ITEM_OWNER_ID |
NUMBER(9) |
ID of the item owner |
ITEM_OWNER_NAME |
VARCHAR2(1000) |
Name of the item owner |
ITEM_FOLDER_ID |
NUMBER(9) |
The identifier of the item folder that the drill level is based on |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
The name of the item folder that the drill level is based on |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-139 ALL_IV_ITEM_FOLDERS
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the item folder |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the item folder |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the item folder |
DESCRIPTION |
VARCHAR2(4000) |
Description of the item folder |
FOLDER_TYPE |
VARCHAR2(40) |
Type of item folder (simple or complex) |
IS_VISIBLE |
NUMBER |
Whether the item folder is visible to the end user |
SOURCE_OBJECT_ID |
NUMBER(9) |
ID of the source object |
SOURCE_OBJECT_TYPE |
VARCHAR2(4000) |
Type of the source object (Table, Cube, Dimension) |
SOURCE_OBJECT_NAME |
VARCHAR2(255) |
Name of the source object |
DIMENSION_ROLE_ID |
NUMBER(9) |
If this item folder was derived for a dimension role, then this returns the identifier of that dimension role |
DIMENSION_ROLE_NAME |
VARCHAR2(255) |
If this item folder was derived for a dimension role, then this returns the name of that dimension role |
RELATED_LEVEL_ID |
NUMBER(9) |
If this item folder was derived for a level, then this returns the identifier of the level |
RELATED_LEVEL_NAME |
VARCHAR2(255) |
If this item folder was derived for a level then this returns the name of the level |
VALID |
CHAR(1) |
Flag to indicate if it is valid |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-140 ALL_IV_ITEM_FOLDER_JOIN_USAGES
Column Name | Data Type | Description |
---|---|---|
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the complex item folder |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the complex item folder |
JOIN_ID |
NUMBER(9) |
ID of the join between two base item folders of the complex item folder |
JOIN_NAME |
VARCHAR2(255) |
Name of the join between two base item folders of the complex item folder |
Column Name | Data Type | Description |
---|---|---|
ITEM_OWNER_ID |
NUMBER(9) |
Item owner ID |
ITEM_OWNER_NAME |
VARCHAR2(1000) |
Name of the item owner |
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the item folder |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the item folder |
ITEM_ID |
NUMBER(9) |
ID of the item |
ITEM_NAME |
VARCHAR2(255) |
Name of the item |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the item |
DESCRIPTION |
VARCHAR2(4000) |
Description of the item |
IS_COLUMN_ITEM |
CHAR(1) |
Whether this item is based on a column |
DATATYPE |
VARCHAR2(40) |
The data type of the item |
ALIGNMENT |
VARCHAR2(40) |
Alignment for display (Default, Left, Center, Right) |
CASE_STORAGE |
VARCHAR2(40) |
How alphabetic characters are stored in the database (Unknown, Lower, Upper, Mixed) |
CONTENT_TYPE |
VARCHAR2(40) |
Specifies whether the item can be used to launch an external application |
DEFAULT_AGGREGATE |
VARCHAR2(255) |
Name of default rollup function |
DEFAULT_POSITION |
VARCHAR2(40) |
Default placement for query item (Unknown, Measure, Axis, X-axis, Y-axis, Z-axis) |
DEFAULT_WIDTH |
NUMBER(9) |
Default number of characters in display |
DISPLAY_CASE |
VARCHAR2(40) |
How alphabetic characters should be displayed (Unchanged, Lower, Upper, InitCapped) |
FORMAT_MASK |
VARCHAR2(255) |
The format of the way that the item is displayed |
FORMULA |
CLOB |
The item's expression |
HEADING |
VARCHAR2(255) |
The value of the default heading in a report |
IS_VISIBLE |
NUMBER |
Whether the item is visible to the end user |
IS_WORD_WRAP |
CHAR(1) |
Whether word wrap is allowed when displaying values in a report |
MAX_CHAR_FETCHED |
NUMBER(9) |
Maximum number of characters retrieved from the database |
REPLACE_NULL_WITH |
VARCHAR2(255) |
Value to be displayed for null values |
RELATED_ATTRIBUTE_ID |
NUMBER(9) |
If this item was derived, then the identifier of the attribute it was derived from |
RELATED_ATTRIBUTE_TYPE |
VARCHAR2(4000) |
If this item was derived, then the type of the attribute it was derived from |
RELATED_ATTRIBUTE_NAME |
VARCHAR2(255) |
If this item was derived, then the name of the attribute it was derived from |
LIST_OF_VALUES_ID |
NUMBER |
If this item has a list of values, then the list of values identifier |
LIST_OF_VALUES_NAME |
VARCHAR2(255) |
If this item has a list of values, then the list of values name |
ALTERNATIVE_SORT_ORDER_ID |
NUMBER |
If this item has an alternative sort order then the ID of the alternative sort order |
ALTERNATIVE_SORT_ORDER_NAME |
VARCHAR2(255) |
If this item has an alternative sort order then the name of the alternative sort order |
DRILL_TO_DETAIL_ID |
NUMBER |
If this item has a drill to detail then the ID of the drill to detail |
DRILL_TO_DETAIL_NAME |
VARCHAR2(255) |
If this item has a drill to detail then the name of the drill to detail |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-142 ALL_IV_ITEM_FORMULA_REFS
Column Name | Data Type | Description |
---|---|---|
ITEM_OWNER_ID |
NUMBER(9) |
ID of item owner |
ITEM_OWNER_NAME |
VARCHAR2(1000) |
Name of the item owner |
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the item folder |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the item folder |
ITEM_ID |
NUMBER(9) |
ID of the item |
ITEM_NAME |
VARCHAR2(255) |
Name of the item |
TAG |
NUMBER(9) |
Refers to the tag value used in the formula of the item |
REFERENCED_FUNCTION_ID |
NUMBER(9) |
ID of the referenced function |
REFERENCED_FUNCTION_TYPE |
VARCHAR2(4000) |
Type of the referenced function |
REFERENCED_FUNCTION_NAME |
VARCHAR2(255) |
Name of the referenced function |
REFERENCED_ITEM_OWNER_ID |
NUMBER(9) |
ID of the referenced item owner |
REFERENCED_ITEM_OWNER_NAME |
VARCHAR2(1000) |
Name of the referenced item owner |
REFERENCED_ITEM_FOLDER_ID |
NUMBER(9) |
ID of the referenced item folder |
REFERENCED_ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the referenced item folder |
REFERENCED_ITEM_ID |
NUMBER(9) |
ID of the referenced item |
REFERENCED_ITEM_NAME |
VARCHAR2(255) |
Name of the referenced item |
Column Name | Data Type | Description |
---|---|---|
TEMPLATE_ID |
NUMBER(9) |
ID of the presentation template |
TEMPLATE_NAME |
VARCHAR2(255) |
Name of the presentation template |
DATA_ITEM_ID |
NUMBER(9) |
ID of the data item |
DATA_ITEM_NAME |
VARCHAR2(255) |
Name of the data item |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the data item |
DESCRIPTION |
VARCHAR2(4000) |
Description of the data item |
MEASURE_ID |
NUMBER(9) |
The identifier of the measure used as the data item |
MEASURE_NAME |
VARCHAR2(255) |
The name of the measure used as the data item |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
TEMPLATE_ID |
NUMBER(9) |
ID of the presentation template |
TEMPLATE_NAME |
VARCHAR2(255) |
Name of the presentation template |
EDGE_ITEM_ID |
NUMBER(9) |
Identifier of the edge item |
EDGE_ITEM_NAME |
VARCHAR2(255) |
Name of the edge item |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the edge item |
DESCRIPTION |
VARCHAR2(4000) |
Description of the edge item |
PLACEMENT |
VARCHAR2(40) |
The axis the edge item is on |
DIMENSION_ROLE_ID |
NUMBER(9) |
ID of the dimension role |
DIMENSION_ROLE_NAME |
VARCHAR2(255) |
Name of the dimension role |
DIMENSION_ID |
NUMBER(9) |
ID of the dimension |
DIMENSION_NAME |
VARCHAR2(255) |
Name of the dimension |
HIERARCHY_ID |
NUMBER(9) |
Not used |
HIERARCHY_NAME |
VARCHAR2(255) |
Not used |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-145 ALL_IV_DRILL_PATHS
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
DRILL_PATH_ID |
NUMBER(9) |
ID of the drill path |
DRILL_PATH_NAME |
VARCHAR2(255) |
Name of the drill path |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the drill path |
DESCRIPTION |
VARCHAR2(4000) |
Description of the drill path |
DIMENSION_ID |
NUMBER(9) |
If the drill path was derived from a dimension hierarchy, then the ID of the dimension |
DIMENSION_NAME |
VARCHAR2(255) |
If the drill path was derived from a dimension hierarchy then the name of the dimension |
DIMENSION_ROLE_ID |
NUMBER(9) |
If the drill path was derived from a dimension role's hierarchy then its identifier |
DIMENSION_ROLE_NAME |
VARCHAR2(255) |
If the drill path was derived from a dimension role's hierarchy then its name |
HIERARCHY_ID |
NUMBER(9) |
The identifier of the hierarchy the drill path was derived from |
HIERARCHY_NAME |
VARCHAR2(255) |
The name of the hierarchy the drill path was derived from |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-146 ALL_IV_DRILL_LEVEL_ITEMS
Column Name | Data Type | Description |
---|---|---|
DRILL_PATH_ID |
NUMBER(9) |
Owning drill path identifier |
DRILL_PATH_NAME |
VARCHAR2(255) |
Owning drill path name |
DRILL_LEVEL_ID |
NUMBER(9) |
ID of the drill level |
DRILL_LEVEL_NAME |
VARCHAR2(255) |
Name of the drill level |
DRILL_ITEM_ID |
NUMBER(9) |
ID of the drill item |
DRILL_ITEM_NAME |
VARCHAR2(1000) |
Name of the drill item |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of drill level item |
DESCRIPTION |
VARCHAR2(4000) |
Description |
ITEM_OWNER_ID |
NUMBER(9) |
ID of the item owner |
ITEM_OWNER_NAME |
VARCHAR2(1000) |
Name of the item owner |
ITEM_FOLDER_ID |
NUMBER(9) |
Item folder ID |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Item folder name |
ITEM_ID |
NUMBER(9) |
ID of the item |
ITEM_NAME |
VARCHAR2(255) |
Name of the item |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-147 ALL_IV_DRILL_PATH_JOIN_USAGES
Column Name | Data Type | Description |
---|---|---|
DRILL_PATH_ID |
NUMBER(9) |
ID of the drill path |
DRILL_PATH_NAME |
VARCHAR2(255) |
Name of the drill path |
PARENT_DRILL_LEVEL_ID |
NUMBER(9) |
ID of the parent drill level |
PARENT_DRILL_LEVEL_NAME |
VARCHAR2(255) |
Name of the parent drill level |
CHILD_DRILL_LEVEL_ID |
NUMBER(9) |
ID of the child drill level |
CHILD_DRILL_LEVEL_NAME |
VARCHAR2(255) |
Name of the child drill level |
JOIN_ID |
NUMBER(9) |
ID of the join |
JOIN_NAME |
VARCHAR2(255) |
Name of the join |
Table 2-148 ALL_IV_LISTS_OF_VALUES
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
LIST_OF_VALUES_ID |
NUMBER(9) |
ID of the list of values |
LIST_OF_VALUES_NAME |
VARCHAR2(255) |
Name of the list of values |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the list of values |
DESCRIPTION |
VARCHAR2(4000) |
Description of the list of values |
IS_DRILL_TO_DETAIL |
CHAR(1) |
Whether it acts as a drill to detail when deployed to Discoverer |
IS_CACHE_VALUES |
CHAR(1) |
Indicates whether Discoverer should cache the list of values in memory for the current session, once it has been displayed for the first time |
IS_REQUIRE_SEARCH |
CHAR(1) |
Value 1 causes Discoverer to request the end user to enter search criteria to reduce the list of values to a subset of the whole list |
IS_SHOW_IN_NAVIGATOR |
CHAR(1) |
Indicates whether Discoverer should show the values in the "Select Items" page of the Worksheet Wizard (the item navigator) |
IS_SORTED_DISTINCT |
CHAR(1) |
Value 1 indicates that the values should be displayed alphabetically sorted and with duplicates hidden |
RETRIEVE_VALUE_GROUP_SIZE |
NUMBER(9) |
The maximum number of rows to be fetched from the database at a time |
VALUES_ITEM_ID |
NUMBER(9) |
The identifier of the item that supplies the values |
VALUES_ITEM_NAME |
VARCHAR2(255) |
The name of the item that supplies the values |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-149 ALL_IV_REGISTERED_FUNCTIONS
Column Name | Data Type | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
ID of the module |
MODULE_NAME |
VARCHAR2(255) |
Name of the module |
REGISTERED_FUNCTION_ID |
NUMBER(9) |
ID of the registered function |
REGISTERED_FUNCTION_NAME |
VARCHAR2(255) |
Name of the registered function |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the registered function |
DESCRIPTION |
VARCHAR2(4000) |
Description of the registered function |
SIGNATURE |
VARCHAR2(4000) |
The signature of the registered function |
IS_AVAILABLE |
CHAR(1) |
Whether a Discoverer end user may use this function in calculations |
SOURCE_FUNCTION_ID |
NUMBER(9) |
The identifier of the function it was derived from |
SOURCE_FUNCTION_NAME |
VARCHAR2(255) |
The name of the function it was derived from |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-150 ALL_IV_CONDITION_FORMULA_REFS
Column Name | Data Type | Description |
---|---|---|
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the item folder |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the item folder |
ITEM_ID |
NUMBER(9) |
ID of the condition |
ITEM_NAME |
VARCHAR2(255) |
Name of the condition |
TAG |
NUMBER(9) |
Refers to the tag value used in the condition's formula |
REFERENCED_FUNCTION_ID |
NUMBER(9) |
ID of the referenced function |
REFERENCED_FUNCTION_TYPE |
VARCHAR2(4000) |
Type of the referenced function |
REFERENCED_ITEM_ID |
NUMBER(9) |
ID of the referenced item |
REFERENCED_ITEM_NAME |
VARCHAR2(255) |
Name of the referenced item |
REFERENCED_CONDITION_ID |
NUMBER(9) |
ID of the referenced condition |
REFERENCED_CONDITION_NAME |
VARCHAR2(255) |
Name of the referenced condition |
Table 2-151 ALL_IV_JOIN_COMPONENTS
Column Name | Data Type | Description |
---|---|---|
ITEM_OWNER_ID |
NUMBER(9) |
ID of the item owner |
ITEM_OWNER_NAME |
VARCHAR2(1000) |
Name of the item owner |
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the item folder |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the item folder |
JOIN_ID |
NUMBER(9) |
ID of the join |
JOIN_NAME |
VARCHAR2(255) |
Name of the join |
JOIN_COMPONENT_ID |
NUMBER(9) |
Identifier of the join component |
JOIN_COMPONENT_NAME |
VARCHAR2(255) |
Name of the join component |
BUSINESS_NAME |
VARCHAR2(1000) |
Business Name of the join component |
DESCRIPTION |
VARCHAR2(4000) |
Description of the join component |
JOIN_OPERATOR |
VARCHAR2(40) |
The operator for the join component |
DETAIL_ITEM_ID |
NUMBER(9) |
The identifier of the item referenced in the detail item folder |
DETAIL_ITEM_NAME |
VARCHAR2(255) |
The name of the item referenced in the detail item folder |
MASTER_ITEM_ID |
NUMBER(9) |
The identifier of the item referenced in the master item folder |
MASTER_ITEM_NAME |
VARCHAR2(255) |
The name of the item referenced in the master item folder |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the item owner |
ITEM_OWNER_NAME |
VARCHAR2(1000) |
Name of the item owner |
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the detail item folder |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the detail item folder |
JOIN_ID |
NUMBER(9) |
ID of the join |
JOIN_NAME |
VARCHAR2(255) |
Name of the join |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the join |
DESCRIPTION |
VARCHAR2(4000) |
Description of the join |
IS_OUTER_JOIN_ON_MASTER |
CHAR(1) |
Indicates whether to perform an outer join on the master item folder. If this is set, any detail rows that have no related master row will be included in the results of the join |
IS_OUTER_JOIN_ON_DETAIL |
CHAR(1) |
Indicates whether to perform an outer join on the detail item folder. If this is set, any master rows that have no related detail rows will be included in the results of the join |
IS_DETAIL_EXISTS_ON_MASTER |
CHAR(1) |
Indicates whether every detail row must refer to a valid master row |
IS_ONE_TO_ONE |
CHAR(1) |
Indicates whether each master row only ever has a single detail row |
REFERENCED_ITEM_OWNER_ID |
NUMBER(9) |
ID of the referenced item owner |
REFERENCED_ITEM_OWNER_NAME |
VARCHAR2(1000) |
Name of the referenced item owner |
REFERENCED_ITEM_FOLDER_ID |
NUMBER(9) |
The identifier of the master item folder referenced from the join |
REFERENCED_ITEM_FOLDER_NAME |
VARCHAR2(255) |
The name of the master item folder referenced from the join |
RELATED_FOREIGN_KEY_ID |
NUMBER(9) |
The identifier of the foreign key that this join was derived from |
RELATED_FOREIGN_KEY_NAME |
VARCHAR2(255) |
The name of the foreign key that this join was derived from |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the item folder |
ITEM_FOLDER_NAME |
VARCHAR2(255) |
Name of the item folder |
CONDITION_ID |
NUMBER(9) |
ID of the condition |
CONDITION_NAME |
VARCHAR2(255) |
Name of the condition |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the condition |
DESCRIPTION |
VARCHAR2(4000) |
Description of the condition |
IS_MANDATORY |
CHAR(1) |
Whether the condition is mandatory |
FORMULA |
CLOB |
Formula of the condition |
IS_MATCH_CASE |
CHAR(1) |
Whether the alphabetic character case must match exactly |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-154 ALL_IV_CATALOG_FOLDER_DRILLS
Column Name | Datatype | Description |
---|---|---|
MODULE_ID |
NUMBER (9) |
Module ID |
MODULE_NAME |
VARCHAR2 (1000) |
Name of the module |
CATALOG_FOLDER_ID |
NUMBER (9) |
ID of the catalog folder |
CATALOG_FOLDER_NAME |
VARCHAR2 (1000) |
Name of the catalog folder |
DRILL_PATH_ID |
NUMBER (9) |
ID of the drill path |
DRILL_PATH_NAME |
VARCHAR2 (1000) |
Name of the drill path |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the drill path |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the drill path |
IS_TIME_DIMENSION |
CHAR (1) |
Is time dimension |
VALID |
CHAR (1) |
flag to indicate if it is valid |
IS_VALID |
VARCHAR2 (13) |
Is valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-155 ALL_IV_CATALOG_FOLDER_TABLES
Column Name | Datatype | Description |
---|---|---|
MODULE_ID |
NUMBER (9) |
ID of the module |
MODULE_NAME |
VARCHAR2 (1000) |
Name of the module |
CATALOG_FOLDER_ID |
NUMBER (9) |
ID of the catalog folder |
CATALOG_FOLDER_NAME |
VARCHAR2 (1000) |
Name of the catalog folder |
LOGICAL_TABLE_ID |
NUMBER (9) |
ID of the logical table |
LOGICAL_TABLE_NAME |
VARCHAR2 (1000) |
Name of the logical table |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the table |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the table |
IS_VISIBLE |
NUMBER |
Is visible |
IS_BRIDGE_TABLE |
CHAR (1) |
Is bridge table |
DISTINCT_VALUES |
CHAR (1) |
Distinct values |
VALID |
CHAR (1) |
Flag to indicate if valid |
IS_VALID |
VARCHAR (13) |
Is Valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-156 ALL_IV_CATALOG_FOLDERS
Column Name | Datatype | Description |
---|---|---|
MODULE_ID |
NUMBER (9) |
ID of the module |
MODULE_NAME |
VARCHAR2 (1000) |
Name of the module |
CATALOG_FOLDER_ID |
NUMBER (9) |
ID of the catalog folder |
CATALOG_FOLDER_NAME |
VARCHAR2 (1000) |
Name of the catalog folder |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the catalog folder |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the catalog folder |
VALID |
CHAR (1) |
Flag to indicate if its valid |
IS_VALID |
VARCHAR2 (13) |
Is valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-157 ALL_IV_DRILL_LEVEL_KEY_ITEMS
Column Name | Datatype | Description |
---|---|---|
DRILL_PATH_ID |
NUMBER(9) |
ID of the Drill Path |
DRILL_PATH_NAME |
VARCHAR2(1000) |
Name of the Drill Path |
DRILL_LEVEL_ID |
NUMBER(9) |
Drill Level ID |
DRILL_LEVEL_NAME |
VARCHAR2(1000)) |
Drill Level name |
DRILL_LEVEL_KEY_ID |
NUMBER(9) |
ID of the Drill Level Key |
DRILL_LEVEL_KEY_NAME |
VARCHAR2(1000) |
Name of the Drill Level Key |
DRILL_ITEM_ID |
NUMBER(9) |
ID of the Drill Item |
DRILL_ITEM_NAME |
VARCHAR2(1000) |
Name of the Drill Item |
Table 2-158 ALL_IV_DRILL_LEVEL_LINKS
Column Name | Datatype | Description |
---|---|---|
DRILL_PATH_ID |
NUMBER(9) |
ID of the Drill Path |
DRILL_PATH_NAME |
VARCHAR2(1000) |
Name of the Drill Path |
PARENT_DRILL_LEVEL_ID |
NUMBER(9) |
ID of the parent Drill Level |
PARENT_DRILL_LEVEL_NAME |
VARCHAR2(1000) |
Name of the parent Drill Level |
CHILD_DRILL_LEVEL_ID |
NUMBER(9) |
ID of the child Drill Level |
CHILD_DRILL_LEVEL_NAME |
VARCHAR2(1000) |
Name of the Child Drill Level |
Table 2-159 ALL_IV_DRILL_LEVEL_KEYS
Column Name | Datatype | Description |
---|---|---|
DRILL_PATH_ID |
NUMBER(9) |
ID of the Drill Path |
DRILL_PATH_NAME |
VARCHAR2(1000) |
Name of the Drill Path |
DRILL_LEVEL_ID |
NUMBER(9) |
ID of the Drill Level |
DRILL_LEVEL_NAME |
VARCHAR2(1000) |
Name of the Drill Level |
DRILL_LEVEL_KEY_ID |
NUMBER(9) |
ID of the Drill Level Key |
DRILL_LEVEL_KEY_NAME |
VARCHAR2(1000) |
Name of the Drill Level Key |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the Drill Level Key |
DESCRIPTION |
VARCHAR2(4000) |
Description of the Drill Level Key |
IS_PRIMARY_KEY |
CHAR(1) |
Flag to indicate if it is the primary key |
IS_CHRONOLOGICAL_KEY |
CHAR(1) |
Is chronological key |
USE_FOR_DRILLDOWN |
CHAR(1) |
Use for drilldown |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-160 ALL_IV_DRILL_LEVELS_DISTINCT
Column Name | Datatype | Description |
---|---|---|
DRILL_PATH_ID |
NUMBER(9) |
ID of the Drill Path |
DRILL_PATH_NAME |
VARCHAR2(1000) |
Name of the Drill Path |
DRILL_LEVEL_ID |
NUMBER(9) |
ID of the Drill Level |
DRILL_LEVEL_NAME |
VARCHAR2(1000) |
Name of the Drill Level |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name |
DESCRIPTION |
VARCHAR(4000) |
Description |
IS_DEFAULT_ROOT_LEVEL |
VARCHAR2(1) |
Is default root level |
IS_GRAND_TOTAL_LEVEL |
VARCHAR2(1) |
Is grand total level |
SUPPORTS_ROLLUP |
VARCHAR2(1) |
Support rollup |
RELATED_LEVEL_ID |
NUMBER(9) |
Related level ID |
RELATED_LEVEL_NAME |
VARCHAR2(1000) |
Related level name |
ITEM_OWNER_ID |
NUMBER(9) |
ID of the Item owner |
ITEM_OWNER_NAME |
VARCHAR2(1000) |
Name of the Item owner |
ITEM_FOLDER_ID |
NUMBER(9) |
ID of the Item Folder |
ITEM_FOLDER_NAME |
VARCHAR2(1000) |
Name of the Item Folder |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-161 ALL_IV_LOGICAL_TABLE_DBOJECTS
Column Name | Datatype | Description |
---|---|---|
LOGICAL_TABLE_ID |
NUMBER(9) |
ID of the logical table |
LOGICAL_TABLE_NAME |
VARCHAR2(1000) |
Name of the logical table |
OBJECT_ID |
NUMBER(9) |
ID of the object |
OBJECT_TYPE |
VARCHAR2(4000) |
Type of object |
OBJECT_NAME |
VARCHAR2(1000) |
Name of the object |
Table 2-162 ALL_IV_LOGICAL_TABLES
Column Name | Datatype | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
Module ID |
MODULE_NAME |
VARCHAR2(1000) |
Name of the module |
LOGICAL_TABLE_ID |
NUMBER(9) |
ID of the logical table |
LOGICAL_TABLE_NAME |
VARCHAR2(1000) |
Name of the logical table |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the logical table |
DESCRIPTION |
VARCHAR2(4000) |
Description of the logical table |
IS_VISIBLE |
NUMBER |
Is visible |
IS_BRIDGE_TABLE |
CHAR(1) |
Is bridge table |
DISTINCT_VALUES |
CHAR(1) |
Distinct values |
SOURCE_OBJECT_ID |
NUMBER(9) |
ID of the source object |
SOURCE_OBJECT_TYPE |
VARCHAR2(4000) |
Type of source object |
SOURCE_OBJECT_NAME |
VARCHAR2(1000) |
Source object name |
DIMENSION_ROLE_ID |
NUMBER(9) |
ID of the dimension role |
DIMENSION_ROLE_NAME |
VARCHAR2(1000) |
Name of dimension role |
RELATED_LEVEL_ID |
NUMBER(9) |
Related level ID |
RELATED_LEVEL_NAME |
VARCHAR2(1000) |
Related level name |
VALID |
CHAR(1) |
Flag to indicate if valid |
IS_VALID |
VARCHAR2(13) |
Is valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-163 ALL_IV_LOGICAL_TABLE_FK_USAGES
Column Name | Datatype | Description |
---|---|---|
LOGICAL_TABLE_ID |
NUMBER(9) |
ID of the logical table |
LOGICAL_TABLE_NAME |
VARCHAR2(1000) |
Name of the logical table |
FOREIGN_KEY_ID |
NUMBER(9) |
Foreign key ID |
FOREIGN_KEY_NAME |
VARCHAR2(1000) |
Name of the foreign key |
LOGICAL_TABLE_ID |
NUMBER(9) |
Logical table ID |
LOGICAL_TABLE_NAME |
VARCHAR2(1000) |
Name of the logical table |
Table 2-164 ALL_IV_LOGICAL_TABLE_AGGLEVELS
Column Name | Datatype | Description |
---|---|---|
LOGICAL_TABLE_ID |
NUMBER(9) |
Logical table ID |
LOGICAL_TABLE_NAME |
VARCHAR2(1000) |
Name of the logical table |
DRILL_PATH_ID |
NUMBER(9) |
Drill path ID |
DRILL_PATH_NAME |
VARCHAR2(1000) |
Name of the drill path |
DRILL_LEVEL_ID |
NUMBER(9) |
Drill level ID |
DRILL_LEVEL_NAME |
VARCHAR2(1000) |
Name of the drill level |
Table 2-165 ALL_IV_STREAMS_QUEUES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
QUEUE_ID |
NUMBER(9) |
ID of the queue |
QUEUE_NAME |
VARCHAR2(255) |
Name of the queue |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the queue |
DESCRIPTION |
VARCHAR2(4000) |
Description of the queue |
QUEUE_TABLE |
VARCHAR2(255) |
Physical name of the queue table |
QUEUE_TABLE_ID |
NUMBER(9) |
ID of the queue table |
PAYLOAD_TYPE |
CHAR(11) |
Type of payload |
IS_VALID |
VARCHAR2(13) |
Is the queue valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
QUEUE_ID |
NUMBER(9) |
ID of the queue |
QUEUE_NAME |
VARCHAR2(255) |
Name of the queue |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the queue |
DESCRIPTION |
VARCHAR2(4000) |
Description of the queue |
QUEUE_TABLE |
VARCHAR2(255) |
Physical name of the queue table |
QUEUE_TABLE_ID |
NUMBER(9) |
ID of the queue table |
PAYLOAD_TYPE |
VARCHAR2(255) |
Type of payload for the queue |
PAYLOAD_TYPE_ID |
NUMBER |
ID of the payload type |
IS_VALID |
VARCHAR2(13) |
Is the queue valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-167 ALL_IV_QUEUE_PROPAGATIONS
Column Name | Data Type | Description |
---|---|---|
QUEUEPROPAGATION_ID |
NUMBER(9) |
ID of the queue propagation |
QUEUETABLE_NAME |
VARCHAR2(255) |
Physical name of the queue table |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the queue table |
DESCRIPTION |
VARCHAR2(4000) |
Description of the queue table |
SOURCE_QUEUE |
VARCHAR2(255) |
Name of the source queue |
SOURCE_QUEUE_ID |
NUMBER(9) |
ID of the source queue |
TARGET_QUEUE |
VARCHAR2(255) |
Name of the target queue |
TARGET_QUEUE_ID |
NUMBER(9) |
ID of the target queue |
IS_VALID |
VARCHAR2(13) |
Is the queue table valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-168 ALL_IV_QUEUE_TABLES
Column Name | Data Type | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2(255) |
Name of the schema |
QUEUETABLE_ID |
NUMBER(9) |
ID of the queue table |
QUEUETABLE_NAME |
VARCHAR2(255) |
Name of the queue table |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the queue table |
DESCRIPTION |
VARCHAR2(4000) |
Description of the queue table |
PAYLOAD_TYPE |
VARCHAR2(767) |
Type of payload |
PAYLOAD_TYPE_ID |
NUMBER(9) |
ID of payload type |
IS_VALID |
VARCHAR2(13) |
Is queue table valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-169 ALL_IV_STREAMS_CAPTURE
Column Name | Data Type | Description |
---|---|---|
STREAMSCAPTURE_ID |
NUMBER(9) |
ID of the streams capture |
STREAMSCAPTURE_NAME |
VARCHAR2(255) |
Name of the streams capture |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the streams capture |
DESCRIPTION |
VARCHAR2(4000) |
Description of the streams capture |
STREAMS_QUEUE |
VARCHAR2(255) |
Streams queue |
STREAMS_QUEUE_ID |
NUMBER(9) |
ID of the streams queue |
IS_VALID |
VARCHAR2(13) |
Validation status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-170 ALL_IV_CAPTURE_RELATIONS
Column Name | Data Type | Description |
---|---|---|
STREAMS_CAPTURE_ID |
NUMBER(9) |
ID of the streams capture |
STREAMS_CAPTURE_NAME |
VARCHAR2(255) |
Name of the streams capture |
TABLE_ID |
NUMBER(9) |
ID of the table |
TABLE_NAME |
VARCHAR2(255) |
Name of the table |
CAPTURERELATION_ID |
NUMBER(9) |
ID of the capture relation |
CAPTUREREALTION_NAME |
VARCHAR2(255) |
Name of the capture relation |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the capture relation |
DESCRIPTION |
VARCHAR2(4000) |
Description of the capture relation |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-171 ALL_IV_SCHEDULABLE
Column Name | Data Type | Description |
---|---|---|
OBJECT_ID |
NUMBER(9) |
ID of the object |
OBJECT_TYPE |
VARCHAR2(4000) |
Type of the object |
OBJECT_NAME |
VARCHAR2(255) |
Name of the object |
CONFIGURATION_ID |
NUMBER(9) |
ID of the configuration |
CONFIGURATION_NAME |
VARCHAR2(255) |
Name of the configuration |
SCHEDULE_ID |
NUMBER(9) |
ID of the applied schedule |
SCHEDULE_NAME |
VARCHAR2(255) |
Name of the applied schedule |
Table 2-172 ALL_IV_CALENDAR_SCHEDULES
Column Name | Data Type | Description |
---|---|---|
CALENDAR_ID |
NUMBER(9) |
ID of the calendar |
CALENDAR_NAME |
VARCHAR2(255) |
Name of the calendar |
SCHEDULE_ID |
NUMBER(9) |
ID of the schedule |
SCHEDULE_NAME |
VARCHAR2(255) |
Name of the schedule |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the schedule |
DESCRIPTION |
VARCHAR2(4000) |
Description of the schedule |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
STARTTIME |
DATE |
Start time of the schedule |
ENDTIME |
DATE |
End time of the schedule |
REPEATEXPRESSION |
VARCHAR2(4000) |
Expression defining how often the schedule is active |
TIMEZONE |
VARCHAR2(255) |
Time zone that the start and end time refer to |
Column Name | Data Type | Description |
---|---|---|
GRANTEE |
VARCHAR2(255) |
Grantee name, user, or role receiving the grant |
OBJECT_ID |
NUMBER(9) |
ID of the object |
OBJECT_NAME |
VARCHAR2(255) |
Name of the object |
OBJECT_TYPE |
VARCHAR2(4000) |
Type of object |
PRIVILEGE |
VARCHAR2(100) |
Object privilege granted to the grantee |
Column Name | Data Type | Description |
---|---|---|
GRANTEE |
VARCHAR2(255) |
Grantee name, user, or role receiving the grant |
GRANTED_ROLE |
VARCHAR2(255) |
The granted role |
Column Name | Data Type | Description |
---|---|---|
GRANTEE |
VARCHAR2(255) |
Grantee name, user, or role receiving the grant |
PRIVILEGE |
VARCHAR2(100) |
System privilege name granted to the grantee |
Column Name | Data Type | Description |
---|---|---|
ROLE_ID |
NUMBER(9) |
ID of the role |
ROLE_NAME |
VARCHAR2(255) |
Name of the role |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the role |
DESCRIPTION |
VARCHAR2(4000) |
Description of the role |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
USER_ID |
NUMBER(9) |
ID of the user |
USER_NAME |
VARCHAR2(255) |
Name of the user |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the user |
DESCRIPTION |
VARCHAR2(4000) |
Description of the user |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-178 ALL_IV_CT_VARIABLES
Column Name | Datatype | Description |
---|---|---|
CT_ID |
NUMBER(9) |
ID of the code template |
CT_NAME |
VARCHAR2(1000) |
Name of the code template |
VARIABLE_ID |
NUMBER(9) |
Variable ID |
VARIABLE_NAME |
VARCHAR2(1000) |
Variable name |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the variable |
DESCRIPTION |
VARCHAR2(4000) |
Description of the variable |
DATA_TYPE |
VARCHAR2(40) |
Data type of the variable |
DEFAULT_VALUE |
VARCHAR2(4000) |
Default value of the variable |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Datatype | Description |
---|---|---|
CT_ID |
NUMBER(9) |
ID of the code template |
CT_NAME |
VARCHAR2(1000) |
Name of the code template |
TASK_ID |
NUMBER(9) |
Task ID |
TASK_NAME |
VARCHAR2(1000) |
Name of the task |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the task |
DESCRIPTION |
VARCHAR2(4000) |
Description of the task |
TASK_TYPE |
VARCHAR2(40) |
Type of task |
BOUND_OBJECT_ID |
NUMBER(9) |
ID of the bound object |
BOUND_OBJECT_NAME |
VARCHAR2(40) |
Name of the bound object |
MAIN |
VARCHAR2(4000) |
Main |
PREPROCESSING |
VARCHAR2(4000) |
Preprocessing |
POSTPROCESSING |
VARCHAR2(4000) |
Postprocessing |
INSTRUCTION |
VARCHAR2(4000) |
Instruction |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Datatype | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
Project ID |
PROJECT_NAME |
VARCHAR2(1000) |
Name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
Information system ID |
INFORMATION_SYSTEM_NAME |
VARCHAR2(1000) |
Name of the information system |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the folder |
DESCRIPTION |
VARCHAR2(4000) |
Description of the folder |
VALID |
CHAR(1) |
Flag to indicate if valid |
IS_VALID |
VARCHAR2(13) |
Is valid |
STATUS |
VARCHAR2(40) |
Status |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-181 ALL_IV_CT_TRANSITIONS
Column Name | Datatype | Description |
---|---|---|
CT_ID |
NUMBER(9) |
ID of the code template |
CT_NAME |
VARCHAR2(1000) |
Name of the code template |
TRANSITION_ID |
NUMBER(9) |
Transition ID |
TRANSITION_NAME |
VARCHAR2(1000) |
Name of the transition |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the transition |
DESCRIPTION |
VARCHAR2(4000) |
Description of the transition |
CONDITION |
VARCHAR2(4000) |
Condition |
TRANSITION_ORDER |
NUMBER(9) |
Transition order |
SOURCE_ACTIVITY_ID |
NUMBER(9) |
ID of the source activity |
SOURCE_ACTIVITY_NAME |
VARCHAR2(1000) |
Name of the source activity |
TARGET_ACTIVITY_ID |
NUMBER(9) |
ID of the target activity |
TARGET_ACTIVITY_NAME |
VARCHAR2(1000) |
Name of the target activity |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-182 ALL_IV_CT_PARAMETERS
Column Name | Datatype | Description |
---|---|---|
PARAMETER_OWNER_ID |
NUMBER(9) |
ID of the owner |
PARAMETER_OWNER_NAME |
VARCHAR2(1000) |
Name of the owner |
PARAMETER_OWNER_TYPE |
VARCHAR2(4) |
Type of parameter owner |
PARAMETER_ID |
NUMBER(9) |
ID of the parameter |
PARAMETER_NAME |
VARCHAR2(1000) |
Name of the parameter |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the parameter |
DESCRIPTION |
VARCHAR2(4000) |
Description of the parameter |
POSITION |
NUMBER(9) |
Position |
DATA_TYPE |
VARCHAR2(40) |
Data type of the parameter |
DEFAULT_VALUE |
VARCHAR2(4000) |
Default value of the parameter |
DIRECTION |
VARCHAR2(5) |
Direction |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Datatype | Description |
---|---|---|
MODULE_ID |
NUMBER(9) |
Module ID |
MODULE_NAME |
VARCHAR2(1000) |
Name of the module |
CT_ID |
NUMBER(9) |
ID of the code template |
CT_NAME |
VARCHAR2(1000) |
Name of the code template |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the code template |
DESCRIPTION |
VARCHAR2(4000) |
Description of the code template |
CT_TYPE |
VARCHAR2(13) |
Type of code template |
BOUND_OBJECT_ID |
NUMBER(9) |
ID of the bound object |
BOUND_OBJECT_NAME |
VARCHAR2(40) |
Name of the bound object |
VALID |
CHAR(1) |
Flag to indicate valid |
IS_VALID |
VARCHAR2(13) |
Is valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-184 ALL_IV_EXEC_UNIT_MAP_COMP_USES
Column Name | Data Type | Description |
---|---|---|
EXECUTION_UNIT_ID |
NUMBER(9) |
ID of the execution unit |
EXECUTION_UNIT_NAME |
VARCHAR2(1000) |
Name of the execution unit |
MAP_COMPONENT_ID |
NUMBER(9) |
ID of the map component |
MAP_COMPONENT_NAME |
VARCHAR2(1000) |
Name of the map component |
Column Name | Data Type | Description |
---|---|---|
MAP_ID |
NUMBER(9) |
ID of the map |
MAP_NAME |
VARCHAR2(1000) |
Name of the map |
EXECUTION_UNIT_ID |
NUMBER(9) |
ID of the execution unit |
EXECUTION_UNIT_NAME |
VARCHAR2(1000) |
Name of the execution unit |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name |
DESCRIPTION |
VARCHAR2(4000) |
Desciption |
CONFIGURATION_ID |
NUMBER(9) |
ID of the configuration |
CONFIGURATION_NAME |
VARCHAR2(1000) |
Name of the configuration |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-186 ALL_IV_EXEC_UNIT_CT_USES
Column Name | Data Type | Description |
---|---|---|
EXECUTION_UNIT_ID |
NUMBER(9) |
ID of the execution unit |
EXECUTION_UNIT_NAME |
VARCHAR2(1000) |
Name of the execution unit |
CODE_TEMPLATE_TYPE |
VARCHAR2(22) |
Type of CT |
CODE_TEMPLATE_ID |
NUMBER(9) |
ID of CT |
CODE_TEMPLATE_NAME |
VARCHAR2(1000) |
Name of the CT |
PARAMETER_NAME |
VARCHAR2(1000) |
Parameter name |
BUSINESS_NAME |
VARCHAR2(4000) |
Business name |
DESCRIPTION |
VARCHAR2(4000) |
Description |
VALUE |
VARCHAR2(4000) |
Value |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-187 ALL_IV_APP_SERVER_MODULES
Column Name | Datatype | Description |
---|---|---|
PROJECT_ID |
NUMBER (9) |
ID of the project |
PROJECT_NAME |
VARCHAR2 (1000) |
Name of the project |
INFORMATION_SYSTEM_ID |
NUMBER (9) |
ID of the information system |
INFORMATION_SYSTEM_NAME |
VARCHAR2 (1000) |
Name of the information system |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the application server module |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the application server module |
DATABASE_LINK |
VARCHAR2 (40) |
Database link used by the application server module. |
VALID |
CHAR (1) |
The validation result of the application server module. 1 indicates valid and 0 indicates invalid. |
IS_VALID |
VARCHAR2 (13) |
String to represent the validation value; can be Y, N, or Not Validated. |
STATUS |
VARCHAR2 (40) |
The module status; is always set to Development for an application server module. |
LOCATION_ID |
NUMBER (9) |
ID of the location |
LOCATION_NAME |
VARCHAR2 (1000) |
Name of the location |
LOCATION_TYPE |
VARCHAR2 (40) |
Type of location |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-188 ALL_IV_WEB_SERVICE_PACKAGES
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER (9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2 (1000) |
Name of the schema |
PACKAGE_ID |
NUMBER (9) |
Package ID |
PACKAGE_NAME |
VARCHAR2 (1000) |
Name of the package |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the package |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the package |
VALID |
CHAR (1) |
The validation result of the web service package. 1 indicates valid and 0 indicates invalid. |
IS_VALID |
VARCHAR2 (13) |
String to represent the validation value; can be Y, N, or Not Validated. |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-189 ALL_IV_WEB_SERVICES
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER (9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2 (1000) |
Name of the schema |
PACKAGE_ID |
NUMBER |
Package ID |
PACKAGE_NAME |
VARCHAR2 (1000) |
Package name |
WEBSERVICE_ID |
NUMBER (9) |
ID of the webservice |
WEBSERVICE_NAME |
VARCHAR2 (1000) |
Name of the webservice |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the webservice |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the webservice |
ASYNC |
CHAR (1) |
Indicates whether the web service is asynchronous or not. |
SOAP_VERSION |
VARCHAR2 (40) |
SOAP version |
WSDL_URL |
VARCHAR2 (4000) |
URL of WSDL |
WSDL_VERSION |
VARCHAR2 (40) |
WSDL version |
VALID |
CHAR (1) |
The validation result of the web service. 1 indicates Valid and 0 indicates Invalid. |
IS_VALID |
VARCHAR2 (13) |
String to represent the validation value; can be Y, N, or Not Validated. |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-190 ALL_IV_ACTIVITY_FOLDERS
Column Name | Data Type | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(255) |
Name of the project |
ACTIVITY_FOLDER_ID |
NUMBER(9) |
ID of the activity folder |
ACTIVITY_FOLDER_NAME |
VARCHAR2(255) |
Name of the activity folder |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the activity folder |
DESCRIPTION |
VARCHAR2(4000) |
Description of the activity folder |
IS_VALID |
VARCHAR2(13) |
Is the activity folder valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-191 ALL_IV_ACTIVITY_TEMPLATES
Column Name | Data Type | Description |
---|---|---|
ACTIVITY_FOLDER_ID |
NUMBER(9) |
ID of the activity folder |
ACTIVITY_FOLDER_NAME |
VARCHAR2(255) |
Name of the activity folder |
ACTIVITY_TEMPLATE_ID |
NUMBER(9) |
ID of the activity template |
ACTIVITY_TEMPLATE_NAME |
VARCHAR2(255) |
Name of the activity template |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the activity template |
DESCRIPTION |
VARCHAR2(4000) |
Description of the activity template |
IS_VALID |
VARCHAR2(13) |
Is the activity template valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-192 ALL_IV_PLS_COLLECTIONS
Column Name | Data Type | Description |
---|---|---|
LIBRARY_ID |
NUMBER(9) |
ID of the library |
LIBRARY_NAME |
VARCHAR2(255) |
Name of the library |
COLLECTION_ID |
NUMBER(9) |
ID of the collection |
COLLECTION_NAME |
VARCHAR2(255) |
Name of the collection |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the collection |
DESCRIPTION |
VARCHAR2(4000) |
Description of the collection |
COLLECTION_TYPE |
VARCHAR2(255) |
Type of the collection |
RELATED_RECORD_ID |
NUMBER(9) |
ID of the related PLS record |
RELATED_RECORD_NAME |
VARCHAR2(255) |
Name of the related PLS record |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-193 ALL_IV_PLS_RECORDS
Column Name | Data Type | Description |
---|---|---|
LIBRARY_ID |
NUMBER(9) |
ID of the library |
LIBRARY_NAME |
VARCHAR2(255) |
Name of the library |
RECORD_ID |
NUMBER(9) |
ID of the record |
RECORD_NAME |
VARCHAR2(255) |
Name of the record |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the record |
DESCRIPTION |
VARCHAR2(4000) |
Description of the record |
RECORD_TYPE |
VARCHAR2(40) |
Type of the record |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-194 ALL_IV_ROW_RELATIONSHIPS
Column Name | Data Type | Description |
---|---|---|
PROFILE_ID |
NUMBER(9) |
ID of the profile |
PROFILE_NAME |
VARCHAR2(255) |
Name of the profile |
ENTITY_ID |
NUMBER(9) |
ID of the entity |
ENTITY_NAME |
VARCHAR2(255) |
Name of the entity |
ROW_RELATIONSHIP_ID |
NUMBER(9) |
ID of the row relationship |
ROW_RELATIONSHIP_NAME |
VARCHAR2(255) |
Name of the row relationship |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the row relationship |
REMOTE_KEY_ID |
NUMBER(9) |
ID of the other row relationship |
IS_DISCOVERED |
CHAR(3) |
If this row relationship was discovered |
IS_DOCUMENTED |
CHAR(2) |
If this row relationship is documented |
LOCAL_MAX_CARDINALITY |
VARCHAR2(40) |
Maximum number of values found on the local side |
LOCAL_MIN_CARDINALITY |
VARCHAR2(40) |
Minimum number of values found on the local side |
REMOTE_MAX_CARDINALITY |
VARCHAR2(40) |
Maximum number of values found on the remote side |
REMOTE_MIN_CARDINALITY |
VARCHAR2(40) |
Minimum number of values found on the remote side |
NUM_ORPHANS |
VARCHAR2(40) |
Number of distinct values found in the local column but not in the remote column |
COMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that satisfy the discovered row relationship |
COMPLIANT_CNT_QUERY |
VARCHAR2(4000) |
Not used |
NONCOMPLIANT_QUERY |
VARCHAR2(4000) |
The query used to get the rows that do not satisfy the discovered common format |
NONCOMPLIANT_CNT_QUERY |
VARCHAR2(4000) |
Not used |
DRILLDOWN_QUERY |
VARCHAR2(4000) |
The query used to get all the rows of the table but distinguishes which row satisfies the discovered row relationship and which does not |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
CLASSTYPENAME |
VARCHAR2(255) |
Object type name |
PUSAGEID |
NUMBER(9) |
ID of the usage definition of the property. (The attributes of a property may be context specific. For example, columns of an external table may have different properties, or the properties may have different constraints.) |
PDEFID |
NUMBER(9) |
ID of the property definition |
PROPNAME |
VARCHAR2(255) |
The name of the property as used in OMB*Plus |
PUSAGETYPE |
VARCHAR2(7) |
Property type for this usage, which determines where it is automatically displayed in the UI: CORE: Not displayed LOGICAL: Editor Property Inspector CONFIG: Configuration Property Inspector USERDEF: User Defined Properties tab |
STORAGETYPE |
VARCHAR2(7) |
Storage type for this property, which determines how it is physically stored: CORE: Column of object row LOGICAL: Child row of object CONFIG: Child row of configuration of object USERDEF: Child row of object |
DATATYPE |
NUMBER |
ID for the data type of this usage |
TYPENAME |
VARCHAR2(255) |
Data type name of this usage |
HIDDEN |
VARCHAR2(4000) |
Is this usage shown in the UI (PropertyInspector)? Value is true or false |
PUBLISHTOPUBLICAPI |
VARCHAR2(4000) |
Is this usage included in OMB*Plus scripting documentation? Value is true or false |
CONTRIBUTETOSIGNATURE |
VARCHAR2(4000) |
Do changes in this property affect the semantic value of the owning object with respect to mapping or deployment? That is, would a change in the value of this property require the owning object to be regenerated before being deployed. Value is true or false |
DYNAMICDEFAULT |
VARCHAR2(4000) |
Fully qualified name of the Java class providing the value for this property if it has not been set. This is called each time the property value is requested. (If this value is defined, then the value shown in the DEFAULTVALUE column should be considered invalid.) |
DEFAULTVALUE |
VARCHAR2(4000) |
The static, default value for the usage. The primary default value of usage, property, domain, and primitive type, in that order. DYNAMIC DEFAULT takes precedence if defined. (Note that Null is not used as an indicator for this because Null is a potential legitimate value, and is specifically the default for any reference property) |
PSETID |
NUMBER(9) |
The ID of the property set containing this usage. (Property sets are the context grouping mechanism for usage definitions. Usage type is actually defined at the property set level.) |
PSETNAME |
VARCHAR2(255) |
The name of the property set containing this usage. (Also referred to as the selector key – generally gives indication of the context in which this property set is active. For example, maps have different sets based on generation language with the names SQLLOADER, PLSQL, ABAP, and so on. The value DEFAULT indicates the name selector mechanism is not used for this property set.) |
PSETCLASSNAME |
VARCHAR2(255) |
Type name of the parent context for this property set. If defined, this property set is only active when the owning object is a child of an object of this type. For example, Index has different configuration property sets for the child object of Table or Materialized View |
NLSKEY |
VARCHAR2(255) |
NLS lookup key base for localized property name, description |
DESCRIPTION |
VARCHAR2(4000) |
Description of the usage from the definition file. Usually the same as the default <NLSKEY>:DESCRIPTION (English) shown in the UI/OMB*Plus. |
GROUPID |
NUMBER(9) |
The ID of the display group for this property. Used only in the UI (Property Inspector category) |
GROUPNAME |
VARCHAR2(255) |
Name of the group from the definition file. Usually in uppercase, with the spaces converted to underscore. Version of the default <GROUPDEFINITIONKEY>:NAME (English) shown in the property inspector |
GROUPDEFINITIONKEY |
VARCHAR2(255) |
The NLS lookup key base for localized group name |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-196 ALL_IV_FLD_CONTAINED_OBJECTS
Column Name | Data Type | Description |
---|---|---|
FOLDER_ID |
NUMBER (9) |
ID of the folder |
FOLDER_NAME |
VARCHAR2(1000) |
Name of the folder |
CONTAINED_OBJECT_ID |
NUMBER(9) |
ID of the object contained in the folder |
CONTAINED_OBJECT_NAME |
VARCHAR2(1000) |
Name of the object contained in the folder |
DESCRIPTION |
VARCHAR2(4000) |
Description |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name |
CONTAINED_OBJECT_PATH |
VARCHAR2(4000) |
Path of the contained object |
REFERENCED_OBJECT_TYPE |
VARCHAR2(4000) |
Type of the referenced object |
REFERENCED_OBJECT_ID |
NUMBER(9) |
ID of the referenced object |
REFERENCED_OBJECT_NAME |
VARCHAR2(1000) |
Name of the referenced object |
CONTAINED |
CHAR(1) |
Flag to indicate if it is contained |
IS_CONTAINED |
VARCHAR2(7) |
Is contained |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Data Type | Description |
---|---|---|
OWNER_ID |
NUMBER(9) |
ID of the owner |
OWNER_NAME |
VARCHAR2(1000) |
Name of the owner |
FOLDER_ID |
NUMBER(9) |
ID of the folder |
FOLDER_NAME |
VARCHAR2(1000) |
Name of the folder |
BUSINESS_NAME |
VARCHAR2(1000) |
Business Name |
DESCRIPTION |
VARCHAR2(4000) |
Description |
VALID |
CHAR(1) |
Flag to indicate if it is valid |
IS_VALID |
VARCHAR2(13) |
Is valid |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-198 ALL_IV_DATABASE_MODULES
Column Name | Datatype | Description |
---|---|---|
PROJECT_ID |
NUMBER(9) |
ID of the project |
PROJECT_NAME |
VARCHAR2(1000) |
Name of the project |
INFORMATION_SYSTEM_ID |
NUMBER(9) |
ID of the information system |
INFORMATION_SYSTEM_NAME |
VARCHAR2(1000) |
Name of the information system |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name |
DESCRIPTION |
VARCHAR2(4000) |
Description |
DATABASE_LINK |
VARCHAR2(40) |
Database link |
STRONG_TYPE_NAME |
VARCHAR2(255) |
Strong type name |
PLATFORM_ID |
NUMBER(9) |
Platform ID |
PLATFORM_NAME |
VARCHAR2(1000) |
Platform Name |
VALID |
CHAR(1) |
Flag to indicate if it is valid |
IS_VALID |
VARCHAR2(13) |
Is valid |
STATUS |
VARCHAR2(40) |
Status |
LOCATION_ID |
NUMBER(9) |
Location ID |
LOCATION_NAME |
VARCHAR2(1000) |
Location Name |
METADATA_LOCATION_ID |
NUMBER(9) |
ID of the Metadata Location |
METADATA_LOCATION_NAME |
VARCHAR2(1000) |
Name of the Metadata Location |
MODULE_TYPE |
VARCHAR2(1000) |
Module Type |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-199 ALL_IV_CLASS_DEFINITIONS
Column Name | Datatype | Description |
---|---|---|
CLASS_DEFINITION_ID |
NUMBER (9) |
ID of the class definition |
CLASS_DEFINITION_NAME |
VARCHAR2 (1000) |
Name of the class definition |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the class definition |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the class definition |
OWNING_MODEL |
VARCHAR2 (1000) |
Owning model |
OWNING_MODEL_ID |
NUMBER (9) |
Owning model ID |
SCRIPTING_NAME |
VARCHAR2 (1000) |
Scripting name |
ABSTRACT |
CHAR (1) |
Flag |
CLASS_TYPE |
VARCHAR2 (20) |
Class type |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER (9) |
ID of the schema |
SCHEMA_NAME |
VARCHAR2 (1000) |
Schema name |
ENTITY_ID |
NUMBER (9) |
ID of the entity |
ENTITY_TYPE |
VARCHAR2 (4000) |
Entity type |
ENTITY_NAME |
VARCHAR2 (1000) |
Entity name |
ATTRIBUTE_SET_NAME |
VARCHAR2 (1000) |
Name of the attribute set |
ATTRIBUTE_SET_ID |
NUMBER (9) |
Attribute set ID |
ATTRIBUTE_NAME |
VARCHAR2 (1000) |
Name of the attribute |
POSITION |
NUMBER (9) |
Position of the attribute |
ATTRIBUTE_ID |
NUMBER (9) |
Attribute ID |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the attribute |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the attribute |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-201 ALL_IV_ATTRIBUTE_SETS
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER (9) |
Schema ID |
SCHEMA_NAME |
VARCHAR2 (1000) |
Name of the schema |
ENTITY_ID |
NUMBER (9) |
Entity ID |
ENTITY_TYPE |
VARCHAR2 (4000) |
Entity type |
ENTITY_NAME |
VARCHAR2 (1000) |
Name of the entity |
ATTRIBUTE_SET_NAME |
VARCHAR2 (1000) |
Name of the attribute set |
ATTRIBUTE_SET_ID |
NUMBER (9) |
Attribute set ID |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the attribute set |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the attribute set |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-202 ALL_IV_XFORM_MAP_GROUPS
Column Name | Datatype | Description |
---|---|---|
MAP_ID |
NUMBER (9) |
ID of the map |
MAP_NAME |
VARCHAR2 (1000) |
Name of the map |
MAP_COMPONENT_ID |
NUMBER (9) |
ID of the map component |
MAP_COMPONENT_NAME |
VARCHAR2 (1000) |
Name of the map component |
PARAMETER_GROUP_ID |
NUMBER (9) |
ID of the parameter group |
PARAMETER_GROUP_NAME |
VARCHAR2 (1000) |
Name of the parameter group |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the map |
PARAMETER_GROUP_TYPE |
VARCHAR2 (5) |
Parameter group type |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the Map |
POSITION |
NUMBER (9) |
Position of the map |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-203 ALL_IV_WORKSPACE_ASSIGNMENTS
Column Name | Datatype | Description |
---|---|---|
WORKSPACE_ID |
NUMBER (9) |
ID of the workspace |
WORKSPACE_NAME |
VARCHAR2 (1000) |
Name of the workspace |
WORKSPACE_BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the workspace |
WORKSPACE_DESCRIPTION |
VARCHAR2 (4000) |
Description of the workspace |
USER_NAME |
VARCHAR2 (1000) |
User name |
ISWORKSPACEOWNER |
CHAR (1) |
Flag to indicate if the user is workspace owner |
USER_CREATEDBY |
VARCHAR2 (40) |
User created by |
USER_CREATIONTIMESTAMP |
DATE |
Timestamp when user is created |
USER_UPDATEBY |
VARCHAR2 (40) |
Updated by |
USER_UPDATETIMESTAMP |
DATE |
Update timestamp |
Column Name | Datatype | Description |
---|---|---|
WORKSPACE_ID |
NUMBER (9) |
Workspace ID |
WORKSPACE_NAME |
VARCHAR2 (1000) |
Workspace name |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the workspace |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the workspace |
WORKSPACE_OWNER |
VARCHAR2 (1000) |
Owner of the workspace |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-205 ALL_IV_SUBPARTITION_TEMPLATES
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER (9) |
Schema ID |
SCHEMA_NAME |
VARCHAR2 (1000) |
Name of the schema |
ENTITY_ID |
NUMBER (9) |
Entity ID |
ENTITY_TYPE |
VARCHAR2 (4000) |
Type of entity |
ENTITY_NAME |
VARCHAR2 (1000) |
Name of the entity |
PARTITION_ID |
NUMBER (9) |
Partition ID |
PARTITIONING_TYPE |
VARCHAR2 (40) |
Type of partition |
NAME |
VARCHAR2 (1000) |
Name |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name |
DESCRIPTION |
VARCHAR2 (4000) |
Description |
POSITION |
VARCHAR2 (40) |
Position of partition |
VALUE_CLAUSE |
VARCHAR2 (4000) |
Value clause |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-206 ALL_IV_SUBPARTITIONS
Column Name | Datatype | Description |
---|---|---|
ENTITY_ID |
NUMBER (9) |
Entity ID |
ENTITY_TYPE |
VARCHAR2 (4000) |
Type of entity |
ENTITY_NAME |
VARCHAR2 (1000) |
Name of the entity |
PARENT_PARTITION_ID |
NUMBER (9) |
ID of the parent partition |
PARENT_NAME |
VARCHAR2 (1000) |
Name of the parent |
PARTITIONING_TYPE |
VARCHAR2 (40) |
Type of partitioning |
SUBPARTITION_ID |
NUMBER (9) |
ID of the subpartition |
NAME |
VARCHAR2 (1000) |
Name of the subpartition |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the subpartition |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the subpartition |
POSITION |
VARCHAR2 (40) |
Position of the subpartition |
VALUE_CLAUSE |
VARCHAR2 (4000) |
Value clause |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-207 ALL_IV_SUBPARTITION_KEYS
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER (9) |
Schema ID |
SCHEMA_NAME |
VARCHAR2 (1000) |
Name of the schema |
ENTITY_ID |
NUMBER (9) |
Entity ID |
ENTITY_TYPE |
VARCHAR2 (4000) |
Type of entity |
ENTITY_NAME |
VARCHAR2 (1000) |
Name of the entity |
PARTITIONING_TYPE |
VARCHAR2 (40) |
Partition type |
SUBPARTITION_KEY_COLUMN_ID |
NUMBER (9) |
ID of the subpartition key column |
SUBPARTITION_KEY_COLUMN |
VARCHAR2 (1000) |
Name |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the subpartition key |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the subpartition key |
POSITION |
NUMBER (9) |
Position of the subpartition key |
COUNT |
NUMBER (9) |
Count |
HASH_PARTITION_QUANTITY |
VARCHAR2 (40) |
Hash partition quantity |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-208 ALL_IV_PROPERTY_DEFINITIONS
Column Name | Datatype | Description |
---|---|---|
PROPERTY_DEFINITION_ID |
NUMBER (9) |
Property definition ID |
PROPERTY_DEFINITION_NAME |
VARCHAR2 (1000) |
Name of the property definition |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the property definition |
PREDEFINED |
CHAR (1) |
Flag to indicate if its predefined. |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the property definition |
OWNING_CLASS |
VARCHAR2 (1000) |
Owning class |
OWNING_CLASS_ID |
NUMBER (9) |
Owning class ID |
OWNING_PROPERTY_SET_ID |
NUMBER (9) |
ID of the owning property set |
DEFAULT_VALUE |
VARCHAR2 (4000) |
Default value |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER (9) |
Schema ID |
SCHEMA_NAME |
VARCHAR2 (1000) |
Name of the schema |
ENTITY_ID |
NUMBER (9) |
Entity ID |
ENTITY_TYPE |
VARCHAR2 (4000) |
Type of entity |
ENTITY_NAME |
VARCHAR2 (1000) |
Name of the entity |
PARTITION_ID |
NUMBER (9) |
Partition ID |
PARTITION_TYPE |
VARCHAR2 (40) |
Type of partition |
NAME |
VARCHAR2 (1000) |
Partition name |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the partition |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the partition |
POSITION |
VARCHAR2 (40) |
Position of the partition |
VALUE_CLAUSE |
VARCHAR2 (4000) |
Value clause |
HASH_SUBPARTITION_COUNT |
VARCHAR2 (40) |
Hash subpartition count |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Datatype | Description |
---|---|---|
PLATFORM_ID |
NUMBER (9) |
ID of the platform |
PLATFORM_NAME |
VARCHAR2 (1000) |
Name of the platform |
BUSINESS_NAME |
VARCHAR2 (1000) |
Business name of the platform |
DESCRIPTION |
VARCHAR2 (4000) |
Description of the platform |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-211 ALL_IV_PARTITION_KEYS
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
Schema ID |
SCHEMA_NAME |
VARCHAR2(1000) |
Name of the schema |
ENTITY_ID |
NUMBER(9) |
Entity ID |
ENTITY_TYPE |
VARCHAR2(4000) |
Type of entity |
ENTITY_NAME |
VARCHAR2(1000) |
Name of the entity |
PARTITIONING_TYPE |
VARCHAR2(40) |
Partitioning type |
PARTITION_KEY_COLUMN_ID |
NUMBER(9) |
ID of the partition key column |
PARTITION_KEY_COLUMN |
VARCHAR2(1000) |
Partition key column |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the partition key |
DESCRIPTION |
VARCHAR2(4000) |
Description of the partition key |
POSITION |
NUMBER(9) |
Position |
COUNT |
NUMBER(9) |
Count |
HASH_PARTITION_QUANTITY |
VARCHAR2(40) |
Hash partition quantity |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-212 ALL_IV_INDEX_PARTITIONS
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
Schema ID |
SCHEMA_NAME |
VARCHAR2(1000) |
Name of the schema |
ENTITY_ID |
NUMBER(9) |
Entity ID |
ENTITY_TYPE |
VARCHAR2(4000) |
Type of entity |
ENTITY_NAME |
VARCHAR2(1000) |
Name of the entity |
INDEX_ID |
NUMBER(9) |
ID of the index |
INDEX_NAME |
VARCHAR2(1000) |
Name of the index |
INDEX_TYPE |
VARCHAR2(40) |
Type of index |
INDEX_PARTITIONING_TYPE |
VARCHAR2(40) |
Index partitioning type |
PARTITION_ID |
NUMBER(9) |
Partition ID |
NAME |
VARCHAR2(1000) |
Name of the partition |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the partition |
DESCRIPTION |
VARCHAR2(4000) |
Description of the partition |
POSITION |
VARCHAR2(40) |
Position |
VALUE_CLAUSE |
VARCHAR2(4000) |
Value clause |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 2-213 ALL_IV_INDEX_PARTITION_KEYS
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
Schema ID |
SCHEMA_NAME |
VARCHAR2(1000) |
Name of the schema |
ENTITY_ID |
NUMBER(9) |
Entity ID |
ENTITY_TYPE |
VARCHAR2(4000) |
Type of entity |
ENTITY_NAME |
VARCHAR2(1000) |
Name of the entity |
INDEX_NAME |
VARCHAR2(1000) |
Name of the index |
INDEX_PARTITIONING_TYPE |
VARCHAR2(40) |
Index partitioning type |
INDEX_ID |
NUMBER(9) |
Index ID |
INDEX_PARTITION_KEY_COLUMN_ID |
NUMBER(9) |
Column ID of the index partition key |
INDEX_PARTITION_KEY_COLUMN |
VARCHAR2(1000) |
Index partition key column |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the partition key |
DESCRIPTION |
VARCHAR2(4000) |
Description of the partition key |
POSITION |
NUMBER(9) |
Position |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |
Column Name | Datatype | Description |
---|---|---|
SCHEMA_ID |
NUMBER(9) |
Schema ID |
SCHEMA_NAME |
VARCHAR2(1000) |
Name of the schema |
ENTITY_ID |
NUMBER(9) |
Entity ID |
ENTITY_TYPE |
VARCHAR2(4000) |
Type of entity |
ENTITY_NAME |
VARCHAR2(1000) |
Name of the entity |
INDEX_NAME |
VARCHAR2(1000) |
Index name |
INDEX_ID |
NUMBER(9) |
Index ID |
INDEX_TYPE |
VARCHAR2(40) |
Type of index |
INDEX_KEY_COLUMN_ID |
NUMBER(9) |
ID of the index key column |
INDEX_KEY_COLUMN |
VARCHAR2(1000) |
Index key column |
BUSINESS_NAME |
VARCHAR2(1000) |
Business name of the index key |
DESCRIPTION |
VARCHAR2(4000) |
Description of the index key |
POSITION |
NUMBER(9) |
Position of Index |
UPDATED_ON |
DATE |
Update timestamp |
CREATED_ON |
DATE |
Creation timestamp |
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
CREATED_BY |
VARCHAR2(40) |
Created by user |