Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | DATASTORE |
| Short Name | DST |
| View Name | CI_DATASTORES |
| Description | Definition of a datastore, providing the source or destination for |
| one or more dataflows | |
| BPR use datastores for material stores as well as stores of data. | |
| Sub-type of | SHAREABLE_ELEMENT |
| Versioning: | Structure of DATASTORE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
SHORT_IDENTIFIER NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DST |
| Changes: | Summary of changes to DATASTORE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| BUSINESS_UNIT_REFERENCE | Y | Prompt: Business Unit | May be the responsibility of one and only one BUSINESS_UNIT | |
| FUNCTION_REFERENCE | Y | Prompt: Function | May be owned by one and only one FUNCTION | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| 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 | TIME_UNIT1 | |
| AVERAGE_VOLUME | NUMBER(9, 0) | Y | BPR. Average volume of this store
Prompt: Average Volume | ||
| BPR_USE_IN_GENERATE_FLAG | VARCHAR2(1) | N | BPR. Indicates whether this store is to be used on generation of functions
Prompt: BPR Use in Generation ? Uppercase | YESNO | N |
| CPA_FINISH_DATE | DATE | Y | BPR. Finish date calculated by CPA
Prompt: CPA Finish Date System maintained Not updatable by user | ||
| CPA_RELATIVE_FINISH_TIME | NUMBER(23, 3) | Y | BPR. Finish, 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, 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 System maintained Not updatable by user | ||
| CRITICAL_PATH_FLAG | VARCHAR2(1) | N | BPR. Indicates whether this datastore is on the critical path
Prompt: Critical Path ? Uppercase System maintained Not updatable by user | YESNO | N |
| DATASTORE_TYPE | VARCHAR2(10) | Y | The datastore type e.g. 'M'anual,'C'omputer.
Prompt: Type Uppercase | DATASTORE_TYPE Non-enforced | |
| 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 datastore in application system from which this datastore has been exported
Not displayed | ||
| FREQUENCY | NUMBER(10, 0) | Y | BPR. Indicates the frequency with which this datastore is accessed
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 | ||
| MAXIMUM_VOLUME | NUMBER(9, 0) | Y | BPR. Maximum volume of this store
Prompt: Maximum Volume | ||
| MEASURED_TIME_1 | NUMBER(23, 3) | Y | BPR. An actual total time recorded for the datastore
Prompt: Measured Time 1 | ||
| MEASURED_TIME_2 | NUMBER(23, 3) | Y | BPR. An actual total time recorded for the datastore
Prompt: Measured Time 2 | ||
| MEASURED_TIME_3 | NUMBER(23, 3) | Y | BPR. An actual total time recorded for the datastore
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 | TIME_UNIT | |
| MINIMUM_VOLUME | NUMBER(9, 0) | Y | BPR. Minimum volume of this store
Prompt: Minimum Volume | ||
| NAME | VARCHAR2(40) | N | The name of this datastore.
Prompt: Name Uppercase | ||
| 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 textual, 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 | 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 | TIME_UNIT | |
| POST_DELAY_TIME | NUMBER(23, 3) | Y | BPR. Delay after work has finished on this datastore
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 | TIME_UNIT | |
| PRIOR_DELAY_TIME | NUMBER(23, 3) | Y | BPR. Delay before work starts on this datastore
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 | TIME_UNIT | |
| QUALITY_CHECK_TIME | NUMBER(23, 3) | Y | BPR. Time taken for quality checking this datastore
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 | TIME_UNIT | |
| QUALITY_PERCENT | NUMBER(3, 0) | Y | BPR. An indication of the quality of this store, expressed as a percentage (eg number of perfect widgets per 100). Used primarily in manufacturing.
Prompt: Quality Percentage | ||
| REMARK | VARCHAR2(70) | Y | Any notes or comments about this datastore.
Prompt: Comment | ||
| RESOURCE_REQUIRED_1 | VARCHAR2(100) | Y | BPR. The main resource required to carry out this job
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 | ||
| SHORT_IDENTIFIER | VARCHAR2(10) | N | The short reference to identify this datastore.
Prompt: Id Uppercase | ||
| SOUND_FILE | VARCHAR2(60) | Y | BPR. Sound file used in the Process Modeller
Prompt: Sound File | ||
| STORE_TYPE | VARCHAR2(1) | Y | BPR. Classification of the type of store, 'Data', 'Material' or 'Unclassified'
Prompt: Store Type | STORE_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 | TIME_UNIT | |
| TOTAL_TIME | NUMBER(23, 3) | Y | BPR. Total time taken, 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 | TIME_UNIT | |
| VALUE_ADDED | VARCHAR2(1) | Y | BPR. An indication of the value this store 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 taken to carry out this datastore
Prompt: Work Time | ||
| WORK_TIME_UNIT | VARCHAR2(10) | Y | BPR. Unit of time in which WORK_TIME is expressed
Prompt: Work Time Unit | TIME_UNIT | |
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| PROBLEM_AREAS | BPRPRO | Problem Areas |
| SIMPLE_RULES | BPRRUL | Simple Rules |
| VALUE_CHAIN_ANALYSIS | BPRVCA | Value Chain Analysis |
| Other Properties |
|---|
| DATASTORE 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 DATASTORE:
Note: