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


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

Table 25. Columns Denormalized During Upgrades from Release 6.2.1 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_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_CAL_TYPE_CD

[ACTIVITY_ID].[CAL_TYPE_CD]

S_EVT_ACT

CAL_TYPE_CD

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

INTR_PUBLISH_FLG

S_CTLGCT_RESITM

RI_NAME

[RES_ITEM_ID].[NAME]

S_RES_ITEM

NAME

S_CTLGCT_RESITM

RI_TYPE_CD

[RES_ITEM_ID].[TYPE_CD]

S_RES_ITEM

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

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

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

PERIOD_NAME

[PERIOD_ID].[NAME]

S_PERIOD

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

SETUP_STYLE_CD

[PROP_STYLE_ID].[SETUP_STYLE_CD]

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