Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | BUSINESS_UNIT |
| Short Name | BUN |
| View Name | CI_BUSINESS_UNITS |
| Description | Business unit definitions. |
| Business units are also used by BPR to represent roles, in a similar | |
| way to HR. A role is typically at the leaf level of a business | |
| unit hierarchy. | |
| Sub-type of | SHAREABLE_ELEMENT |
| Versioning: | Structure of BUSINESS_UNIT versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME SHORT_NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_BUN |
| Changes: | Summary of changes to BUSINESS_UNIT in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| PARENT_REFERENCE | Y | Prompt: Parent | May be part of one and only one BUSINESS_UNIT | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| 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 business unit in application system from which this business unit has been exported
Not displayed | ||
| HEADCOUNT | NUMBER(10, 0) | Y | BPR. Number of people in this business unit
Prompt: Headcount | ||
| 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 | ||
| NAME | VARCHAR2(40) | N | The full name of the business unit.
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. Indicates whether the annotation is textual, graphical or both
Prompt: Note Type | ANNOTATION_TYPE | |
| PRIMARY_CONTACT | VARCHAR2(240) | Y | BPR. Name of the primary contact for this business unit or role
Prompt: Primary Contact | ||
| PRIMARY_LOCATION | VARCHAR2(100) | Y | BPR. Main location for this business unit or role
Prompt: Primary Location | ||
| REMARK | VARCHAR2(240) | Y | Any notes or comments about this business unit.
Prompt: Comment | ||
| ROLE_COST_RATE | NUMBER(23, 3) | Y | BPR. Applies to roles: rate per unit of time at which costs are incurred for this role
Prompt: Role Cost Rate | ||
| ROLE_COST_RATE_UNIT | VARCHAR2(10) | Y | BPR. Applies to roles: units of time in which ROLE_COST_RATE is expressed
Prompt: Role Cost Rate Unit Uppercase | TIME_UNIT | |
| ROLE_FLAG | VARCHAR2(1) | N | BPR. Indicates whether this business unit represents a role
Prompt: Role ? Uppercase | YESNO | N |
| ROLE_RESPONSIBILITIES | VARCHAR2(240) | Y | BPR. Applies to roles: a brief description of the main responsibilities of the role
Prompt: Role Responsibilities | ||
| ROLE_SKILL_1 | VARCHAR2(240) | Y | BPR. Applies to roles: Skill required for this role
Prompt: Role Skill 1 | ||
| ROLE_SKILL_2 | VARCHAR2(240) | Y | BPR. Applies to roles: Skill required for this role
Prompt: Role Skill 2 | ||
| ROLE_SKILL_3 | VARCHAR2(240) | Y | BPR. Applies to roles: Skill required for this role
Prompt: Role Skill 3 | ||
| ROLE_SKILL_4 | VARCHAR2(240) | Y | BPR. Applies to roles: Skill required for this role
Prompt: Role Skill 4 | ||
| SEQUENCE_IN_PARENT | NUMBER(6, 0) | Y | The sequence of this business unit within its parent
Prompt: Sequence in Parent | ||
| SHORT_NAME | VARCHAR2(10) | N | The short name of the business unit.
Prompt: Short Name Uppercase | ||
| SOUND_FILE | VARCHAR2(60) | Y | BPR. Sound file used in the Process Modeller
Prompt: Sound File | ||
| VIDEO_FILE | VARCHAR2(60) | Y | BPR. Video file used in the Process Modeller
Prompt: Video File | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| BUSINESS_UNIT 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 BUSINESS_UNIT:
Note: