Upgrade Guide for DB2 UDB for z/OS > Siebel Marketing Upgrade Reference >

Obsolete Siebel Marketing Data


Upgrades: Releases 7.0.x, 7.5.x.

Table 46 lists marketing data that is obsolete as of Release 7.7. In the table, the Comments field explains how the data is handled.

Table 46. Obsolete Siebel Marketing Data as of Release 7.7
Data
Effect of Upgrade
Obsolete Tables
Obsolete Business Components
Comments

Programs (program occurrences)

Obsolete

None

None

Activities migrated to parent program.

Stages (stage occurrences)

Obsolete

 

 

 

Campaigns (campaign occurrences)

Obsolete

None

DBM Campaign

Campaign Occurrences

Campaign Occurrences Delete

Campaign Results

Campaign Segment Allocation

Campaign Template Related Event Templates

Campaign Wave List Distribution

DBM Campaign Cost

DBM Campaign Cost (Fixed)

DBM Campaign Cost (Inbound)

DBM Campaign Cost (Outbound)

DBM Campaign Occurrence Cost

DBM Campaign Occurrence Lists

Campaign Occurrence Offer

DBM Preview List

A campaign load record is created for each occurrence.

eNewsletter Offers

Obsolete

 

Enewsletter Offer

Enewsletter Offer Attachments

Enewsletter Offer Attachments.Sequence Number (Sequence)

Enewsletter Offer Comm Profile Parameter

Enewsletter Offer Related URLs

Enewsletter Offer Template

Related Web Offers f/ Enewsletter Offer

Related Web Surveys f/ Enewsletter Offer

Newsletter functionality is supported by conditional content formatting in email offers.

Segments

Usage history in programs is preserved.

Segment criteria are obsolete.

S_CALL_LST_CRIT

S_CALL_LST_DTL

S_CALL_LST_QRY

Segment Detail-DD

Segment Expression

Campaign Segment Allocation

Segment Campaign Allocation

Segments should be reconstructed in the Segment Designer.

Filters

Obsolete

S_DD_FILTER

S_DD_FILTER_DTL

Filters

Filters Detail

Filters Expression Save

Attribute Level Look Up

Filters should be applied using criteria in the Segment Designer or Segment Tree Designer or metadata constraints in the Siebel Analytics repository.

List Formats

Obsolete

S_DD_LST_FMT

S_DD_LST_FMTDTL

S_DD_PROGLSTFMT

List Columns

List Columns.Sequence (Sequence)

List Formats

Program List Formats

Dependent List Format

Create List Formats using the List Format Designer.

Source Code Formats

Obsolete

None

None

Old source code formats are obsolete. After upgrade, source code formats need to be re-created with new elements.

Tables Joins

Obsolete

S_DD_DATA_OBJ

S_DD_UNION_MBR

S_DD_JOIN

S_DD_JOIN_SPEC

DD Field

DD Join

DD Table

Fields One Level

Join Fields

Join Fields.Sequence (Sequence)

Union Tables

All data source metadata is managed in the Siebel Analytics repository.

List Measures Bound Measures Custom Measures

Obsolete

S_DD_MEAS

S_DD_MEASRSTRCT

S_DD_SUBMEAS

Aggregation Function

Available Measures

Base Measure

Bound Measures

Custom Measures

Dependent List Format

Functions (Logical)

Functions (Mathematical)

List Measures

Measures

Parent Measures

RowNum Measure

SubMeasures

Measure Aggregation (Tree)

Members.Sequence (Sequence)

Measure Restrict

Measure Restrict (Tree)

Replaced by formulas in the Siebel Analytics repository.

Buckets (Measure Base Attributes)

Obsolete

S_DD_MEASATRPAR

S_DD_MEAS_ATTR

Measure Attribute Members

Measure Attribute Members (Tree)

Measure Attribute

Measure Attributes

Measure Attributes (Tree)

Replaced by formulas in the Siebel Analytics repository.

Attributes and Attribute Families

Obsolete

S_DD_ATRFAMLVMB

S_DD_ATTRFAM

S_DD_ATTRFAMLVL

S_DD_ATTRFAMVAL

S_DD_FIELD

S_DD_HIERATR

S_DD_HIERATRKEY

S_DD_HIERATRLVL

S_DD_HIERATRVAL

Attribute Families

Attribute Family Resync VBC

Attribute Family Value

Attribute Filters Detail

Attribute Levels

Attribute Levels.Sequence (Sequence)

Hierarchical Attribute Value

Hierarchical Attributes

Hierarchy (Fields)

Hierarchy (Tree)

Hierarchy Levels (Tree)

Hierarchy Levels Search (Tree)

Hierarchy Search (Fields)

Hierarchy Search (Tree)

Hierarchy Values (Fields)

Hierarchy Values (Tree)

Hierarchy.Sequence (Sequence)

Segment criteria are now created using presentation columns ("fields") in the Segment Designer.

Customer Hierarchies

Obsolete

S_DD_STRFAM

S_DD_SRTFAM_LVL

S_DD_SRTFAM_MAP

Hierarchy

Hierarchy Levels Hierarchy Levels (Fields)

User Defined Levels

User Defined Levels.Sequence (Sequence)

No longer necessary. Customer-level targeting is supported by Target Levels in the Siebel Analytics repository.

Campaign Load Mappings

(Contact Key Formats)

Obsolete

 

 

 

Server tables (internal use)

Obsolete

S_DD_CUBE S_DD_DIM

S_DD_DIM_DTL

S_DD_EXTRACT

S_DD_EXTRACT_CL

S_DD_PROGEXPORT

S_DD_SNPSHT_FMT

S_DD_PRPERFMEAS

Snapshot Elements

These tables were used by obsolete Siebel Server Components (Data Dictionary Manager and Marketing Server).

Upgrade Guide for DB2 UDB for z/OS