Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | PLANNING_ITEM |
| Short Name | A9 |
| View Name | CI_PLANNING_ITEMS |
| Description | Planning data specific to a business unit at a specific location. For |
| example, where a business operates at more than one site, the budgets | |
| may be apportioned between the sites. Similarly, if more than one | |
| business unit resides at the same location, each business unit may be | |
| responsible for a proportion of the costs. | |
| Sub-type of | INTERSECTION |
| Versioning: | Belongs to: LOCATION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
BUSINESS_UNIT_REFERENCE LOCATION_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_A9 |
| Changes: | Summary of changes to PLANNING_ITEM in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| BUSINESS_UNIT_REFERENCE | N |
Prompt: Business Unit
Transferable only if null |
Must be a use for one and only one BUSINESS_UNIT | |
| LOCATION_REFERENCE | N |
Prompt: Location
Transferable only if null |
Must be a part of one and only one LOCATION | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| BUDGET | VARCHAR2(16) | Y | The budget for this business unit at this location. (This OUGHT to be numeric, but is being left as varchar2 because of the difficulty in converting existing CD 5.1 data)
Prompt: Budget | ||
| BUNIT_OF_MEASURE | VARCHAR2(20) | Y | The unit of measure for the budget.
Prompt: Budget Unit | ||
| CDATE_EFFECTIVE | VARCHAR2(20) | Y | The date on which the planning item is to come into effect.
Prompt: Date Effective | ||
| COMMENTS | VARCHAR2(70) | Y | A comment about the association
Prompt: Comment | ||
| HCUNIT_OF_MEASURE | VARCHAR2(20) | Y | The unit of measure for the headcount.
Prompt: Headcount Unit | ||
| HEADCOUNT | VARCHAR2(20) | Y | The headcount for this business unit at this location.
Prompt: Headcount | ||
| SET_BY | VARCHAR2(30) | Y | The person or committee that was responsible for setting the planning item.
Prompt: Set By | ||
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Common repository version identifier of owning PAC
Not displayed System maintained Updatable only if null Defined on SE supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed System maintained Not updatable by user Defined on SE supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
| PLANNING_ITEM 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 PLANNING_ITEM:
Note: