Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | MODULE |
| Short Name | MOD |
| View Name | CI_MODULES |
| Description | Definition of a module |
| Sub-type of | SHAREABLE_ELEMENT |
| Non-instantiable super-type of | GENERAL_MODULE |
| JAVA_MODULE | |
| PLSQL_MODULE | |
| 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_MOD |
| Changes: | Summary of changes to MODULE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| 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 | ||
| CANDIDATE_FLAG | VARCHAR2(1) | N | Indicates whether or not this module is a candidate module
Prompt: Candidate ? Uppercase | YESNO | N |
| COMPLETION_STATUS | VARCHAR2(12) | N | Indicates whether or not the build of this module is complete.
Prompt: Status Uppercase | MODULE_COMPLETION | NOT STARTED |
| COMPLEXITY | VARCHAR2(10) | Y | An indication of the complexity of this module.
Prompt: Complexity Uppercase | MOD_COMPLEXITY | |
| ESTIMATE | NUMBER(8, 2) | Y | An estimate of the time needed to complete this module.
Prompt: Time Estimate Uppercase | ||
| ESTIMATE_UNITS | VARCHAR2(10) | Y | The units of time in which the estimate is measured e.g. DAYS, HOURS.
Prompt: Estimate Units | TIME_UNIT Non-enforced | |
| 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 | 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 | ||
| PROJECT_CODE | VARCHAR2(12) | Y | The name or code of the project that contains this module.
Prompt: Project Uppercase | ||
| PURPOSE | VARCHAR2(70) | N | The purpose of this module.
Prompt: Purpose | ||
| SHORT_NAME | VARCHAR2(20) | N | The short name of this module.
Prompt: Short Name Uppercase | ||
| SIZE_OF_MODULE | NUMBER(6, 0) | Y | The estimated size of this module.
Prompt: Size | ||
| TASK_CODE | VARCHAR2(10) | Y | The name or code of the task that is to implement this module.
Prompt: Task Uppercase | ||
| 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 | YESNO | N |
| 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 | ||
| 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 | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| RELEASE_NOTES | CDRNOT | Release Notes |
| Other Properties |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference MODULE:
Note: