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