Element Type Definition: VIEW_OBJECT

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	VIEW_OBJECT_ATTRIBUTE
Short Name	VOA
View Name	CI_VIEW_OBJECT_ATTRIBUTES
Description	An attribute, or property, of a view object

Sub-type of	CLASSIFIER_ATTRIBUTE
Versioning:	Belongs to: VIEW_OBJECT versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	VIEW_OBJECT_REFERENCE NAME
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_CAT

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
VIEW_OBJECT_REFERENCE	N	Prompt: View Object Transferable only if null	Must be defined in one and only one VIEW_OBJECT
CLASSIFIER_REFERENCE	Y	Prompt: Classifier Datatype Defined on CAT supertype	May be of datatype of one and only one CLASSIFIER
ENTITY_OBJECT_USAGE_REFERENCE	Y	Prompt: Entity Object Usage Transferable only if null	May be defined from one and only one ENTITY_OBJECT_USAGE
EO_ATTRIBUTE_REFERENCE	Y	Prompt: Entity Object Attribute Transferable only if null	May be bound to one and only one ENTITY_OBJECT_ATTRIBUTE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
CHANGE_RESTRICTION	VARCHAR2(8)	N	Indicates whether the value may be modified after the object is created and, if so, what restrictions apply Prompt: Change Restriction Uppercase Defined on CAT supertype	CHANGE_RESTRICTION	NONE
CLASSIFIER_ATTRIBUTE_SUBTYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating whether the attribute is an entity object attribute (EAT) or a general attribute (GAT) Not displayed Uppercase System maintained Not updatable by user Defined on CAT supertype	CLASSIFIER_ATTRIBUTE_SUBTYPE
CREATABLE_FLAG	VARCHAR2(1)	N	Indicates whether a value for this view object attribute can be inserted Prompt: Is Creatable Uppercase	YESNO	Y
DATATYPE_FORMAT	VARCHAR2(10)	N	Internal property acting as "logical arc discriminator" between SCALAR_DATATYPE and CLASSIFIER_REFERENCE, indicating which is populated. These are both optional, but one or other MUST be specified Not displayed Uppercase System maintained Not updatable by user Defined on CAT supertype	DATATYPE_FORMAT
DECIMAL_PLACES	NUMBER(4, 0)	Y	For numeric datatypes, specifies the number of decimal places allowed for this attribute Prompt: Decimal Places Defined on CAT supertype
DEFAULT_VALUE	VARCHAR2(2000)	Y	Default value for the attribute. If the attribute is an array, the default values are held as a comma separated list Prompt: Default Value Defined on CAT supertype
DELETABLE_FLAG	VARCHAR2(1)	N	Indicates whether the value of this view object attribute can be nullified Prompt: Is Deletable Uppercase	YESNO	Y
DISPLAY_FLAG	VARCHAR2(1)	N	Indicates whether the view object attribute is displayed Prompt: Is Displayed Uppercase	YESNO	Y
JDBC_TYPE	VARCHAR2(13)	N	The jdbc datatype to be used for this attribute on the middle tier Prompt: JDBC Datatype Uppercase	JDBC_TYPE	VARCHAR
MAXIMUM_LENGTH	NUMBER(5, 0)	Y	Maximum length of data that this attribute can contain Prompt: Maximum Length Defined on CAT supertype
MAXIMUM_MULTIPLICITY	VARCHAR2(10)	N	*Maximum multiplicity of the attribute. A value of 1 indicates a single attribute, whereas a value > 1 or '' indicates an array** Prompt: Maximum Multiplicity Defined on CAT supertype		1
MINIMUM_MULTIPLICITY	NUMBER(10, 0)	N	Minimum multiplicity of the attribute. A value of 0 indicates the attribute is optional, 1 (or more) that it is mandatory Prompt: Minimum Multiplicity Defined on CAT supertype		0
NAME	VARCHAR2(100)	N	Name of the attribute Prompt: Name Defined on CAT supertype
PROGRAMMED_UPDATE_FLAG	VARCHAR2(1)	N	Used for an unbound attribute to denote it will cause an update to the data, performed by user code Prompt: Programmed Update ? Uppercase	YESNO	N
PROMPT	VARCHAR2(132)	Y	Prompt to be used when displaying this attribute Prompt: Prompt Defined on CAT supertype
RETRIEVABLE_FLAG	VARCHAR2(1)	N	Indicates whether user is allowed to access the values stored in this attribute. If the attribute has a datatype of a domain then the equivalent property on the domain determines whether the attribute is queryable Prompt: Is Retrievable Uppercase Defined on CAT supertype	YESNO	Y
SCALAR_DATATYPE	VARCHAR2(15)	Y	Scalar datatype of the attribute, where datatype not defined as a classifier Prompt: Scalar Datatype Defined on CAT supertype	SCALAR_DATATYPE
SEQUENCE	NUMBER(6, 0)	N	Sequence for use by the transformers, indicating the position of this attribute among other attributes for the same classifier Prompt: Sequence in Classifier System maintained: API provides a value only if left null by the user Defined on CAT supertype
SERIALIZABLE_FLAG	VARCHAR2(1)	N	Indicates, in Java, whether the attribute is part of the persistent state of the object and will be serialized with the object Prompt: Is Serializable Uppercase Defined on CAT supertype	YESNO	N
SQL_ALIAS	VARCHAR2(30)	N	Alias to be used in SQL queries Prompt: SQL Alias Uppercase
STATIC_FLAG	VARCHAR2(1)	N	Indicates whether the attribute is a "class attribute", ie at the class level with only a single value for all instances Prompt: Is Static Uppercase Defined on CAT supertype	YESNO	N
UPDATABLE_FLAG	VARCHAR2(1)	N	Indicates whether the user is allowed to update the values stored in this attribute. If the attribute has a datatype of a domain then the equivalent property on the domain determines whether the attribute is updatable Prompt: Is Updatable Uppercase Defined on CAT supertype	YESNO	Y
VISIBILITY	VARCHAR2(10)	N	Visibility of the attribute Prompt: Visibility Uppercase Defined on CAT supertype	VISIBILITY	PRIVATE
VOLATILE_FLAG	VARCHAR2(1)	N	Indicates, in Java, whether the attribute may be accessed by unsynchronized threads and so certain code optimizations must not be performed on it Prompt: Is Volatile Uppercase Defined on CAT supertype	YESNO	N
PARENT_IVID	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs Not displayed System maintained Updatable only if null Defined on SAC supertype
PAC_REFERENCE	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs Not displayed System maintained Not updatable by user Defined on SAC supertype

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC Defined on CAT supertype	Description
NOTES	CDINOT Defined on CAT supertype	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 VIEW_OBJECT_ATTRIBUTE:

Each ATTRIBUTE_DERIVATION_RULE must be applied to one and only one CLASSIFIER_ATTRIBUTE
Each CONTEXT_MAPPING may be a mapping from one and only one CLASSIFIER_ATTRIBUTE (in arc)
Each CONTEXT_MAPPING must be a mapping to one and only one CLASSIFIER_ATTRIBUTE (in arc)
Each CROSS_OBJ_RULE_IMPLEMENT must be applied to one and only one CLASSIFIER_ATTRIBUTE
Each DATA_COMPONENT must be a use of one and only one CLASSIFIER_ATTRIBUTE (in arc)
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 INTEGRITY_RULE may be applied to one and only one CLASSIFIER_ATTRIBUTE
Each MEMBER_COMPONENT must be a use of one and only one CLASSIFIER_ATTRIBUTE (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)
Each VIEW_LINK_COMPONENT must be a use of one and only one VIEW_OBJECT_ATTRIBUTE
Each WORKFLOW_ATTRIBUTE may be based on one and only one CLASSIFIER_ATTRIBUTE

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