G
OWB Public View Tables Management

Table G-1 ALL_IV_INSTALLATIONS 

Column Name	Data Type	Description
installation_id	Number(9)	object ID
installation_name	Varchar2(255)	name of the project
business_name	Varchar2(4000)	display name for the project
description	Varchar2(4000)
installed_version	Varchar2(2000)
release	Varchar2(40)
repository_model_version	Number(9)
public_view_version	Char(6)	Version ID of the public SQL views
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-2 ALL_IV_PROJECTS  

Column Name	Data Type	Description
project_id	Number(9)	object ID
project_name	Varchar2(255)	name of the project
business_name	Varchar2(4000)	display name for the project
description	Varchar2(4000)	description
version_label	Varchar2(255)	label representing the project version
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-3 ALL_IV_INFORMATION_SYSTEMS 

Column Name	Data Type	Description
project_id	Number(9)	object ID
project_name	Varchar2(255)	name of the project that
information_system_id	Number(9)	Object ID of the information system
information_system_name	Varchar2(255)	Name of the information system
business_name	Varchar2(4000)	display name for the information system
description	Varchar2(4000)	description for the information system
product_type	Varchar2(255)	This is the application product type
system_type	Varchar2(255)	System type
version_label	Number(9)
vendor	Varchar2(2000)	This is optional. This would return `Oracle', `SAP'.
database_link	Varchar2(40)	this helps connect to the physical external data source. For data warehouse information systems this is optional. Typically, if a warehouse has been created based on the design of an external database schema, this would be populated for warehouses as well.
integrator_name	Varchar2(255)	Name of the integrator. For each Information System there is one and only one Integrator specified
is_valid	Varchar2(7)
status	Varchar2(40)	The status of the information system. Warehouse Builder supports Production, Development and Quality Assurance
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Data Model

Table G-4 ALL_IV_SCHEMAS 

Column Name	Data Type	Description
project_id	Number(9)	Project ID
project_name	Varchar2(255)	name of the project that the schema is in
schema_id	Number(9)	Identifier for the schema
schema_name	Varchar2(255)	name of the schema
business_name	Varchar2(4000)	display name for the schema
description	Varchar2(4000)	description
is_valid	Varchar2(7)
information_system_id	Number(9)	The information system which this schema belongs to
information_system_name	Varchar2(255)	The name of the information system
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-5 ALL_IV_DIMENSIONS 

Column Name	Data Type	Description
schema_id	Number(9)	Owner (schema) of the dimension
schema_name	Varchar2(255)	Name of the schema
dimension_id	Number(9)	Object ID of the dimension
dimension_name	Varchar2(255)	Name of the dimension
business_name	Varchar2(4000)	display name
plural_name	Varchar2(40)	plural name for the dimension used for reporting purposes
description	Varchar2(4000)	Description for dimension
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-6 ALL_IV_DIM_LEVELS 

Column Name	Data Type	Description
dimension_id	Number(9)	ID of the dimension
dimension_name	Varchar2(255)	Name of the dimension
level_id	Number(9)	object ID
level_name	Varchar2(255)	Level name. Unique within a dimension
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	Description for level
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-7 ALL_IV_DIM_LEVEL_ATTRIBUTES 

Column Name	Data Type	Description
level_id	Number(9)	ID of the dimension level
level_name	Varchar2(255)	Name of the dimension level
attribute_id	Number(9)	Object ID
attribute_name	Varchar2(255)	Unique within a dimension level
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	Description for dimension attribute
position	Number(9)	position of the level attribute within a level
data_type	Varchar2(255)	Data type of the level attribute
length	Number(9)	length of the attribute
precision	Number(9)	precision of the attribute
scale	Number(9)	scale of the attribute
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-8 ALL_IV_DIM_HIERARCHIES 

Column Name	Data Type	Description
dimension_id	Number(9)	ID of the dimension
dimension_name	Varchar2(255)	Name of the dimension
hierarchy_id	Number(9)	Object ID
hierarchy_name	Varchar2(255)	Hierarchy name
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	Description for the hierarchy
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-9 ALL_IV_DIM_HIERARCHY_LEVELS 

Column Name	Data Type	Description
level_use_id	Number(9)	Object ID that represents a particular use of a level within a hierarchy
hierarchy_id	Number(9)	ID of the hierarchy
hierarchy_name	Varchar2(255)	Hierarchy name
level_id	Number(9)	ID of the level
level_name	Varchar2(255)	Name of the level
position	Number	Hierarchical position within this hierarchy, position 1 being the most detailed

Table G-10 ALL_IV_CUBES 

Column Name	Data Type	Description
schema_id	Number(9)	schema of the cube
schema_name	Varchar2(255)	name of the schema
cube_id	Number(9)	object ID of the cube
cube_name	Varchar2(255)	Name of the cube
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	Description for cube
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-11 ALL_IV_CUBE_MEASURES 

Column Name	Data Type	Description
cube_id	Number(9)	ID of the cube
cube_name	Varchar2(255)	Name of the cube
measure_id	Number(9)	object ID of the measure
measure_name	Varchar2(255)	Name of the measure
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	Description for measure
position	Number(9)	position of the measure within the cube
data_type	Varchar2(255)	data type of the measure
length	Number(9)	length of the attribute
precision	Number(9)	precision of the attribute
scale	Number(9)	scale of the attribute
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-12 ALL_IV_CUBE_MEASURE_DIM_USES 

Column Name	Data Type	Description
cube_id	Number(9)	Object ID
cube_name	Varchar2(255)	Name of the cube
measure_id	Number	ID of the measure
measure_name	Varchar2(255)	Name of the measure
dimension_id	Number	ID of the dimension
dimension_name	Varchar2(255)	name of dimension
dimension_alias	Varchar2(255)	alias of dimension

Table G-13 ALL_IV_TABLES 

Column Name	Data Type	Description
schema_id	Number(9)	Owner of the table
schema_name	Varchar2(255)	Name of the schema
table_id	Number(9)	object ID of the table
table_name	Varchar2(255)	Name of the table
business_name	Varchar2(4000)	Logical - business name for this object
description	Varchar2(4000)	description
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-14 ALL_IV_VIEWS 

Column Name	Data Type	Description
schema_id	Number(9)	Owner of the view
schema_name	Varchar2(255)	Name of the schema
view_id	Number(9)	object ID of the view
view_name	Varchar2(255)	name of the view
business_name	Varchar2(4000)	Logical - business name for this object
description	Varchar2(4000)	description
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-15 ALL_IV_MATERIALIZED_VIEWS 

Column Name	Data Type	Description
schema_id	Number(9)	Owner of the view
schema_name	Varchar2(255)	Name of the schema
view_id	Number(9)	object ID of the view
view_name	Varchar2(255)	name of the view
business_name	Varchar2(4000)	Logical - business name for this object
description	Varchar2(4000)	description
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-16 ALL_IV_SEQUENCES 

Column Name	Data Type	Description
schema_id	Number(9)	Owner of the sequence table
schema_name	Varchar2(255)	Name of the schema
sequence_id	Number(9)	Object ID of the key
sequence_name	Varchar2(255)	Name of the sequence
business_name	Varchar2(4000)	Display name Note: This will more then likely be equal to the name of the sequence.
description	Varchar2(4000)	description
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-17 ALL_IV_KEYS 

Column Name	Data Type	Description
entity_id	Number(9)	ID of the entity that this key is attached to
entity_type	Varchar2(4000)
entity_name	Varchar2(255)	Name of the entity that the key is attached to
key_id	Number(9)
key_name	Varchar2(255)	Name of the foreign key
business_name	Varchar2(4000)	Display name of the key
description	Varchar2(4000)	description
schema_id	Number(9)	Owner of the constraint
schema_name	Varchar2(255)	Name of the schema
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-18 ALL_IV_FOREIGN_KEYS 

Column Name	Data Type	Description
entity_id	Number(9)	ID of the entity that this key is attached to
entity_type	Varchar2(4000)
entity_name	Varchar2(255)	Name of the entity that the key is attached to
foreign_key_name	Varchar2(255)	Name of the foreign key
foreign_key_id	Number(9)	Object ID
business_name	Varchar2(4000)	Display name of the key
description	Varchar2(4000)	description
key_id	Number(9)	Id of the key that this foreign key is pointing to
key_name	Varchar2(255)	Name of the key that this foreign key is pointing to
schema_id	Number(9)	Owner of the constraint
schema_name	Varchar2(255)	Name of the schema
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-19 ALL_IV_KEY_COLUMN_USES 

Column Name	Data Type	Description
key_id	Number(9)	Object ID of the key
key_type	Varchar2(11)
key_name	Varchar2(255)	Name of the foreign key
column_id	Number(9)	ID of the column
column_name	Varchar2(255)	Name of the key column
position	Number(9)	Ordinal position of the key column within the key.

Table G-20 ALL_IV_COLUMNS 

Column Name	Data Type	Description
entity_id	Number(9)	ID of the entity that this key is attached to
entity_type	Varchar2(4000)
entity_name	Varchar2(255)	Name of the entity that the key is attached to
column_id	Number(9)	Object ID of the column
column_name	Varchar2(255)	Name of the column
business_name	Varchar2(4000)	Logical - business name for this object
description	Varchar2(4000)	description
position	Number(9)	position of the column within the table
data_type	Varchar2(255)	Data type of the column
length	Number(9)	length of the column
precision	Number(9)	precision of the column
scale	Number(9)	scale of the column
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Implementation Model

Table G-21 ALL_IV_DIM_IMPLS 

Column Name	Data Type	Description
implementation_id	Number(9)	Object ID of the dimension implementation
item_id	Number(9)	Object ID of the dimensional item
item_type	Char(15)	Type of item
item_name	Varchar2(255)	Name of the dimensional item
dimension_id	Number(9)	ID of the dimension
dimension_name	Varchar2(255)	Name of the dimension
column_id	Number(9)	ID of the column
column_name	Varchar2(255)	object ID
position	Number(9)	e.g. Position of the level attribute column. Note that Oracle8 attribute is single column.
table_id	Number(9)	Object ID of the table
table_name	Varchar2(255)	Name of the table that owns the column

Table G-22 ALL_IV_CUBE_IMPLS 

Column Name	Type	Description
implementation_id	Number(9)	Object ID of the cube map Note: Exception to the naming convention rules: No map_name column exists.
item_id	Number(9)	Object ID of the cube item
item_type	Varchar2(18)	Type of item
item_name	Varchar2(255)	Name of the cube item
cube_id	Number(9)	ID of the cube
cube_name	Varchar2(255)	Name of the cube
dimension_id	Number	ID of the dimension that CUBE_DIM_USE is pointing to
dimension_name	Varchar2(255)	Name of the dimension
dimension_alias	Varchar2(255)	Alias of the dimension
column_id	Number	ID of the column
column_name	Varchar2(255)	object ID
position	Number	e.g. Position of the level attribute column. Note that Oracle8 attribute is single column.
table_id	Number(9)	Object ID of the table
table_name	Varchar2(255)	Name of the table that owns the column or foreign key
foreign_key_id	Number	ID of the foreign key
foreign_key _name	Varchar2(255)	object ID
dim_implementation_id	Number	Object ID of the dimension map that this foreign key relies on (map dependency from the CWM model)

Flat File/Record Model

Table G-23 ALL_IV_FILES 

Column Name	Type	Description
information_system_ID	Number(9)	Object ID of the information system
information_system_name	Varchar2(255)	Name of the information system
file_id	Number(9)	Object ID of the file
file_name	Varchar2(255)	Name of the file
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	description
is_valid	Varchar2(7)
record_classifier_position	Number(9)	When a file consists of multiple record types, each row of information read from the file contains a field that encodes the record type of the data row. This points to the position of that field.
record_classifier_length	Number(9)	This returns the length of the field that acts as record classifier.
record_size	Number(9)	This indicates the maximum size of a record for non delimited files.
n_physical_records_in_logical	Number(9)	The number of physical records that make up a logical record. This is only used where a fixed number of physical records make up a logical record.
Continuation_at_end	Char(1)	If the continuation string is given, this indicates when the continuation string is found at the end of the physical record. If false the continuation string will be at the start.
Continuation_delimiter	Varchar2(40)	When the number of physical records per logical record is variable, this indicates how a continuation record is identified. Note that this is more like a physical record delimiter when compared to recordDelimiter which is logical.
is_self_describing	Char(1))	True if fields in the first record contain column names applicable to subsequent records. Source from hasFieldNamesInFirstRow (will be added to Warehouse Builder).
is_fixed_width	Char(1)	Indicates that all records are of the same fixed length.
record_delimiter	Varchar2(40)	The string that delimits a record. If this is not set then the RecordSize should be used to determine the end of a record.
text_start_delimiter	Varchar2(40)	The delimiter of a text string in the record such as a quote.
text_end_delimiter	Varchar2(40)
updated_on	Date	The time the object was last modified.
created_on	Date	The time this object was created.

Table G-24 ALL_IV_RECORDS 

Column Name	Type	Description
file_id	Number(9)	Object ID of the file
file_name	Varchar2(255)	Name of the file
record_id	Number(9)	Object ID of the record
record_name	Varchar2(255)	Name of the record
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	description
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-25 ALL_IV_FIELDS 

Column Name	Type	Description
record_id	Number(9)	Object ID of the record
record_name	Varchar2(255)	Name of the record
field_id	Number(9)	ID for the field
field_name	Varchar2(255)	Name of the field
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	description
position	Number(9)	position of the field within the record
data_type	Varchar2(255)	Data type of the field
length	Number(9)	length of the field
precision	Number(9)	precision of the field
scale	Number(9)	scale of the field
picture	Varchar2(40)	Picture clause
sign_type	Number(9)	The type of sign
usage	Varchar2(40)	How data is stored internally
occurs	Number(9)
structure _id	Number(9)	This is a foreign key to the parent field (structure)
structure_name	Varchar2(255)	Name of the parent field (structure)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Impact Analysis/Data Lineage Model

Table G-26 ALL_IV_ALL_OBJECTS 

Column Name	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
business_name	Varcahr2(4000)	Display name for the object
context_name	Varcahr2(4000)	The fully qualified name for the object. For example a table ORDERS in schema OP in project MyProject would be MyProject.OP.ORDERS
description	Varchar2(4000)	description
parent_object_id	Number	Object ID of the parent
parent_object_type	Varchar2(4000)	Type of the parent object
parent_object_name	Varchar2(4000)	Name of the parent object. For example, Table is considered to be parent of Column, Dimension is considered to be parent of Level, and Level Attribute, Cube is considered to be parent of Measures, EntityMap is considered to be parent of ItemMaps, etc.
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-27 ALL_IV_IMPACT_DEPENDENTS 

Column Name	Type	Description
object_id	Number	Object ID of the object whose dependents are listed
object_type	Varchar2(4000)	Type of the object
object_name	Varchar2(255)	Name of the object.
business_name	Varchar2(4000)	display name of the object
context_name	Varcahr2(4000)	The fully qualified name for the object. For example a table ORDERS in schema OP in project MyProject would be MyProject.OP.ORDERS
description	Varchar2(4000)	description
parent_object_id	Number	Object ID of the parent
parent_object_type	Varchar2(4000)	Type of the parent object
parent_object_name	Varchar2(4000)	Name of the parent object. For example, Table is considered to be parent of Column, Dimension is considered to be parent of Level, and Level Attribute, Cube is considered to be parent of Measures, EntityMap is considered to be parent of ItemMaps.
dep_object_id	Number	ID of the dependent object
dep_object_type	Varchar2(4000)	type of the dependent object
dep_object_name	Varchar2(255)	Name of the dependent object
dep_object_business_name	Varchar2(4000)	Display name for the dependent object
dep_object_context_name	Varchar2(4000)	Display name for the dependent object
dep_expression	Varchar2(4000)	If a dependent object has an expression, it will be returned here. For example, if a column x is the result of a function `h=g+1' and x is wired to h, when you get the dependents of x, you will get h together with the `h=g+1' expression In addition, if the dependent object is an item (e.g.`column'), where an entity level expression (such as a filter or join condition on the stage component) applies, this expression will also be returned with each item (e.g. stage component parameter) that is aggregated by that entity (e.g. stage component) Suggestion: that the expressions coming from the entities are prefixed by the type of expression. for example: "FILTER:d>1'. This way, we can differentiate what immediately applies to the item and what comes from the parent entity. Strong Recommendation: Replace %1 %2... with the actual argument names.
dep_object_parent_id	Number	ID of the dependent object
dep_object_parent_type	Varchar2(4000)	type of the dependent object
dep_object_parent_name	Varchar2(4000)	Name of the dependent object
dep_object_operator_type	Varchar2(4000)	Name of the dependent object

Table G-28 ALL_IV_LINEAGE_DEPENDENTS 

Column Name	Type	Description
object_id	Number	Object ID of the object whose dependents are listed
object_type	Varchar2(4000)	Type of the object
object_name	Varchar2(255)	Name of the object
business_name	Varchar2(4000)	display name of the object
context_name	Varcahr2(4000)	The fully qualified name for the object. For example a table ORDERS in schema OP in project MyProject would be MyProject.OP.ORDERS
description	Varchar2(4000)	description
parent_object_id	Number	Object ID of the parent
parent_object_type	Varchar2(4000)	Type of the parent object
parent_object_name	Varchar2(4000)	Name of the parent object. For example, Table is considered to be parent of Column, Dimension is considered to be parent of Level, and Level Attribute, Cube is considered to be parent of Measures, EntityMap is considered to be parent of ItemMaps, etc.
dep_object_id	Number	ID of the dependent object
dep_object_type	Varchar2(4000)	type of the dependent object
dep_object_name	Varchar2(255)	Name of the dependent object
dep_object_business_name	Varchar2(4000)	Display name for the dependent object
dep_object_context_name	Varchar2(4000)
dep_expression	Varchar2(4000)	If a dependent object has an expression, it will be returned here. For example, if a column x is the result of a function `h=g+1' and x is wired to h, when you get the dependents of x, you will get h together with the `h=g+1' expression. In addition, if the dependent object is an item (e.g.`column'), where an entity level expression (such as a filter or join condition on the stage component) applies, this expression will also be returned with each item (e.g. stage component parameter) that is aggregated by that entity (e.g. stage component) Suggestion: that the expressions coming from the entities are prefixed by the type of expression. for example: "FILTER:d>1'. This way, we can differentiate what immediately applies to the item and what comes from the parent entity. Strong Recommendation: Replace %1 %2... with the actual argument names.
dep_object_parent_id	Number	ID of the dependent object
dep_object_parent_type	Varchar2(4000)	type of the dependent object
dep_object_parent_name	Varchar2(4000)	Name of the dependent object
dep_object_operator_type	Varchar2(4000)

Classification Model

Table G-29 ALL_IV_CLASSIFICATIONS 

Column Name	Type	Description
information_system_id	Number(9)	Object ID of the information system
information_system_name	Varchar2(255)	Name of the information system
classification_id	Number(9)	Object ID of the catalog
classification_name	Varchar2(255)	Name of the catalog. May be null if the root of the catalog tree.
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	description
classification_type	Varchar2(14)	Type of the classification
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-30 ALL_IV_CLASSIFICATION_ITEMS 

Column Name	Type	Description
classification_id	Number	Object ID of the classification.
classification_name	Varchar2(255)	name of the classification
classified_object_id	Number(9)	ID of the object that is classified
classified_object_type	Varchar2(4000)	Type of the object
classified_object_name	Varchar2(255)	Name of the object classified

Expression & Function Model

Table G-31 ALL_IV_FUNCTION_LIBRARIES 

Column Name	Type	Description
information_system_id	Number(9)	ID of the information system
information_system_name	Varchar2(255)	Name of the information system
function_library_id	Number(9)	Unique ID of the function library
function_library_name	Varchar2(255)	Name of the function library
business_name	Varchar2(4000)	Display name
description	Varchar2(4000)	description
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-32 ALL_IV_FUNCTIONS 

Column Name	Type	Description
function_library_id	Number(9)	ID of the function library
function_library_name	Varchar2(255)	Name of the function library.
function_id	Number(9)	Unique ID of the function
function_name	Varchar2(255)	Name of the function. Note that this name by itself may not be unique across the project. Use signature to display a unique function signature.
business_name	Varchar2(4000)	Display name. Note that this name by itself may not be unique across the project. Use signature to display a unique function signature.
description	Varchar2(4000)	description
signature	Varchar2(4000)	signature string.
function_type	Varchar2(40)	Type of the function
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-33 ALL_IV_FUNCTION_PARAMETERS 

Column Name	Type	Description
function_id	Number(9)	Unique ID of the function
function_name	Varchar2(255)	name of the function
parameter_id	Number(9)	ID of the parameter
parameter_name	Varchar2(255)	Name of the parameter
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	Description
position	Number(9)	Position of the parameter within function
data_type	Varchar2(255)	Data type of the parameter
length	Number(9)	length of the parameter
precision	Number(9)	Precision
scale	Number(9)	scale of the parameter
parameter_type	varchar2(2000)	Whether the parameter is input, output or input_output
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-34 ALL_IV_FUNCTION_IMPLS 

Column Name	Type	Description
function_id	Number(9)	Unique ID of the function
function_name	Varchar2(255)	name of the function
function_implementation_id	Number(9)	ID of the parameter
unction_implementation_name	Varchar2(255)	Name of the parameter
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	Description
language	Varchar2(255)	Implementation language
script	Varchar2(4000)	The text of the script
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Configuration & Deployment Model

Table G-35 ALL_IV_OBJECT_CONFIGURATIONS 

Column Name	Type	Description
configured_object_id	Number(9)	ID of the configured object
configured_object_type	Varchar2(4000)	Type of the object
configured_object_name	Varchar2(255)	Name of the configured object
physical_name	Varchar2(255)	Name of the physical object
configuration_parameter_ID	Number(9)	Unique identifier for the configuration structure
configuration_parameter_name	Varchar2(4000)	Name of the configuration structure
configuration_parameter_type	Varchar2(23)	Name of the configuration structure
business_name	Varchar2(4000)	Display name for the configuration parameter
description	Varchar2(4000)	description for the configuration parameter
position	Number(9)	The position of the parameter within the parameter group
argument	Varchar2(2000)	The actual value assigned for a configuration item (parameter). This is of type string.
complex_argument	Varchar2(4000)
group_name	Varchar2(64)	Parent configuration structure identifier. This may be null.
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Transformation/Mapping Model

Table G-36 ALL_IV_XFORM_MAPS 

Column Name	Type	Description
information_system_id	Number(9)	ID of the parent information system
information_system _name	Varchar2(255)	name of the parent information system
map_id	Number(9)	ID of the map
map_name	Varchar2(255)	name of the map
business_name	Varchar2(4000)	display name
description	Varchar2(4000)	description
composite_map_component_id	Number(9)	ID of the root map component
composite_map_component_name	Varchar2(255)	Name of the root map component
is_valid	Varchar2(7)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-37 ALL_IV_XFORM_MAP_COMPONENTS 

Column Name	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(4000)	Display name
description	Varchar2(4000)	Description
operator_type	Varchar2(4000)	Type of the operator
composite_component_id	Number(9)	Parent transformation map component ID. This is a foreign key to self.
composite_component_name	Varchar2(255)	Name of the parent transformation map component
data_entity_id	Number(9)	Unique ID of the object that is passed as argument
data_entity_type	Varchar2(4000)	Type of the object
data_entity_name	Varchar2(255)	Name of the object
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-38 ALL_IV_XFORM_MAP_PROPERTIES 

Column Name	Type	Description
map_component_id	Number(9)	ID of the map component
map_component_name	Varchar2(255)	Name of the map component
property_id	Number(9)	ID of the property
property_name	Varchar2(255)	Name of the property
business_name	Varchar2(4000)	Display name
description	Varchar2(4000)	Description
property_group_name	Varchar2(255)	Group name
property_value	Varchar2(255)	Value of the property

Table G-39 ALL_IV_XFORM_MAP_PARAMETERS 

Column Name	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 map parameter
parameter_name	Varchar2(255)	Name of the parameter
business_name	Varchar2(4000)	Display name
description	Varchar2(4000)	Description
map_id	Number(9)	ID of the transformation map
map_name	Varchar2(255)	Name of the map
parameter_group_name	Varchar2(255)	Name of the parameter group
parameter_group_id	Number(9)
parameter_type	varchar2(4000)	Whether the parameter is input, output or input_output
Position	Number(9)	Position of the parameter within the mapping
data_type	Varchar2(2000)	Data type of the parameter
transformation_expression	Varchar2(4000)	Expression that defines the transformation NOTE: The expression string should be parsed, and the tokens has to be replaced with real object names before presenting here.
data_item_id	Number(9)	unIque ID of the object that is passed as argument
data_item_type	Varchar2(2000)	type of the data object
data_item_name	Varchar2(255)	Name of the data object
source_parameter_id	Number(9)	unique ID of the object that is passed as argument
Source_parameter_name	Varchar2(255)	Name of the source parameter object
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Runtime Public Views

Table G-40 ALL_IV_PROCESS 

Column Name	Type	Description
process_id	Number
process_name	Varchar2(4000)
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-41 ALL_IV_PROCESS_RUN 

Column Name	Type	Description
process_id	Number	FK to ALL_IV_PROCESS.process_id
process_run_id	Number	ID of the process run
start_time	Date	The time the process was started
end_time	Date	The time the process was completed
status	Varchar2(4000)	The status of the process. Could be `RUNNING', `COMPLETE', `FAILURE'
number_records_selected	Number	Number of records selected
number_records_inserted	Number	Number of records inserted
number_records_updated	Number	Number of records updated
number_records_deleted	Number	Number of records deleted
number_records_discarded	Number	Number of records discarded
number_errors	Number	Number of errors in the process run
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-42 ALL_IV_MAP_RUN 

Column Name	Type	Description
Process_run_id	Number	FK to ALL_IV_PROCESS_RUN.process_run_id
map_id	Number	not currently used
map_name	Varchar2(4000)	name of the map.
map_run_id	Number	ID of the map run
Start_time	Date	The time the map run was started
end_time	Date	The time the map run was completed
Status	Varchar2(4000)	The status of the map run. Could be `RUNNING', `COMPLETE', or `FAILURE'.
number_records_selected	Number	Number of records selected. Sum of the number of records selected for all component steps.
number_records_inserted	Number	Number of records inserted. Sum of the number of records inserted for all component steps.
number_records_updated	Number	Number of records updated. Sum of the number of records updated for all component steps.
number_records_deleted	Number	Number of records deleted. Sum of the number of records deleted for all component steps.
number_records_discarded	Number	Number of records discarded. Sum of the number of records discarded for all component steps.
number_errors	Number	Number of errors in the map run. Sum of the errors for all component steps.
updated_on	Date	The time the object was last modified. The latest update time of the component steps.
Created_on	Date	The time this object was created. The earliest creation time of the component steps.

Table G-43 ALL_IV_RUN_TARGET 

Column Name	Type	Description
map_run_id	Number	FK to ALL_IV_MAP_RUN.map_run_id
run_target_name	Varchar2(4000)	Name of the target
run_target_id	Number	ID of the run target entry
map_name	Varchar2(4000)	Name of the mapping step
number_records_inserted	Number	Number of records inserted
number_records_updated	Number	Number of records updated
number_records_deleted	Number	Number of records deleted
number_errors	Number	Number of errors in this mapping step
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created

Table G-44 ALL_IV_RUN_ERROR 

Column Name	Type	Description
map_run_id	Number	FK to ALL_IV_MAP_RUN.map_run_id
run_target_name	Varchar(4000)	Name of the target
run_target_id	Number	ID of the run target entry. FK to ALL_IV_RUN_TARGET.run_target_id
run_error_id	Number	ID of the map run
error_number	Number	Number of the error
error_message	Varchar2(4000)	Text of the error message
updated_on	Date	The time the object was last modified
created_on	Date	The time this object was created