Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | ITEM |
| Short Name | ITE |
| View Name | CI_ITEMS |
| Description | An item that can be included in a module component (eg a block in a |
| Form or a query in a report), previously known as | |
| MODULE_DETAIL_COLUMN_USAGE | |
| ITEM is the super-type of | |
| DATA_BOUND_ITEM - items that are a usage of a column in a table | |
| UNBOUND_ITEM - items not usages of columns, eg denormalised | |
| totals or summary information | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Non-instantiable super-type of | DATA_BOUND_ITEM |
| UNBOUND_ITEM | |
| As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc | |
| Underlying table: | SDD_ITE |
| Changes: | Summary of changes to ITEM in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| MODULE_UNIT_REFERENCE | N | Prompt: Module Unit | Must be within one and only one MODULE_UNIT | 86 |
| SQL_QUERY_SET_REFERENCE | N | Prompt: SQL Query Set | Must be within one and only one SQL_QUERY_SET | 86 |
| ITEM_GROUP_REFERENCE | Y | Prompt: Item Group | 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 | 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 | 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 | BASIC_DATATYPE | |
| DEFAULT_VALUE | VARCHAR2(60) | Y | Default value for this item
Prompt: Default Value | ||
| DEFAULT_VALUE_TYPE | VARCHAR2(15) | N | Indicates the nature of the default value
Prompt: Default Value Type Uppercase | DEFAULT_VALUE_TYPE | LITERAL |
| DISPLAY_FLAG | VARCHAR2(1) | N | Indicates whether the item is displayed by the module
Prompt: Display ? Uppercase | YESNO | Y |
| DISPLAY_FORMAT | VARCHAR2(60) | Y | The display format mask
Prompt: Format Mask | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| HIGHLIGHTING | VARCHAR2(240) | Y | Display formatting for this item e.g. BOLD, REVERSE.
Prompt: Formatting Uppercase | ||
| HINT_TEXT | VARCHAR2(132) | Y | Single line help text describing the purpose of the item
Prompt: Hint | ||
| IMPLEMENTATION_ITEM | VARCHAR2(30) | Y | Name of template/library object on which the generated item will be based.
Prompt: Template/Library Object | ||
| INSERT_FLAG | VARCHAR2(1) | N | Indicates whether the generated module will allow the user to enter values into this item
Prompt: Insert ? Uppercase | 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 | 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 | ITEM_TYPE | |
| JUSTIFICATION | VARCHAR2(6) | Y | Justification to be applied to the item on reports and screens
Prompt: Alignment Uppercase | JUSTIFICATION | |
| 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 | ||
| 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 | YESNO | N |
| ORDER_SEQUENCE | NUMBER(6, 0) | Y | Sequence of this item in an ORDER BY clause
Prompt: Order By Sequence | ||
| PROMPT | VARCHAR2(130) | Y | The prompt to be used for the item in reports and screens.
Prompt: Prompt | ||
| 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 | YESNODEF | D |
| REMARK | VARCHAR2(240) | Y | A comment on the use of the item by the module.
Prompt: Comment | ||
| 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 | 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 | SHOW_MEANING
Language specific values | |
| SORTING_ORDER | VARCHAR2(1) | Y | The sorting order of the item - Ascending or Descending.
Prompt: Sort Order Uppercase | 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 | ||
| 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 | MCI_TRUNCATE_FLAG | W |
| UPDATE_FLAG | VARCHAR2(1) | N | Indicates whether the generated module will allow the user to update the value of this item
Prompt: Update ? Uppercase | 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 | ||
| 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 |
| DESCRIPTION | CDIDSC | Description |
| HELP | CDHELP | User/Help Text |
| NOTES | CDINOT | Notes |
| PLSQL | CDIPLS | PL/SQL Block |
| Other Properties |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference ITEM:
Note: