Bookshelf v7.8: Denormalized Columns for 7.0.4 Siebel Industry Solutions

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

Table 54. 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`