Siebel Database Upgrade Guide for DB2 for z/OS > Columns Denormalized During Upgrade to Siebel CRM 8.1 >
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.
Table 18. Columns Denormalized During Upgrades from Siebel Industry Applications Version 7.5.3
|
|
|
|
|
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
|
|