Siebel Database Upgrade Guide for DB2 UDB for z/OS > Columns Denormalized During Upgrade to Siebel Release 8.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
|
|
|
|
|
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
|
|