Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name DATAFLOW_ATTRIBUTE_USAGE
Short Name DFLATT
View NameCI_DATAFLOW_ATTRIBUTE_USAGES
Description An attribute used in a dataflow
Sub-type of INTERSECTION
Versioning: Belongs to:
DATASTORE versionable object
EXTERNAL versionable object
FUNCTION versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: DATAFLOW_REFERENCE
ATTRIBUTE_REFERENCE
Used by: Oracle Designer
Underlying table:SDD_DFLATT
Changes: Summary of changes to DATAFLOW_ATTRIBUTE_USAGE in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
ATTRIBUTE_REFERENCE N Prompt: Attribute
Transferable only if null
Must be of one and only one ATTRIBUTE
DATAFLOW_REFERENCE N Prompt: Dataflow
Transferable only if null
Must be for one and only one DATAFLOW

Properties
Name Datatype Opt ? Notes Domain Default Value
ENTITY_REFERENCE NUMBER(38, 0) N The internal reference of the entity.
Not displayed
System maintained
Not updatable by 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

Other Properties
DATAFLOW_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:
  • ID
  • IRID
  • IVID
  • ELEMENT_TYPE_NAME
  • DATE_CREATED
  • CREATED_BY
  • DATE_CHANGED
  • CHANGED_BY
  • NUMBER_OF_TIMES_MODIFIED
  • TYPES

Other element types that reference DATAFLOW_ATTRIBUTE_USAGE:


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