Database View Reference

10.5.6
- 10.5.4
- 10.5
- 10.4.0

Back Next

MRX_OBJECT_SUMMARY

The MRX_OBJECT_SUMMARY view provides a summary of objects. The view provides information about the project that the object belongs to, the object path, and user activity on the object.

The following table describes the columns in the MRX_OBJECT_SUMMARY view:

Column Name	Datatype	Description
NS_ID*	NUMBER	Namespace ID. Each design-time object belongs to the same namespace. Each deployed object belongs to a namespace that corresponds to the deployed application.
CID*	NUMBER	Container ID. A container is an object that contains other objects and child containers. For example, projects, folders, and mappings are containers.
PARENT_CID	NUMBER	Parent container ID.
PROJECT_GRP_NAME	VARCHAR(765)	Project group name. Each design-time object belongs to the Tools project group. Each deployed object belongs to a project group that corresponds to the deployed application.
PROJECT_ID	NUMBER	Project ID.
PROJECT_NAME	VARCHAR(765)	Project name.
OID*	NUMBER	Object ID.
OBJECT_TYPENAME*	VARCHAR(765)	Object type.
OBJECT_NAME	VARCHAR(255)	Object name.
OBJECT_PATH	VARCHAR(3900)	Path of the object from the root folder.
CREATED_BY	VARCHAR(255)	User who created the object.
CREATION_TIME	VARCHAR(255)	Date and time that the object was created, with precision to the millisecond.
LAST_MODIFIED_BY	VARCHAR(255)	User who last modified the object.
LAST_UPDATED_TIME	VARCHAR(255)	Date and time that the object was last updated, with precision to the millisecond.
*Indicates that the combination of NS_ID, CID, OID, and OBJECT_TYPENAME is the key column.

Rename Saved Search

Table of Contents

Database View Reference

Database View Reference

MRX_OBJECT_SUMMARY

MRX_OBJECT_SUMMARY