Element Type Definition: DATA_BOUND

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	DATA_BOUND_ITEM
Short Name	DBI
View Name	CI_DATA_BOUND_ITEMS
Description	A DATA_BOUND_ITEM is an ITEM that is a usage of a column in a table.

	(ITEMS were previously called MODULE_DETAIL_COLUMN_USAGES)

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 DATA_BOUND_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
COLUMN_REFERENCE	N	Prompt: Column	Must be a usage of one and only one COLUMN
DETAIL_TABLE_USAGE_REFERENCE	N	Prompt: Table Usage Transferable only if null	Must be within one and only one MODULE_DETAIL_TABLE_USAGE
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
CONTEXT_OPTION_QUERY_FLAG	VARCHAR2(1)	N	*Indicates whether the Oracle ConText Option 'contains' clause is to be used to query this item. (Oracle Context being the new SQLTextRetrieval)** Prompt: ConText Option ? 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 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 datatype to be used for the bound item in reports and screens Prompt: Display Type Uppercase	DISPLAY DATATYPE 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
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
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
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
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
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

Other Properties
DATA_BOUND_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: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference DATA_BOUND_ITEM:

Each ARGUMENT_ITEM_USAGE must be of one and only one ITEM
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each LOV_INCLUSION may be bound to one and only one ITEM
Each PREFERENCE_SET_USAGE must be for one and only one CIELEMENT (in arc)
Each PASSED_VALUE may be the value of one and only one ITEM (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT
Each USER_PREFERENCE must be for one and only one CIELEMENT (in arc)

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype