Database Schema Changes

ccppmop159
The following
Classic PPM
database and data warehouse schema tables and columns are new, changed, or dropped in the specified release.
This page summarizes the changes in recent releases. To view the complete
detailed
Classic PPM
database and data warehouse schema files, see
Clarity
Advanced Reporting and Database Schema Index
.
Database and Data Warehouse Schema Changes:
2
2
New! Schema Changes from Release 15.8.1 to
15.9.0
Schema Changes from Release 15.8 to 15.8.1
Schema Changes from Release 15.7.1 to 15.8
Schema Changes from Release 15.7 to 15.7.1
Schema Changes from Release 15.6.1 to 15.7
Schema Changes from Release 15.6.0 to 15.6.1
Schema Changes from Release 15.5.1 to 15.6.0
Schema Changes from Release 15.5.0 to 15.5.1
Schema Changes from Release 15.4.1 to 15.5.0
Schema Changes from Release 15.4.0 to 15.4.1
Schema Changes from Release 15.3.0 to 15.4.0
Clarity
15.4 and higher releases use _v2 views instead of the old _v views. To learn more, see the 15.4 Change Impact and Upgrade documentation.
Schema Changes from Release 15.2.0 to 15.3.0
Schema Changes from Release 15.1.0 to 15.2.0
In the 15.2 schema files, you can safely ignore schema report entries or references to about a dozen new DWH_TRD tables. These tables are not available in Release 15.2. They are reserved for future use.
Schema Changes for Release 15.1 and Previous Releases
3
3
Database Schema Changes from Release 14.4.0 to 15.1.0
New Tables:
  • DWH_TMP_RECORD_KEYS
  • PRTODO
Updated Tables (New or Changed Columns):
  • CAL_ACTION_ITEMS: SUBJECT
  • CLB_NOTIFICATION_PARAMS: VALUE
  • CMN_SEC_USERS: TRACE_LEVEL_EXPIRATION
  • CMN_SEC_USERS: TRACE_LEVEL
  • CMN_SEC_USERS_N5: TRACE_LEVEL
  • DWH_SETTINGS: FIN_PLANS_POR_ONLY
Updated Tables (New or Changed Index):
  • CMN_SEC_USERS_N5
New Views (MS SQL):
  • DWH_SEC_USER_V.xml
  • DWH_INV_ASGN_I_PER_FACTS_V.xml
  • DWH_SEC_GLOBAL_RIGHT_V.xml
  • DWH_INV_TEAM_I_PER_FACTS_V.xml
Data WareHouse Schema Changes from Release 14.4.0 to 15.1.0
New Tables:
  • DWH_CMN_PERIOD_MAPPING
  • DWH_SEC_ASSIGN_PERM
  • DWH_SEC_ASSIGN_RIGHT
  • DWH_SEC_GLOBAL_RIGHT
  • DWH_SEC_GROUP
  • DWH_SEC_GROUP_HIER
  • DWH_SEC_PERM_ELEMENT
  • DWH_SEC_RIGHT
  • DWH_SEC_UNIT_BY_MODE
  • DWH_SEC_USER
  • DWH_SEC_USER_GROUP
  • DWH_TMP_RECORD_KEYS
  • DWH_X_RES_AVAIL_PER_FACTS_MV (Oracle)
Removed Tables:
  • DWH_INV_SECURITY
  • DWH_INV_SECURITY_N2
  • DWH_INV_SECURITY_N3
  • DWH_INV_SECURITY_N4 (Oracle)
  • DWH_INV_SECURITY_N5 (Oracle)
  • DWH_RES_SECURITY
  • DWH_RES_SECURITY_N2
  • DWH_RES_SECURITY_N3
Updated Tables (New or Changed Columns):
  • DWH_CFG_SETTINGS: DWH_SEC_LOAD_DATE
  • DWH_INV_SUMMARY_FACTS: PCT_COMPLETE
  • DWH_INV_SUMMARY_FACTS: PCT_EXPENDED
  • DWH_INV_TASK_SUMMARY_FACTS: PCT_EXPENDED
  • DWH_INV_TASK_SUMMARY_FACTS: PCT_COMPLETE
  • DWH_X_INV_SUM_FACTS: PCT_COMPLETE
  • DWH_X_INV_TASK_SUM_FACTS: PCT_COMPLETE
Updated Tables (Oracle):
  • DWH_X_INV_TRAN_PER_FACTS_MV: INVESTMENT_KEY
  • DWH_X_INV_TRAN_PER_FACTS_MV: PERIOD_KEY
  • DWH_X_INV_TRAN_PER_FCTS_MV_N2: INVESTMENT_KEY
  • DWH_X_INV_TRAN_PER_FCTS_MV_N2: PERIOD_KEY
  • DWH_X_INV_TRAN_PER_FCTS_MV_N1: DW_UPDATED_DATE
  • DWH_X_RES_TIME_PER_FACTS_MV: RESOURCE_KEY
  • DWH_X_RES_TIME_PER_FACTS_MV: RESOURCE_KEY
  • DWH_X_RES_TIME_PER_FACTS_MV: PERIOD_KEY
  • DWH_X_RES_TIME_PER_FACTS_MV: PERIOD_KEY
  • DWH_X_RES_TIME_PER_FCTS_MV_N2: RESOURCE_KEY
  • DWH_X_RES_TIME_PER_FCTS_MV_N2: PERIOD_KEY
  • DWH_X_RES_TIME_PER_FCTS_MV_N1: DW_UPDATED_DATE
  • DWH_X_RES_TRAN_PER_FACTS_MV: RESOURCE_KEY
  • DWH_X_RES_TRAN_PER_FACTS_MV: RESOURCE_KEY
  • DWH_X_RES_TRAN_PER_FACTS_MV: PERIOD_KEY
  • DWH_X_RES_TRAN_PER_FACTS_MV: PERIOD_KEY
  • DWH_X_RES_TRAN_PER_FCTS_MV_N1: DW_UPDATED_DATE
  • DWH_X_RES_TRAN_PER_FCTS_MV_N2: RESOURCE_KEY
  • DWH_X_RES_TRAN_PER_FCTS_MV_N2: PERIOD_KEY
Removed Columns (Oracle):
  • DWH_X_INV_TRN_PER_FCTS_MV_N1: INVESTMENT_KEY
  • DWH_X_INV_TRN_PER_FCTS_MV_N2: PERIOD_KEY
  • DWH_X_INV_TRN_PER_FCTS_MV_N3: INVESTMENT_KEY
  • DWH_X_INV_TRN_PER_FCTS_MV_N3: PERIOD_KEY
New Views (MS SQL):
  • DWH_SEC_INV_OBS_ENTITIES_V.xml
  • DWH_RES_SECURITY.xml
  • DWH_SEC_RES_OBS_ENTITIES_V.xml
  • DWH_X_RES_AVAIL_PER_FACTS_MV.xml
  • DWH_SEC_RES_INST_SECURITY_V.xml
  • DWH_FIN_PLAN_VIRTUAL_V.xml
  • DWH_INV_SECURITY.xml
  • DWH_FIN_PLAN_VIRTUAL_SUM_V.xml
  • DWH_SEC_INV_INST_SECURITY_V.xml
Removed Procedures (MS SQL):
  • DWH_INV_SECURITY_PRC.xml
  • DWH_RES_SECURITY_PRC.xml
New Procedures (MS SQL):
  • DWH_SEC_GROUP_LOAD.xml
  • DWH_SEC_GROUP_HIER_LOAD.xml
  • DWH_SEC_UNIT_BY_MODE_LOAD.xml
  • DWH_SEC_ASSIGN_RIGHT_LOAD.xml
  • CMN_DROP_TABLE_SP.xml
  • DWH_SEC_RIGHT_LOAD.xml
  • DWH_SEC_ASSIGN_PERM_LOAD.xml
  • CMN_DROP_PROCEDURE_SP.xml
  • DWH_SEC_USER_LOAD.xml
  • DWH_TMP_RECORD_KEYS_LOAD.xml
  • DWH_SEC_GLOBAL_RIGHT_LOAD.xml
  • DWH_SEC_USER_GROUP_LOAD.xml
  • DWH_CMN_PERIOD_MAPPING_LOAD.xml
  • DWH_SEC_PERM_ELEMENT_LOAD.xml
New Functions (MS SQL):
  • DWH_CAL_END_OF_MONTH_FCT.xml
Database Schema Changes from Release 14.3 to Release 14.4
The data model changes for Release 14.4 include the following table changes:
Added Tables:
  • ODF_OBJECT_FAVORITES
  • CMN_JGROUPS_PING
  • CMN_FEATURES
  • NMC_CONVERSATIONS
  • CLB_NOTIFICATION_PARAMS
  • CMN_UI_PREFERENCES
Updated Tables
The following tables were updated for this release.
  • CMN_LOOKUPS:
    FEATURE_CODE
  • CMN_LOOKUP_TYPES:
    FEATURE_CODE
  • CMN_SEC_GROUPS:
    FEATURE_CODE
  • CMS_CONTENT_ADDINS:
    EOL_DATE
  • DWH_SETTINGS
Added columns:
MONTHLY_SLICES
ONE_SET_OF_FISCAL_PERIODS
DISABLE_INVESTMENT_SECURITY
DISABLE_RESOURCE_SECURITY
WEEKLY_SLICES
FISCAL_SLICES
  • NMC_INTEGRATIONS
Added columns:
API_KEY
USER_NAME
PASSWORD
AUTH_TYPE
  • ODF_CUSTOM_ATTRIBUTES
Added column: IS_SYSTEM
  • ODF_OBJECTS
Added columns:
IS_SYSTEM
API_HTTP_METHODS
IS_PRIVATE_API
IS_FAVORITE_ENABLED
  • PFM_INV_CONSTRAINT_SUMS
Changed column: PH_CURVE_SUM
  • RPT_CALENDAR
Changed column: FTE
Data Warehouse Schema Changes from Release 14.3 to Release 14.4
The data model changes for the Data Warehouse for Release 14.4 include the following table changes:
Added Tables:
  • DWH_X_RES_TRAN_PER_FACTS_MV
  • DWH_X_RES_TIME_PER_FACTS_MV
  • DWH_X_INV_PLAN_PER_FACTS_MV
  • DWH_X_INV_ASGN_PER_FACTS_MV
  • DWH_X_INV_BEN_PER_FACTS_MV
  • DWH_X_RES_TEAM_PER_FACTS_MV
Updated Tables
The following tables were updated for this release.
  • DWH_CFG_SETTINGS
Added columns:
WEEK_START_DAY_CHANGED
ENTITY_CHANGED
MONTHLY_SLICES
CURRENT_FISCAL_PERIOD_KEY
FISCAL_PERIOD_CHANGED
ONE_SET_OF_FISCAL_PERIODS
DISABLE_RESOURCE_SECURITY
WEEKLY_SLICES
FISCAL_ROLLOVER_OCCURRED
DAILY_ROLLOVER_DATE
WEEKLY_ROLLOVER_DATE
DAILY_ROLLOVER_OCCURRED
MONTHLY_ROLLOVER_OCCURRED
FULL_RELOAD
DISABLE_INVESTMENT_SECURITY
MONTHLY_ROLLOVER_DATE
SINGLE_CURRENCY
WEEKLY_ROLLOVER_OCCURRED
FISCAL_ROLLOVER_DATE
FISCAL_SLICES
ENTITY_KEY
  • DWH_CMN_PERIOD
Changed column:
PERIOD_FTE
  • DWH_INV_OBS_MAPPING
Added column:
TABLE_NAME
Database Schema Changes from Release 14.2 to 14.3
Added Tables
  • NMC_INTEGRATIONS
  • CMN_MAP_COLORS
  • CMN_SEC_USERS_UID_N1 (index)
Removed Tables
  • XBKP_CAP_SCENARIOS
  • XBKP_CAP_SCENARIO_MEMBERS
  • XBKP_ODF_FILTER_EXPRESSIONS
  • XBKP_PMA_EF_CANDIDATES
  • XBKP_PMA_EF_INVESTMENTS
  • XBKP_PMA_PINNED_INVESTMENTS
  • XBKP_PMA_PORTFOLIOS
  • XBKP_PMA_PORTFOLIO_CONTENTS
  • XBKP_PMA_PORTFOLIO_ROLES
  • XBKP_PMA_PRTFLIO_INCL_CTNT_TYP
  • XBKP_PMA_SCENARIO_CONSTRAINTS
  • XBKP_PMA_SCENARIO_OPT_PARAMS
  • XBKP_PRJ_BLB_SLICEREQUESTS
Updated Tables
The following tables were updated for this release.
  • CBK_GL_ALLOCATION
Added column:
COST_TYPE
  • CLB_NOTIFICATION_PREFS
Added columns:
STATUS
PRINCIPAL_TYPE
  • CMN_GRAPHS
Added columns:
IS_DRILLDOWN
SHOW_SUBTITLE
TM_LAYOUT
  • CMN_GRAPH_AXES
Added column:
NUM_GROUPS
  • CMN_LANGUAGES
Added column:
WIKI_LANGUAGE_CODE
  • CMN_SEC_USERS
Added column:
USER_UID
  • ENTITY
Added columns:
TRANS_LOCATION_EQUIPMENT
TRANS_LOCATION_EXPENSE
TRANS_LOCATION_MATERIAL
  • ODF_CUSTOM_ATTRIBUTES
Added column:
API_ALIAS
  • ODF_OBJECTS
Added columns:
API_ALIAS
IS_API_ENABLED
  • PPA_WIP
Added column:
RESOURCE_ID
  • RPT_RES_SKILLS_FLAT
Changed columns:
LEVEL1_NAME
LEVEL2_NAME
LEVEL3_NAME
LEVEL4_NAME
LEVEL5_NAME
LEVEL6_NAME
LEVEL7_NAME
LEVEL8_NAME
LEVEL9_NAME
LEVEL10_NAME
  • TEMP_TASKSEARCHNLR
Added column:
COST_TYPE
Data Warehouse Schema Changes from Release 14.2.0 to 14.3.0
The data model changes for the Data Warehouse for Release 14.3 include the following table changes:
Updated Tables
The following tables and indexes were updated for this release.
  • DWH_INV_SECURITY
Added column:
USER_UID
  • DWH_RES_RESOURCE
Added column:
USER_UID
  • DWH_RES_SECURITY
Added column:
USER_UID
  • DWH_RIM_CHANGE_REQUEST
Added columns:
ORIGINATING_RISK_NAME
ORIGINATING_RISK_KEY
ORIGINATING_ISSUE_NAME
ORIGINATING_ISSUE_KEY
ORIGINATING_RISK_ID
ORIGINATING_ISSUE_ID
Changed columns:
CHANGE_IN_COST
CHANGE_IN_SCHEDULE
  • DWH_RIM_ISSUE
Added columns:
ORIGINATING_RISK_NAME
ORIGINATING_RISK_KEY
ORIGINATING_CHANGE_NAME
ORIGINATING_CHANGE_KEY
ORIGINATING_RISK_ID
ORIGINATING_CHANGE_ID
  • DWH_RIM_RISK
Added columns:
ORIGINATING_CHANGE_NAME
ORIGINATING_CHANGE_KEY
ORIGINATING_CHANGE_ID
  • DWH_INV_SECURITY_N1
    (index)
Changed columns:
USER_NAME
GLOBAL_VIEW_RIGHT
INVESTMENT_TYPE_KEY
INVESTMENT_KEY
  • DWH_RES_SECURITY_N1
    (index)
Changed columns:
USER_NAME
GLOBAL_VIEW_RIGHT
RESOURCE_KEY
Database Schema Changes from Release 14.1.0 to 14.2.0
These tables were added, dropped, or updated for Release 14.2.
Added Tables
These tables were added for Release 14.2.
  • CMN_JASPER_SESSIONS
  • CMN_JASPER_SYNCED_USERS
  • DOMAIN_META_TABLE
  • DWH_LOOKUP_DIM_MAPPING
  • DWH_BLB_SLICES
  • DWH_META_COLUMNS
  • DWH_META_TABLES
  • DWH_OBJ_TSV_VIEW_MAPPING
  • DWH_SETTINGS
  • OBJECT_DOMAIN_MAPPING
  • ODF_SL_ACTCOST
  • ODF_SL_ALLOCCOST
  • ODF_SL_ETCCOST
  • ODF_SL_HARDCOST
  • PFM_EDITS
  • PFM_RANK_EDITS
  • PRJ_FISCAL_BLB_SLICES
  • TEMP_ODF_CA_PFM_INVESTMENT
  • TEMP_PFM_APPLICATIONS
  • TEMP_PFM_ASSETS
  • TEMP_PFM_CA_APPLICATION
  • TEMP_PFM_CA_ASSET
  • TEMP_PFM_CA_FINANCIALS
  • TEMP_PFM_CA_IDEA
  • TEMP_PFM_CA_INV
  • TEMP_PFM_CA_NPIOFINPROPERTIES
  • TEMP_PFM_CA_OTHER
  • TEMP_PFM_CA_PRODUCT
  • TEMP_PFM_CA_PROJECT
  • TEMP_PFM_CA_SERVICE
  • TEMP_PFM_CONSTRAINT_AGGRS
  • TEMP_PFM_FINANCIALS
  • TEMP_PFM_IDEAS
  • TEMP_PFM_INVESTMENTS
  • TEMP_PFM_MNT_PROJECTS
  • TEMP_PFM_OTHERS
  • TEMP_PFM_PRODUCTS
  • TEMP_PFM_PROJECTS
  • TEMP_PFM_RANK_EDITS
  • TEMP_PFM_ROLE_DEMAND
  • TEMP_PFM_SERVICES
Dropped Tables
No tables were dropped for Release 14.2.
Updated Tables
These tables were updated for Release 14.2.
  • CMN_LANGUAGES
Added column:
IS_DW_ENABLED
  • ODF_CUSTOM_ATTRIBUTES
Added column:
IS_DW_ENABLED
  • ODF_OBJECTS
Added column:
IS_DW_ENABLED
IS_ODATA_ENABLED
  • PRASSIGNMENT
Added columns:
ETCCOST_CURVE
ETCCOST_SUM
ODF_SS_ACTCOST_CURVE
ODF_SS_ETCCOST_CURVE
Added index:
PRASSIGNMENT_GN2
  • PRJ_BLB_SLICEREQUESTS
Added columns:
FISCAL_ENTITY_ID
FISCAL_PERIOD_TYPE
IS_DWH_REQUEST
Added indexes:
PRJ_BLB_SLICEREQUESTS_N1
PRJ_BLB_SLICEREQUESTS_N2
  • PRTEAM
Added columns:
ALLOCCOST_CURVE
ALLOCCOST_SUM
HARDALLCCOST_CURVE
HARDALLCCOST_SUM
ODF_SS_HARDALLCCOST_CURVE
ODF_SS_ALLOCCOST_CURVE
Added indexes:
PRTEAM_GN1
PRTEAM_GN2
PRTEAM_N12
Database Schema Changes from Release 13.3.0 to 14.1.0
These tables were added, dropped, or updated for Release 14.1.
Added Tables
These tables were added for Release 14.1.
  • CMS_CONTENT_ADDIN_ITEMS
  • CMS_CONTENT_ADDINS
  • CMS_CONTENT_ITEMS
  • CMS_CONTENT_PACKAGES
  • CMS_CONTENT_TYPES
  • LOG_DETAILS
  • LOG_FILES
  • LOG_REPORTDEFS
  • LOG_SESSIONS
  • LOG_SUMMARY
Dropped Tables
No tables were dropped for Release 14.1.
Updated Tables
These tables were updated for Release 14.1.
  • CAL_ACTION_ITEM_ASSIGNEES
Added columns:
AI_DESCRIPTION
AI_SUBJECT
  • CMN_INSTALL_HISTORY
Updated column:
INSTALL_ID
  • CMN_NOTES
Updated column:
SUBJECT
  • CMN_NOTIFICATIONS
Added column:
IS_ADMIN_VISIBLE
  • PRASSIGNMENT
Added column:
ODF_SS_ACTCOST_CURVE
Added index:
PRASSIGNMENT_GN1
  • PRDEPENDENCY
Added column:
PRLAGFORMAT
  • RPT_CALENDAR
Added columns:
CREATED_DATE
LAST_UPDATED_DATE
  • RPT_INV_HIERARCHY
Added columns:
CREATED_DATE
INV_HIERARCHIES_ID
  • RSM_SKILLS
Updated column:
SKILL_NAME
Database Schema Changes from Release 13.2.0 to 13.3.0
These tables were added, dropped, or updated for Release 13.3.
Added Tables
This table was added for Release 13.3.
CMN_GEL_TAGS.
Dropped Tables
No tables were dropped for Release 13.3.
Updated Tables
These tables were updated for Release 13.3.
  • CMN_AUDITS
Dropped column:
CLASS_CODE
Added index:
CMN_AUDITS_N6
  • CMN_SEC_USERS
Added column:
SALT
  • PRJ_BLB_SLICES
Dropped columns:
ID
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATED_DATE
UNIT
  • PRTASK
Added columns:
PRMSPWBSLEVEL
PRMSPWBSSEQUENCE
Database Schema Changes from Release 13.1.0 to 13.2.0
These tables were added, dropped, or updated for Release 13.2.
Added Tables
These tables were added for Release 13.2.
Added tables with the identifier XBPK are not included in this list. These tables are backup tables for the Portfolio feature that is removed for this release.
  • CMN_INSTANCE_RANK
  • CMN_RANK_CONTEXTS
  • PFM_APPLICATIONS
  • PFM_APPLICATIONS_PLAN
  • PFM_ASSETS
  • PFM_ASSETS_PLAN
  • PFM_ATTR_REGISTRY
  • PFM_BASELINE_DETAILS
  • PFM_CA_FINANCIALS
  • PFM_CA_NPIOFINPROPERTIES
  • PFM_CLOB_CURVES
  • PFM_CONTENT_FILTERS
  • PFM_EV_HISTORY
  • PFM_FINANCIALS
  • PFM_FLAT_HIERARCHIES
  • PFM_HIERARCHIES
  • PFM_IDEAS
  • PFM_IDEAS_PLAN
  • PFM_INVESTMENTS
  • PFM_INVESTMENTS_PLAN
  • PFM_MNT_PROJECTS
  • PFM_OTHERS
  • PFM_OTHERS_PLAN
  • PFM_PINNED_INVESTMENTS
  • PFM_PLANS
  • PFM_PORTFOLIOS
  • PFM_PRODUCTS
  • PFM_PRODUCTS_PLAN
  • PFM_PROJECTS
  • PFM_PROJECTS_PLAN
  • PFM_ROLE_CAPACITY
  • PFM_ROLE_DEMAND
  • PFM_ROLE_DEMAND_PLAN
  • PFM_SERVICES
  • PFM_SERVICES_PLAN
  • PFM_USER_SELECTED_PLAN
  • PFM_WEIGHTING_ATTRS
  • PFM_WEIGHTING_OPTS
  • RPT_INV_HIERARCHY
  • RPT_RES_SKILLS_FLAT
  • RPT_RES_SKILLS_INDEX
Updated Tables
These tables were updated for Release 13.2.
CAP_SCENARIOS
Dropped column: PORTFOLIO_ID
Dropped index: CAP_SCENARIOS_N2
CMN_AUDITS
Added columns:
  CLASS_CODE
  TRANSACTION_ID
Updated column:
  ATTRIBUTE_CODE
CMN_AUDITS_TSV
Updated column:
ATTRIBUTE_CODE
CMN_GG_ITEMS
Added column:
GROUP_BY_FUNCTION
CMN_GRAPHS
Added columns:
GROUPBY_COL_CODE
DEFAULT_GROUP_BY_FUNCTION
CMN_GRIDS
Added columns:
SNAP_TO_WATERLINE
OBJECT_INSTANCE_ID
Updated index:
CMN_GRIDS_U1
FIN_COST_PLAN_DETAILS
Added column:
COST_TYPE_ID
Updated index:
FIN_COST_PLAN_DETAILS_U1
FIN_FINANCIALS
Added columns:
BUDGET_ACTUAL_BENEFIT
BUDGET_ACTUAL_BENEFIT_TOTAL
BUDGET_COST_CAPITAL
BUDGET_COST_OPERATING
BUDGET_CST_CAPITAL_TOTAL
BUDGET_CST_OPERATING_TOTAL
ODF_SS_BUDGET_ACTUAL_BENEFIT
ODF_SS_BUDGET_COST_CAP
ODF_SS_BUDGET_COST_OP
ODF_SS_PLAN_ACTUAL_BENEFIT
ODF_SS_PLAN_COST_CAP
ODF_SS_PLAN_COST_OP
PLANNED_ACTUAL_BENEFIT
PLANNED_ACTUAL_BENEFIT_TOTAL
PLANNED_COST_CAPITAL
PLANNED_COST_OPERATING
PLANNED_CST_CAPITAL_TOTAL
PLANNED_CST_OPERATING_TOTAL
Added indexes:
FIN_FINANCIALS_GN1
FIN_FINANCIALS_GN2
FIN_FINANCIALS_GN3
FIN_FINANCIALS_GN4
FIN_FINANCIALS_GN5
FIN_FINANCIALS_GN6
ODF_AUDITED_ATTRIBUTES
Updated column:
ATTRIBUTE_CODE
PAC_MNT_PROJECTS
Added column:
COST_TYPE
PPA_TRANSCONTROL
Added column:
COST_TYPE
PPA_TRANSWIPADJUST
Added column:
COST_TYPE
PPA_WIP
Added column:
COST_TYPE
PRTASK
Added column:
COST_TYPE
Added index:
PRTASK_N6
PRTEAM
Added column:
CAPITAL_PERCENTAGE
Added index:
PRTEAM_N3
PRTIMEENTRY
Added column:
ODF_SS_ACTUALS
Added index:
PRTIMEENTRY_GN1
TEMP_IMP_VALIDATE_TRANSIMPORT
Added column:
COST_TYPE
Dropped Tables
These tables were dropped for Release 13.2.
  • PMA_AGGR_KEYS
  • PMA_AGGR_VALUES
  • PMA_AGGR_VALUES_VALIDITY
  • PMA_EF_CANDIDATES
  • PMA_EF_INVESTMENTS
  • PMA_FINANCIAL_VALUES
  • PMA_PINNED_INVESTMENTS
  • PMA_PORTFOLIO_CONTENTS
  • PMA_PORTFOLIO_ROLES
  • PMA_PORTFOLIOS
  • PMA_PRIORITY_CHART_CONF
  • PMA_PRTFLIO_INCL_CTNT_TYPES
  • RPT_PORTFOLIO_CONTENT
Database Schema Changes from Version 13.0.0 to 13.1.0
The following tables describe the tables that were added, dropped, or updated for Release 13.1.
cmn_actions
Updates
deleted column
CLASS_CODE
updated index
CMN_ACTIONS_N4
cmn_attribute_value_sets
Updates
deleted column
CLASS_CODE
cmn_audits
Updates
deleted column
CLASS_CODE
updated index
CLASS_CODE
cmn_audits_tsv
Microsoft SQL Server
Updates
dataType
added column
TRANSACTION_ID
dataType: nvarchar; length: 0;
deleted column
CLASS_CODE
Not Applicable
Oracle
Updates
dataType
updated column
CREATED_DATE
dataType: timestamp; oldLength: 11; length: 0;
added column
TRANSACTION_ID
dataType: varchar; length: 30; nullable: false;
deleted column
CLASS_CODE
Not Applicable
Updates
added index
CMN_AUDITS_TSV_N6
added index
CMN_AUDITS_TSV_N8
cmn_captions_nls
Updates
updated index
CMN_CAPTIONS_NLS_U1
deleted index
CMN_CAPTIONS_NLS_U2
deleted index
CMN_CAPTIONS_NLS_U3
fin_financials
Updates
added index
FIN_FINANCIALS_N9
cmn_filter_fields
Updates
Description
updated column
DATA_TYPE
oldNullable: false;6.5 nullable: true;
cmn_grids
Updates
deleted column
CLASS_CODE
updated index
CMN_GRIDS_U1
cmn_sec_assgnd_obj_perm
Updates
deleted column
CLASS_CODE
added index
CMN_SEC_ASSGND_OBJ_PERM_N6
deleted index
CMN_SEC_ASSGND_OBJ_PERM_N7
cmn_sec_groups
Updates
deleted column
CLASS_CODE
deleted column
CLASS_ID
updated index
CMN_SEC_GROUPS_U1
updated index
CMN_SEC_GROUPS_U2
deleted index
CMN_SEC_GROUPS_N1
deleted index
CMN_SEC_GROUPS_N2
deleted index
CMN_SEC_GROUPS_N4
cmn_sec_users
Updates
dataType
added column
NO_CSRF_MSG
dataType: boolean; nullable: true;
cmn_sec_policies
Updates
deleted column
CLASS_CODE
cmn_sec_right
Updates
deleted column
CLASS_CODE
deleted column
CLASS_ID
updated index
CMN_SEC_RIGHT_U2
updated index
CMN_SEC_RIGHT_U3
updated index
CMN_SEC_RIGHT_U4
added index
CMN_SEC_RIGHT_U1
deleted index
CMN_SEC_RIGHT_N3
fin_plans
Microsoft SQL Server
Updates
dataType
added column
SOURCE_COST_PLAN_ID
dataType: numeric; length: 0;
added column
BUDGET_SUBMIT_OPTION
dataType: nvarchar; length: 30;
Oracle
Updates
dataType
added column
SOURCE_COST_PLAN_ID
dataType: numeric; length: 0;
added column
BUDGET_SUBMIT_OPTION
dataType: varchar; length: 30;
imp_transactionimport
Microsoft SQL Server
Updates
dataType
updated column
PROJECT_CODE
dataType: varchar; oldLength: 23;length: 60
Oracle
Updates
dataType
updated column
PROJECT_CODE
dataType: varchar; oldLength: 23;length: 60
inv_flat_hierarchies
Updates
deleted column
HIERARCHY_PATH
deleted index
INV_FLAT_HIERARCHIES_HIER_PATH
inv_investments
Updates
dataType
added column
TRACK_ASSGN_ONLY
dataType: numeric; length: 5;
nameoptions
Microsoft SQL Server
Updates
dataType
added column
RES_FIN_EDIT_RIGHT_AUTO
dataType: integer; length: 0; defaultValue: 1;
Oracle
Updates
dataType
added column
RES_FIN_EDIT_RIGHT_AUTO
dataType: boolean; length: 0; defaultValue: 1;
odf_action_viewability
Updates
deleted column
CATEGORY_ID
deleted column
STAGE_ID
deleted column
CLASS_CODE
updated index
ODF_ACTION_VIEWABILITY_U1
odf_aud_multi_val_lovs
Updates
added index
ODF_AUD_MULTI_VAL_LOVS_N3
odf_custom_attributes
Updates
dataType
added column
IS_USM_ENABLED
dataType: numeric; length: 0;
odf_objects
Microsoft SQL Server
Updates
dataType
added column
USM_ENABLED_MODE
dataType: nvarchar; length: 0;
Oracle
Updates
dataType
added column
USM_ENABLED_MODE
dataType: varchar; length: 0;
odf_restored_views
Updates
deleted column
CLASS_CODE
odf_tab_viewability
Updates
Deleted Column
CATEGORY_ID
Deleted Column
STAGE_ID
Deleted Column
CLASS_CODE
Updated Index
ODF_TAB_VIEWABILITY_U1
odf_views
Updates
deleted column
CLASS_CODE
odf_view_sections
Microsoft SQL Server
Updates
dataType
added column
CODE
dataType: nvarchar; length: 30; nullable: true;
Oracle
Updates
dataType
added column
CODE
dataType: varchar; length: 30; nullable: true;
pac_mnt_projects
Updates
added index
PAC_MNT_PROJECTS_N7
ppa_wip
Updates
added index
PPA_WIP_U1
ppa_wip_values
Updates
updated index
ppa_wip_values_u1
updated index
PPA_WIP_VALUES_U2
prj_blb_slices_d_act
Updates
updated index
PRJ_BLB_SLICES_D_ACT_U1
updated index
PRJ_BLB_SLICES_D_ACT_U2
prj_blb_slices_d_alc
Updates
updated index
PRJ_BLB_SLICES_D_ALC_U1
updated index
PRJ_BLB_SLICES_D_ALC_U2
prj_blb_slices_d_avl
Updates
updated index
PRJ_BLB_SLICES_D_AVL_U1
updated index
PRJ_BLB_SLICES_D_AVL_U2
prj_blb_slices_d_etc
Updates
updated index
PRJ_BLB_SLICES_D_ETC_U1
updated index
PRJ_BLB_SLICES_D_ETC_U2
prj_blb_slices_d_hardalc
Updates
updated index
PRJ_BLB_SLICES_D_HARDALC_U1
updated index
PRJ_BLB_SLICES_D_HARDALC_N1
prj_blb_slices_m_act
Updates
updated index
PRJ_BLB_SLICES_M_ACT_U1
updated index
PRJ_BLB_SLICES_M_ACT_U2
prj_blb_slices_m_alc
Updates
updated index
PRJ_BLB_SLICES_M_ALC_U1
updated index
PRJ_BLB_SLICES_M_ALC_U2
prj_blb_slices_m_avl
Updates
updated index
PRJ_BLB_SLICES_M_AVL_U1
updated index
PRJ_BLB_SLICES_M_AVL_U2
prj_blb_slices_m_cap_alc
Updates
updated index
PRJ_BLB_SLICES_M_CAP_ALC_U1
updated index
PRJ_BLB_SLICES_M_CAP_ALC_U2
prj_blb_slices_m_etc
Updates
updated index
PRJ_BLB_SLICES_M_ETC_U1
updated index
PRJ_BLB_SLICES_M_ETC_U2
prj_blb_slices_m_hardalc
Updates
updated index
PRJ_BLB_SLICES_M_HARDALC_U1
updated index
PRJ_BLB_SLICES_M_HARDALC_N1
prj_blb_slices_w_act
Updates
updated index
PRJ_BLB_SLICES_W_ACT_U1
updated index
PRJ_BLB_SLICES_W_ACT_U2
prj_blb_slices_w_alc
Updates
updated index
PRJ_BLB_SLICES_W_ALC_U1
updated index
PRJ_BLB_SLICES_W_ALC_U2
prj_blb_slices_w_avl
Updates
updated index
PRJ_BLB_SLICES_W_AVL_U1
updated index
PRJ_BLB_SLICES_W_AVL_U2
prj_blb_slices_w_etc
Updates
updated index
PRJ_BLB_SLICES_W_ETC_U1
updated index
PRJ_BLB_SLICES_W_ETC_U2
prj_blb_slices_w_hardalc
Updates
updated index
PRJ_BLB_SLICES_W_HARDALC_U1
updated index
PRJ_BLB_SLICES_W_HARDALC_N1
pac_mnt_resources
Updates
Description
updated column
RESOURCE_CLASS
oldNullable: false; nullable: true;
updated column
TRANSCLASS
oldNullable: false; nullable: true;
prdocument
Updates
Description
updated column
PRCREATEDBY
oldLength: 32; length: 240;
prtimeentry
Microsoft SQL Server
added column: SOURCE
dataType: nvarchar
length: 50
nullable: true
Oracle
added column: SOURCE
dataType: varchar
length: 50
nullable: true
prj_obs_units_flat
updated index: PRJ_OBS_UNITS_FLAT_N1
updated index: PRJ_OBS_UNITS_FLAT_N1
srm_resources
added index: SRM_RESOURCES_N10
Other Changes
deleted table: ODF_STAGE
deleted table: ODF_CLASS
deleted table: ODF_CATEGORY_CLASS_MAPPING
deleted table: ODF_CATEGORY
added view: INV_WIP_COST_V
deleted view: RPT_PRJ_Q_BASE_HRS_V
deleted view: RPT_RES_M_BASE_FTE_V
deleted view: RPT_PRJ_Q_BASE_FTE_V
deleted view: RPT_PRJ_D_BASE_FTE_V
deleted view: RPT_RES_D_BASE_HRS_V
deleted view: RPT_RES_Q_BASE_HRS_V
deleted view: RPT_PRJ_D_BASE_HRS_V
deleted view: RPT_RES_M_BASE_COST_V
deleted view: RPT_PRJ_M_BASE_HRS_V
deleted view: RPT_PRJ_W_BASE_FTE_V
deleted view: RPT_RES_D_BASE_FTE_V
deleted view: RPT_RES_D_BASE_COST_V
deleted view: RPT_PRJ_W_BASE_HRS_V
deleted view: RPT_RES_W_BASE_HRS_V
deleted view: RPT_RES_W_BASE_FTE_V
deleted view: RPT_RES_W_BASE_COST_V
deleted view: RPT_PRJ_D_BASE_COST_V
deleted view: RPT_RES_Q_BASE_COST_V
deleted view: RPT_RES_Q_BASE_FTE_V
deleted view: RPT_PRJ_W_BASE_COST_V
deleted view: RPT_RES_M_BASE_HRS_V
deleted view: RPT_PRJ_Q_BASE_COST_V
deleted view: RPT_PRJ_M_BASE_COST_V
deleted view: RPT_PRJ_M_BASE_FTE_V
deleted procedure: DATA_SERVICE_TYPE_UPD_SP
deleted procedure: CMN_CLASS_RIGHT_COPY_SP