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 Financial Services Applications


Table 29 lists columns that are denormalized during upgrades from Release 7.0.4 Siebel Financial Services applications to Release 7.8 Siebel Industry Applications.

Table 29. Columns Denormalized During Upgrades from Release 7.0.4 Siebel Financial Services Applications
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_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

ASSET_NUM

[ASSET_ID].[ASSET_NUM]

S_ASSET

ASSET_NUM

S_ASSET_BU

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

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

NEW_LOAN_FLG

[OPTY_ID].[NEW_
LOAN_FLG]

S_OPTY

NEW_LOAN_FLG

S_ORG_BU

ORG_REF_CUST_
FLG

[ORG_ID].[REFERENCE_CUST_FLG]

S_ORG_EXT

REFERENCE_CUST_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

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