Bookshelf v7.7: Denormalized Columns for 7.5.2 Siebel Industry Applications

Table 48 lists columns that are denormalized during upgrades from Release 7.5.2 Siebel Industry applications to Release 7.7 Siebel Industry applications.

Table 48. 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`