Element Type Definition: GENERAL

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	GENERAL_MODULE
Short Name	GEM
View Name	CI_GENERAL_MODULES
Description	A sub-type of MODULE, representing modules of any language other
	than PL/SQL, for example Forms, Reports, Charts etc.

Sub-type of	MODULE
Versioning:	Structure of GENERAL_MODULE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	SHORT_NAME
Used by:	Oracle Designer
Underlying table:	SDD_MOD
Changes:	Summary of changes to GENERAL_MODULE in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
LANGUAGE_REFERENCE	Y	Prompt: Language	May be written in one and only one LANGUAGE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
ACTIVITY_CODE	VARCHAR2(10)	Y	The name or code of the activity that is to implement this module. Prompt: Activity Uppercase Defined on MOD supertype
BOTTOM_TITLE	VARCHAR2(70)	Y	The title used for the bottom of each report, page or screen Prompt: Bottom Title
CANDIDATE_FLAG	VARCHAR2(1)	N	Indicates whether or not this module is a candidate module Prompt: Candidate ? Uppercase Defined on MOD supertype	YESNO	N
COMMAND_LINE	VARCHAR2(2000)	Y	The command line used to invoke this module from the operating system Prompt: Command Line
COMPLETION_STATUS	VARCHAR2(12)	N	Indicates whether or not the build of this module is complete. Prompt: Status Uppercase Defined on MOD supertype	MODULE_COMPLETION	NOT STARTED
COMPLEXITY	VARCHAR2(10)	Y	An indication of the complexity of this module. Prompt: Complexity Uppercase Defined on MOD supertype	MOD_COMPLEXITY
ESTIMATE	NUMBER(8, 2)	Y	An estimate of the time needed to complete this module. Prompt: Time Estimate Uppercase Defined on MOD supertype
ESTIMATE_UNITS	VARCHAR2(10)	Y	The units of time in which the estimate is measured e.g. DAYS, HOURS. Prompt: Estimate Units Defined on MOD supertype	TIME_UNIT Non-enforced
FORMAT	VARCHAR2(20)	Y	The format in which the screen or report is laid out e.g CONTROL BREAK, LABEL. Prompt: Layout Format Uppercase	MOD_FORMAT Language specific values
GENERAL_MODULE_TYPE	VARCHAR2(10)	N	Indicates type of module if other than the normal default type for the language. Values are language specific Prompt: Module Type Uppercase	GENERAL_MODULE_TYPE Language specific values	DEFAULT
HELP_CONTEXT_ID_PREFIX	NUMBER(3, 0)	Y	Used by the help generator. Unique Number to identify help context ids allocated for this module Prompt: Help Context Id Prefix
HELP_FILE_NAME	VARCHAR2(100)	Y	Used by the help generator. The name of the help project file created for this and called modules Prompt: Help File Name
HELP_GRAPHIC_FILE_NAME	VARCHAR2(60)	Y	Used by the help generator. The name of the graphic file (.bmp, .wmf, .mrb) for this module Prompt: Help Graphic File Name
IMPLEMENTATION_NAME	VARCHAR2(30)	Y	Name to be used on implementation, defaults to the module short name in lower case Prompt: Implementation Name
MODULE_TYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating whether the MODULE is a PLSQL_MODULE (PLM) or a GENERAL_MODULE (GEM) Not displayed Uppercase System maintained Not updatable by user Defined on MOD supertype	MODULE_SUBTYPE
NAME	VARCHAR2(40)	N	The name of this module. Prompt: Name Uppercase System maintained: API provides a value only if left null by the user Defined on MOD supertype
PREVENT_GENERATION_FLAG	VARCHAR2(1)	N	If set by the user, will stop the module from being generated again (but not re-generated, for those generators that have this capability) Prompt: Prevent Generation ? Uppercase	YESNO	N
PROJECT_CODE	VARCHAR2(12)	Y	The name or code of the project that contains this module. Prompt: Project Uppercase Defined on MOD supertype
PURPOSE	VARCHAR2(70)	N	The purpose of this module. Prompt: Purpose Defined on MOD supertype
RETURN_TYPE	VARCHAR2(70)	Y	The datatype of the value returned by this module. Prompt: Return Type	DATATYPE_LARGE Non-enforced
RUNTIME_PATHNAME	VARCHAR2(132)	Y	The full pathname of the runtime file. Prompt: Runtime Path
SHORT_NAME	VARCHAR2(20)	N	The short name of this module. Prompt: Short Name Uppercase Defined on MOD supertype
SHORT_TITLE	VARCHAR2(70)	Y	The title used on pull-down and bar menus. Prompt: Short Title
SIZE_OF_MODULE	NUMBER(6, 0)	Y	The estimated size of this module. Prompt: Size Defined on MOD supertype
SOURCE_PATHNAME	VARCHAR2(132)	Y	The full name of the file that contains the source code for this module. Prompt: Source Path
TASK_CODE	VARCHAR2(10)	Y	The name or code of the task that is to implement this module. Prompt: Task Uppercase Defined on MOD supertype
TOP_LEVEL_FLAG	VARCHAR2(1)	N	Used to 'top level' modules from those that can only be executed in the context of another module, via a MODULE_NETWORK. Orininally required for Module Dictionary support. Information only, not used by the generators Prompt: Top Level ? Uppercase Defined on MOD supertype	YESNO	N
TOP_TITLE	VARCHAR2(70)	Y	The title used for the top of each report page or screen Prompt: Top Title
PARENT_IVID	NUMBER(38, 0)	Y	Internal property, applicable to type body PLSQL_MODULES only. The IVID of the parent ORACLE_OBJECT_TYPE Not displayed System maintained Updatable only if null Defined on MOD supertype
PAC_REFERENCE	NUMBER(38, 0)	Y	Internal property, applicable to type body PLSQL_MODULES only. The IRID of the parent ORACLE_OBJECT_TYPE Not displayed System maintained Not updatable by user Defined on MOD supertype

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

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

Each SYSTEM_OBJECTIVE_OF_MODULE must be a use for one and only one MODULE
Each DISTRIBUTED_PROCESSING must be a use for one and only one MODULE
Each MODULE_ASSUMPTION must be a use for one and only one MODULE
Each PROBLEM_TO_MODULE must be a use for one and only one MODULE
Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each MODULE_ARGUMENT must be within one and only one GENERAL_MODULE (in arc)
Each BATCHLINE may be for generation or design capture of one and only one GENERAL_MODULE
Each ORACLE_USER_MODULE_ACCESS must be for one and only one GENERAL_MODULE
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 ROLE_MODULE_ACCESS must be for one and only one GENERAL_MODULE
Each LOV_INCLUSION must be the usage in one and only one GENERAL_MODULE
Each CHANGE_HISTORY must be for one and only one MODULE
Each MODULE_COMPONENT_LINK must be from one and only one GENERAL_MODULE
Each MODULE_COMPONENT_LINK must be to one and only one GENERAL_MODULE
Each MODULE_COMPONENT_INCLUSION must be the usage in one and only one GENERAL_MODULE
Each MODULE_BUSINESS_UNIT must be for one and only one MODULE
Each MODULE_FUNCTION must be for one and only one MODULE
Each MODULE_NETWORK must be for one and only one MODULE
Each MODULE_NETWORK must be of one and only one MODULE
Each MODULE_PROGRAM_DATUM must be for one and only one GENERAL_MODULE (in arc)
Each PROGRAM_DATUM must be owned by one and only one GENERAL_MODULE (in arc)
Each PREFERENCE_SET_USAGE must be for one and only one CIELEMENT (in arc)
Each SPECIFIC_LOV must be specific to one and only one GENERAL_MODULE
Each SPECIFIC_MCO must be specific to one and only one GENERAL_MODULE
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (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)
Each WINDOW must be within one and only one GENERAL_MODULE

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