Jump to: navigation, search
(Deleting notes about checksum totals)
Line 1: Line 1:
 
= Summary of Info Mart Schema Changes =
 
= Summary of Info Mart Schema Changes =
  
−
<div><font color=red>'''Writer's note:''' From separate Cargo queries (see [[User:Jdruker/CargoQueriesForPDMs]]:
+
<!--<font color=red>'''Writer's note:''' Total is consistent with DPL checksum and 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:
 
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.
 
* 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.</font>
+
* 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.</font>-->
−
</div>
 
−
 
 
 
<onlyinclude>
 
<onlyinclude>
 
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.
 
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.

Revision as of 20:38, July 23, 2018

Summary of Info Mart Schema Changes

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
Comments or questions about this documentation? Contact us for support!