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
Table
6.0.1
6.2.1
6.3
6.3.1

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

Siebel Database Upgrade Guide