| Element Type Name | ATTRIBUTE |
| Short Name | ATT |
| View Name | CI_ATTRIBUTES |
| Description | A specific detail of the ENTITY to which it belongs |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to:
ENTITY versionable object |
| Rules: | API
Spec
Uniqueness Criteria Deletion Rules |
| Descriptor: | ENTITY_REFERENCE
NAME |
| Used by: | Oracle Designer |
| Underlying table: | SDD_ATT |
| Changes: | Summary of changes to ATTRIBUTE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ENTITY_REFERENCE | N | Prompt: Entity
Transferable only if null |
Must be of one and only one ENTITY | |
| DOMAIN_REFERENCE | Y | Prompt: Domain | May be defined by one and only one DOMAIN | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| AUTHORITY | VARCHAR2(10) | Y | The level of authority needed for updating this attribute.
Prompt: Authority |
||
| AVERAGE_LENGTH | NUMBER(5, 0) | Y | The average length of this attribute when it contains
a value
Prompt: Average Length |
||
| AVERAGE_USAGE | NUMBER(3, 0) | N | The average percentage the attribute is used.
Prompt: Percent Used - Average Range: 0 to 100 |
50 | |
| DEFAULT_VALUE | VARCHAR2(60) | Y | The default value for this attribute.
Prompt: Default |
||
| DERIVATION | VARCHAR2(240) | Y | An algorithm or expression that describes how the value
for this attribute was derived.
Prompt: Derivation |
||
| FORMAT | VARCHAR2(35) | N | The format for this attribute (e.g date).
Prompt: Format Uppercase |
DATAFORMAT | CHAR |
| INITIAL_USAGE | NUMBER(3, 0) | N | The usage of this attribute when initially loaded (as
a percentage).
Prompt: Percent Used - Initial Range: 0 to 100 |
50 | |
| MAXIMUM_LENGTH | NUMBER(5, 0) | Y | The maximum length of this attribute.
Prompt: Maximum Length |
||
| NAME | VARCHAR2(40) | N | The name of this attribute.
Prompt: Name Uppercase |
||
| NOTES | VARCHAR2(2000) | Y | A brief note about this attribute.
Prompt: Comment |
||
| NULL_VALUE | VARCHAR2(40) | Y | The value that indicates that the attribute is not present
for an occurrence of the entity.
Prompt: Null Value |
||
| OPTIONAL_FLAG | VARCHAR2(1) | N | Indicates whether or not this attribute is mandatory.
Prompt: Optional ? Uppercase |
YESNO | Y |
| OPTION_CONDITION | VARCHAR2(80) | Y | The conditions under which this attribute can be used.
For optional attributes only.
Prompt: On Condition |
||
| ORDER_SEQUENCE | NUMBER(6, 0) | Y | Sequence number of attribute in sort key of entity, qualified
by SORTING_ORDER, carried down to equivalent column at design level COLUMN.ORDER_SEQUENCE
by the transformer
Prompt: Sequence in Sort Key |
||
| PRECISION | NUMBER(4, 0) | Y | The number of decimal places for the length of this attribute.
Prompt: Decimal Places |
||
| RESPONSIBLE | VARCHAR2(10) | Y | An identifier for the user who is responsible for this
attribute.
Prompt: Responsible |
||
| SEQUENCE_NUMBER | NUMBER(6, 0) | Y | A sequence number used to order attributes within the
entity, carried down to COLUMN.SEQUENCE_NUMBER by the DDD
Prompt: Sequence in Entity |
||
| SHORT_NAME | VARCHAR2(10) | Y | An abbreviation for this attribute.
Not displayed Uppercase |
||
| SORTING_ORDER | VARCHAR2(1) | Y | Qualifies ORDER_SEQUENCE, indicating whether the normal
sorting order for this attribute in the sort key is ascending or descending.
Carried down to COLUMN.SORTING_ORDER by transformer
Prompt: Sort Sequence Order Uppercase |
SORTING_ORDER | |
| UNIT_OF_MEASURE | VARCHAR2(10) | Y | The unit of measure for this attribute (e.g. metres,
kilograms).
Prompt: Units |
||
| 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 | Description |
| EXPRESSION | CDEXPR | Validation Rules |
| FULL_NOTES | CDINOT | Notes |
| Other Properties |
|---|
| ATTRIBUTE has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element
types:
|
Other element types that reference ATTRIBUTE:
Note: