Element Type Definition: LIST_OF

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	LIST_OF_VALUES
Short Name	LOV
View Name	CI_LISTS_OF_VALUES
Description
Sub-type of	MODULE_UNIT
Non-instantiable super-type of	REUSABLE_LOV
	SPECIFIC_LOV

	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_MUN

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
DISPLAY_TITLE	VARCHAR2(70)	Y	The title to be displayed in screens and reports for this module unit Prompt: Title Defined on MUN supertype
HELP_CONTEXT_ID_PREFIX	NUMBER(3, 0)	Y	If specified, Help Generator will use it to allocate unique help context ids for all help items derived from the component Prompt: Help Context Id Prefix
IMPLEMENTATION_ITEM	VARCHAR2(30)	Y	Name of template/library object on which the generated list of values will be based. Prompt: Template/Library Object
LAYOUT_STYLE	VARCHAR2(20)	Y	Layout style to be applied to this module unit Prompt: Layout Style Uppercase Defined on MUN supertype	MTI_REPORT_FORMAT Language specific values
MODULE_UNIT_SUBTYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating the type of MODULE_UNIT Not displayed Uppercase System maintained Not updatable by user Defined on MUN supertype	MUN_SUBTYPE
NAME	VARCHAR2(30)	N	Name by which this module unit is identified Prompt: Name Uppercase Defined on MUN supertype
REQ_PAGE_HEIGHT	NUMBER(6, 0)	Y	Required page/popup height. In units specified in the template form Prompt: Height Defined on MUN supertype
REQ_PAGE_WIDTH	NUMBER(6, 0)	Y	Required page/popup width. In units specified in the template form Prompt: Width Defined on MUN supertype
ROWS_DISPLAYED	NUMBER(10, 0)	Y	The number of rows of the base table to be displayed in this module unit Prompt: Rows Displayed Defined on MUN supertype
SHORT_DESCRIPTION	VARCHAR2(60)	Y	Short textual description of the module unit Prompt: Short Description Defined on MUN 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 MUN 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 MUN supertype

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC Defined on MUN supertype	Description
HELP	CDHELP	User/Help Text
NOTES	CDINOT Defined on MUN supertype	Notes

Other Properties
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 LIST_OF_VALUES:

Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
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 ITEM must be within one and only one MODULE_UNIT (in arc)
Each LOV_INCLUSION must be the usage of one and only one LIST_OF_VALUES
Each MODULE_DETAIL_TABLE_USAGE must be within one and only one MODULE_UNIT (in arc)
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each SQL_QUERY_SET must be inset operation with one and only one LIST_OF_VALUES (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

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