Share this page

# Tables

This section describes the major changes to the data model since 9.50 as compared to their respective previous versions. Some tables have been deleted, some new tables have been introduced, some existing tables have been modified, some tables have been deprecated and are unused, and other tables have been replaced by views.

In this topic:

## Table changes in 26.2

The following table lists the changes to data tables in 26.2 as compared to version 25.4.

Table | Impact | Change Details
--- | --- | ---
PM_SP_CALENDAR_PRECEDENCE | Added in 26.2 |
KNTA_TS_APPROVAL_REMINDER_SENT | Added in 26.2 |
WIA_SCENARIOS | Modified in 26.2 | Added the columns START_DATE_ID and END_DATE_ID
KNTA_NOTIFICATIONS | Modified in 26.2 | Added the column REMINDER_FLAG and index KNTA_NOTIFICATIONS_N4
TM_TIME_SHEETS | Modified in 26.2 | Added index TM_TIME_SHEETS_N3
RSC_POSITION_FORECAST | Modified in 26.2 | Added index RSC_POSITION_FORECAST_N8
RSC_STAFF_PROF_ALLOCATION | Modified in 26.2 | Added index RSC_STAFF_PROF_ALLOCATION_N5

## Table changes in 25.4

The following table lists the changes to data tables in 25.4 as compared to version 25.3.

Table | Impact | Change Details
--- | --- | ---
WIA_SCENARIOS | Modified in 25.4 | Added the column RESOURCE_POOLS
KCRT_REQUEST_TYPE_SECURITY | Modified in 25.4 | Added the column CAN_DELETE_DRAFT_CODE

## Table changes in 25.3

The following table lists the changes to data tables in 25.3 as compared to version 25.2.

Table | Impact | Change Details
--- | --- | ---
WIA_SCENARIOS | Modified in 25.3 | Added the columns IS_LOCKED and SCENARIO_STATUS

## Table changes in 25.2

The following table lists the changes to data tables in 25.2 as compared to version 25.1.

Table | Impact | Change Details
--- | --- | ---
PPM_CHAT_MS_TEAMS_INFO | Added in 25.2 |
WIA_CONTENT_CHANGE_LOG | Added in 25.2 |
WIA_SCENARIO_LOG_MAPPING | Added in 25.2 |
WIA_SCENARIO_UNSYNCED | Added in 25.2 |
WIA_SCENARIOS | Modified in 25.2 | Added the column AUTO_SYNC_CONTENT_CHANGE

## Table changes in 25.1

The following table lists the changes to data tables in 25.1 as compared to version 24.4.

Table | Impact | Change Details
--- | --- | ---
WIA_SCENARIO_LOCKED | Added in 25.1 |
KNTA_USER_NOTIF_OPT_CONF | Added in 25.1 |
PPM_CONFIG_RECO_HIDDEN | Added in 25.1 |
PPM_CONFIG_RECOMMENDATIONS | Added in 25.1 |

## Table changes in 24.4

The following table lists the changes to data tables in PPM 24.4 as compared to PPM version 24.3.

Table | Impact | Change Details
--- | --- | ---
PPM_MENU_CUSTOM | Added in 24.4 |
PPM_MENU_SEED | Added in 24.4 |
KNTA_USER_NOTIF_OPT | Added in 24.4 |
KRSC_RSC_POOL_PERIOD_SUM | Modified in 24.4 | Added the columns TOTAL_HOUR and ROLLUP_HOUR
RSC_RP_NOTIFICATION_SETUPS | Modified in 24.4 | Added the column RSCRQ_SEND_WITHDRAW_TO_RPMGR

## Table changes in 24.3

The following table lists the changes to data tables in PPM 24.3 as compared to PPM version 24.2.

Table | Impact | Change Details
--- | --- | ---
KNTA_LICENSE_DATASOURCE | Modified in 24.3 | Added the column SOURCE
KNTA_USERS | Modified in 24.3 | Added the column LANGUAGE
RSC_POSITIONS | Modified in 24.3 | Added the column SHARED_RESOURCE_FLAG

## Table changes in 24.2

The following table lists the changes to data tables in PPM 24.2 as compared to PPM version 24.1.

Table | Impact | Change Details
--- | --- | ---
PPM_LANDING_FAVORITE_VIEW | Added in 24.2 |
PPM_USER_RECENT_ACTIONS | Added in 24.2 |
ITG_NOTES | Modified in 24.2 | Added the column NOTE_HTML
KNTA_NOTE_ENTRIES | Modified in 24.2 | Added the column NOTE_HTML
KCRT_REQUEST_TYPES | Modified in 24.2 | Added the column TABS_ENABLED_FLAG

## Table changes in 24.1

The following table lists the changes to data tables in PPM 24.1 as compared to PPM version 23.4.

Table | Impact | Change Details
--- | --- | ---
PPM_TAGS | Added in 24.1 |
PPM_API_KEYS | Modified in 24.1 | Added the column ENABLE_BEARER_TOKEN
DSH_DESKTOP_PAGES | Modified in 24.1 | Added the column PAGE_RELATIVE_URL
DSH_LANDING_PAGES | Modified in 24.1 | Added the column PAGE_RELATIVE_URL

## Table changes in 23.4

The following table lists the changes to data tables in PPM 23.4 as compared to PPM version 23.3.

Table | Impact | Change Details
--- | --- | ---
KCRT_REQUEST_TYPE_TABS | Added in 23.4 |
KNTA_USERS_AVATAR | Added in 23.4 |
WIA_SCENARIO_SNAPSHOTS | Added in 23.4 |
KNTA_REFERENCES | Modified in 23.4 | Changed the data type of the column PARAMETER1-20 from VARCHAR2(200) to VARCHAR2(500) Changed the data type of the column VISIBLE_PARAMETER1-20 from VARCHAR2(200) to VARCHAR2(500)

## Table changes in 23.3

The following table lists the changes to data tables in PPM 23.3 as compared to PPM version 2023.

Table | Impact | Change Details
--- | --- | ---
WIA_TEMPLATES | Added in 23.3 |
WIA_TEMPLATE_APPLIED | Added in 23.3 |
WIA_SCENARIOS | Added in 23.3 |
KNTA_NOTIF_TXN_BOT_SCHEDULE | Added in 23.3 |
KRSC_STAFF_PROF_PERIOD_SUM | Modified in 23.3 | Added the column PLAN_TOTAL_HOUR
PFM_BUSINESS_GOALS | Modified in 23.3 | Added the column PARENT_ID
KNTA_NOTIF_TXN_RECIPIENTS | Modified in 23.3 | Added the columns SENT_FLAG, STATUS, and INFO
PGM_PROGRAM_TYPES | Modified in 23.3 | Added the columns PROGRAM_TYPE_EDIT_ACCESS_ID and PROGRAM_TYPE_USAGE_ID

## Table changes in 2023

The following table lists the changes to data tables in PPM 2023 as compared to PPM version 10.0.4.

Table | Impact | Change Details
--- | --- | ---
PPM_WEB_HOOKS | Added in 2023 |
PPM_INT_AGILE_PORTFOLIO_MAP | Added in 2023 |
WP_USER_DATA | Modified in 2023 | Adds 80 more user data columns.
KCRT_FG_PFM_PROJECT | Modified in 2023 | The columns PRJ_PORTFOLIO_ID and PRJ_PORTFOLIO_NAME were deprecated.
KCRT_FG_PFM_PROGRAM | Modified in 2023 | The columns PRJ_PORTFOLIO_ID and PRJ_PORTFOLIO_NAME were deprecated.

## Table changes in 10.0.4

The following table lists the changes to data tables in PPM 10.0.4 as compared to PPM version 10.0.3.

Table | Impact | Change Details
--- | --- | ---
PPM_INT_AGILE_PORTFOLIO_AUDIT | Added in 10.0.4 |

## Table changes in 10.0.3

The following table lists the changes to data tables in PPM 10.0.3 as compared to PPM version 10.0.2.

Table | Impact | Change Details
--- | --- | ---
PPM_SAML_METADATA_CONFIG | Added in 10.0.3 |
RSC_POSITIONS | Modified in 10.0.3 | Added the column REGION_ID.
DSH_PORTLETS | Modified in 10.0.3 | Added the column LAYOUT

## Table changes in 10.0.2

The following table lists the changes to data tables in PPM 10.0.2 as compared to PPM version 10.0.1.

Table | Impact | Change Details
--- | --- | ---
KCRT_REQUEST_TYPE_SECURITY | Modified in 10.0.2 | Added the column CAN_SEARCH_CODE.
PFM_STRATEGIC_THEMES | Modified in 10.0.2 | Added the column PORTFOLIO_TYPE_ID. Added the foreign key PORTFOLIO_TYPE_ID.
PFM_BUSINESS_GOALS | Modified in 10.0.2 | Added the column PORTFOLIO_TYPE_ID.

## Table changes in 10.0.1

There are no table changes in 10.0.1.

## Table changes in 10.0

The following table lists the changes to data tables in PPM 10.0 as compared to PPM version 9.66.

Table | Impact | Change Details
--- | --- | ---
PPMIC_WORKPLAN_MAPPING | Modified in 10.0 | Changed the type of the column CONFIGURATION_DISPLAY_JSON from VARCHAR2 (4000) to CLOB (4000). Changed the type of the column CONFIGURATION_JSON from VARCHAR2 (4000) to CLOB (4000).
KNTA_USER_SESSIONS | Modified in 10.0 | Changed the type of the column BROWSER from VARCHAR2(80) to VARCHAR2(256).

## Table changes in 9.66

The following table lists the changes to data tables in PPM 9.66 as compared to PPM version 9.65.

Table | Impact | Change Details
--- | --- | ---
PPM_ODATA_LINKS | Added in 9.66 |
PPM_API_KEYS | Added in 9.66 |
DSH_PORTLET_PREFERENCES | Modified in 9.66 | Added the column DRILL_TO_PORTLET_ID
KNTA_COMMANDS | Modified in 9.66 | Added the column EVENT_CODE
PM_PROJECTS | Modified in 9.66 | Added the column PROGRESS

## Table changes in 9.65

The following table lists the changes to data tables in PPM 9.65 as compared to PPM version 9.64.

Table | Impact | Change Details
--- | --- | ---
PPM_ODATA_DATA_SOURCES | Added in 9.65 |

## Table changes in 9.64

There are no table changes in 9.64.

## Table changes in 9.63

The following table lists the changes to data tables in OpenText PPM 9.63 as compared to OpenText PPM version 9.62.

Table | Impact | Change Details
--- | --- | ---
PFM_CUSTOM_ICON | Added in 9.63 |
PFM_PORTFOLIO_TYPES | Added in 9.63 |
KNTA_USER_UPLOADED_FILES | Added in 9.63 |
PFM_PORTFOLIOS | Modified in 9.63 | Added the foreign keys PF_SETTINGS_ID and PORTFOLIO_TYPE_ID. Added the columns PORTFOLIO_TYPE_ID and PF_SETTINGS_ID Added the indexes PFM_PORTFOLIOS_N3 and PFM_PORTFOLIOS_N4
KCRT_REQUEST_TYPES | Modified in 9.63 | Added the columns DASHBOARD_ENABLED_FLAG and ENABLED_COPY_REQUEST_FLAG
KNTA_PARAM_SET_FIELDS | Modified in 9.63 | Added the column REVERSE_PARAMETER_SET_FIELD_ID

## Table changes in 9.62

The following table lists the changes to data tables in OpenText PPM 9.62 as compared to OpenText PPM version 9.61.

Table | Impact | Change Details
--- | --- | ---
PPM_SYNC_OPERATION_DETAILS | Modified in 9.62 | Changed the type of the column SERVER from VARCHAR2 (30) to VARCHAR2 (200)
KCRT_FG_MASTER_PROJ_REF_INT | Modified in 9.62 | Changed the type of the column REF_MASTER_PROJECT_NAME from VARCHAR2(80) to VARCHAR2(1200)
KNTA_NOTIFICATIONS | Modified in 9.62 | Added the column ENABLE_CHATBOT_APPROVALS

## Table changes in 9.61

The following table lists the changes to data tables in OpenText PPM 9.61 as compared to OpenText PPM version 9.60.

Table | Impact | Change Details
--- | --- | ---
DSH_BUILDER_DEF_PREFS | Added in 9.61 |
KNTA_PARAM_SET_FIELDS | Modified in 9.61 | Added the column ADVANCED_DEF_PROPERTY
KPFM_CONFIGURATIONS | Modified in 9.61 | Added the column ENABLE_OVERVIEW_FLAG
PFM_STRATEGIC_THEMES | Modified in 9.61 | Added the columns STRATEGIC_THEME_TYPE and PARENT_ID
WP_WORK_UNITS | Modified in 9.61 | Added the column RESOURCE_FROM_POSITION

## Table changes in 9.60

The following table lists the changes to data tables in OpenText PPM 9.60 as compared to OpenText PPM version 9.55.

Table | Impact | Change Details
--- | --- | ---
PPM_SYNC_OPERATIONS | Added in 9.60 |
PPM_SYNC_OPERATION_DETAILS | Added in 9.60 |
ITG_UI_VIEW_SETTINGS | Added in 9.60 |
PPM_CHAT_ACTIONS | Added in 9.60 |
PPM_CHAT_ACTION_CONTENTS | Added in 9.60 |
PPM_CHAT_ACTION_ENTITIES | Added in 9.60 |
PPM_CHAT_INTENTS_NLS | Added in 9.60 |
PPM_CHAT_INTENT_ITEMS | Added in 9.60 |
PPM_USAGE_MONITORING_SETTINGS | Added in 9.60 |
PPM_USAGE_MONITORING | Added in 9.60 |
DSH_DESKTOP_PAGES | Added in 9.60 |
PPM_FEATURE_TOGGLES | Modified in 9.60 | Added the column TAGS
DSH_HTML_PLUS_PORTLET_DEFS | Modified in 9.60 | Added the column EXTRA_DATASOURCES
DSH_LANDING_PAGES | Modified in 9.60 | Removed the column CUSTOMER_ID Added the columns RULE_SCOPE, PRIORITY, and RULE_CRITERIA.
KNTA_USER_PROFILES | Modified in 9.60 | Added the column PREVENT_USAGE_MONITORING
TM_PENDING_APPROVAL | Modified in 9.60 | Added the index TM_PENDING_APPROVAL_N2

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: