Siebel Database Upgrade Guide for DB2 UDB for z/OS > Columns Denormalized During Upgrade to Siebel Release 8.0 >

Denormalized Columns for 6.2.1 Siebel Business Applications


Table 26 lists columns that are denormalized during upgrades from Release 6.2.1 Siebel Business Applications to Release 7.8 Siebel Industry Applications.

Table 26. Columns Denormalized During Upgrades from Release 6.2.1 Siebel Business Applications
Target Table
Target Column
Denorm Path
Source Table
Source Column

S_ACCNT_POSTN

ORG_REF_CUST_FLG

[OU_EXT_ID].[REFERENCE_CUST_FLG]

S_ORG_EXT

REFERENCE_CUST_FLG

S_ACT_CAL_RSRC

ACT_APPT_REPT_
FLG

[ACTIVITY_ID].[APPT_REPT_FLG]

S_EVT_ACT

APPT_REPT_FLG

S_ACT_CAL_RSRC

ACT_APPT_RPTEND_DT

[ACTIVITY_ID].[APPT_REPT_END_DT]

S_EVT_ACT

APPT_REPT_END_
DT

S_ACT_CAL_RSRC

ACT_CAL_TYPE_CD

[ACTIVITY_ID].[CAL_TYPE_CD]

S_EVT_ACT

CAL_TYPE_CD

S_ACT_CAL_RSRC

ACT_TEMPLATE_FLG

[ACTIVITY_ID].[TEMPLATE_FLG]

S_EVT_ACT

TEMPLATE_FLG

S_ACT_CAL_RSRC

ACT_TODO_PLNEND_DT

[ACTIVITY_ID].[TODO_PLAN_END_DT]

S_EVT_ACT

TODO_PLAN_END_
DT

S_ACT_CAL_RSRC

ACT_TODO_
PLNSTRTDT

[ACTIVITY_ID].[TODO_PLAN_START_DT]

S_EVT_ACT

TODO_PLAN_
START_DT

S_ACT_EMP

ACT_ALARM_FLG

[ACTIVITY_ID].[ALARM_FLAG]

S_EVT_ACT

ALARM_FLAG

S_ACT_EMP

ACT_APPT_REPT_
FLG

[ACTIVITY_ID].[APPT_REPT_FLG]

S_EVT_ACT

APPT_REPT_FLG

S_ACT_EMP

ACT_APPT_RPTEND_DT

[ACTIVITY_ID].[APPT_REPT_END_DT]

S_EVT_ACT

APPT_REPT_END_
DT

S_ACT_EMP

ACT_APPT_START_
DT

[ACTIVITY_ID].[APPT_START_DT]

S_EVT_ACT

APPT_START_DT

S_ACT_EMP

ACT_CAL_DISP_FLG

[ACTIVITY_ID].[CAL_DISP_FLG]

S_EVT_ACT

CAL_DISP_FLG

S_ACT_EMP

ACT_EVT_STAT_CD

[ACTIVITY_ID].[EVT_STAT_CD]

S_EVT_ACT

EVT_STAT_CD

S_ACT_EMP

ACT_TEMPLATE_FLG

[ACTIVITY_ID].[TEMPLATE_FLG]

S_EVT_ACT

TEMPLATE_FLG

S_ACT_EMP

ACT_TODO_PLNEND_DT

[ACTIVITY_ID].[TODO_PLAN_END_DT]

S_EVT_ACT

TODO_PLAN_END_DT

S_ACT_EMP

ACT_TODO_
PLNSTRTDT

[ACTIVITY_ID].[TODO_PLAN_START_DT]

S_EVT_ACT

TODO_PLAN_
START_DT

S_ACT_EMP

ACT_CAL_TYPE_CD

[ACTIVITY_ID].[CAL_TYPE_CD]

S_EVT_ACT

CAL_TYPE_CD

S_AGREE_POSTN

AGREE_NAME

[AGREE_ID].[NAME]

S_DOC_AGREE

NAME

S_AGREE_POSTN

AGREE_STAT_CD

[AGREE_ID].[STAT_CD]

S_DOC_AGREE

STAT_CD

S_AGREE_POSTN

AGREE_VALID_FLG

[AGREE_ID].[VALID_FLG]

S_DOC_AGREE

VALID_FLG

S_CONTACT_BU

CON_FST_NAME

[CONTACT_ID].[FST_NAME]

S_CONTACT

FST_NAME

S_CONTACT_BU

CON_LAST_NAME

[CONTACT_ID].[LAST_NAME]

S_CONTACT

LAST_NAME

S_CONTACT_BU

CON_MID_NAME

[CONTACT_ID].[MID_NAME]

S_CONTACT

MID_NAME

S_CONTACT_BU

CON_EMP_FLG

[CONTACT_ID].[EMP_FLG]

S_CONTACT

EMP_FLG

S_CTLG_CAT_AUC

AUC_AUC_LOT_NUM

[AUC_ITEM_ID].[AUC_LOT_NUM]

S_AUC_ITEM

AUC_LOT_NUM

S_CTLG_CAT_CRSE

CRSE_NAME

[CRSE_ID].[NAME]

S_CRSE

NAME

S_CTLG_CAT_CRSE

CRSE_SUB_TYPE

[CRSE_ID].[SUB_TYPE]

S_CRSE

SUB_TYPE

S_CTLG_CAT_DFCT

DFCT_DFCT_NUM

[PROD_DEFECT_ID].[DEFECT_NUM]

S_PROD_DEFECT

DEFECT_NUM

S_CTLG_CAT_ISS

ISS_NAME

[ISS_ID].[NAME]

S_ISS

NAME

S_CTLG_CAT_LIT

LIT_NAME

[LIT_ID].[NAME]

S_LIT

NAME

S_CTLG_CAT_ORG

ORG_CMPT_FLG

[ORG_ID].[CMPT_FLG]

S_ORG_EXT

CMPT_FLG

S_CTLG_CAT_ORG

ORG_LOC

[ORG_ID].[LOC]

S_ORG_EXT

LOC

S_CTLG_CAT_ORG

ORG_NAME

[ORG_ID].[NAME]

S_ORG_EXT

NAME

S_CTLG_CAT_ORG

ORG_PRTNR_FLG

[ORG_ID].[PRTNR_FLG]

S_ORG_EXT

PRTNR_FLG

S_CTLG_CAT_PROD

PROD_EFF_END_DT

[PROD_ID].[EFF_END_DT]

S_PROD_INT

EFF_END_DT

S_CTLG_CAT_PROD

PROD_EFF_START_
DT

[PROD_ID].[EFF_START_DT]

S_PROD_INT

EFF_START_DT

S_CTLG_CAT_PROD

PROD_NAME

[PROD_ID].[NAME]

S_PROD_INT

NAME

S_CTLG_CAT_SR

SR_SR_NUM

[SRV_REQ_ID].[SR_NUM]

S_SRV_REQ

SR_NUM

S_CTLG_CAT_SRC

SRC_NAME

[SRC_ID].[NAME]

S_SRC

NAME

S_CTLG_CAT_SRC

SRC_SRC_NUM

[SRC_ID].[SRC_NUM]

S_SRC

SRC_NUM

S_CTLG_CAT_SRC

SRC_SUB_TYPE

[SRC_ID].[SUB_TYPE]

S_SRC

SUB_TYPE

S_CTLGCAT_ASSET

ASSET_ASSET_NUM

[ASSET_ID].[ASSET_NUM]

S_ASSET

ASSET_NUM

S_CTLGCAT_ASSET

ASSET_SERIAL_NUM

[ASSET_ID].[SERIAL_NUM]

S_ASSET

SERIAL_NUM

S_CTLGCAT_PATH

CS_PATH_NAME

[CS_PATH_ID].[NAME]

S_CS_PATH

NAME

S_CTLGCT_RESITM

RI_INTR_PUBL_FLG

[RES_ITEM_ID].[INTR_PUBLISH_FLG]

S_RESITEM

INTR_PUBLISH_
FLG

S_CTLGCT_RESITM

RI_NAME

[RES_ITEM_ID].[NAME]

S_RESITEM

NAME

S_CTLGCT_RESITM

RI_TYPE_CD

[RES_ITEM_ID].[TYPE_CD]

S_RESITEM

TYPE_CD

S_DOC_AGREE_BU

AGREE_NAME

[AGREEMENT_ID].[NAME]

S_DOC_AGREE

NAME

S_DOC_AGREE_BU

AGREE_STAT_CD

[AGREEMENT_ID].[STAT_CD]

S_DOC_AGREE

STAT_CD

S_DOC_AGREE_BU

AGREE_VALID_FLG

[AGREEMENT_ID].[VALID_FLG]

S_DOC_AGREE

VALID_FLG

S_DOC_PPSL_BU

PPSL_DFLT_TMPL_
FLG

[DOC_PPSL_ID].[DFLT_TEMPLATE_FLG]

S_DOC_PPSL

DFLT_TEMPLATE_FLG

S_DOC_PPSL_BU

PPSL_NAME

[DOC_PPSL_ID].[NAME]

S_DOC_PPSL

NAME

S_DOC_PPSL_BU

PPSL_TEMPLATE_
FLG

[DOC_PPSL_ID].[TEMPLATE_FLG]

S_DOC_PPSL

TEMPLATE_FLG

S_DOC_PPSL_BU

PPSL_TYPE_CD

[DOC_PPSL_ID].[PPSL_TYPE_CD]

S_DOC_PPSL

PPSL_TYPE_CD

S_DOC_QUOTE_BU

DOC_QTE_NUM

[DOC_QUOTE_ID].[QUOTE_NUM]

S_DOC_QUOTE

QUOTE_NUM

S_DOC_QUOTE_BU

DOC_QTE_REV_NUM

[DOC_QUOTE_ID].[REV_NUM]

S_DOC_QUOTE

REV_NUM

S_DOC_QUOTE_BU

DOC_QUOTE_NAME

[DOC_QUOTE_ID].[NAME]

S_DOC_QUOTE

NAME

S_INV_TXN_BU

INV_TXN_NUM

[INV_TXN_ID].[INV_TXN_NUM]

S_INV_TXN

INV_TXN_NUM

S_ISS_BU

ISS_LANG_ID

[ISS_ID].[LANG_ID]

S_ISS

LANG_ID

S_ISS_BU

ISS_NAME

[ISS_ID].[NAME]

S_ISS

NAME

S_MDF_BU

MDF_UID

[MDF_ID].[MDF_UID]

S_MDF

MDF_UID

S_OPTY_BU

OPTY_NAME

[OPTY_ID].[NAME]

S_OPTY

NAME

S_OPTY_BU

SUM_CLASS_CD

[OPTY_ID].[SUM_CLASS_CD]

S_OPTY

SUM_CLASS_CD

S_OPTY_BU

SUM_COMMIT_FLG

[OPTY_ID].[SUM_COMMIT_FLG]

S_OPTY

SUM_COMMIT_FLG

S_OPTY_BU

SUM_COST_AMT

[OPTY_ID].[SUM_COST_AMT]

S_OPTY

SUM_COST_AMT

S_OPTY_BU

SUM_DOWNSIDE_AMT

[OPTY_ID].[SUM_DOWNSIDE_AMT]

S_OPTY

SUM_DOWNSIDE_AMT

S_OPTY_BU

SUM_EFFECTIVE_DT

[OPTY_ID].[SUM_EFFECTIVE_DT]

S_OPTY

SUM_EFFECTIVE_DT

S_OPTY_BU

SUM_MARGIN_AMT

[OPTY_ID].[SUM_MARGIN_AMT]

S_OPTY

SUM_MARGIN_AMT

S_OPTY_BU

SUM_REVN_AMT

[OPTY_ID].[SUM_REVN_AMT]

S_OPTY

SUM_REVN_AMT

S_OPTY_BU

SUM_TYPE_CD

[OPTY_ID].[SUM_TYPE_CD]

S_OPTY

SUM_TYPE_CD

S_OPTY_BU

SUM_UPSIDE_AMT

[OPTY_ID].[SUM_UPSIDE_AMT]

S_OPTY

SUM_UPSIDE_AMT

S_OPTY_BU

SUM_WIN_PROB

[OPTY_ID].[SUM_WIN_PROB]

S_OPTY

SUM_WIN_PROB

S_OPTY_POSTN

OPTY_NAME

[OPTY_ID].[NAME]

S_OPTY

NAME

S_OPTY_POSTN

SUM_CLASS_CD

[OPTY_ID].[SUM_CLASS_CD]

S_OPTY

SUM_CLASS_CD

S_OPTY_POSTN

SUM_COMMIT_FLG

[OPTY_ID].[SUM_COMMIT_FLG]

S_OPTY

SUM_COMMIT_FLG

S_OPTY_POSTN

SUM_COST_AMT

[OPTY_ID].[SUM_COST_AMT]

S_OPTY

SUM_COST_AMT

S_OPTY_POSTN

SUM_DOWNSIDE_AMT

[OPTY_ID].[SUM_DOWNSIDE_AMT]

S_OPTY

SUM_DOWNSIDE_
AMT

S_OPTY_POSTN

SUM_EFFECTIVE_DT

[OPTY_ID].[SUM_EFFECTIVE_DT]

S_OPTY

SUM_EFFECTIVE_DT

S_OPTY_POSTN

SUM_MARGIN_AMT

[OPTY_ID].[SUM_MARGIN_AMT]

S_OPTY

SUM_MARGIN_AMT

S_OPTY_POSTN

SUM_REVN_AMT

[OPTY_ID].[SUM_REVN_AMT]

S_OPTY

SUM_REVN_AMT

S_OPTY_POSTN

SUM_TYPE_CD

[OPTY_ID].[SUM_TYPE_CD]

S_OPTY

SUM_TYPE_CD

S_OPTY_POSTN

SUM_UPSIDE_AMT

[OPTY_ID].[SUM_UPSIDE_AMT]

S_OPTY

SUM_UPSIDE_AMT

S_OPTY_POSTN

SUM_WIN_PROB

[OPTY_ID].[SUM_WIN_PROB]

S_OPTY

SUM_WIN_PROB

S_ORDER_BU

ORDER_CAT_CD

[ORDER_ID].[ORDER_CAT_CD]

S_ORDER

ORDER_CAT_CD

S_ORDER_BU

ORDER_DT

[ORDER_ID].[ORDER_DT]

S_ORDER

ORDER_DT

S_ORDER_BU

ORDER_NUM

[ORDER_ID].[ORDER_NUM]

S_ORDER

ORDER_NUM

S_ORDER_POSTN

ORDER_CAT_CD

[ORDER_ID].[ORDER_CAT_CD]

S_ORDER

ORDER_CAT_CD

S_ORDER_POSTN

ORDER_DT

[ORDER_ID].[ORDER_DT]

S_ORDER

ORDER_DT

S_ORDER_POSTN

ORDER_NUM

[ORDER_ID].[ORDER_NUM]

S_ORDER

ORDER_NUM

S_ORG_BU

ORG_CMPT_FLG

[ORG_ID].[CMPT_FLG]

S_ORG_EXT

CMPT_FLG

S_ORG_BU

ORG_LOC

[ORG_ID].[LOC]

S_ORG_EXT

LOC

S_ORG_BU

ORG_NAME

[ORG_ID].[NAME]

S_ORG_EXT

NAME

S_ORG_BU

ORG_PRTNR_FLG

[ORG_ID].[PRTNR_FLG]

S_ORG_EXT

PRTNR_FLG

S_ORG_BU

ORG_REF_CUST_FLG

[ORG_ID].[REFERENCE_CUST_FLG]

S_ORG_EXT

REFERENCE_CUST_FLG

S_ORG_GROUP_BU

OG_GROUP_NAME

[ORG_GROUP_ID].[GROUP_NAME]

S_ORG_GROUP

GROUP_NAME

S_ORG_GROUP_BU

OG_NAME

[ORG_GROUP_ID].[NAME]

S_ORG_GROUP

NAME

S_ORGGRP_POSTN

GRP_NAME

[ORGGRP_ID].[NAME]

S_ORG_GROUP

NAME

S_ORGGRP_POSTN

GRP_GROUP_NAME

[ORGGRP_ID].[GROUP_NAME]

S_ORG_GROUP

GROUP_NAME

S_PARTY_GRP_BU

PG_NAME

[PARTY_GROUP_ID].[NAME]

S_PARTY_GROUP

NAME

S_PERIOD_BU

PERIOD_NAME

[PERIOD_ID].[NAME]

S_PERIOD

NAME

S_PRIFCTR_ITM

PRIMDL_ID

[PRIMDL_FCTR_ID].[PRIMDL_ID]

S_PRIMDL_FCTR

PRIMDL_ID

S_PROD_DFCT_BU

DEFECT_NUM

[PROD_DEFECT_ID].[DEFECT_NUM]

S_PROD_DEFECT

DEFECT_NUM

S_PROD_INT_BU

PROD_EFF_END_DT

[PROD_INT_ID].[EFF_END_DT]

S_PROD_INT

EFF_END_DT

S_PROD_INT_BU

PROD_EFF_START_
DT

[PROD_INT_ID].[EFF_START_DT]

S_PROD_INT

EFF_START_DT

S_PROJ_BU

PROJ_NAME

[PROJ_ID].[NAME]

S_PROJ

NAME

S_PROJ_BU

PROJ_TYPE_CD

[PROJ_ID].[PROJ_TYPE_CD]

S_PROJ

PROJ_TYPE_CD

S_PROJ_BU

PROJ_STATUS_CD

[PROJ_ID].[STATUS_CD]

S_PROJ

STATUS_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

S_SALES_MTHD_BU

SALES_METHOD_
NAME

[SALES_METHOD_ID].[NAME]

S_SALES_METHOD

NAME

S_SRC_BU

SRC_NAME

[SRC_ID].[NAME]

S_SRC

NAME

S_SRV_REQ_BU

SR_TITLE

[SRV_REQ_ID].[SR_TITLE]

S_SRV_REQ

SR_TITLE

S_SRV_REQ_BU

SR_SUB_STAT_ID

[SRV_REQ_ID].[SR_SUB_STAT_ID]

S_SRV_REQ

SR_SUB_STAT_ID

S_SRV_REQ_BU

SR_STAT_ID

[SRV_REQ_ID].[SR_STAT_ID]

S_SRV_REQ

SR_STAT_ID

S_SRV_REQ_BU

SR_SEV_CD

[SRV_REQ_ID].[SR_SEV_CD]

S_SRV_REQ

SR_SEV_CD

S_SRV_REQ_BU

SR_NUM

[SRV_REQ_ID].[SR_NUM]

S_SRV_REQ

SR_NUM

S_SRV_REQ_BU

SR_CST_NUM

[SRV_REQ_ID].[SR_CST_NUM]

S_SRV_REQ

SR_CST_NUM

S_SRV_REQ_BU

SR_AREA

[SRV_REQ_ID].[SR_AREA]

S_SRV_REQ

SR_AREA

S_SRV_REQ_BU

SR_TYPE_CD

[SRV_REQ_ID].[SR_TYPE_CD]

S_SRV_REQ

SR_TYPE_CD

S_TMPL_PLNIT_BU

PLANITEM_NAME

[TMPL_PLANITEM_ID].[NAME]

S_TMPL_
PLANITEM

NAME

S_TMPL_PLNIT_BU

PLANITEM_TYPE_CD

[TMPL_PLANITEM_ID].[TYPE_CD]

S_TMPL_
PLANITEM

TYPE_CD

S_TMPL_PLNIT_BU

PLNIT_TMPL_TYPE_CD

[TMPL_PLANITEM_ID].[TMPL_TYPE_CD]

S_TMPL_
PLANITEM

TMPL_TYPE_CD

S_USERLIST_BU

UL_NAME

[USERLIST_ID].[NAME]

S_USERLIST

NAME

S_WRNTY_CVRG_BU

WRNTY_CVRG_NAME

[WRNTY_CVRG_ID].[WRNTY_NAME]

S_WRNTY_CVRG

WRNTY_NAME

T_MASTER_BU

MASTER_ALIAS

[MASTER_ID].[ALIAS]

T_MASTER

ALIAS

T_MASTER_BU

MASTER_NAME

[MASTER_ID].[NAME]

T_MASTER

NAME

T_MASTER_DETAIL

DETAIL_SX2_NAME

[DETAIL_SX2_ID].[SX2_NAME]

T_DETAIL_SX2

SX2_NAME

T_MASTER_DETAIL

MASTER_NAME

[MASTER_ID].[NAME]

T_MASTER

NAME

T_MASTER_PER

MASTER_ALIAS

[MASTER_ID].[ALIAS]

T_MASTER

ALIAS

T_MASTER_POSTN

MASTER_NAME

[MASTER_ID].[NAME]

T_MASTER

NAME

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