Siebel Innovation Pack 2015: Denormalized Columns for Siebel Industry Applications Version 7.5.3

Table 18 lists columns that are denormalized during upgrades from Siebel Industry Applications version 7.5.3 to Siebel Industry Applications version 8.1 or 8.2.

Table 18. Columns Denormalized During Upgrades from Siebel Industry Applications Version 7.5.3
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 for z/OS		Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.