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 Industry Solutions


Table 30 lists columns that are denormalized during upgrades from Release 7.0.4 Siebel Industry Solutions to Release 7.8 Siebel Industry Applications.

Table 30. Columns Denormalized During Upgrades from Release 7.0.4 Siebel Industry Solutions
Target Table
Target Column
Denorm Path
Source Table
Source Column

S_ACCNT_POSTN

ACCNT_TYPE_CD

[OU_EXT_ID].[ACCNT_TYPE_CD]

S_ORG_EXT

ACCNT_TYPE_CD

S_ACCNT_POSTN

CLIENT_FLG

[OU_EXT_ID].[
CLIENT_FLG]

S_ORG_EXT

CLIENT_FLG

S_ACCNT_POSTN

FACILITY_FLG

[OU_EXT_ID].[
FACILITY_FLG]

S_ORG_EXT

FACILITY_FLG

S_ACCNT_POSTN

INVSTR_FLG

[OU_EXT_ID].
[INVSTR_FLG]

S_ORG_EXT

INVSTR_FLG

S_ACCNT_POSTN

ORG_REF_CUST_
FLG

[OU_EXT_ID].[REFERENCE_CUST_FLG]

S_ORG_EXT

REFERENCE_CUST_FLG

S_ACCNT_POSTN

SRV_PROVDR_FLG

[OU_EXT_ID].[SRV_PROVDR_FLG]

S_ORG_EXT

SRV_PROVDR_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_ASSET_BU

TYPE_CD

[ASSET_ID].[TYPE_CD]

S_ASSET

TYPE_CD

S_ASSET_POSTN

ASSET_NUM

[ASSET_ID].[ASSET_NUM]

S_ASSET

ASSET_NUM

S_ASSET_POSTN

TYPE_CD

[ASSET_ID].[TYPE_CD]

S_ASSET

TYPE_CD

S_CASE_BU

CASE_NAME

[CASE_ID].[NAME]

S_CASE

NAME

S_CASE_BU

CASE_STATUS_CD

[CASE_ID].[STATUS_CD]

S_CASE

STATUS_CD

S_CASE_BU

CASE_TYPE_CD

[CASE_ID].[TYPE_
CD]

S_CASE

TYPE_CD

S_CONTACT_BU

AGENT_FLG

[CONTACT_ID].
[AGENT_FLG]

S_CONTACT

AGENT_FLG

S_CONTACT_BU

CON_EMP_FLG

[CONTACT_ID].[EMP_FLG]

S_CONTACT

EMP_FLG

S_CONTACT_BU

CON_MID_NAME

[CONTACT_ID].[MID_NAME]

S_CONTACT

MID_NAME

S_CONTACT_BU

MEMBER_FLG

[CONTACT_ID].
[MEMBER_FLG]

S_CONTACT

MEMBER_FLG

S_CONTACT_BU

PROVIDER_FLG

[CONTACT_ID].
[PROVIDER_FLG]

S_CONTACT

PROVIDER_FLG

S_INSCLM_BU

INSCLAIM_NUM

[INSCLM_ID].
[INSCLAIM_NUM]

S_INS_CLAIM

INSCLAIM_NUM

S_INSCLM_BU

REV_NUM

[INSCLM_ID].
[REVISION_NUM]

S_INS_CLAIM

REVISION_NUM

S_INSCLMEL_BU

SEQ_NUM

[INSCLM_ELMNT_
ID].[SEQ_NUM]

S_INSCLM_
ELMNT

SEQ_NUM

S_INSCLMEL_BU

TYPE_CD

[INSCLM_ELMNT_
ID].[TYPE_CD]

S_INSCLM_
ELMNT

TYPE_CD

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_PROMO

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_OPTY_POSTN

CONSUMER_OPTY_FLG

[OPTY_ID].[CONSUMER_OPTY_FLG]

S_OPTY

CONSUMER_OPTY_FLG

S_OPTY_POSTN

NEW_LOAN_FLG

[OPTY_ID].[NEW_
LOAN_FLG]

S_OPTY

NEW_LOAN_FLG

S_OPTY_POSTN

OPTY_CLOSED_
FLG

[OPTY_ID].[CLOSED_FLG]

S_OPTY

CLOSED_FLG

S_OPTY_POSTN

SECURE_FLG

[OPTY_ID].[SECURE_FLG]

S_OPTY

SECURE_FLG

S_ORG_BU

ORG_FACILITY_
FLG

[ORG_ID].[FACILITY_FLG]

S_ORG_EXT

FACILITY_FLG

S_ORG_BU

ORG_INVSTR_FLG

[ORG_ID].[INVSTR_FLG]

S_ORG_EXT

INVSTR_FLG

S_ORG_BU

ORG_REF_CUST_
FLG

[ORG_ID].[REFERENCE_CUST_FLG]

S_ORG_EXT

REFERENCE_CUST_FLG

S_ORG_BU

ORG_SRV_PROVDR_FLG

[ORG_ID].[SRV_
PROVDR_FLG]

S_ORG_EXT

SRV_PROVDR_FLG

S_ORG_DIST_LST

OU_ID

[ORG_PROD_ID].
[OU_ID]

S_ORG_PROD

OU_ID

S_ORG_GROUP_BU

OG_GROUP_NAME

[ORG_GROUP_ID].
[GROUP_NAME]

S_ORG_GROUP

GROUP_NAME

S_ORG_GROUP_BU

OG_GROUP_TYPE_CD

[ORG_GROUP_ID].
[GROUP_TYPE_CD]

S_ORG_GROUP

GROUP_TYPE_CD

S_ORG_GROUP_BU

OG_NAME

[ORG_GROUP_ID].
[NAME]

S_ORG_GROUP

NAME

S_ORGGRP_POSTN

GROUP_TYPE_CD

[ORGGRP_ID].
[GROUP_TYPE_CD]

S_ORG_GROUP

GROUP_TYPE_CD

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_POS_BU

POS_NUM

[POS_ID].[POS_
NUM]

S_POS

POS_NUM

S_POSTN_CON

AGENT_FLG

[CON_ID].[AGENT_
FLG]

S_CONTACT

AGENT_FLG

S_POSTN_CON

MEMBER_FLG

[CON_ID].[MEMBER_FLG]

S_CONTACT

MEMBER_FLG

S_POSTN_CON

PROVIDER_FLG

[CON_ID].
[PROVIDER_FLG]

S_CONTACT

PROVIDER_FLG

S_PROD_INT_BU

PROD_CD

[PROD_INT_ID].
[PROD_CD]

S_PROD_INT

PROD_CD

S_PROD_STYL_TNT

SETUP_STYLE_CD

[PROP_STYLE_ID].
[SETUP_STYLE_CD]

S_PROP_STYL_
TNT

SETUP_STYLE_CD

S_PROJ_BU

PROJ_NAME

[PROJ_ID].[NAME]

S_PROJ

NAME

S_PROJ_BU

PROJ_STATUS_CD

[PROJ_ID].[STATUS_CD]

S_PROJ

STATUS_CD

S_PROJ_BU

PROJ_TYPE_CD

[PROJ_ID].[PROJ_
TYPE_CD]

S_PROJ

PROJ_TYPE_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_SRC_BU

SRC_NAME

[SRC_ID].[NAME]

S_SRC

NAME

S_SRV_REQ_BU

SR_AREA

[SRV_REQ_ID].[SR_AREA]

S_SRV_REQ

SR_AREA

S_SRV_REQ_BU

SR_CST_NUM

[SRV_REQ_ID].[SR_CST_NUM]

S_SRV_REQ

SR_CST_NUM

S_SRV_REQ_BU

SR_NUM

[SRV_REQ_ID].[SR_NUM]

S_SRV_REQ

SR_NUM

S_SRV_REQ_BU

SR_SEV_CD

[SRV_REQ_ID].[SR_SEV_CD]

S_SRV_REQ

SR_SEV_CD

S_SRV_REQ_BU

SR_STAT_ID

[SRV_REQ_ID].[SR_STAT_ID]

S_SRV_REQ

SR_STAT_ID

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_TITLE

[SRV_REQ_ID].[SR_TITLE]

S_SRV_REQ

SR_TITLE

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.