Share this page
KPMO_BUSINESS_OBJECTIVES
This table stores all the information pertaining to a Business Objective.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
BUSINESS_OBJECTIVE_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
|
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
|
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
|
ENTITY_LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date a record in the entity was last updated |
|
BUSINESS_OBJECTIVE_NAME |
NOT NULL |
VARCHAR2(80) |
Name of the business objective, this is a translatable column |
|
OWNER_IDS |
NULLABLE |
VARCHAR2(200) |
List of owners that own this business objective |
|
RELATIVE_PRIORITY |
NULLABLE |
NUMBER |
Relative priority of this business objective |
|
STATE_CODE |
NULLABLE |
VARCHAR2(30) |
State of this business objective: see look up type "PMO business Objective states" |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(4000) |
Description of this business objective |
|
DEFINITION_LANGUAGE |
NOT NULL |
VARCHAR2(40) |
Language in which this business objective is defined |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KPMO_BUSINESS_OBJECTIVES_U1 |
UNIQUE |
1 |
BUSINESS_OBJECTIVE_ID |
Sequences
This table uses no sequences.
