Element Type Definition: ACTIVITY

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	ACTIVITY_DEFINITION
Short Name	ACT
View Name	CI_ACTIVITY_DEFINITIONS
Description	An activity describes something that is done in the business, or in
	the system. It can be performed in different contexts (for example
	by different organization units), and so an activity is described
	independently of the context in which it may be performed.

	An activity may be constrained by a "pre" condition and/or a "post"
	condition. These are rules that must evaluate to true in order for
	the activity to start and/or finish. If defined, these are applicable
	in all contexts in which that activity is used

Sub-type of	SHAREABLE_ELEMENT
Versioning:	Structure of ACTIVITY_DEFINITION versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_ACT

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
METHOD_REFERENCE	Y	Prompt: Method	May be the specifier of one and only one METHOD	117
PACKAGE_REFERENCE	Y	Prompt: Package	May be representing a method owned by one and only one PACKAGE	117
GENERAL_ACTION_REFERENCE	Y	Prompt: General Action	May be the activity for one and only one GENERAL_ACTION	119
USE_CASE_REFERENCE	Y	Prompt: Use Case	May be the activity for one and only one USE_CASE	119
EXECUTABLE_FILE_REFERENCE	Y	Prompt: Executable File	May be invoking the execution of one and only one PRIMARY_ACCESS_FILE
ICON_FILE_REFERENCE	Y	Prompt: Icon File	May be iconized using one and only one PRIMARY_ACCESS_FILE
MAPPING_FILE_REFERENCE	Y	Prompt: Mapping File	May be using the mapping file of one and only one PRIMARY_ACCESS_FILE
POST_RULE_REFERENCE	Y	Prompt: Post Condition	May be constrained by post condition of one and only one NAMED_RULE
PRE_RULE_REFERENCE	Y	Prompt: Pre Condition	May be constrained by pre condition of one and only one NAMED_RULE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
ACTIVITY_DEFINITION_FOR	VARCHAR2(3)	Y	Arc 119 discriminator. Internal property indicating the type of element the arc refers to Not displayed Uppercase System maintained Not updatable by user	ACTIVITY_DEFINITION_FOR
DEFAULT_MESSAGING_AUDIT	VARCHAR2(12)	Y	Applicable only to root activity of process to be executed by BPC, Sets the default auditing for all messages (ie transitions) within the process, but can be overridden on an individual message (transition) Prompt: Default Messaging Audit Uppercase	MESSAGING_AUDIT_TYPE
DEF_ADDITIONAL_COST_RATE	NUMBER(23, 3)	Y	Default ADDITIONAL_COST_RATE for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Additional Cost Rate
DEF_ADDITIONAL_COST_RATE_UNIT	VARCHAR2(10)	Y	Default ADDITIONAL_COST_RATE_UNIT for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Def Additional Cost Rate Unit Uppercase	TIME_UNIT1
DEF_EXECUTION_STRING	VARCHAR2(240)	Y	Default EXECUTION_STRING for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Execution String
DEF_FREQUENCY	NUMBER(6, 0)	Y	Default FREQUENCY for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Frequency
DEF_FREQUENCY_UNIT	VARCHAR2(10)	Y	Default FREQUENCY_UNIT for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Frequency Unit Uppercase	TIME_UNIT
DEF_MAX_DURATION	NUMBER(23, 3)	Y	Default MAX_DURATION for all ACTIVITY_USAGES based on this activity Prompt: Default Max Duration
DEF_MAX_DURATION_UNIT	VARCHAR2(10)	Y	Default MAX_DURATION_UNIT for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Max Duration Unit Uppercase	TIME_UNIT
DEF_MESSAGING_PRIORITY	NUMBER(6, 0)	Y	Applicable only to root activity of process for execution by BPC. Sets the default priority of all messages (ie transitions) within the process, which can be overridden on individual activity usages Prompt: Default Messaging Priority
DEF_MIN_DURATION	NUMBER(23, 3)	Y	Default MIN_DURATION for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Min Duration
DEF_MIN_DURATION_UNIT	VARCHAR2(10)	Y	Default MIN_DURATION_UNIT for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Min Duration Unit Uppercase	TIME_UNIT
DEF_QUALITY_PERCENT	NUMBER(3, 0)	Y	Default QUALITY_PERCENT for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Quality Percent
DEF_TOTAL_COST_RATE	NUMBER(23, 3)	Y	Default TOTAL_COST_RATE for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Total Cost Rate
DEF_TOTAL_COST_RATE_UNIT	VARCHAR2(10)	Y	Default TOTAL_COST_RATE_UNIT for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Total Cost Rate Unit Uppercase	TIME_UNIT
DEF_TOTAL_DURATION	NUMBER(23, 3)	Y	Default TOTAL_DURATION for all ACTIVITY_USAGES based on this activity Prompt: Default Total Duration
DEF_TOTAL_DURATION_UNIT	VARCHAR2(10)	Y	Default TOTAL_DURATION_UNIT for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Total Duration Unit Uppercase	TIME_UNIT
DEF_VALUE_ADDED	VARCHAR2(1)	Y	Default VALUE_ADDED for all ACTIVITY_USAGES based on this ACTIVITY Prompt: Default Value Added Uppercase	VALUE_ADDED
EXECUTION_MODE	VARCHAR2(3)	N	Indicates how this activity is normally executed Prompt: Execution Mode Uppercase	EXECUTION_MODE	INT
IMPLEMENTED_BY	VARCHAR2(3)	Y	Arc 117 discriminator. Internal property indicating the method, or the package that will contain the method, that will implement this activity Not displayed Uppercase System maintained Not updatable by user	ACT_IMPLEMENTED_BY
MESSAGING_ACTIVITY_TYPE	VARCHAR2(14)	Y	Indicates that this step is a message process step and, if so, which type. A message process step is not a business activity but has been added to define an executable process Prompt: Messaging Activity Type Uppercase	MESSAGING_ACTIVITY_TYPE
NAME	VARCHAR2(100)	N	Name of the activity Prompt: Name
VOLATILE_EXECUTION_INDICATOR	VARCHAR2(13)	Y	Applicable to message process steps. Prompt: Volatile Execution Indicator Uppercase	VOLATILE_EXECUTION_TYPE

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description
NOTES	CDINOT	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 ACTIVITY_DEFINITION:

Each ACTIVITY_DECOMP must be a part of one and only one ACTIVITY_DEFINITION
Each ACTIVITY_DECOMP must be a use of one and only one ACTIVITY_DEFINITION
Each ACTIVITY_OBJECTIVE must be for one and only one ACTIVITY_DEFINITION
Each ACTIVITY_USAGE must be a representation of one and only one ACTIVITY_DEFINITION
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 ELEMENT_RULE_USAGE must be applicable to one and only one CIELEMENT (in arc)
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each TAGGED_VALUE must be in the context of one and only one CIELEMENT (in arc)
Each TRANSITION must be from one and only one ACTIVITY_DEFINITION (in arc)
Each TRANSITION must be to one and only one ACTIVITY_DEFINITION (in arc)
Each UML_DEPENDENCY_CLIENT must be identifying as client one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_SUPPLIER must be identifying as supplier one and only one CIELEMENT (in arc)

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