| Element Type Name | DOMAIN |
| Short Name | DOM |
| View Name | CI_DOMAINS |
| Description | Definition of a domain, potentially used by attributes. columns, |
| program data, module arguments, datastructure items and/or unbound | |
| items | |
| Sub-type of | SHAREABLE_ELEMENT |
| Versioning: | Structure of DOMAIN versionable object |
| Rules: | API
Spec
Uniqueness Criteria Deletion Rules |
| Descriptor: | NAME |
| Used by: | Oracle Designer
|
| Underlying table: | SDD_DOM |
| Changes: | Summary of changes to DOMAIN in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| SUPERTYPE_REFERENCE | Y | Prompt: Subset Of | May be a subset of one and only one DOMAIN | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ATTRIBUTE_PRECISION | NUMBER(4, 0) | Y | The number of decimal places for attributes in this domain.
Prompt: Att Decimal Places |
||
| AUTHORITY | VARCHAR2(10) | Y | The level of authority required to update this domain.
Prompt: Authority |
||
| AVERAGE_ATTRIBUTE_LENGTH | NUMBER(5, 0) | Y | The average length for attributes in this domain.
Prompt: Average Att Length |
||
| AVERAGE_COLUMN_LENGTH | NUMBER(5, 0) | Y | The average length of columns in this domain.
Prompt: Average Col Length |
||
| COLUMN_PRECISION | NUMBER(4, 0) | Y | The number of decimal places for columns in this domain.
Prompt: Col Decimal Places |
||
| DATATYPE | VARCHAR2(35) | Y | The datatype of columns within this domain.
Prompt: Datatype Uppercase |
DATATYPE | |
| DEFAULT_VALUE | VARCHAR2(60) | Y | The default value for attributes/columns in this domain.
Prompt: Default |
||
| DEFAULT_VALUE_TYPE | VARCHAR2(15) | N | Indicates the nature of the default value of columns
and items
Prompt: Default Value Type Uppercase |
DEFAULT_VALUE_TYPE | LITERAL |
| DERIVATION | VARCHAR2(240) | Y | The derivation of attributes within this domain.
Prompt: Derivation |
||
| DESCRIPTION | VARCHAR2(240) | Y | A description of this domain.
Prompt: Comment |
||
| FORMAT | VARCHAR2(35) | N | The format for the attributes in this domain.
Prompt: Format Uppercase |
DATAFORMAT | CHAR |
| MAXIMUM_ATTRIBUTE_LENGTH | NUMBER(5, 0) | Y | The maximum length for attributes in this domain.
Prompt: Maximum Att Length |
||
| MAXIMUM_COLUMN_LENGTH | NUMBER(5, 0) | Y | The maximum length for columns in this domain.
Prompt: Maximum Col Length |
||
| NAME | VARCHAR2(40) | N | The name of this domain.
Prompt: Name Uppercase |
||
| NULL_VALUE | VARCHAR2(40) | Y | The value representing NULL for the attribute/column
in this domain.
Prompt: Null Value |
||
| SOFT_LOV | VARCHAR2(1) | N | Value of Y indicates that columns in this domain are
to be validated against a table (ie soft-coded). Used by the Forms Generator.
Prompt: Dynamic List ? Uppercase |
YESNO | N |
| UNIT_OF_MEASURE | VARCHAR2(10) | Y | The units of measure for attributes in this domain, e.g.
metres, dollars, hours.
Prompt: Unit Of Measure |
||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| EXPRESSION | CDEXPR | Validation Rules |
| FULL_DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| DOMAIN 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 DOMAIN:
Note: