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

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 will be stored in this column.

VERSION

NOT NULL

NUMBER

Version

STRATEGIC_THEME_COLOR NULLABLE VARCHAR2 (20 CHAR) Color of the strategic theme

Indexes

This table does not have any indexes.

Sequences

Sequence Name

Sequence Type

PFM_STRATEGIC_THEMES_S

STRATEGIC_THEME_ID