Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name INSTALLATION
Short Name A21
View NameCI_INSTALLATIONS
Description A node installed at a specific location
Sub-type of INTERSECTION
Versioning: Belongs to:
LOCATION versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: LOCATION_REFERENCE
NODE_REFERENCE
Used by: Oracle Designer
Underlying table:SDD_A21
Changes: Summary of changes to INSTALLATION in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
LOCATION_REFERENCE N Prompt: Location
Transferable only if null
Must be a part of one and only one LOCATION
NODE_REFERENCE N Prompt: Node
Transferable only if null
Must be a use for one and only one NODE

Properties
Name Datatype Opt ? Notes Domain Default Value
CDATE_FROM VARCHAR2(20) Y The date on which this installation was commissioned.
Prompt: Date Commissioned
CDATE_TO VARCHAR2(20) Y The date on which this installation was decommissioned.
Prompt: Date Decommissioned
COMMENTS VARCHAR2(70) Y A comment about the association
Prompt: Comment
CONTACT_PHONE_NUMBER VARCHAR2(20) Y The telephone number of the person to contact for installation details.
Prompt: Contact Phone Number
INSTALLERS_NAME VARCHAR2(30) Y The name of the person who installed the node at this location.
Prompt: Installer's Name
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
INSTALLATION 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 INSTALLATION:


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