Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | UNBOUND_ITEM |
| Short Name | UBI |
| View Name | CI_UNBOUND_ITEMS |
| Description | An UNBOUND_ITEM is an ITEM that is not a simple usage of a column |
| in a table. | |
| Examples of UNBOUND_ITEMS are totals or summary fields on a screen | |
| or a report. | |
| (ITEM used to be called MODULE_DETAIL_COLUMN_USAGE) | |
| Sub-type of | ITEM |
| Versioning: | Belongs to: GENERAL_MODULE versionable object REUSABLE_LOV versionable object REUSABLE_MCO versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
MODULE_UNIT_REFERENCE SQL_QUERY_SET_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_ITE |
| Changes: | Summary of changes to UNBOUND_ITEM in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| MODULE_UNIT_REFERENCE | N |
Prompt: Module Unit
Defined on ITE supertype |
Must be within one and only one MODULE_UNIT | 86 |
| SQL_QUERY_SET_REFERENCE | N |
Prompt: SQL Query Set
Defined on ITE supertype |
Must be within one and only one SQL_QUERY_SET | 86 |
| DOMAIN_REFERENCE | Y | Prompt: Domain | May be defined by one and only one DOMAIN | |
| ITEM_GROUP_REFERENCE | Y |
Prompt: Item Group
Defined on ITE supertype |
May be grouped into one and only one ITEM_GROUP | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ALIGN_PROMPT_FLAG | VARCHAR2(1) | N | Indicates whether prompt of aligned item is also to be vertically aligned
Prompt: Align Prompt ? Uppercase Defined on ITE supertype | YESNO | N |
| CONTEXT_FLAG | VARCHAR2(1) | N | Indicates whether item is a descriptor value to identify, or provide context for, records in the module component
Prompt: Context ? Uppercase Defined on ITE supertype | YESNO | N |
| DATATYPE | VARCHAR2(10) | Y | Fundamental datatype of the ITEM, if different to that of the underlying column. A null value indicates the datatype of the item is the same as the underlying column.
Prompt: Datatype Uppercase Defined on ITE supertype | BASIC_DATATYPE | |
| DEFAULT_VALUE | VARCHAR2(60) | Y | Default value for this item
Prompt: Default Value Defined on ITE supertype | ||
| DEFAULT_VALUE_TYPE | VARCHAR2(15) | N | Indicates the nature of the default value
Prompt: Default Value Type Uppercase Defined on ITE supertype | DEFAULT_VALUE_TYPE | LITERAL |
| DISPLAY_FLAG | VARCHAR2(1) | N | Indicates whether the item is displayed by the module
Prompt: Display ? Uppercase Defined on ITE supertype | YESNO | Y |
| DISPLAY_FORMAT | VARCHAR2(60) | Y | The display format mask
Prompt: Format Mask Defined on ITE supertype | ||
| DISPLAY_HEIGHT | NUMBER(6, 0) | Y | Number of lines to display. The "height" of the average line may be deduced from the font in use, depending on a preference
Prompt: Height Defined on ITE supertype | ||
| DISPLAY_TYPE | VARCHAR2(20) | Y | The display type to be used for the unbound item in reports and screens
Prompt: Display Type Uppercase | UBI_DISPLAY_TYPE
Language specific values | |
| DISPLAY_WIDTH | NUMBER(5, 0) | Y | Number of characters to use when displaying the item in screens or reports. The "width" of the average character may be deduced from the font used, depending on a preference
Prompt: Width Defined on ITE supertype | ||
| END_TAB | NUMBER(10, 0) | Y | Numeric label of the tab at which the end of the item is to be vertically aligned
Prompt: End Tab Stop Range: 1 to 9999999999 Defined on ITE supertype | ||
| HELP_CONTEXT_ID_SUFFIX | NUMBER(5, 0) | Y | Allocated by the help generator. Combined with the help prefix on the module, forms a unique number within the context of the help
Not displayed Defined on ITE supertype | ||
| HIGHLIGHTING | VARCHAR2(240) | Y | Display formatting for this item e.g. BOLD, REVERSE.
Prompt: Formatting Uppercase Defined on ITE supertype | ||
| HINT_TEXT | VARCHAR2(132) | Y | Single line help text describing the purpose of the item
Prompt: Hint Defined on ITE supertype | ||
| IMPLEMENTATION_ITEM | VARCHAR2(30) | Y | Name of template/library object on which the generated item will be based.
Prompt: Template/Library Object Defined on ITE supertype | ||
| INSERT_FLAG | VARCHAR2(1) | N | Indicates whether the generated module will allow the user to enter values into this item
Prompt: Insert ? Uppercase Defined on ITE supertype | YESNO | N |
| ITEM_FOR | VARCHAR2(3) | N | Arc 86 discriminator. Indicates whether this item is within a MODULE_UNIT or a SQL_SET_MEMBER
Not displayed Uppercase System maintained Not updatable by user Defined on ITE supertype | ITEM_FOR | |
| ITEM_TYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether the ITEM is a DATA_BOUND_ITEM (DBI) or an UNBOUND_ITEM (UBI)
Not displayed Uppercase System maintained Not updatable by user Defined on ITE supertype | ITEM_TYPE | |
| JUSTIFICATION | VARCHAR2(6) | Y | Justification to be applied to the item on reports and screens
Prompt: Alignment Uppercase Defined on ITE supertype | JUSTIFICATION | |
| MAXIMUM_LENGTH | NUMBER(10, 0) | Y | The maximum length of data that this item can contain
Prompt: Maximum Length | ||
| NAME | VARCHAR2(30) | N | Alias by which this item is identified
Prompt: Name Uppercase System maintained: API provides a value only if left null by the user Defined on ITE supertype | ||
| NULLIFY_FLAG | VARCHAR2(1) | N | Indicates whether the generated module will allow the user to set the value of this item to null
Prompt: Optional ? Uppercase Defined on ITE supertype | YESNO | N |
| ORDER_SEQUENCE | NUMBER(6, 0) | Y | Sequence of this item in an ORDER BY clause
Prompt: Order By Sequence Defined on ITE supertype | ||
| PROMPT | VARCHAR2(130) | Y | The prompt to be used for the item in reports and screens.
Prompt: Prompt Defined on ITE supertype | ||
| RANGE_SEARCH_FLAG | VARCHAR2(1) | N | Indicates whether generated application is to provide a pair of 'from/to' controls. Value 'False' indicates only a single control will be provided, and 'Default Behaviour' indicates the generator will determine whether to provide it.
Prompt: Range Search Uppercase Defined on ITE supertype | YESNODEF | D |
| REMARK | VARCHAR2(240) | Y | A comment on the use of the item by the module.
Prompt: Comment Defined on ITE supertype | ||
| RESET_GROUP | VARCHAR2(80) | Y | Named of group at which computed item to be reset. Applicable when UNBOUND_TYPE='COMPUTED' and RESET_LEVEL='NAMED GROUP'.
Prompt: Reset Group Uppercase | ||
| RESET_LEVEL | VARCHAR2(16) | Y | Applies only when UNBOUND_TYPE='COMPUTED'. Indicates level at which computed item to be reset. If reset level is specified as 'NAMED GROUP', then property RESET_GROUP will be populated with name of group at which computed item to be reset
Prompt: Reset Level Uppercase | RESET_LEVEL | |
| SELECT_FLAG | VARCHAR2(1) | N | Indicates whether the generated module will allow the user to select values from this item. ALWAYS indicates that the item must participate in the query
Prompt: Query ? Uppercase Defined on ITE supertype | YESNOALWAYS | N |
| SHOW_MEANING | VARCHAR2(12) | Y | Indicates how meanings corresponding to valid values are to be displayed in a generated module
Prompt: Show Meaning Uppercase Defined on ITE supertype | SHOW_MEANING
Language specific values | |
| SOFT_LOV | VARCHAR2(1) | N | Applicable when unbound item has valid values defined directly against it, as opposed to being in a domain. Value of Y indicates that value of unbound item is to be checked against a table (ie soft coded)
Prompt: Dynamic List ? Uppercase | YESNO | N |
| SORTING_ORDER | VARCHAR2(1) | Y | The sorting order of the item - Ascending or Descending.
Prompt: Sort Order Uppercase Defined on ITE supertype | SORTING_ORDER | |
| START_TAB | NUMBER(10, 0) | Y | Numeric label of the tab at which start of the item is to be vertically aligned
Prompt: Start Tab Stop Range: 1 to 9999999999 Defined on ITE supertype | ||
| TRUNCATE_FLAG | VARCHAR2(1) | N | Indicates whether the text in the item should be allowed to wrap around on to another line or be truncated.
Prompt: Wrap Style Uppercase Defined on ITE supertype | MCI_TRUNCATE_FLAG | W |
| UNBOUND_TYPE | VARCHAR2(16) | N | Classification of the unbound item
Prompt: Unbound Type Uppercase | UNBOUND_TYPE
Language specific values | SQL EXPRESSION |
| UPDATE_FLAG | VARCHAR2(1) | N | Indicates whether the generated module will allow the user to update the value of this item
Prompt: Update ? Uppercase Defined on ITE supertype | YESNO | N |
| USAGE_SEQUENCE | NUMBER(6, 0) | N | The order in which this item is used by the module component
Prompt: Usage Sequence System maintained: API provides a value only if left null by the user Defined on ITE supertype | ||
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DERIVATION_TEXT | CDEXPR | Derivation Text |
| DESCRIPTION | CDIDSC Defined on ITE supertype |
Description |
| HELP | CDHELP Defined on ITE supertype |
User/Help Text |
| NOTES | CDINOT Defined on ITE supertype |
Notes |
| PLSQL | CDIPLS Defined on ITE supertype |
PL/SQL Block |
| UTXT | CGUTXT | User Text Areas |
| Other Properties |
|---|
| UNBOUND_ITEM 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 UNBOUND_ITEM:
Note: