Summary of Info Mart Schema Changes

Writer's note: From separate Cargo queries (see User:Jdruker/CargoQueriesForPDMs:

• Re-created PDMColumn table (after forcing Cargo tables updates by saving with a dummy parameter):
  • Table introduced = 63
  • Column introduced = 71
  • Column modified -- itemized = 159
  • Column discontinued = 4
  • TOTAL = 297 (which is consistent with DPL results)

When the old PDMColumn table was active, the total number of entries in the following combined table was arithmetically correct at 63+71+ 35 + 4 = 173, but the current total is off by 59. The problem is that only 100 of the 159 "Column modified" entries display.

To do:

• Probably not worth tweaking the template now to Include Views, but put something somewhere to prompt an update if deltas for views occur in the future.
• Add to wish list: Put a form on the page to allow users to generate a filtered list based on a starting and ending version they choose.

The following table summarizes Genesys Info Mart schema changes between 8.x releases, for all supported RDBMS types. Some of the changes listed might not apply to the RDBMS you use.

Tip

Type in the Search box to quickly filter the table by release, table name, type of change, and so on. Alternatively, click a column header to sort the table to group entries. Click the table name in an entry to link to a full description of the table.

Table	Column	Changed in release	Type of change	More information
Table	Column	Changed in release	Type of change	More information