Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name FILE_USAGE
Short Name FILPAC
View NameCI_FILE_USAGES
Description Intersection between file and a specific primary access element
indicating that the file is not "independent" as are other files but
needs special handling in the context of the specified PAC
Examples of use are:
The file containing storage of the DIAGRAM
The file containing synchronized code for the CLASSIFIER
Sub-type of INTERSECTION
Versioning: Belongs to:
APPLICATION_MODULE versionable object
ASSOCIATION versionable object
ATTRIBUTE_DOMAIN versionable object
DIAGRAM versionable object
ENTITY_OBJECT versionable object
EVENT_CLASSIFIER versionable object
GENERIC_CLASS versionable object
INTERFACE_CLASSIFIER versionable object
VIEW_LINK versionable object
VIEW_OBJECT versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: ASSOCIATION_REFERENCE
CLASSIFIER_REFERENCE
DIAGRAM_REFERENCE
VIEW_LINK_REFERENCE
PRIMARY_ACCESS_FILE_REFERENCE
Used by: JDeveloper Enterprise Edition

Underlying table:SDD_FILPAC

Reference Properties
Name Opt ? Notes Relationship In Arc
ASSOCIATION_REFERENCE N Prompt: Association
System maintained
Not transferable
Must be a usage by one and only one ASSOCIATION 118
CLASSIFIER_REFERENCE N Prompt: Classifier
System maintained
Not transferable
Must be a usage by one and only one CLASSIFIER 118
DIAGRAM_REFERENCE N Prompt: Diagram
System maintained
Not transferable
Must be a usage by one and only one DIAGRAM 118
VIEW_LINK_REFERENCE N Prompt: View Link
System maintained
Not transferable
Must be a usage by one and only one VIEW_LINK 118
PRIMARY_ACCESS_FILE_REFERENCE N Prompt: File
System maintained
Not transferable
Must be a usage of one and only one PRIMARY_ACCESS_FILE

Properties
Name Datatype Opt ? Notes Domain Default Value
CRC VARCHAR2(20) Y CRC32 signature of the jotted file binary object. A difference between this and the CRC property on PRIMARY_ACCESS_FILE indicates the file has changed since it was last jotted
Not displayed
System maintained
Not updatable by user
FILE_USAGE_FOR VARCHAR2(3) N Arc 118 discriminator. Internal property indicating the type of element in whose context this FILE_USAGE exists
Not displayed
Uppercase
System maintained
Not updatable by user
FILE_USAGE_FOR
OS_TIMESTAMP DATE Y Operating system timestamp of the PRIMARY_ACCESS_FILE at the last update of structured data
Not displayed
System maintained
Not updatable by user
OUT_OF_SYNC_FLAG VARCHAR2(1) N Indicates when structured data is out of sync with the generated code
Not displayed
Uppercase
System maintained
Not updatable by user
YESNO N
TYPE VARCHAR2(12) Y Classification for this file usage
Prompt: Type
Uppercase
System maintained
Not updatable by user
FILE_USAGE_TYPE
VERSION NUMBER(38, 0) N IVID of the PRIMARY_ACCESS_FILE at the last check-in. Purpose is to ensure the correct version of the file is in the workarea
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
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 FILE_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