Element Type Definition: ROLE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	ROLE_QUALIFICATION
Short Name	CATAEN
View Name	CI_ROLE_QUALIFICATIONS
Description	A role qualification is used to qualify an association between two
	classifiers to limit the set of classifiers that are available at the
	end of the association.

	For example: Traversing an association from entity object 'Bank' to
	'Person' using a role qualification based on the Account Number
	attribute of 'Person' will identify the person whose bank account it
	is

	Each role qualification qualifies the association end by a single
	attribute of the classifier to which the association end belongs.
	An association end can have several role qualifications, allowing
	several attributes to be used to limit the selection in various ways
	at the same time

Sub-type of	INTERSECTION
Versioning:	Belongs to: ASSOCIATION versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	ASSOCIATION_END_REFERENCE EO_ATTRIBUTE_REFERENCE GENERAL_ATTRIBUTE_REFERENCE
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_CATAEN

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
EO_ATTRIBUTE_REFERENCE	N	Prompt: Entity Object Attribute Transferable only if null	Must be for qualification by one and only one ENTITY_OBJECT_ATTRIBUTE	111
GENERAL_ATTRIBUTE_REFERENCE	N	Prompt: General Attribute Reference Transferable only if null	Must be for qualification by one and only one GENERAL_ATTRIBUTE	111
ASSOCIATION_END_REFERENCE	N	Prompt: Association End Transferable only if null	Must be for qualification of one and only one ASSOCIATION_END

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
QUALIFIED_BY	VARCHAR2(3)	N	Arc 111 discriminator. Indicates the type of element the "for qualification by" arc is pointing at Not displayed Uppercase System maintained Not updatable by user	QUALIFIED_BY
SEQUENCE	NUMBER(6, 0)	N	Sequence of the attribute within the qualified association end Prompt: Sequence in Association End System maintained: API provides a value only if left null by the user
PARENT_IVID	NUMBER(38, 0)	Y	Internal use only. Common repository version identifier of owning PAC Not displayed System maintained Updatable only if null Defined on SE supertype
PAC_REFERENCE	NUMBER(38, 0)	Y	Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs Not displayed System maintained Not updatable by user Defined on SE supertype

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description
NOTES	CDINOT	Notes

Other Properties
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference ROLE_QUALIFICATION:

Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each ELEMENT_RULE_USAGE must be applicable to one and only one CIELEMENT (in arc)
Each MAPPING_ELEMENT must be sourced from one and only one CIELEMENT (in arc)
Each MAPPING_ELEMENT must be targeted to one and only one CIELEMENT (in arc)
Each TAGGED_VALUE must be in the context of one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_CLIENT must be identifying as client one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_SUPPLIER must be identifying as supplier one and only one CIELEMENT (in arc)

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype