Element Type Definition: PROBLEM

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	PROBLEM
Short Name	E5
View Name	CI_PROBLEMS
Description	A business event or state that inhibits the progress of the enterprise
	toward its objective

Sub-type of	SHAREABLE_ELEMENT
Versioning:	Structure of PROBLEM versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer
Underlying table:	SDD_E5
Changes:	Summary of changes to PROBLEM in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
PROBLEM_REFERENCE	Y	Prompt: Parent Problem	May be part of one and only one PROBLEM

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
BENEFIT	VARCHAR2(70)	Y	A description of the benefits that result from the resolution of the problem. Prompt: Resolution Benefit
CAUSE_CATEGORY	VARCHAR2(20)	Y	The cause of the problem. Prompt: Cause Category Uppercase
CDATE_IDENTIFIED	VARCHAR2(20)	Y	The date on which the problem was first identified. Prompt: Date Identified
CDATE_SOLVED	VARCHAR2(20)	Y	The date on which the problem was solved. Prompt: Date Solved
COMMENTS	VARCHAR2(70)	Y	A comment about the element Prompt: Comment
IDENTIFIED_BY	VARCHAR2(30)	Y	The person, committee or event that identified the problem. Prompt: Identified By
NAME	VARCHAR2(40)	N	The name by which this problem is usually known. Prompt: Name Uppercase
OPPORTUNITIES	VARCHAR2(70)	Y	Any opportunities that may be triggered on the identification of a problem. Prompt: Opportunities
TYPE	VARCHAR2(20)	N	The type of problem, that is the severity level of the problem e.g. high, low. Prompt: Type Uppercase

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description
NOTES	CDINOT	Notes

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

Each BUSINESS_UNIT_TO_PROBLEM must be a use for one and only one PROBLEM
Each PROBLEM_TO_MODULE must be a part of one and only one PROBLEM
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 PROBLEM may be part of one and only one PROBLEM
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (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