Siebel Database Upgrade Guide > Tables Modified or Seeded During a Siebel Upgrade >
Tables Modified During Upgrade from Siebel Siebel 6.x
Upgrades from: Siebel 6.x. Platforms: MS Windows, UNIX, IBM z/OS. Databases: All databases. Table 74 lists tables that are modified during upgrades from Siebel 6.x. Modifications are indicated in the table as follows:
- I = inserted records
- U = updated records
- R = referenced records
Table 74. Tables Modified During Upgrades from Siebel 6.x
|
|
|
|
|
S_ACCELERATOR |
IR |
IR |
IR |
IR |
S_ACCELRTR_INTL |
I |
I |
I |
I |
S_ACCNT_ATT |
I |
I |
I |
I |
S_ACCNT_CHRCTR |
R |
R |
R |
R |
S_ACCNT_POSTN |
IUR |
IUR |
IUR |
IUR |
S_ACT_CONTACT |
IR |
IR |
IR |
IR |
S_ACT_EMP |
IUR |
IUR |
IUR |
IUR |
S_ACT_ORDER |
R |
R |
R |
R |
S_ACT_TIMESTAMP |
R |
R |
R |
R |
S_ACTIVITY_ATT |
R |
R |
R |
R |
S_ADDR_ORG |
IUR |
IR |
IR |
IR |
S_ADDR_ORG_INT |
UR |
R |
R |
R |
S_ADDR_PER |
IUR |
IR |
IR |
IR |
S_AGREE_ITEM |
U |
U |
U |
U |
S_AGREE_POSTN |
IR |
IR |
IR |
IR |
S_APP_VER |
U |
U |
U |
U |
S_APP_VIEW |
R |
R |
R |
R |
S_APP_VIEW_RESP |
U |
U |
U |
U |
S_APPL_WTMPL_IT |
U |
U |
U |
U |
S_APPLET |
R |
R |
R |
R |
S_ASGN_ATTR_COL |
R |
R |
R |
R |
S_ASGN_RULE |
U |
U |
U |
U |
S_ASSESS |
R |
R |
R |
R |
S_ASSESS_VAL |
U |
U |
U |
U |
S_ASSET |
UR |
UR |
UR |
UR |
S_ASSET_ACCNT |
IR |
IR |
IR |
IR |
S_ASSET_WRNTY |
R |
R |
R |
R |
S_AUC_ALRT_CAT |
R |
R |
R |
R |
S_AUC_ALRT_DEF |
U |
U |
U |
U |
S_AUC_ITEM |
U |
U |
U |
U |
S_BC_ENTRY_TRGT |
UR |
UR |
UR |
UR |
S_BC_VIEWMODE |
I |
I |
I |
I |
S_BCSTMSG_DIVN |
R |
R |
R |
R |
S_BRDCST_MSG |
U |
U |
U |
U |
S_BU |
IUR |
IUR |
IUR |
IUR |
S_BUSCOMP |
UR |
UR |
UR |
UR |
S_C_LST_CHRCTR |
I |
I |
I |
I |
S_C_LST_COL_MAP |
R |
R |
R |
R |
S_C_LST_MKT_SEG |
R |
R |
R |
R |
S_C_LST_POSTN |
R |
R |
|
|
S_C_LST_QRY_CAT |
|
|
R |
R |
S_CALL_LST |
UR |
UR |
UR |
UR |
S_CALL_LST_BU |
I |
I |
I |
I |
S_CALL_LST_TMPL |
I |
I |
I |
I |
S_CAMP_CON |
UR |
UR |
UR |
UR |
S_CERT_ATTR_PER |
R |
R |
R |
R |
S_CFG_CLASS |
IR |
IR |
IR |
IR |
S_CFG_ITEM |
R |
R |
R |
R |
S_CFG_PROP_DEF |
IUR |
IUR |
IUR |
IUR |
S_CFG_RULE_DEF |
I |
I |
I |
I |
S_CFG_RULE_SPEC |
R |
R |
R |
R |
S_CFG_SCRIPT |
R |
R |
R |
R |
S_CFG_SCRPT_DEF |
IR |
IR |
IR |
IR |
S_CFG_VAR_DEF |
IUR |
IUR |
IUR |
IUR |
S_CFGA_VARDEF |
R |
R |
R |
R |
S_CHRCTR |
IU |
IU |
IU |
IU |
S_CHRCTR_VAL |
I |
I |
I |
I |
S_CM_CFG_USER |
IR |
IR |
IR |
IR |
S_CM_TELESET |
IR |
IR |
IR |
IR |
S_CM_USER_QUE |
IR |
IR |
IR |
IR |
S_CO_BUS_AREA |
U |
U |
U |
U |
S_COLUMN |
UR |
UR |
UR |
UR |
S_COMM_REQ |
|
|
U |
U |
S_COMM_TMPL |
R |
R |
R |
R |
S_COMMAND |
R |
R |
R |
R |
S_COMMUNICATION |
U |
U |
U |
U |
S_CON_ADDR |
R |
R |
R |
R |
S_CON_CHRCTR |
IR |
IR |
IR |
IR |
S_CON_MKT_SEG |
R |
R |
R |
R |
S_CONTACT |
IUR |
IUR |
IUR |
IUR |
S_CONTACT_ATT |
I |
I |
I |
I |
S_CONTACT_BU |
I |
I |
I |
I |
S_CONTACT_INFO |
R |
R |
R |
R |
S_CONTACT_REL |
U |
U |
U |
U |
S_CONTACT_SS |
U |
U |
U |
U |
S_CONTACT_T |
U |
U |
U |
U |
S_CONTACT_X |
U |
U |
U |
U |
S_CONTROL |
U |
U |
U |
U |
S_CRSE |
R |
R |
R |
R |
S_CRSE_AUD |
UR |
UR |
UR |
UR |
S_CRSE_LIT |
UR |
UR |
UR |
UR |
S_CRSE_OFFR |
UR |
UR |
UR |
UR |
S_CRSE_OFFR_TST |
IUR |
IUR |
IUR |
IUR |
S_CRSE_REG |
R |
R |
R |
R |
S_CRSE_REL |
U |
U |
U |
U |
S_CRSE_TST |
UR |
UR |
UR |
UR |
S_CRSE_TST_LANG |
R |
R |
R |
R |
S_CRSE_TST_QUES |
UR |
UR |
UR |
UR |
S_CRSE_TSTRUN |
U |
U |
U |
U |
S_CS_PATH |
UR |
UR |
UR |
UR |
S_CS_QUEST |
U |
U |
U |
U |
S_CS_RUN |
U |
U |
U |
U |
S_CTI_CFG |
R |
R |
R |
R |
S_CTI_EXTENSION |
R |
R |
R |
R |
S_CTI_TELESET |
R |
R |
R |
R |
S_CTI_USER |
R |
R |
R |
R |
S_CTLG |
UR |
UR |
UR |
UR |
S_CTLG_CAT |
UR |
UR |
UR |
UR |
S_CTLG_CAT_AUC |
R |
R |
R |
R |
S_CTLG_CAT_CRSE |
R |
R |
R |
R |
S_CTLG_CAT_ISS |
R |
R |
R |
R |
S_CTLG_CAT_LIT |
R |
R |
R |
R |
S_CTLG_CAT_ORG |
R |
R |
R |
R |
S_CTLG_CAT_PROD |
UR |
UR |
UR |
UR |
S_CTLG_CAT_SR |
R |
R |
R |
R |
S_CTLG_CAT_SRC |
R |
R |
R |
R |
S_CTLGCT_RESITM |
R |
R |
R |
R |
S_CURRCLM |
R |
R |
R |
R |
S_CURRCLM_CRSE |
U |
U |
U |
U |
S_CURRCLM_PER |
U |
U |
U |
U |
S_CURRCLM_STEP |
I |
I |
I |
I |
S_CUST_SURVEY |
U |
U |
U |
U |
S_DD_HIERATR |
|
|
U |
U |
S_DD_HIERATRVAL |
|
|
U |
U |
S_DD_MEAS_ATTR |
|
|
IR |
IR |
S_DD_PROGLSTFMT |
R |
R |
|
|
S_DEAL_DCP |
R |
R |
R |
R |
S_DMND_CRTN_PRG |
IUR |
IUR |
IUR |
IUR |
S_DNB_CON_MRC |
R |
R |
R |
R |
S_DNB_CONTACT |
R |
R |
R |
R |
S_DNB_ORG |
U |
U |
U |
U |
S_DOC_AGREE |
UR |
UR |
UR |
UR |
S_DOC_AGREE_BU |
I |
I |
I |
I |
S_DOC_ORDER |
U |
U |
U |
U |
S_DOC_PPSL |
R |
R |
R |
R |
S_DOC_PPSL_BU |
I |
I |
I |
I |
S_DOC_QUOTE |
UR |
UR |
UR |
UR |
S_DOC_QUOTE_BU |
I |
I |
I |
I |
S_DOCK_TXN_LOG |
R |
R |
R |
R |
S_DOCK_VIS_RULE |
U |
U |
U |
U |
S_DUAL |
R |
R |
R |
R |
S_EIM_FK_MAP |
UR |
UR |
UR |
UR |
S_EIM_FK_MAPCOL |
UR |
UR |
UR |
UR |
S_EMP_INDUST |
R |
R |
R |
R |
S_EMP_PER |
IUR |
IUR |
IUR |
IUR |
S_EMP_PERF_MEAS |
U |
U |
U |
U |
S_EMPLOYEE_ATT |
R |
R |
R |
R |
S_EMPLOYEE_X |
R |
R |
R |
R |
S_EMPLOYEE_XM |
R |
R |
R |
R |
S_ESCL_REQ |
UR |
R |
R |
R |
S_ESCL_RULE |
R |
|
|
|
S_EVT_ACT |
UR |
UR |
UR |
UR |
S_EVT_ACT_X |
R |
R |
R |
R |
S_EVT_FUL_REQ |
U |
U |
U |
U |
S_EVT_MAIL |
I |
I |
I |
I |
S_EVT_STAFF |
R |
R |
R |
R |
S_EXP_ITEM |
U |
U |
U |
U |
S_EXP_ITEM_TYPE |
R |
R |
R |
R |
S_EXP_RPT |
U |
U |
U |
U |
S_FIELD |
R |
R |
R |
R |
S_FUL_REQ_CNTNT |
R |
R |
R |
R |
S_IC_CALC |
UR |
U |
U |
U |
S_IC_CALC_IT |
UR |
U |
U |
U |
S_IC_CALC_RUN |
IUR |
U |
U |
U |
S_IC_CMPNT_FLTR |
I |
I |
I |
I |
S_IC_DRAW |
|
R |
R |
R |
S_IC_DRAW_BAL |
I |
I |
I |
I |
S_IC_DRAW_DIVN |
|
I |
I |
I |
S_IC_DRAW_PER |
|
IU |
IU |
IU |
S_IC_FLTR |
U |
|
|
|
S_IC_PAYMENT |
UR |
UR |
UR |
UR |
S_IC_PERF_HIST |
U |
U |
U |
U |
S_IC_PLCMP_DIVN |
|
I |
I |
I |
S_IC_PLCMP_PER |
IR |
IR |
IR |
IR |
S_IC_PLN_CMPNT |
UR |
UR |
UR |
UR |
S_IC_RATE |
IUR |
IUR |
IUR |
IUR |
S_IC_TXN |
UR |
UR |
UR |
UR |
S_IC_TXN_IT |
UR |
U |
U |
U |
S_IC_TXN_POSTN |
U |
|
|
|
S_INDUST |
R |
R |
R |
R |
S_INT_CKEY |
IUR |
IUR |
IUR |
IUR |
S_INT_CKEY_FLD |
I |
I |
I |
I |
S_INT_COMP |
UR |
UR |
UR |
UR |
S_INT_COMPMAP |
R |
R |
R |
R |
S_INT_FIELD |
UR |
UR |
UR |
UR |
S_INT_FLDMAP |
R |
R |
R |
R |
S_INT_OBJ |
R |
R |
R |
R |
S_INT_OBJMAP |
R |
R |
R |
R |
S_INV_TXN |
R |
R |
R |
R |
S_INV_TXN_BU |
IR |
IR |
IR |
IR |
S_INVLOC |
UR |
UR |
UR |
UR |
S_INVOICE_ITEM |
U |
U |
U |
U |
S_ISS |
R |
R |
R |
R |
S_ISS_BU |
I |
I |
I |
I |
S_LIST_COLUMN |
U |
U |
U |
U |
S_LIT |
UR |
UR |
UR |
UR |
S_LIT_PRTL_DISP |
|
|
I |
I |
S_LOCALE |
R |
R |
R |
R |
S_LST_OF_VAL |
UR |
UR |
UR |
UR |
S_MBL_DVC |
I |
I |
I |
I |
S_MBL_DVC_ADDR |
I |
I |
I |
I |
S_MDF |
R |
R |
R |
R |
S_MDF_ALLOC |
R |
R |
R |
R |
S_MDF_BU |
IR |
IR |
IR |
IR |
S_MKT_SEG |
UR |
UR |
UR |
UR |
S_MKT_SEG_VAL |
R |
R |
R |
R |
S_NEWS_TOPIC |
I |
I |
I |
I |
S_NEWSTPC_USER |
I |
I |
I |
I |
S_NOTE |
R |
R |
R |
R |
S_NOTE_DCP |
IR |
IR |
IR |
IR |
S_NOTE_USR_MSG |
I |
I |
I |
I |
S_OLAP_CAT |
U |
U |
IUR |
IUR |
S_OLAP_REPORT |
|
|
IR |
IR |
S_OLAP_RPT_CAT |
|
|
I |
I |
S_OLAPCAT_POSTN |
R |
R |
IR |
IR |
S_ONL_OBJ_PARTY |
R |
R |
R |
R |
S_ONL_OBJECT |
U |
U |
U |
U |
S_ONL_PROJ_PRTY |
R |
R |
R |
R |
S_ONL_PROJECT |
U |
U |
U |
U |
S_ONL_PS_CTGRY |
R |
R |
R |
R |
S_OPTY |
UR |
UR |
UR |
UR |
S_OPTY_BU |
I |
I |
I |
I |
S_OPTY_CHRCTR |
R |
R |
R |
R |
S_OPTY_INDUST |
R |
R |
R |
R |
S_OPTY_ORG |
R |
R |
R |
R |
S_OPTY_POSTN |
UR |
UR |
UR |
UR |
S_OPTY_PROD |
R |
R |
R |
R |
S_OPTY_PROJ |
R |
R |
R |
R |
S_ORD_CRDT_ASGN |
I |
I |
I |
I |
S_ORDER |
UR |
UR |
UR |
UR |
S_ORDER_BU |
IU |
IU |
IU |
IU |
S_ORDER_DTL |
R |
R |
R |
R |
S_ORDER_ITEM |
UR |
UR |
UR |
UR |
S_ORDER_POSTN |
IUR |
IUR |
IUR |
IUR |
S_ORDER_SHIP |
R |
R |
R |
R |
S_ORDER_TYPE |
R |
R |
R |
R |
S_ORG_BU |
I |
I |
I |
I |
S_ORG_CRDT_AREA |
R |
R |
R |
R |
S_ORG_EXT |
IUR |
IUR |
IUR |
IUR |
S_ORG_EXT_SS |
U |
U |
U |
U |
S_ORG_EXT_T |
UR |
UR |
UR |
UR |
S_ORG_EXT_X |
U |
U |
U |
U |
S_ORG_FUL |
U |
U |
|
|
S_ORG_FUL_PER |
R |
R |
|
|
S_ORG_GROUP |
UR |
UR |
UR |
UR |
S_ORG_GROUP_BU |
I |
I |
I |
I |
S_ORG_GROUP_X |
U |
U |
U |
U |
S_ORG_INT_ATT |
R |
R |
R |
R |
S_ORG_MKT_SEG |
R |
R |
R |
R |
S_ORG_PRTNR |
U |
U |
U |
U |
S_ORG_PRTNR_ATT |
R |
R |
R |
R |
S_ORG_PRTNR_EXP |
R |
R |
R |
R |
S_ORG_PRTNR_RGN |
R |
R |
R |
R |
S_ORG_REL |
R |
R |
R |
R |
S_ORGGRP_POSTN |
UR |
UR |
UR |
UR |
S_ORGGRP_TERR |
R |
R |
R |
R |
S_OU_PRTNR_TIER |
IR |
IR |
IR |
IR |
S_OU_PRTNR_TYPE |
I |
I |
I |
I |
S_PARTY |
IUR |
IUR |
IUR |
IUR |
S_PARTY_PER |
IR |
IR |
IR |
IR |
S_PARTY_REL |
U |
U |
U |
U |
S_PARTY_RPT_REL |
IR |
IR |
IR |
IR |
S_PER_COMM_ADDR |
R |
R |
R |
R |
S_PER_PRTNRAPPL |
U |
U |
U |
U |
S_PER_RESP |
IR |
IR |
IR |
IR |
S_PER_WRK_EXP |
R |
R |
R |
R |
S_PERIOD |
R |
R |
R |
R |
S_PICKLIST |
U |
U |
U |
U |
S_POSTN |
UR |
UR |
UR |
UR |
S_POSTN_CON |
I |
I |
I |
I |
S_PPSL_SECT |
U |
U |
U |
U |
S_PRD_DFCT_EMP |
R |
R |
R |
R |
S_PRD_DFCT_TAG |
R |
R |
R |
R |
S_PRDFCT_PRJITM |
IR |
IR |
IR |
IR |
S_PRDFCT_SYMP |
R |
R |
R |
R |
S_PREPAY_BAL |
U |
U |
U |
U |
S_PREPAYBAL_PTY |
R |
R |
R |
R |
S_PRI_LST |
UR |
UR |
UR |
UR |
S_PRI_LST_BU |
IR |
IR |
IR |
IR |
S_PRI_LST_ITEM |
U |
U |
U |
U |
S_PRILST_MKTSEG |
R |
R |
R |
R |
S_PRIMDL_FCTR |
U |
U |
U |
U |
S_PROD_CFGVER |
IR |
IR |
IR |
IR |
S_PROD_DEFECT |
UR |
UR |
UR |
UR |
S_PROD_DFCT_BU |
I |
I |
I |
I |
S_PROD_INT |
IUR |
IUR |
IUR |
IUR |
S_PROD_INT_BU |
U |
U |
U |
U |
S_PROD_INT_CRSE |
I |
I |
I |
I |
S_PROD_ITEM |
IUR |
IUR |
IUR |
IUR |
S_PROJ |
IUR |
IUR |
IUR |
IUR |
S_PROJ_BU |
I |
I |
I |
I |
S_PROJ_POSTN |
I |
I |
I |
I |
S_PROJ_RSRC |
IR |
IR |
IR |
IR |
S_PROJITEM |
IUR |
IUR |
IUR |
IUR |
S_PROJITEM_ATT |
I |
I |
I |
I |
S_PROJITEM_DIVN |
R |
R |
R |
R |
S_PROJITEM_ORG |
I |
I |
I |
I |
S_PROJITEM_REL |
R |
R |
R |
R |
S_PROJITEM_RSRC |
IR |
IR |
IR |
IR |
S_PROJITEM_TAG |
R |
R |
R |
R |
S_PRSP_CONTACT |
IUR |
IUR |
IUR |
IUR |
S_PRTL_DISP |
|
|
IR |
IR |
S_PRTNRAPP_REGN |
R |
R |
R |
R |
S_PRTNRAPPL_EXP |
R |
R |
R |
R |
S_PRTNRAPPL_IND |
R |
R |
R |
R |
S_PRTNRAPPL_MKT |
R |
R |
R |
R |
S_PTSHP_MKT_SEG |
R |
R |
R |
R |
S_QRY_CAT |
|
|
R |
R |
S_QTA_ACHIEVE |
U |
|
|
|
S_QTA_INCENTV |
UR |
UR |
UR |
UR |
S_QTA_OBJ |
UR |
UR |
UR |
UR |
S_QTA_OBJASGN |
R |
R |
R |
R |
S_QTA_OBJCRT |
U |
U |
U |
U |
S_QTA_ORG_INT |
|
R |
R |
R |
S_QTA_PLAN |
UR |
R |
R |
R |
S_QTA_POSTN |
UR |
UR |
UR |
UR |
S_QTAOBJAS_DIVN |
|
I |
I |
I |
S_QTAOBJAS_PER |
U |
IU |
IU |
IU |
S_QTASGN_POSTN |
U |
U |
U |
U |
S_QUOTA |
R |
R |
R |
R |
S_QUOTE_ITEM |
U |
U |
U |
U |
S_QUOTE_SOLN |
R |
R |
R |
R |
S_REPOSITORY |
UR |
UR |
UR |
UR |
S_RESITEM |
U |
U |
U |
U |
S_RESP |
UR |
UR |
UR |
UR |
S_REVN |
IR |
IR |
IR |
IR |
S_RULE_DESIGNER |
R |
R |
R |
R |
S_RULE_TMPL |
U |
U |
U |
U |
S_SALES_METHOD |
R |
R |
R |
R |
S_SALES_MTHD_BU |
IR |
IR |
IR |
IR |
S_SHIPMENT |
U |
U |
U |
U |
S_SRC |
IUR |
IUR |
IUR |
IUR |
S_SRC_BU |
I |
I |
I |
I |
S_SRC_COST |
U |
U |
U |
U |
S_SRC_DCP |
IR |
IR |
IR |
IR |
S_SRC_EVT |
IUR |
IUR |
IUR |
IUR |
S_SRC_EVT_REG |
IUR |
IUR |
IUR |
IUR |
S_SRC_INDUST |
R |
R |
R |
R |
S_SRC_PAYMENT |
IUR |
IUR |
IUR |
IUR |
S_SRC_POSTN |
I |
I |
I |
I |
S_SRC_VENUE |
R |
R |
R |
R |
S_SRM_ACT_PARAM |
R |
R |
R |
R |
S_SRM_ACTION |
R |
R |
R |
R |
S_SRM_REQUEST |
R |
R |
R |
R |
S_SRV_ACT |
I |
I |
I |
I |
S_SRV_REQ |
UR |
UR |
UR |
UR |
S_SRV_REQ_BU |
I |
I |
I |
I |
S_STG_LIT |
R |
R |
R |
R |
S_STORE_COND |
U |
U |
U |
U |
S_SYMPTOM |
R |
R |
R |
R |
S_SYS_PREF |
U |
U |
U |
U |
S_TABLE |
UR |
UR |
UR |
UR |
S_TERR |
R |
|
|
|
S_TMPL_PLANITEM |
R |
R |
R |
R |
S_TMPL_PLNIT_BU |
IR |
IR |
IR |
IR |
S_TMSHT |
U |
U |
U |
U |
S_TMSHT_ITEM |
UI |
UI |
UI |
UI |
S_TST_QUES |
I |
I |
I |
I |
S_UK_ATTJOIN |
R |
R |
R |
R |
S_USER |
IR |
IR |
IR |
IR |
S_USER_KEY |
UR |
UR |
UR |
UR |
S_USER_KEY_ATT |
UR |
UR |
UR |
UR |
S_USR_MSG |
IR |
IR |
IR |
IR |
S_USR_MSG_ATT |
I |
I |
I |
I |
S_USR_MSG_CAT |
I |
I |
I |
I |
S_USR_MSG_PREF |
I |
I |
I |
I |
S_VIEW |
U |
U |
U |
U |
S_VIEW_WTMPL_IT |
U |
U |
U |
U |
S_WEB_PG_ITM |
U |
U |
U |
U |
S_WEB_TMPL |
R |
R |
R |
R |
S_WEB_TMPL_FILE |
I |
I |
I |
I |
S_WF_PROC_FLOW |
U |
U |
U |
U |
S_WF_STEP |
U |
U |
U |
U |
S_WF_STEP_ARG |
U |
U |
U |
U |
S_WRNTY_CVRG |
R |
R |
R |
R |
S_WRNTY_CVRG_BU |
IR |
IR |
IR |
IR |
S_XA_ATTR |
IR |
IR |
IR |
IR |
S_XA_CLASS |
IUR |
IUR |
IUR |
IUR |
S_XA_CLASS_REL |
I |
I |
I |
I |
|