Documentation:GIM:Library:InfoMartSchemaChanges:8.5DRAFT

Summary of Info Mart Schema Changes

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

• Old PDMColumn table:
  • Table introduced = 63
  • Column introduced = 71
  • Column modified -- itemized = 35 (Column modified -- consolidated = 31 vs. 150 per DPL)
  • Column discontinued = 4
• 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

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, so the query was validated.

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