Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | CHANGE_HISTORY |
| Short Name | MCH |
| View Name | CI_CHANGE_HISTORY |
| Description | CHANGE_HISTORY allows the user to log the changes made to a module and |
| record the location in which those changes are made. Its purpose is | |
| to facilitate the control of versions and releases of modules. | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: GENERAL_MODULE versionable object JAVA_MODULE versionable object ORACLE_OBJECT_TYPE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
MODULE_REFERENCE CHANGE_REF |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_MCH |
| Changes: | Summary of changes to CHANGE_HISTORY in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| MODULE_REFERENCE | N |
Prompt: Module / PLSQL / Java Def
Transferable only if null |
Must be for one and only one MODULE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| CHANGE_REF | VARCHAR2(10) | N | Unique reference number associated with this change. eg CR No., Task No
Prompt: Reference Uppercase | ||
| DATE_COMPLETE | DATE | Y | Date that this change is completed
Prompt: Date Complete Uppercase | ||
| DATE_OUT | DATE | N | Date the module was logged out for change
Prompt: Date Out Uppercase | ||
| DATE_TRANSFERRED | DATE | Y | Date that the module is transferred back to system test location
Prompt: Date Transferred Back Uppercase | ||
| DESCRIPTION | VARCHAR2(240) | N | Brief description of the change
Prompt: Short Description | ||
| DEVELOPER | VARCHAR2(20) | N | Name or id of the person who is implementing the change
Prompt: Developer Uppercase | ||
| DEVELOPMENT_DIR | VARCHAR2(30) | N | Directory or location where this change is being implemented
Prompt: Directory Uppercase | ||
| PRODUCT_VERSION | VARCHAR2(10) | N | Version number or project phase the change is being made for
Prompt: Version Uppercase | ||
| TRANSFERRED_BY | VARCHAR2(20) | Y | Name or id of person responsible for program file source transfer
Prompt: Transferred By Uppercase | ||
| 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 |
| FULL_DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| CHANGE_HISTORY 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:
|
Other element types that reference CHANGE_HISTORY:
Note: