Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | FUNCTION |
| Short Name | FUN |
| View Name | CI_FUNCTIONS |
| Description | A business function identified during analysis of business |
| requirements | |
| Sub-type of | NON_SHAREABLE_ELEMENT |
| Versioning: | Structure of FUNCTION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
FUNCTION_LABEL SHORT_DEFINITION |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_FUN |
| Changes: | Summary of changes to FUNCTION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| COMMON_FUNCTION_REFERENCE | Y | Prompt: Master Function | May be a copy of one and only one FUNCTION | |
| PARENT_REFERENCE | Y | Prompt: Parent Function | May be a part decomposition of 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 Uppercase | TIME_UNIT1 | |
| BPR_GENERATE_FLAG | VARCHAR2(1) | N | BPR. Indicates whether this function is to be generated by BPR
Prompt: BPR Generate ? Uppercase | YESNO | N |
| COMPETITIVE_INDEX_VALUE | NUMBER(5, 2) | Y | BPR. Value of the process index with respect to competitors
Prompt: Competitive Index Value | ||
| 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 function, 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 function, 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 |
| ELEMENTARY_FLAG | VARCHAR2(1) | N | Indicates whether or not the function is elementary.
Prompt: Elementary ? Uppercase | YESNO | N |
| 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 function in application system from which this function has been exported
Not displayed | ||
| FREQUENCY | NUMBER(6, 0) | Y | The frequency with which the function is carried out.
Prompt: Frequency Range: 0 to 999999 | ||
| FREQUENCY_UNIT | VARCHAR2(10) | Y | The unit of time for the frequency e.g. 'S'econd,'M'inute.
Prompt: Frequency Unit | TIME_UNIT Non-enforced | |
| FUNCTION_LABEL | VARCHAR2(30) | N | A unique label for this function.
Prompt: Label Uppercase | ||
| FUNCTION_TYPE | VARCHAR2(2) | Y | BPR. Indicates the nature of the function (eg 'Decision', 'Data Entry', 'Report' etc)
Prompt: Function Type Uppercase | FUNCTION_TYPE | |
| 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 | ||
| MEASURED_TIME_1 | NUMBER(23, 3) | Y | BPR. An actual total time recorded for the function
Prompt: Measured Time 1 | ||
| MEASURED_TIME_2 | NUMBER(23, 3) | Y | BPR. An actual total time recorded for the function
Prompt: Measured Time 2 | ||
| MEASURED_TIME_3 | NUMBER(23, 3) | Y | BPR. An actual total time recorded for the function
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 | |
| NOTE_PICTURE_FILE | VARCHAR2(240) | Y | BPR. Name of graphical file used for annotation.
Prompt: Note Picture File | ||
| NOTE_TEXT | VARCHAR2(240) | Y | BPR. Text used for annotation
Prompt: Note Text | ||
| NOTE_TYPE | VARCHAR2(1) | Y | BPR. Classifies the type of annotation
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 work has finished on this function
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 work begins on this function
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 | BPR. Time for quality checking on this function
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 function expressed as a percentage (eg number of perfect widgets per 100 produced). Used primarily in manufacturing.
Prompt: Quality Percentage | ||
| 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 | ||
| RESPONSE_NEEDED | VARCHAR2(12) | Y | Indicates whether the implementation of the function is to be immediate (I) or overnight (O).
Prompt: Response Needed Uppercase | RESPONSE_TIME Non-enforced | |
| SEQUENCE_IN_PARENT | NUMBER(6, 0) | N | The sequence of this function within the parent function.
Prompt: Sequence in Parent System maintained: API provides a value only if left null by the user Range: 1 to 999999 | ||
| SHORT_DEFINITION | VARCHAR2(240) | N | A short definition/description of this function.
Prompt: Short Definition | ||
| SOUND_FILE | VARCHAR2(60) | Y | BPR. Sound file used in the Process Modeller
Prompt: Sound File | ||
| 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 function, 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 | |
| TO_BE_AUTOMATED_FLAG | VARCHAR2(1) | N | BPR. Indicates whether process step is intended to be automated (as opposed to being a manual process). This is information only, to record the intention in the early stages, before MODULES and MODULE_FUNCTIONS exist
Prompt: Intention to Automate ? Uppercase | YESNO | Y |
| VALUE_ADDED | VARCHAR2(1) | Y | BPR. An indication of the value this function 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 to carry out this function
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 | |
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| COMPETITIVE_INDEX_NOTES | BPRCIN | Competitive Index Notes |
| DESCRIPTION | CDIDSC | Description |
| ENTITY_NOTES | BPRENN | Entity Notes |
| NOTES | CDINOT | Notes |
| PROBLEM_AREAS | BPRPRO | Problem Areas |
| SIMPLE_RULES | BPRRUL | Simple Rules |
| VALUE_CHAIN_ANALYSIS | BPRVCA | Value Chain Analysis |
| Other Properties |
|---|
| FUNCTION 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 FUNCTION:
Note: