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

Denormalized Columns for 7.0.4 Siebel Business Applications


Table 28 lists columns that are denormalized during upgrades from Release 7.0.4 Siebel Business applications to Release 7.8 Siebel Industry Applications.

Table 28. Columns Denormalized During Upgrades from Release 7.0.4 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_CAL_TYPE_CD

[ACTIVITY_ID].[CAL_
TYPE_CD]

S_EVT_ACT

CAL_TYPE_CD

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_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_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_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_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_USERLIST_BU

UL_NAME

[USERLIST_ID].
[NAME]

S_USERLIST

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.