Share this page
PFM_STRATEGIC_THEMES
This table stores strategic themes information.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
| PFM_PORTFOLIO_TYPES | PORTFOLIO_TYPE_ID | PORTFOLIO_TYPE_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
STRATEGIC_THEME_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATION_ DATE |
NOT NULL |
DATE |
Date when the record was created |
|
CREATED_ BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
LAST_ UPDATE_ DATE |
NOT NULL |
DATE |
Date when the record was last updated |
|
LAST_ UPDATED_ BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
|
STRATEGIC_THEME_NAME |
NOT NULL |
VARCHAR2(255 CHAR) |
Strategic theme name |
| STRATEGIC_THEME_TYPE | |||
| PARENT_ID | |||
|
OWNER_IDS |
NULLABLE |
VARCHAR2(200 CHAR) |
Identifiers for the owners of the strategic theme owners. IDs are separated by |
|
RANK |
NULLABLE |
NUMBER |
Strategic theme rank |
|
STATUS |
NULLABLE |
VARCHAR2(10 CHAR) |
Strategic theme status. Possible values: ACTIVE, DRAFT, RETIRED |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(4000 CHAR) |
Strategic theme description |
|
PORTFOLIO_ID |
NULLABLE |
NUMBER |
If the strategic theme is created by a portfolio instead of being managed globally, the portfolio ID is stored in this column. |
|
VERSION |
NOT NULL |
NUMBER |
Version |
| STRATEGIC_THEME_COLOR | NULLABLE | VARCHAR2 (20 CHAR) | Color of the strategic theme |
| PORTFOLIO_TYPE_ID | NULLABLE | NUMBER |
If the strategic theme is created by a portfolio type, the portfolio type ID is stored in this column. |
Indexes
This table does not have any indexes.
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
PFM_STRATEGIC_THEMES_S |
STRATEGIC_THEME_ID |
