Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name DATAFLOW_DATA_ITEM_USAGE
Short Name DFLDIT
View NameCI_DATAFLOW_DATA_ITEM_USAGES
Description A data item 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
DATA_ITEM_REFERENCE
Used by: Oracle Designer
Underlying table:SDD_DFLDIT
Changes: Summary of changes to DATAFLOW_DATA_ITEM_USAGE in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
DATAFLOW_REFERENCE N Prompt: Dataflow
Transferable only if null
Must be for one and only one DATAFLOW
DATA_ITEM_REFERENCE N Prompt: Data Item
Transferable only if null
Must be of one and only one DATA_ITEM

Properties
Name Datatype Opt ? Notes Domain Default Value
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_DATA_ITEM_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_DATA_ITEM_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