Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | ATTRIBUTE_VALUE |
| Short Name | ATV |
| View Name | CI_ATTRIBUTE_VALUES |
| Description | An allowable value belonging to a domain, attribute, column, unbound |
| item or module argument | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: DOMAIN versionable object ENTITY versionable object GENERAL_MODULE versionable object ORACLE_OBJECT_TYPE versionable object RECORD versionable object REUSABLE_LOV versionable object REUSABLE_MCO versionable object SNAPSHOT_DEFINITION versionable object TABLE_DEFINITION versionable object VIEW_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
ATTRIBUTE_REFERENCE COLUMN_REFERENCE DOMAIN_REFERENCE MODULE_ARGUMENT_REFERENCE UNBOUND_ITEM_REFERENCE LOW_VALUE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_ATV |
| Changes: | Summary of changes to ATTRIBUTE_VALUE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ATTRIBUTE_REFERENCE | N |
Prompt: Attribute
Transferable only if null |
Must be for one and only one ATTRIBUTE | 63 |
| COLUMN_REFERENCE | N |
Prompt: Column
Transferable only if null |
Must be for one and only one COLUMN | 63 |
| DOMAIN_REFERENCE | N |
Prompt: Domain
Transferable only if null |
Must be for one and only one DOMAIN | 63 |
| MODULE_ARGUMENT_REFERENCE | N |
Prompt: Module Argument
Transferable only if null |
Must be for one and only one MODULE_ARGUMENT | 63 |
| UNBOUND_ITEM_REFERENCE | N |
Prompt: Unbound Item
Transferable only if null |
Must be for one and only one UNBOUND_ITEM | 63 |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ABBREVIATION | VARCHAR2(20) | Y | An abbreviation or short code for the attribute value record.
Prompt: Abbreviation | ||
| ATTRIBUTE_VALUE_FOR | VARCHAR2(3) | N | Arc 63 discriminator. Indicates type of element arc is pointing at (ATT, COL, DOM, ARG or UBI)
Not displayed Uppercase System maintained Not updatable by user | ATTRIBUTE_VALUE_FOR | |
| HIGH_VALUE | VARCHAR2(40) | Y | A high value for the attribute, if a range of values is defined.
Prompt: High Value | ||
| HIGH_VALUE_TYPE | VARCHAR2(15) | N | Indicates the nature of the high value
Prompt: High Value Type Uppercase | DEFAULT_VALUE_TYPE_2 | LITERAL |
| LOW_VALUE | VARCHAR2(40) | N | A valid value for the attribute. When defining a range of values, this field is used to define the low value.
Prompt: Value | ||
| LOW_VALUE_TYPE | VARCHAR2(15) | N | Indicates the nature of the low value
Prompt: Value Type Uppercase | DEFAULT_VALUE_TYPE_2 | LITERAL |
| MEANING | VARCHAR2(240) | Y | The full meaning for the abbreviation or code value which describes the value or range of values for the attribute.
Prompt: Meaning | ||
| RADIO_SEQUENCE | NUMBER(6, 0) | Y | The sequence in which the value appears on a radio button
Prompt: Display Sequence | ||
| 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 |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| ATTRIBUTE_VALUE 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_VALUE:
Note: