Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | APPLICATION_SYSTEM |
| Short Name | APP |
| View Name | CI_APPLICATION_SYSTEMS |
| Description | A type of container, used primarily in the context of Oracle Designer. |
| An application system is a general purpose mechanism for organizing | |
| elements into groups. It provides the context and namespace for the | |
| elements it owns | |
| Sub-type of | CONTAINER_ELEMENT |
| Versioning: | Structure of APPLICATION_SYSTEM versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_FOLDERS |
| Changes: | Summary of changes to APPLICATION_SYSTEM in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| APPLICATION_TYPE | VARCHAR2(1) | N | An indicator of the type of Application System and used to distinguish between (C)orporate (ie normal), (D)ummy and (W)orking Application Systems
Not displayed Uppercase System maintained Not updatable by user | APPLICATION_TYPE | C |
| AUTHORITY | VARCHAR2(10) | Y | The name of the person or organization authorizing this application system.
Prompt: Authority | ||
| CONSTRAINTS | VARCHAR2(240) | Y | The constraints on this application system.
Prompt: Constraints | ||
| CONTAINER_SUBTYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether the container element is a folder or an application system
Not displayed Uppercase System maintained Not updatable by user Defined on CEL supertype | CONTAINER_SUBTYPE | |
| DATAWAREHOUSE_FLAG | VARCHAR2(1) | N | Indicates whether or not this is a data warehousing application
Prompt: Data Warehouse ? Uppercase | YESNO | N |
| DISPLAY_TITLE | VARCHAR2(40) | Y | The display title of the application system that is to be reported on screens and reports.
Prompt: Title | ||
| NAME | VARCHAR2(256) | N | Name of the application system or folder
Prompt: Name Defined on CEL supertype | ||
| OS_TIMESTAMP | DATE | Y | Operating system timestamp
Prompt: OS Timestamp System maintained Not updatable by user Defined on CEL supertype | ||
| OWNING_USER | VARCHAR2(30) | N | Name of the database user owning this application system, folder or package.
Prompt: Owner Uppercase System maintained Not updatable by user Defined on CEL supertype | ||
| PRIORITIES | VARCHAR2(240) | Y | The priorities of this application system.
Prompt: Priorities | ||
| REMARK | VARCHAR2(240) | Y | A comment about this application system.
Prompt: Comment | ||
| ROOT_FLAG | VARCHAR2(1) | N | Indicates whether this container is a root
Not displayed Uppercase System maintained Not updatable by user Defined on CEL supertype | YESNO | N |
| SYSTEM_ELEMENT_FLAG | VARCHAR2(1) | N | Indicates whether this is a "system element", ie one created automatically for which the user has limited or not update capability
Not displayed Uppercase Defined on CEL supertype | YESNO | N |
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC Defined on CEL supertype |
Description |
| NOTES | CDINOT Defined on CEL supertype |
Notes |
| OBJECTIVES | CDIOBJ | Objectives |
| SUMMARY | CDISUM | Summary |
| Other Properties |
|---|
| APPLICATION_SYSTEM 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:
|
Other element types that reference APPLICATION_SYSTEM:
Note: