Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | FUNCTION_ATTRIBUTE_USAGE |
| Short Name | FUNATT |
| View Name | CI_FUNCTION_ATTRIBUTE_USAGES |
| Description | An attribute used by a function |
| Sub-type of | INTERSECTION |
| Versioning: | Belongs to: FUNCTION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
FUNCTION_REFERENCE ATTRIBUTE_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_FUNATT |
| Changes: | Summary of changes to FUNCTION_ATTRIBUTE_USAGE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ATTRIBUTE_REFERENCE | N |
Prompt: Attribute
Transferable only if null |
Must be applicable to one and only one ATTRIBUTE | |
| FUNCTION_REFERENCE | N |
Prompt: Function
Transferable only if null |
Must be for one and only one FUNCTION | |
| FUNENT_REFERENCE | N |
Not displayed
System maintained Not transferable |
Must be within one and only one FUNCTION_ENTITY_USAGE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ARCHIVE_FLAG | VARCHAR2(1) | N | Indicates whether values of this attribute are archived by the function.
Prompt: Archive ? Uppercase | YESNO | N |
| ENTITY_REFERENCE | NUMBER(38, 0) | N | The internal reference of the entity that contains this attribute.
Not displayed System maintained Not updatable by user | ||
| INSERT_FLAG | VARCHAR2(1) | N | Indicates whether or not values for this attribute can be inserted by the function.
Prompt: Insert ? Uppercase | YESNO | N |
| NULLIFY_FLAG | VARCHAR2(1) | N | Indicates whether values of this attribute are set to NULL by the function.
Prompt: Nullify ? Uppercase | YESNO | N |
| REMARK | VARCHAR2(240) | Y | A comment on the use of this attribute by this function.
Prompt: Comment | ||
| RETRIEVE_FLAG | VARCHAR2(1) | N | Indicates whether values of this attribute are retrieved by the function.
Prompt: Retrieve ? Uppercase | YESNO | N |
| UPDATE_FLAG | VARCHAR2(1) | N | Indicates whether values of this attribute are updated by this function.
Prompt: Update ? Uppercase | YESNO | N |
| USER_DEFINED_USAGE_FLAG | VARCHAR2(1) | N | Indicates whether this is a user defined usage of the attribute by the function.
Prompt: Other ? Uppercase | YESNO | N |
| 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 |
| Other Properties |
|---|
| FUNCTION_ATTRIBUTE_USAGE 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 FUNCTION_ATTRIBUTE_USAGE:
Note: