Previous Topic: User InterfaceNext Topic: Version 13.0 Updates


Data Model Changes

Database Table Changes

The following tables have fields that were updated, added, or removed. Update custom queries or reports that use these fields.

Note: CLASS_CODE is no longer used. The CLASS_CODE column has been removed from all tables where it appeared before this release. For information about all changes to the database tables since the last release, see the Technical Reference Guide.

Table

Column

BIZ_COM_PERIODS

Removed:

  • P_QUARTER
  • PERIOD

FIN_PLANS

Added:

  • SOURCE_COST_PLAN_ID
  • BUDGET_SUBMIT_OPTION

NAMEOPTIONS

Added:

  • RES_FIN_EDIT_RIGHT_AUTO

NBI_DIM_FISCAL_TIME

Updated:

  • PERIOD_KEY
  • QUARTER_KEY
  • TIME_KEY

PAC_MNT_RESOURCES

Updated:

  • RESOURCE_CLASS
  • TRANSCLASS