Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | LOCATION |
| Short Name | E6 |
| View Name | CI_LOCATIONS |
| Description | A geographical location at which business functions are performed. |
| Sub-type of | SHAREABLE_ELEMENT |
| Versioning: | Structure of LOCATION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_E6 |
| Changes: | Summary of changes to LOCATION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| LOCATION_REFERENCE | Y | Prompt: Parent Location | May be part of one and only one LOCATION | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ADDRESS_LINE_1 | VARCHAR2(40) | Y | The first line of the location address.
Prompt: Address Line 1 | ||
| ADDRESS_LINE_2 | VARCHAR2(40) | Y | The second line of the location address.
Prompt: Address Line 2 | ||
| CODE | VARCHAR2(20) | Y | A short code for the location (e.g. postal/zip code).
Prompt: Code Uppercase | ||
| COMMENTS | VARCHAR2(70) | Y | A comment about the element
Prompt: Comment | ||
| CONTACT | VARCHAR2(30) | Y | The person or department to contact at this location.
Prompt: Contact | ||
| COORDINATE_1 | VARCHAR2(10) | Y | The first coordinate of the location.
Prompt: Coordinate 1 Uppercase | ||
| COORDINATE_2 | VARCHAR2(10) | Y | The second coordinate of the location.
Prompt: Coordinate 2 Uppercase | ||
| NAME | VARCHAR2(30) | N | The name by which this location is usually known.
Prompt: Name Uppercase | ||
| TELEPHONE_NUMBER | VARCHAR2(30) | Y | The telephone number of the person/department to contact at the location.
Prompt: Telephone Number Uppercase | ||
| TYPE | VARCHAR2(20) | N | The type of location that is being defined (e.g. office, site, region).
Prompt: Type Uppercase | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| LOCATION 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 LOCATION:
Note: