Release 14.2 Updates › Data Model Changes for Release 14.2

Data Model Changes for Release 14.2

This section provides data model changes for CA Clarity PPM Release 14.2.

Added Tables

The following tables were added for this release:

• 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 this release.

Updated Tables

The following tables were updated for this release.

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