Changes to the data model for Oracle

Tables

The following tables were modified:
  • VALUE/H_VALUE
    • Added column DESCRIPTION CLOB(5K)
  • USAGE_INSTANCE_TYPE
    • Added column "COUNT_QUALIFIER1" VARCHAR2(255) NOT NULL WITH DEFAULT ' '
    • Added column "COUNT_QUALIFIER2" VARCHAR2(255) NOT NULL WITH DEFAULT ' '
  • OBJ_BASE
    • Added column SCHEME VARCHAR(60)
  • APPLICATION
    • Added column DEFAULT_SCHEME VARCHAR(60)
  • CALENDAR_GROUP/H_CALENDAR_GROUP
    • APP_VERSION_ID to nullable
  • SCHEDULE_ENTRY/H_SCHEDULE_ENTRY
    • APP_VERSION_ID to nullable
The following new tables were created:
  • OBJTYPE_REL/H_OBJTYPE_REL
    • Table used to store data for object type to object type relationships.
  • PAYMENT_SCHEME_TYPE
    • Stores the list of payment scheme types.

Views

The following views were modified:
  • APP_CURRENT_VERSION_V
    • Added APPLICATION.DEFAULT_SCHEME column.
  • TRANSMISSION_V, TRANSACTION_V, TXN_PAYMENT_V, TXN_SECURITIES_V, BATCH_V, BATCH_V_UPD, FRAGMENT_V
    • Added OBJ_BASE.SCHEME column.
The following new views were created:
  • SCHEME_V
    • Join on new PAYMENT_SCHEME_TYPE table and existing CALEMDAR_GROUP and SCHEDULE_ENTRY tables.

Triggers

The following triggers were modified:
  • T_VALUE_U, T_VALUE_D
    • Updated for the new VALUE.DESCRIPTION column.
  • T_SCHEDULE_ENTRY_I, T_SCHEDULE_ENTRY_U
    • Updated to cater for null SCHEDULE_ENTRY.APP_VERSION_ID.
The following new triggers were created:
  • T_OBJTYPE_REL_UT, T_OBJTYPE_REL_BI, T_OBJTYPE_REL_I, T_OBJTYPE_REL_U, T_OBJTYPE_REL_D
    • New history triggers for the new OBJTYPE_REL table.

Constraints

The following constraints were removed:
  • C_SCP_FK - FOREIGN KEY - CALENDAR_ENTRY
  • CC_CPR1_FK - FOREIGN KEY - CAL_PARTY_REL
  • CC_CO2_FK - FOREIGN KEY - CAL_OBJ_REL
  • C_SSP_FK - FOREIGN KEY - SCHEDULE_ENTRY
  • CALENDAR_GROUP PRIMARY KEY
  • SCHEDULE_ENTRY PRIMARY KEY