Bookshelf v8.0: Denormalized Columns for 7.5.2 Siebel Industry Applications

Table 31 lists columns that are denormalized during upgrades from Release 7.5.2 of Siebel Industry Applications to Release 7.8 of Siebel Industry Applications provided by Oracle.

Table 31. Columns Denormalized During Upgrades from Release 7.5.2 Siebel Industry Applications
Target Table	Target Column	Denorm Path	Source Table	Source Column
`S_LOY_MEM_BU`	`MEM_NUM`	[MEMBER_ID]. [MEM_NUM]	`S_LOY_MEMBER`	`MEM_NUM`
`S_LOY_MEM_BU`	`MEM_TYPE_CD`	[MEMBER_ID].[MEM_TYPE_CD]	`S_LOY_MEMBER`	`MEM_TYPE_CD`
`S_LOY_MEM_PSTN`	`MEM_NUM`	[MEMBER_ID].[MEM_NUM]	`S_LOY_MEMBER`	`MEM_NUM`
`S_LOY_MEM_PSTN`	`MEM_TYPE_CD`	[MEMBER_ID].[MEM_TYPE_CD]	`S_LOY_MEMBER`	`MEM_TYPE_CD`
`S_LOY_PROG_BU`	`PROG_NAME`	[PROG_ID].[NAME]	`S_LOY_PROGRAM`	`NAME`
`S_LOY_PROMO_BU`	`PROMO_NAME`	[PROMO_ID]. [NAME]	`S_LOY_PROMO`	`NAME`
`S_LOY_PROMO_BU`	`PROMO_NUM`	[PROMO_ID]. [PROMO_NUM]	`S_LOY_PRO`	`PROMO_NUM`
`S_LOY_TXN_BU`	`TXN_NUM`	[TXN_ID].[TXN_ NUM]	`S_LOY_TXN`	`TXN_NUM`
`S_LOY_TXN_BU`	`TXN_STATUS_CD`	[TXN_ID].[STATUS_CD]	`S_LOY_TXN`	`STATUS_CD`
`S_LOY_TXN_BU`	`TXN_SUB_TYPE_ CD`	[TXN_ID].[SUB_ TYPE_CD]	`S_LOY_TXN`	`SUB_TYPE_CD`
`S_LOY_TXN_BU`	`TXN_TYPE_CD`	[TXN_ID].[TYPE_ CD]	`S_LOY_TXN`	`TYPE_CD`
`S_POS_BU`	`POS_NUM`	[POS_ID].[POS_ NUM]	`S_POS`	`POS_NUM`
`S_PROD_STYL_TNT`	`SETUP_STYLE_CD`	[PROP_STYLE_ID]. [SETUP_STYLE_CD]	`S_PROP_STYL_ TNT`	`SETUP_STYLE_CD`
`S_PSP_PROC_BU`	`VOD_NAME`	[VOD_ID].[VOD_ NAME]	`S_VOD`	`VOD_NAME`
`S_QUOTE_POSTN`	`QUOTE_NUM`	[QUOTE_ID]. [QUOTE_NUM]	`S_DOC_QUOTE`	`QUOTE_NUM`

Siebel Database Upgrade Guide for DB2 UDB for z/OS		Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.