Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name SET_MEMBER_ITEM
Short Name SMI
View NameCI_SET_MEMBER_ITEMS
Description Identification of a specific element as belonging to a specific set
Sub-type of INTERSECTION
Versioning: Belongs to:
USER_DEFINED_SET versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: USER_DEFINED_SET_REFERENCE
ELEMENT_REFERENCE
Used by: Oracle Designer

Underlying table:SDD_SMI
Changes: Summary of changes to SET_MEMBER_ITEM in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
ELEMENT_REFERENCE N Prompt: Element in Set
Transferable only if null
Must be of one and only one PRIMARY_ACCESS_ELEMENT 130
USER_DEFINED_SET_REFERENCE N Prompt: Set
Transferable only if null
Must be in one and only one USER_DEFINED_SET

Properties
Name Datatype Opt ? Notes Domain Default Value
ELEMENT_TYPE_FOR VARCHAR2(10) N Arc 130 discriminator. Internal property indicating the element type that the ELEMENT_REFERENCE property refers to. Contains the el_type_of or the el_occur_type, if element is a sub-type.
Not displayed
Uppercase
Updatable only if null
OLD_UID_NAME VARCHAR2(100) Y Internal property capturing the old UID of the PAC at time of checkout
Not displayed
Uppercase
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
SET_MEMBER_ITEM 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 SET_MEMBER_ITEM:


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