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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: