Oracle and MS SQL Database Schema Changes

The following cappm database and data warehouse schema tables and columns are new, changed, or dropped in the specified release.
ccppmop155
The following 
Clarity 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
 Clarity PPM database and data warehouse schema files, see Advanced Reporting and Database Schema Index.
Database and Data Warehouse Schema Changes:
 
 
2
 
2
 
 
Each spreadsheet shows the schema differences on the following four tabs as seen in Microsoft Excel:
  1. CA PPM DB Oracle
  2. CA PPM DB MS-SQL
  3. CA PPM DWH Oracle
  4. CA PPM DWH MS-SQL
 
New! 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
CA PPM 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 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