Previous Topic: XML Open Gateway ChangesNext Topic: Release 13.1 Updates


Data Model Changes

Added Tables

The following list shows tables added for Release 13.2.00.

Note: Added tables with the identifier XBPK are not included in the list. These tables are backup tables for the Portfolio feature removed for this release.

Updated Tables

The following list of tables indicates what changed in the update:

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

The following tables were dropped for Release 13.2.00: