Bookshelf v7.8: Denormalized Columns for 7.0.4 Siebel eBusiness Applications

Table 52 lists columns that are denormalized during upgrades from Release 7.0.4 Siebel eBusiness applications to Release 7.8 Siebel Industry applications.

Table 52. Columns Denormalized During Upgrades from Release 7.0.4 Siebel eBusiness 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`