Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | DATAFLOW |
| Short Name | DFL |
| View Name | CI_DATAFLOWS |
| Description | Dataflow definitions. |
| Dataflows are also used by BPR for flows other than data. This | |
| includes flows of materials and also "temporal" flows where there | |
| is a required precedence in terms of time but no actual flow of | |
| information or materials. | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: DATASTORE versionable object EXTERNAL versionable object FUNCTION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME FUNCTION_SOURCE_REFERENCE DATASTORE_SOURCE_REFERENCE EXTERNAL_SOURCE_REFERENCE FUNCTION_DEST_REFERENCE DATASTORE_DEST_REFERENCE EXTERNAL_DEST_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DFL |
| Changes: | Summary of changes to DATAFLOW in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| DATASTORE_SOURCE_REFERENCE | N | Prompt: Datastore | Must be from one and only one DATASTORE | 56 |
| EXTERNAL_SOURCE_REFERENCE | N | Prompt: External | Must be from one and only one EXTERNAL | 56 |
| FUNCTION_SOURCE_REFERENCE | N | Prompt: Function | Must be from one and only one FUNCTION | 56 |
| DATASTORE_DEST_REFERENCE | N | Prompt: Datastore | Must be to one and only one DATASTORE | 57 |
| EXTERNAL_DEST_REFERENCE | N | Prompt: External | Must be to one and only one EXTERNAL | 57 |
| FUNCTION_DEST_REFERENCE | N | Prompt: Function | Must be to one and only one FUNCTION | 57 |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ACTIVATE_FLOW_FLAG | VARCHAR2(1) | N | BPR. Indicates whether this dataflow is to be activated, overriding the normal decision making process of the animator, causing its destination to be animated
Prompt: Animate Branch ? Uppercase | YESNO | N |
| ADDITIONAL_COST_RATE | NUMBER(23, 3) | Y | BPR. Cost rate per unit (eg per unit of time, per use, per box) at which additional costs are incurred
Prompt: Additional Cost Rate | ||
| ADDITIONAL_COST_RATE_UNIT | VARCHAR2(10) | Y | BPR. Units to which ADDITIONAL_COST_RATE applies
Prompt: Additional Cost Rate Unit Uppercase | TIME_UNIT1 | |
| AND_OR_FLAG | VARCHAR2(1) | Y | BPR. Indicates and/or logic at the destination end of a dataflow, used to determine whether the destination becomes animated
Prompt: And/Or Flag Uppercase | AND_OR | |
| BPR_USE_IN_GENERATE_FLAG | VARCHAR2(1) | N | BPR. Indicates whether this dataflow is to be used on generation of functions
Prompt: BPR Use in Generation ? Uppercase | YESNO | N |
| CLASSIFICATION | VARCHAR2(20) | Y | A user defined classification for this dataflow e.g. letter, report.
Prompt: Classification Uppercase | ||
| CPA_FINISH_DATE | DATE | Y | BPR. Finish date calculated by CPA
Prompt: CPA Finish Date Uppercase System maintained Not updatable by user | ||
| CPA_RELATIVE_FINISH_TIME | NUMBER(23, 3) | Y | BPR. Finish of dataflow, expressed as a number of seconds from the start of the overall process to which it belongs. Populated by CPA.
Prompt: CPA Relative Finish Time System maintained Not updatable by user | ||
| CPA_RELATIVE_START_TIME | NUMBER(23, 3) | Y | BPR. Start of dataflow, expressed as a number of seconds from the start of the overall process to which it belongs. Populated by CPA.
Prompt: CPA Relative Start Time System maintained Not updatable by user | ||
| CPA_START_DATE | DATE | Y | BPR. Start date calculated by CPA
Prompt: CPA Start Date Uppercase System maintained Not updatable by user | ||
| CRITICAL_PATH_FLAG | VARCHAR2(1) | N | BPR. Indicates whether this function is on the critical path
Prompt: Critical Path ? Uppercase System maintained Not updatable by user | YESNO | N |
| DESCRIPTION | VARCHAR2(70) | Y | The description of this dataflow.
Prompt: Definition | ||
| DESTINATION_TYPE | VARCHAR2(15) | N | Arc 57 discriminator. The type of element which is the destination of this dataflow e.g. function, datastore.
Not displayed Uppercase System maintained Not updatable by user | DATAFLOW END TYPE | |
| EXECUTION_STRING | VARCHAR2(70) | Y | BPR. Execution String used in the Process Modeller
Prompt: Execution String | ||
| EXPORT_ID | NUMBER(38, 0) | Y | BPR. Internal ID of dataflow in application system from which this dataflow has been exported
Not displayed | ||
| FLOW_PERCENT | NUMBER(3, 0) | Y | BPR. Percentage of the 100% of output from the source that uses this particular flow
Prompt: Branch Percentage | ||
| FLOW_RULE | VARCHAR2(240) | Y | BPR. Rule that governs the start of this dataflow
Prompt: Branch Rule | ||
| FLOW_TYPE | VARCHAR2(1) | Y | BPR. Indicates the nature of the flow (eg 'Data', 'Material' etc)
Prompt: Flow Type Uppercase | FLOW_TYPE | |
| FREQUENCY | NUMBER(10, 0) | Y | BPR. Indicates the frequency with which this dataflow is executed
Prompt: Frequency | ||
| FREQUENCY_UNIT | VARCHAR2(10) | Y | BPR. The units in which FREQUENCY is expressed
Prompt: Frequency Unit Uppercase | TIME_UNIT | |
| ICON_FILE | VARCHAR2(60) | Y | BPR. Icon file used in the Process Modeller
Prompt: Icon File | ||
| IMAGE_FILE | VARCHAR2(60) | Y | BPR. Image file used in the Process Modeller
Prompt: Image File | ||
| INVISIBLE_FLAG | VARCHAR2(1) | N | BPR. Indicates whether the flow is to be displayed
Prompt: Invisible ? Uppercase | YESNO | N |
| MEASURED_TIME_1 | NUMBER(23, 3) | Y | BPR. An actual total time recorded for this dataflow
Prompt: Measured Time 1 | ||
| MEASURED_TIME_2 | NUMBER(23, 3) | Y | BPR. An actual total time recorded for this dataflow
Prompt: Measured Time 2 | ||
| MEASURED_TIME_3 | NUMBER(23, 3) | Y | BPR. An actual total time recorded for this dataflow
Prompt: Measured Time 3 | ||
| MEASURED_TIME_UNIT | VARCHAR2(10) | Y | BPR. Time unit in which MEASURED_TIME_1, 2 and 3 are expressed
Prompt: Measured Time Unit Uppercase | TIME_UNIT | |
| NAME | VARCHAR2(40) | N | The name of this dataflow.
Prompt: Name | ||
| NOTE_PICTURE_FILE | VARCHAR2(240) | Y | BPR. Name of file in which graphical annotation is stored
Prompt: Note Picture File | ||
| NOTE_TEXT | VARCHAR2(240) | Y | BPR. Brief textual note used for the annotation
Prompt: Note Text | ||
| NOTE_TYPE | VARCHAR2(1) | Y | BPR. Classifies the annotation as text, graphical or both
Prompt: Note Type | ANNOTATION_TYPE | |
| OVERHEAD_COST_RATE | NUMBER(23, 3) | Y | BPR. Cost rate per unit of time at which overhead costs are incurred
Prompt: Overhead Cost Rate | ||
| OVERHEAD_COST_RATE_UNIT | VARCHAR2(10) | Y | BPR. Unit of time to which the OVERHEAD_COST_RATE applies
Prompt: Overhead Cost Rate Unit Uppercase | TIME_UNIT | |
| PERSON_COST_RATE | NUMBER(23, 3) | Y | BPR. Cost rate per unit of time at which "person" costs are incurred
Prompt: Person Cost Rate | ||
| PERSON_COST_RATE_UNIT | VARCHAR2(10) | Y | BPR. Unit of time to which the PERSON_COST_RATE applies
Prompt: Person Cost Rate Unit Uppercase | TIME_UNIT | |
| POST_DELAY_TIME | NUMBER(23, 3) | Y | BPR. Delay after dataflow
Prompt: Post Delay Time | ||
| POST_DELAY_TIME_UNIT | VARCHAR2(10) | Y | BPR. Time unit in which POST_DELAY_TIME is expressed
Prompt: Post Delay Time Unit Uppercase | TIME_UNIT | |
| PRIOR_DELAY_TIME | NUMBER(23, 3) | Y | BPR. Delay before this dataflow
Prompt: Prior Delay Time | ||
| PRIOR_DELAY_TIME_UNIT | VARCHAR2(10) | Y | BPR. Time unit in which PRIOR_DELAY_TIME is expressed
Prompt: Prior Delay Time Unit Uppercase | TIME_UNIT | |
| QUALITY_CHECK_TIME | NUMBER(23, 3) | Y | Time for quality checking this dataflow
Prompt: Quality Check Time | ||
| QUALITY_CHECK_TIME_UNIT | VARCHAR2(10) | Y | BPR. Unit of time in which QUALITY_CHECK_TIME is expressed
Prompt: Quality Check Time Unit Uppercase | TIME_UNIT | |
| QUALITY_PERCENT | NUMBER(3, 0) | Y | BPR. An indication of the quality of this dataflow, expressed as a percentage (eg the number of perfect widgets per 100). Used primarily in manufacturing.
Prompt: Quality Percentage | ||
| RESOURCE_REQUIRED_1 | VARCHAR2(100) | Y | BPR. The main resource required for this dataflow
Prompt: Resource Required 1 | ||
| RESOURCE_REQUIRED_2 | VARCHAR2(100) | Y | BPR. Secondary resource
Prompt: Resource Required 2 | ||
| RESOURCE_REQUIRED_3 | VARCHAR2(100) | Y | BPR. Secondary resource
Prompt: Resource Required 3 | ||
| RESOURCE_REQUIRED_4 | VARCHAR2(100) | Y | BPR. Secondary resource
Prompt: Resource Required 4 | ||
| SIGNIFICANT_AT_DEST | VARCHAR2(1) | N | BPR. Indicates whether this dataflow is of primary significance to its destination
Prompt: Significant at Destination ? Uppercase | YESNO | N |
| SIGNIFICANT_AT_SOURCE | VARCHAR2(1) | N | BPR. Indicates whether this dataflow is of primary significance to its source
Prompt: Significant at Source ? Uppercase | YESNO | N |
| SOUND_FILE | VARCHAR2(60) | Y | BPR. Sound file used in the Process Modeller
Prompt: Sound File | ||
| SOURCE_TYPE | VARCHAR2(15) | N | Arc 56 discriminator. The source type of this dataflow e.g. datastore, function.
Not displayed Uppercase System maintained Not updatable by user | DATAFLOW END TYPE | |
| TOTAL_COST_RATE | NUMBER(23, 3) | Y | BPR. Cost rate per unit of time at which total costs are incurred
Prompt: Total Cost Rate | ||
| TOTAL_COST_RATE_UNIT | VARCHAR2(10) | Y | BPR. Unit of time to which the TOTAL_COST_RATE applies
Prompt: Total Cost Rate Unit Uppercase | TIME_UNIT | |
| TOTAL_TIME | NUMBER(23, 3) | Y | BPR. Total time for this dataflow, inclusive of delays
Prompt: Total Time | ||
| TOTAL_TIME_UNIT | VARCHAR2(10) | Y | BPR. Unit of time in which TOTAL_TIME is expressed
Prompt: Total Time Unit Uppercase | TIME_UNIT | |
| VALUE_ADDED | VARCHAR2(1) | Y | BPR. An indication of the value this dataflow adds to the overall process to which it belongs
Prompt: Value Added Uppercase | VALUE_ADDED | |
| VIDEO_FILE | VARCHAR2(60) | Y | BPR. Video file used in the Process Modeller
Prompt: Video File | ||
| WORK_TIME | NUMBER(23, 3) | Y | BPR. Time this dataflow takes
Prompt: Work Time | ||
| WORK_TIME_UNIT | VARCHAR2(10) | Y | BPR. Unit of time in which WORK_TIME is expressed
Prompt: Work Time Unit Uppercase | TIME_UNIT | |
| 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 |
| DESCRIPTION_TEXT | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| PROBLEM_AREAS | BPRPRO | Problem Areas |
| SIMPLE_RULES | BPRRUL | Simple Rules |
| VALUE_CHAIN_ANALYSIS | BPRVCA | Value Chain Analysis |
| Other Properties |
|---|
| DATAFLOW 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 DATAFLOW:
Note: