Search

Database View Reference

Database View Reference

10.4.0
- 10.5.4
- 10.5

Back Next

MRX_PROFILE_RULES

MRX_PROFILE_RULES

The MRX_PROFILE_RULES view contains information about rules in all the profiles.

The following table describes the columns in the MRX_PROFILE_RULES view:

Column	Datatype	Description
PID	NUMBER	Serial ID of the profile task that the Model Repository Service assigns.
NSID	NUMBER	Namespace ID of the profile task. Each design-time object belongs to the same namespace. Each deployed object belongs to a unique namespace assigned to the deployed application.
PROFILE_TASK_ID	VARCHAR(3060)	Profile task ID.
CID	NUMBER	Profile task container ID. A container is an object that contains other objects and child containers. For example, projects, folders, and mappings are containers.
PROFILE_NAME	VARCHAR(1536)	Name of the profile.
PROFILE_PROJECT	VARCHAR(3060)	Name of the project that contains the profile.
PROFILE_PATH	VARCHAR(4000)	Path of the profile from its root.
RULE_NAME	VARCHAR(3060)	Name of the rule.
RULE_PROJECT	VARCHAR(3060)	Name of the project that contains the rule. The value is NULL if RULE_TYPE is EXPRESSION.
RULE_PATH	VARCHAR(4000)	Path of the rule from its root. The value is NULL if RULE_TYPE is EXPRESSION.
RULE_TYPE	VARCHAR(40)	Type of the rule, such as mapplet rule or expression rule.
RULE_EXPR	CLOB	Rule expression. The value is NULL if RULE_TYPE is MAPPLET.
RULE_OUTPUT_FIELD	VARCHAR(3060)	Name of the rule output field.
RULE_DESC	CLOB	Rule description.

Model Repository (MRX) Views

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.