Data Model Changes for Version 13.0

Release 13.0 Updates › Data Model Changes for Version 13.0

Data Model Changes for Version 13.0

This section provides data model changes for CA Clarity PPM Version 13.0.

Database Table Changes

The following tables had deprecated fields that were updated, added, or removed. If you have custom queries or reports that use the fields, they need to be updated.

Table	Column
APMASTER	Added CREATED_DATE CREATED_BY LAST_UPDATED_DATE LAST_UPDATED_BY
CBK_GL_ALOCATION_DETAIL	OVERHEAD_ENTITY_ID
CLNTCLASS	Added CREATED_DATE CREATED_BY LAST_UPDATED_DATE LAST_UPDATED_BY
FIN_COST_PLAN_DETAILS	Updated SOURCE (Updated) Added TRANSACTION_CLASS_ID ROLE_ID CHARGE_CODE_ID INPUT_TYPE_CODE_ID LOCATION_ID RESOURCE_ID RESOURCE_CLASS_ID DEPARTMENT_ID Deleted PLAN_DETAIL_1_KEY PLAN_DETAIL_2_KEY TRANSCLASS_ID PRROLE_ID PRCHARGECODE_ID AGG_UNITS AGG_COST AGG_REVENUE AGG_UNITS_ACTUAL AGG_COST_ACTUAL AGG_REVENUE_ACTUAL AGG_TOTAL_COST AGG_TOTAL_UNITS AGG_TOTAL_REVENUE AGG_TOTAL_COST_ACTUAL AGG_TOTAL_UNITS_ACTUAL AGG_TOTAL_REVENUE_ACTUAL
FIN_FINANCIALS	Added IS_SYS_VAL_FOR_TCC TOTAL_COST_OF_CAPITAL IS_SYS_VAL_FOR_RR REINVESTMENT_RATE INITIAL_INVESTMENT BUDGET_IRR BUDGET_MIRR BUDGET_PAYBACK_PERIOD FORECAST_IRR FORECAST_MIRR FORECAST_PAYBACK_PERIOD PLANNED_IRR PLANNED_MIRR PLANNED_PAYBACK_PERIOD
INV_INVESTMENTS	Added TARGET_MANAGER_ID ASSGN_POOL
INV_Projects	Deleted Prbasestart Prbasefinish prbasetime
PAC_MNT_RESOURCES	Added CREATED_DATE CREATED_BY LAST_UPDATED_DATE LAST_UPDATED_BY
PMA_AGGR_VALUES	Added INITIAL_INVESTMENT PLANNED_IRR PLANNED_MIRR PLANNED_PAYBACK_PERIOD PLANNED_BREAKEVEN BUDGET_IRR BUDGET_MIRR BUDGET_PAYBACK_PERIOD BUDGET_BREAKEVEN FORECAST_IRR FORECAST_MIRR FORECAST_PAYBACK_PERIOD FORECAST_BREAKEVEN
PRAssignment	Deleted Prbasepattern Prbasesum Prbasemax
PROJCLASS	Added CREATED_DATE CREATED_BY LAST_UPDATED_DATE LAST_UPDATED_BY
PRTask	Deleted Prbasestart Prbasefinish Prbaseduration Prbaseisfixed Prbasetime
WIPCLASS	Added CREATED_DATE CREATED_BY LAST_UPDATED_DATE LAST_UPDATED_BY

Upgrade action:

Identify custom queries or reports that use any of the fields that were removed. The references must be updated to use the correct database fields.
All baseline information is stored in:
- PRJ_Baselines (primary revisions)
- PRJ_Baseline_Details (baseline detail records for each revision)
For example:

You can get the current baseline revision by joining the baseline_id from the investment to the PRJ_Baselines table.

You can get baseline details by joining PRJ_Baseline_details.baseline_id to PRJ_Baselines.id, selecting object type (for example, TASK) and the object ID (for example, PRTask.prid).