Skip Headers
Oracle® Communications Data Model Reference
11g Release 2 (11.2)

Part Number E15886-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

4 Oracle Communications Data Model Physical Data Model

This chapter provides information about the physical data model of Oracle Communications Data Model.

This chapter includes the following sections:

Introduction to Oracle Communications Data Model Physical Data Model

The Physical Data Model of the Oracle Communications Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions, indexes, and Materialized Views have been added to aid performance.

The Physical data model includes the following:

Important:

Do not make changes to the schemas as such changes are not supported.

Table 4-1 shows the table name prefix conventions. When you examine the predefined physical model, keep in mind the naming conventions shown in Table 4-1 that use DW (Data Warehouse) prefixes to identify the types of tables and views.

Table 4-1 Table Name Prefix Conventions

Prefix Description

DWA_

Aggregate table

DWB_

Base transaction table

DWD_

Derived (data mining) table

DWL_

Lookup table

DWR_

Reference data table


Reference Tables

Table 4-2 briefly describes the Reference tables in Oracle Communications Data Model.

Table 4-2 Reference Tables

Table Name Description More information

DWR_ACCS_MTHD

ACCESS METHOD

ACCESS METHOD

DWR_ACCS_MTHD_ACCT_ASGN

ACCESS METHOD ACCOUNT ASSIGNMENT

ACCESS METHOD ACCOUNT ASSIGNMENT

DWR_ACCS_MTHD_ASGN

ACCESS METHOD ASSIGNMENT

ACCESS METHOD ASSIGNMENT

DWR_ACCS_MTHD_ELMNT

ACCESS METHOD ELEMENT

ACCESS METHOD ELEMENT

DWR_ACCS_MTHD_EQPMNT_ASGN

ACCESS METHOD EQUIPMENT ASSIGNMENT

ACCESS METHOD EQUIPMENT ASSIGNMENT

DWR_ACCS_MTHD_GEO_ASGN

ACCESS METHOD GEOGRAPHY ASSIGNMENT

ACCESS METHOD GEOGRAPHY ASSIGNMENT

DWR_ACCS_MTHD_POOL

ACCESS METHOD POOL

ACCESS METHOD POOL

DWR_ACCS_MTHD_PRTY_ASGN

ACCESS METHOD PARTY ASSIGNMENT

ACCESS METHOD PARTY ASSIGNMENT

DWR_ACCS_MTHD_SBRP_ASGN

ACCESS METHOD SUBSCRIPTION ASSIGNMENT

ACCESS METHOD SUBSCRIPTION ASSIGNMENT

DWR_ACCS_MTHD_SGMNT

ACCESS METHOD SEGMENT

ACCESS METHOD SEGMENT

DWR_ACCSRS

ACCESSORIES

ACCESSORIES

DWR_ACCT

ACCOUNT

ACCOUNT

DWR_ACCT_ASGN

ACCOUNT ASSIGNMENT

ACCOUNT ASSIGNMENT

DWR_ACCT_BLLG_CYCL_HIST

ACCOUNT BILLING CYCLE HISTORY

ACCOUNT BILLING CYCLE HISTORY

DWR_ACCT_BLLG_FRQNCY_HIST

ACCOUNT BILLING FREQUENCY HISTORY

ACCOUNT BILLING FREQUENCY HISTORY

DWR_ACCT_BLLG_PRD_HIST

ACCOUNT BILLING PERIOD HISTORY

ACCOUNT BILLING PERIOD HISTORY

DWR_ACCT_CNRT_RLTN

ACCOUNT CONTRACT RELATIONSHIP

ACCOUNT CONTRACT RELATIONSHIP

DWR_ACCT_PREF_INVC_DLVRY

ACCOUNT PREFERRED INVOICE DELIVERY

ACCOUNT PREFERRED INVOICE DELIVERY

DWR_ACCT_PREF_PYMT_MTHD

ACCOUNT PREFERRED PAYMENT METHOD

ACCOUNT PREFERRED PAYMENT METHOD

DWR_ACCT_PRFL

ACCOUNT PROFILE

ACCOUNT PROFILE

DWR_ACCT_PRTY_PMP_RLTN

ACCOUNT PARTY PMP RELATIONSHIP

ACCOUNT PARTY PMP RELATIONSHIP

DWR_ACCT_SBRP_ASGN

ACCOUNT SUBSCRIPTION ASSIGNMENT

ACCOUNT SUBSCRIPTION ASSIGNMENT

DWR_ACCT_SGMNT

ACCOUNT SEGMENT

ACCOUNT SEGMENT

DWR_ACCT_SGMNT_ASGN_HIST

ACCOUNT SEGMENT ASSIGNMENT HISTORY

ACCOUNT SEGMENT ASSIGNMENT HISTORY

DWR_ACCT_SGMNT_MDL

ACCOUNT SEGMENTATION MODEL

ACCOUNT SEGMENTATION MODEL

DWR_ADDR_LOC

ADDRESS LOCATION

ADDRESS LOCATION

DWR_ADDR_RLTD

ADDRESS RELATED

ADDRESS RELATED

DWR_ADTNL_TXT

ADDITIONAL TEXT

ADDITIONAL TEXT

DWR_ADVR_PRD

ADVERTISING PERIOD

ADVERTISING PERIOD

DWR_ADVR_QTR

ADVERTISING QUARTER

ADVERTISING QUARTER

DWR_ADVR_WK

ADVERTISING WEEK

ADVERTISING WEEK

DWR_ADVR_YR

ADVERTISING YEAR

ADVERTISING YEAR

DWR_AM_SGMNT_PROD_CPBLTY_RL

ACCESS METHOD SEGMENT PROD CAPABILITY RL

ACCESS METHOD SEGMENT PROD CAPABILITY RL

DWR_ANZSIC_CLSFCTN

ANZSIC CLASSIFICATION

ANZSIC CLASSIFICATION

DWR_BASE_STN_CNTRLR

BASE STATION CONTROLLER

BASE STATION CONTROLLER

DWR_BASE_TRNSCVR_STN

BASE TRANSCEIVER STATION

BASE TRANSCEIVER STATION

DWR_BNK

BANK

BANK

DWR_BNK_DRCT_DEBT_CHNL

BANK DIRECT DEBIT CHANNEL

BANK DIRECT DEBIT CHANNEL

DWR_BRDBND

BROADBAND

BROADBAND

DWR_BRDBND_RTNG_PLN

BROADBAND RATING PLAN

BROADBAND RATING PLAN

DWR_BRND

BRAND

BRAND

DWR_BSNS_HLF_MO

BUSINESS HALF MONTH

BUSINESS HALF MONTH

DWR_BSNS_HLF_YR

BUSINESS HALF YEAR

BUSINESS HALF YEAR

DWR_BSNS_MO

BUSINESS MONTH

BUSINESS MONTH

DWR_BSNS_QTR

BUSINESS QUARTER

BUSINESS QUARTER

DWR_BSNS_UNIT_JB_RL

BUSINESS UNIT JOB ROLE

BUSINESS UNIT JOB ROLE

DWR_BSNS_UNIT_SHFT

BUSINESS UNIT SHIFT

BUSINESS UNIT SHIFT

DWR_BSNS_WK

BUSINESS WEEK

BUSINESS WEEK

DWR_BSNS_YR

BUSINESS YEAR

BUSINESS YEAR

DWR_CALL_CNTR

CALL CENTER

CALL CENTER

DWR_CALL_CNTR_AGNT

CALL CENTER AGENT

CALL CENTER AGENT

DWR_CALL_CNTR_SRVC_CAPBLTY

CALL CENTER SERVICE CAPABILITY

CALL CENTER SERVICE CAPABILITY

DWR_CALL_FRWD

CALL FORWARD

CALL FORWARD

DWR_CALL_SRC_DSTN

CALL SOURCE DESTINATION

CALL SOURCE DESTINATION

DWR_CALLR_ID

CALLER ID

CALLER ID

DWR_CARRIER

CARRIER

COURIER

DWR_CBL_MDM

CABLE MODEM

CABLE MODEM

DWR_CELL

CELL

CELL

DWR_CELL_SCTR

CELL SECTOR

CELL SECTOR

DWR_CELL_SITE

CELL SITE

CELL SITE

DWR_CHNL

CHANNEL

CHANNEL

DWR_CLNDR_HLF_MO

CALENDAR HALF MONTH

CALENDAR HALF MONTH

DWR_CLNDR_HLF_YR

CALENDAR HALF YEAR

CALENDAR HALF YEAR

DWR_CLNDR_MO

CALENDAR MONTH

CALENDAR MONTH

DWR_CLNDR_QTR

CALENDAR QUARTER

CALENDAR QUARTER

DWR_CLNDR_WK

CALENDAR WEEK

CALENDAR WEEK

DWR_CLNDR_YR

CALENDAR YEAR

CALENDAR YEAR

DWR_CMPGN

CAMPAIGN

CAMPAIGN

DWR_CMPGN_CHNL

CAMPAIGN CHANNEL

CAMPAIGN

DWR_CMPGN_MGMT_HIST

CAMPAIGN MANAGEMENT HISTORY

CAMPAIGN MANAGEMENT HISTORY

DWR_CMPGN_MSG

CAMPAIGN MESSAGE

CAMPAIGN MESSAGE

DWR_CMPGN_MSG_DPCT

CAMPAIGN MESSAGE DEPICTION

CAMPAIGN MESSAGE DEPICTION

DWR_CNCT_LST

CONTACT LIST

CONTACT LIST

DWR_CNRT

CONTRACT

CONTRACT

DWR_CNRT_ASGN

CONTRACT ASSIGNMENT

CONTRACT ASSIGNMENT

DWR_CNRT_DOC

CONTRACT DOCUMENT

CONTRACT DOCUMENT

DWR_CNRT_PROD_ASGN

CONTRACT PRODUCT ASSIGNMENT

CONTRACT PRODUCT ASSIGNMENT

DWR_CNTNT

CONTENT

CONTENT

DWR_CNTNT_PRICE

CONTENT PRICE

CONTENT PRICE

DWR_CNTNT_PRVDR

CONTENT PROVIDER

CONTENT PROVIDER

DWR_COLLCTN_AGNCY

COLLECTION AGENCY

COLLECTION AGENCY

DWR_COST_CNTR

COST CENTER

COST CENTER

DWR_CRCUT_CMPNT

CIRCUIT COMPONENT

CIRCUIT COMPONENT

DWR_CRDT_CTGRY

CREDIT CATEGORY

CREDIT CATEGORY

DWR_CRNCY_GEO_ENT_ASGN

CURRENCY GEOGRAPHY ENTITY ASSIGNMENT

CURRENCY GEOGRAPHY ENTITY ASSIGNMENT

DWR_CUST

CUSTOMER

CUSTOMER

DWR_CUST_CLASS_ASGN

CUSTOMER CLASS ASSIGNMENT

CUSTOMER CLASS ASSIGNMENT

DWR_CUST_INDVL

CUSTOMER INDIVIDUAL

CUSTOMER INDIVIDUAL

DWR_CUST_OCCSN

CUSTOMER OCCASION

CUSTOMER OCCASION

DWR_CUST_ORG

CUSTOMER ORGANIZATION

CUSTOMER ORGANIZATION

DWR_CUST_RSTRCT_INFO

CUSTOMER RESTRICTED INFO

CUSTOMER RESTRICTED INFO

DWR_CUST_RVN_BND_ASGN

CUSTOMER REVENUE BAND ASSIGNMENT

CUSTOMER REVENUE BAND

DWR_CUST_SCR

CUSTOMER SCORE

CUSTOMER SCORE

DWR_CUST_SGMNT

CUSTOMER SEGMENT

CUSTOMER SEGMENT

DWR_CUST_SGMNT_MDL

CUSTOMER SEGMENTATION MODEL

CUSTOMER SEGMENTATION MODEL

DWR_CUST_SIC_ASGN

CUSTOMER SIC ASSIGNMENT

CUSTOMER SIC ASSIGNMENT

DWR_CUST_SRC

CUSTOMER SOURCE

CUSTOMER SOURCE

DWR_DAY

DAY

DAY

DWR_DAY_ACT_CONDITION

DAY ACTUAL CONDITION

DAY ACTUAL CONDITION

DWR_DAY_TODATE_TRANS

DAY TODATE TRANSFORMATION

DAY TODATE TRANSFORMATION

DWR_DAY_TRANS

DAY TRANSFORMATION

DAY TRANSFORMATION

DWR_DEAL

DEAL

DEAL

DWR_DEAL_VNDR_ITEM_ASGN

DEAL VENDOR ITEM ASSIGNMENT

DEAL VENDOR ITEM ASSIGNMENT

DWR_DEMOG_ATRIB

DEMOGRAPHY ATTRIBUTE

DEMOGRAPHY ATTRIBUTE

DWR_DEMOG_GRP

DEMOGRAPHY GROUP

DEMOGRAPHY ATTRIBUTE

DWR_DISC_GRP

DISCOUNT GROUP

DISCOUNT GROUP

DWR_DLR

DEALER

DEALER

DWR_DLR_DISC_GRP_ASGN

DEALER DISCOUNT GROUP ASSIGNMENT

DEALER DISCOUNT GROUP ASSIGNMENT

DWR_DRVD_VAL

DERIVED VALUE

DERIVED VALUE

DWR_DSL_MDM

DSL MODEM

DSL MODEM

DWR_EMP

EMPLOYEE

EMPLOYEE

DWR_EMP_DISC_GRP_ASGN

EMPLOYEE DISCOUNT GROUP ASSIGNMENT

EMPLOYEE DISCOUNT GROUP ASSIGNMENT

DWR_EMP_JB_RL_ASGN

EMPLOYEE JOB ROLE ASSIGNMENT

EMPLOYEE JOB ROLE ASSIGNMENT

DWR_EMP_LANG_CAPBLTY

EMPLOYEE LANGUAGE CAPABILITY

EMPLOYEE LANGUAGE CAPABILITY

DWR_EMP_RSTRCT_INFO

EMPLOYEE RESTRICTED INFO

EMPLOYEE RESTRICTED INFO

DWR_EMP_SCHL

EMPLOYEE SCHEDULE

EMPLOYEE SCHEDULE

DWR_EQPMNT

EQUIPMENT

EQUIPMENT

DWR_EQPMNT_CNTR

EQUIPMENT CENTER

EQUIPMENT CENTER

DWR_EQPMNT_FNCTNLTY

EQUIPMENT FUNCTIONALITY

EQUIPMENT FUNCTIONALITY

DWR_EQPMNT_FNCTNLTY_ASGN

EQUIPMENT FUNCTIONALITY ASSIGNMENT

EQUIPMENT FUNCTIONALITY ASSIGNMENT

DWR_EQPMNT_INSTNC

EQUIPMENT INSTANCE

EQUIPMENT INSTANCE

DWR_EQPMNT_INSTNC_RENTING_CNRT

EQUIPMENT INSTANCE RENTING CONTRACT

EQUIPMENT INSTANCE RENTING CONTRACT

DWR_EVT_LOC

EVENT LOCATION

EVENT LOCATION

DWR_EVT_PRTY_RL

EVENT PARTY ROLE

EVENT PARTY ROLE

DWR_EVT_RSLTN

EVENT RESOLUTION

EVENT RESOLUTION

DWR_EXTRNL_INFO_SRC

EXTERNAL INFORMATION SOURCE

EXTERNAL INFORMATION SOURCE

DWR_EXTRNL_OPRTR

EXTERNAL OPERATOR

EXTERNAL OPERATOR

DWR_FCTR_CMPNY

FACTOR COMPANY

FACTOR COMPANY

DWR_FIXED_LN

FIXED LINE

FIXED LINE

DWR_FIXED_LN_PRT

FIXED LINE PORT

FIXED LINE PORT

DWR_FIXED_LN_RTNG_PLN

FIXED LINE RATING PLAN

FIXED LINE RATING PLAN

DWR_FSCL_HLF_MO

FISCAL HALF MONTH

FISCAL HALF MONTH

DWR_FSCL_HLF_YR

FISCAL HALF YEAR

FISCAL HALF YEAR

DWR_FSCL_MO

FISCAL MONTH

FISCAL MONTH

DWR_FSCL_QTR

FISCAL QUARTER

FISCAL QUARTER

DWR_FSCL_WK

FISCAL WEEK

FISCAL WEEK

DWR_FSCL_YR

FISCAL YEAR

FISCAL YEAR

DWR_GEO_CITY

GEOGRAPHY CITY

GEOGRAPHY CITY

DWR_GEO_CNTRY

GEOGRAPHY COUNTRY

GEOGRAPHY COUNTRY

DWR_GEO_CNTY

GEOGRAPHY COUNTY

GEOGRAPHY COUNTY

DWR_GEO_DEMOG_ATRIB

GEOGRAPHY DEMOGRAPHY ATTRIBUTE

GEOGRAPHY DEMOGRAPHY ATTRIBUTE

DWR_GEO_DEMOG_GRP

GEOGRAPHY DEMOGRAPHIC GROUP

GEOGRAPHY DEMOGRAPHIC GROUP

DWR_GEO_DEMOG_VAL

GEOGRAPHY DEMOGRAPHY VALUE

GEOGRAPHY DEMOGRAPHY VALUE

DWR_GEO_ENT

GEOGRAPHY ENTITY

GEOGRAPHY ENTITY

DWR_GEO_ENT_ASGN

GEOGRAPHY ENTITY ASSIGNMENT

GEOGRAPHY ENTITY ASSIGNMENT

DWR_GEO_ENT_HIER_LVL_ASGN

GEOGRAPHY ENTITY HIER LEVEL ASSIGNMENT

GEOGRAPHY ENTITY HIER LEVEL ASSIGNMENT

DWR_GEO_HRCHY

GEOGRAPHY HIERARCHY

GEOGRAPHY HIERARCHY

DWR_GEO_HRCHY_LVL

GEOGRAPHY HIERARCHY LEVEL

GEOGRAPHY HIERARCHY LEVEL

DWR_GEO_HRCHY_LVL_ASGN

GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT

GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT

DWR_GEO_LVL

GEOGRAPHY LEVEL

GEOGRAPHY LEVEL

DWR_GEO_LVL_ATRIB

GEOGRAPHY LEVEL ATTRIBUTE

GEOGRAPHY LEVEL ATTRIBUTE

DWR_GEO_LVL_ATRIB_VAL

GEOGRAPHY LEVEL ATTRIBUTE VALUE

GEOGRAPHY LEVEL ATTRIBUTE VALUE

DWR_GEO_RGN

GEOGRAPHY REGION

GEOGRAPHY REGION

DWR_GEO_SBRGN

GEOGRAPHY SUB REGION

GEOGRAPHY SUB REGION

DWR_GEO_STATE

GEOGRAPHY STATE

GEOGRAPHY STATE

DWR_GEO_WORLD

GEOGRAPHY WORLD

GEOGRAPHY WORLD

DWR_GL_REF

GL REFERENCE

GL REFERENCE

DWR_GPRS_SRVC

GPRS SERVICE

GPRS SERVICE

DWR_HH

HOUSEHOLD

HOUSEHOLD

DWR_HLF_HR

HALF HOUR

HALF HOUR

DWR_HLF_MO_TODATE_TRANS

HALF MONTH TODATE TRANSFORMATION

HALF MONTH TODATE TRANSFORMATION

DWR_HLF_MO_TRANS

HALF MONTH TRANSFORMATION

HALF MONTH TRANSFORMATION

DWR_HLF_YR_TODATE_TRANS

HALF YEAR TODATE TRANSFORMATION

HALF YEAR TODATE TRANSFORMATION

DWR_HLF_YR_TRANS

HALF YEAR TRANSFORMATION

HALF YEAR TRANSFORMATION

DWR_HNDST_INSTNC

HANDSET INSTANCE

HANDSET INSTANCE

DWR_HNDST_MDL

HANDSET MODEL

HANDSET MODEL

DWR_HR

HOUR

HOUR

DWR_IDD

IDD

IDD

DWR_IN_PLTFRM

IN PLATFORM

IN PLATFORM

DWR_INDVL_DEMOG_PRFL

INDIVIDUAL DEMOGRAPHY PROFILE

INDIVIDUAL DEMOGRAPHY PROFILE

DWR_INDVL_DEMOG_VAL

INDIVIDUAL DEMOGRAPHY VALUE

INDIVIDUAL DEMOGRAPHY VALUE

DWR_INTRACN_CHNL

INTERACTION CHANNEL

INTERACTION CHANNEL

DWR_INVC_ADJ_QTA

INVOICE ADJUSTMENT QUOTA

INVOICE ADJUSTMENT QUOTA

DWR_INVC_PYMT_TRM

INVOICE PAYMENT TERM

INVOICE PAYMENT TERM

DWR_IP_ADDR_POOL

IP ADDRESS POOL

IP ADDRESS POOL

DWR_ISP

ISP

ISP

DWR_ISP_BSNS

ISP BUSINESS

ISP BUSINESS

DWR_ISP_BSNS_ASGN

ISP BUSINESS ASSIGNMENT

ISP BUSINESS ASSIGNMENT

DWR_ISP_USER

ISP USER

ISP USER

DWR_ITEM

ITEM

ITEM

DWR_JB

JOB

JOB

DWR_JB_RL

JOB ROLE

JOB ROLE

DWR_LYLTY_PROG

LOYALTY PROGRAM

LOYALTY PROGRAM

DWR_LYLTY_PROG_CHNL

LOYALTY PROGRAM CHANNEL

LOYALTY PROGRAM CHANNEL

DWR_MAILBOX

MAILBOX

MAILBOX

DWR_MBL_SWTCHNG_CNTR

MOBILE SWITCHING CENTER

MOBILE SWITCHING CENTER

DWR_MEDIA_OBJ

MEDIA OBJECT

MEDIA OBJECT

DWR_MEDIA_OBJ_ASGN

MEDIA OBJECT ASSIGNMENT

MEDIA OBJECT ASSIGNMENT

DWR_MKT_AREA

MARKET AREA

MARKET AREA

DWR_MKT_AREA_LVL

MARKET AREA LEVEL

MARKET AREA LEVEL

DWR_MKT_PLN_SUB_BY_DOC

MARKET PLAN SUBSTITUTE BY DOC

MARKET PLAN SUBSTITUTE BY DOC

DWR_MKT_PLN_TERM_VAL

MARKET PLAN TERM VALUE

MARKET PLAN TERM VALUE

DWR_MMS

MMS

MMS

DWR_MNT

MINUTE

MINUTE

DWR_MO_TODATE_TRANS

MONTH TODATE TRANSFORMATION

MONTH TODATE TRANSFORMATION

DWR_MO_TRANS

MONTH TRANSFORMATION

MONTH TRANSFORMATION

DWR_MUS_DNLD

MUSIC DOWNLOAD

MUSIC DOWNLOAD

DWR_NAICS_CLSFCTN

NAICS CLASSIFICATION

NAICS CLASSIFICATION

DWR_NAICS_INDSTRY

NAICS INDUSTRY

NAICS INDUSTRY

DWR_NAICS_INDSTRY_GRP

NAICS INDUSTRY GROUP

NAICS INDUSTRY GROUP

DWR_NAICS_INDSTRY_SCTR

NAICS INDUSTRY SECTOR

NAICS INDUSTRY SECTOR

DWR_NAICS_INDSTRY_SUBSCTR

NAICS INDUSTRY SUBSECTOR

NAICS INDUSTRY SUBSECTOR

DWR_NBR_AREA

NUMBER AREA

NUMBER AREA

DWR_NBR_CNTRY

NUMBER COUNTRY

NUMBER COUNTRY

DWR_NP_MBL_MSISDN

NP MOBILE MSISDN

NP MOBILE MSISDN

DWR_NTWK

NETWORK

NETWORK

DWR_NTWK_ELMNT

NETWORK ELEMENT

NETWORK ELEMENT

DWR_NTWK_SRVC_COVRG_ASGN

NETWORK SERVICE COVERAGE ASSIGNMENT

NETWORK SERVICE COVERAGE ASSIGNMENT

DWR_NTWK_TCHPNT

NETWORK TOUCHPOINT

NETWORK TOUCHPOINT

DWR_ORDR_LN_ITEM_STATE

ORDER LINE ITEM STATE

ORDER LINE ITEM STATE

DWR_ORG_AREA

ORGANIZATION AREA

ORGANIZATION AREA

DWR_ORG_BNR

ORGANIZATION BANNER

ORGANIZATION BANNER

DWR_ORG_BSNS_ENT

ORGANIZATION BUSINESS ENTITY

ORGANIZATION BUSINESS ENTITY

DWR_ORG_BSNS_UNIT

ORGANIZATION BUSINESS UNIT

ORGANIZATION BUSINESS UNIT

DWR_ORG_CHAIN

ORGANIZATION CHAIN

ORGANIZATION CHAIN

DWR_ORG_CMPNY

ORGANIZATION COMPANY

ORGANIZATION COMPANY

DWR_ORG_CRPRT

ORGANIZATION CORPORATE

ORGANIZATION CORPORATE

DWR_ORG_DIV

ORGANIZATION DIVISION

ORGANIZATION DIVISION

DWR_ORG_DSTRCT

ORGANIZATION DISTRICT

ORGANIZATION DISTRICT

DWR_ORG_HRCHY

ORGANIZATION HIERARCHY

ORGANIZATION HIERARCHY

DWR_ORG_HRCHY_LVL

ORGANIZATION HIERARCHY LEVEL

ORGANIZATION HIERARCHY LEVEL

DWR_ORG_HRCHY_LVL_ASGN

ORGANIZATION HIERARCHY LEVEL ASSIGNMENT

ORGANIZATION HIERARCHY LEVEL ASSIGNMENT

DWR_ORG_HRCHY_VRSN

ORGANIZATION HIERARCHY VERSION

ORGANIZATION HIERARCHY VERSION

DWR_ORG_ITEM_SLNG_PRICE

ORGANIZATION ITEM SELLING PRICE

ORGANIZATION ITEM SELLING PRICE

DWR_ORG_LVL

ORGANIZATION LEVEL

ORGANIZATION LEVEL

DWR_ORG_LVL_ATRIB_VAL

ORGANIZATION LEVEL ATTRIBUTE VALUE

ORGANIZATION LEVEL ATTRIBUTE VALUE

DWR_ORG_LVL_ATTR

ORGANIZATION LEVEL ATTRIBUTES

ORGANIZATION LEVEL ATTRIBUTES

DWR_ORG_MKT_DATA

ORGANIZATION MARKET DATA

ORGANIZATION MARKET DATA

DWR_ORG_RGN

ORGANIZATION REGION

ORGANIZATION REGION

DWR_ORG_SRVC_WBSITE

ORGANIZATION SERVICE WEBSITE

ORGANIZATION SERVICE WEBSITE

DWR_ORG_WRHS

ORGANIZATION WAREHOUSE

ORGANIZATION WAREHOUSE

DWR_ORGNTL_DEMOG_VAL

ORGANIZATIONAL DEMOGRAPHY VALUE

ORGANIZATIONAL DEMOGRAPHY VALUE

DWR_OTHR_INDVL

OTHER INDIVIDUAL

OTHER INDIVIDUAL

DWR_PAY_TV

PAY TV

PAY TV

DWR_PBLCTN

PUBLICATION

PUBLICATION

DWR_PHONE_NBR_POOL

TELEPHONE NUMBER POOL

TELEPHONE NUMBER POOL

DWR_PLNG_PRD

PLANNING PERIOD

PLANNING PERIOD

DWR_PLNG_QTR

PLANNING QUARTER

PLANNING QUARTER

DWR_PLNG_SEASON

PLANNING SEASON

PLANNING SEASON

DWR_PLNG_WK

PLANNING WEEK

PLANNING WEEK

DWR_PLNG_YR

PLANNING YEAR

PLANNING YEAR

DWR_PMP_ORG_AVLBLTY

PMP ORGANIZATION AVAILABILITY

PMP ORGANIZATION AVAILABILITY

DWR_POSTCD

POSTCODE

POSTCODE

DWR_PRD_TODATE_TRANS

PERIOD TO DATE TRANSFORMATION

PERIOD TO DATE TRANSFORMATION

DWR_PRD_TRANS

PERIOD TRANSFORMATION

PERIOD TRANSFORMATION

DWR_PRICE_DRVTN_RULE

PRICE DERIVATION RULE

PRICE DERIVATION RULE

DWR_PRMTN

PROMOTION

PROMOTION

DWR_PRMTN_MKT_PLN_ASGN

PROMOTION MARKET PLAN ASSIGNMENT

PROMOTION MARKET PLAN ASSIGNMENT

DWR_PRMTN_MSG_RNDRNG

PROMOTION MESSAGE RENDERING

PROMOTION MESSAGE RENDERING

DWR_PROD

PRODUCT

PRODUCT

DWR_PROD_ADTNL_TXT

PRODUCT ADDITIONAL TEXT

PRODUCT ADDITIONAL TEXT

DWR_PROD_ASGN

PRODUCT ASSIGNMENT

PRODUCT ASSIGNMENT

DWR_PROD_CAPBLTY

PRODUCT CAPABILITY

PRODUCT CAPABILITY

DWR_PROD_CAPBLTY_VAL

PRODUCT CAPABILITY VALUE

PRODUCT CAPABILITY VALUE

DWR_PROD_CHRG_TYP_RLTN

PRODUCT CHARGE TYPE RELATIONSHIP

PRODUCT CHARGE TYPE RELATIONSHIP

DWR_PROD_FNCTNLTY_DPNDNTCY

PRODUCT FUNCTIONALITY DEPENDENCY

PRODUCT FUNCTIONALITY DEPENDENCY

DWR_PROD_FTR

PRODUCT FEATURE

PRODUCT FEATURE

DWR_PROD_FTR_ASGN

PRODUCT FEATURE ASSIGNMENT

PRODUCT FEATURE ASSIGNMENT

DWR_PROD_GEO_ASGN

PRODUCT GEOGRAPHY ASSIGNMENT

PRODUCT GEOGRAPHY ASSIGNMENT

DWR_PROD_GRP_ASGN

PRODUCT GROUP ASSIGNMENT

PRODUCT GROUP ASSIGNMENT

DWR_PROD_INSTNC

PRODUCT INSTANCE

PRODUCT INSTANCE

DWR_PROD_MKT_PLN

PRODUCT MARKET PLAN

PRODUCT MARKET PLAN

DWR_PROD_MKT_PLN_ASGN

PRODUCT MARKET PLAN ASSIGNMENT

PRODUCT MARKET PLAN ASSIGNMENT

DWR_PROD_MKT_PLN_GEO_ASGN

PRODUCT MARKET PLAN GEOGRAPHY ASSIGNMENT

PRODUCT MARKET PLAN GEOGRAPHY ASSIGNMENT

DWR_PROD_MKT_PLN_GRP

PRODUCT MARKET PLAN GROUP

PRODUCT MARKET PLAN GROUP

DWR_PROD_MKT_PLN_GRP_ASGN

PRODUCT MARKET PLAN GROUP ASSIGNMENT

PRODUCT MARKET PLAN GROUP ASSIGNMENT

DWR_PROD_NTWK_ASGN

PRODUCT NETWORK ASSIGNMENT

PRODUCT NETWORK ASSIGNMENT

DWR_PROD_PKG

PRODUCT PACKAGE

PRODUCT PACKAGE

DWR_PROD_PKG_ASGN

PRODUCT PACKAGE ASSIGNMENT

PRODUCT PACKAGE ASSIGNMENT

DWR_PROD_RTNG_PLN

PRODUCT RATING PLAN

PRODUCT RATING PLAN

DWR_PROD_RTNG_PLN_DTL

PRODUCT RATING PLAN DETAIL

PRODUCT RATING PLAN DETAIL

DWR_PROD_VRSN

PRODUCT VERSION

PRODUCT VERSION

DWR_PRPD_MBL_VCHR

PREPAID MOBILE VOUCHER

PREPAID MOBILE VOUCHER

DWR_PRPD_VCHR

PREPAID VOUCHER

PREPAID VOUCHER

DWR_PRPD_WRLS

PREPAID WIRELESS

PREPAID WIRELESS

DWR_PRSPCT

PROSPECT

PROSPECT

DWR_PRSPCT_INDVL

PROSPECT INDIVIDUAL

PROSPECT INDIVIDUAL

DWR_PRSPCT_ORG

PROSPECT ORGANIZATION

PROSPECT ORGANIZATION

DWR_PRTNR_PRMTN_PROG

PARTNER PROMOTION PROGRAM

PARTNER PROMOTION PROGRAM

DWR_PRTY

PARTY

PARTY

DWR_PRTY_ACCT_ASGN

PARTY ACCOUNT ASSIGNMENT

PARTY ACCOUNT ASSIGNMENT

DWR_PRTY_ADDR_LOC_ASGN

PARTY ADDRESS LOCATION ASSIGNMENT

PARTY ADDRESS LOCATION ASSIGNMENT

DWR_PRTY_ASGN

PARTY ASSIGNMENT

PARTY ASSIGNMENT

DWR_PRTY_CNCT_INFO

PARTY CONTACT INFORMATION

PARTY CONTACT INFORMATION

DWR_PRTY_CNRT_ASGN

PARTY CONTRACT ASSIGNMENT

PARTY CONTRACT ASSIGNMENT

DWR_PRTY_GEO_ENT_ASGN

PARTY GEOGRAPHY ENTITY ASSIGNMENT

PARTY GEOGRAPHY ENTITY ASSIGNMENT

DWR_PRTY_ID

PARTY IDENTIFICATION

PARTY IDENTIFICATION

DWR_PRTY_LYLTY_PROG_PRTCPTN

PARTY LOYALTY PROGRAM PARTICIPATION

PARTY LOYALTY PROGRAM PARTICIPATION

DWR_PRTY_RL_ASGN

PARTY ROLE ASSIGNMENT

PARTY ROLE ASSIGNMENT

DWR_PRTY_RL_STAT

PARTY ROLE STATUS

PARTY ROLE STATUS

DWR_PRTY_SBRP_ASGN

PARTY SUBSCRIPTION ASSIGNMENT

PARTY SUBSCRIPTION ASSIGNMENT

DWR_PRTY_SIM_CARD_ASGN

PARTY SIM CARD ASSIGNMENT

PARTY SIM CARD ASSIGNMENT

DWR_PSTPD_WRLS

POSTPAID WIRELESS

POSTPAID WIRELESS

DWR_PYMT_CHNL

PAYMENT CHANNEL

PAYMENT CHANNEL

DWR_QTR_HR

QUARTER HOUR

QUARTER HOUR

DWR_QTR_TODATE_TRANS

QUARTER TO DATE TRANSFORMATION

QUARTER TO DATE TRANSFORMATION

DWR_QTR_TRANS

QUARTER TRANSFORMATION

QUARTER TRANSFORMATION

DWR_RF_CARRIER

RF CARRIER

RF CARRIER

DWR_RLS_HRCHY

ROLES HIERARCHY

ROLES HIERARCHY

DWR_RNGTN

RINGTONE

RINGTONE

DWR_RTL_STORE

RETAIL STORE

RETAIL STORE

DWR_RUTNG_DVC

ROUTING DEVICE

ROUTING DEVICE

DWR_SBRP

SUBSCRIPTION

SUBSCRIPTION

DWR_SBRP_ASGN

SUBSCRIPTION ASSIGNMENT

SUBSCRIPTION ASSIGNMENT

DWR_SBRP_CLASS_OF_SRVC

SUBSCRIPTION SERVICE CLASS ASSIGNMENT

SUBSCRIPTION SERVICE CLASS ASSIGNMENT

DWR_SBRP_PMP_ASGN

SUBSCRIPTION PMP ASSIGNMENT

SUBSCRIPTION PMP ASSIGNMENT

DWR_SCND

SECOND

SECOND

DWR_SCRPT

SCRIPT

SCRIPT

DWR_SCRPT_QUES

SCRIPT QUESTION

SCRIPT QUESTION

DWR_SET_TOP_BOX

SET TOP BOX

SET TOP BOX

DWR_SET_TOP_BOX_MDL

SET TOP BOX MODEL

SET TOP BOX MODEL

DWR_SGMNT_CRTRA

SEGMENT CRITERIA

SEGMENT CRITERIA

DWR_SIC_ASGN

SIC ASSIGNMENT

SIC ASSIGNMENT

DWR_SIC_DIV

SIC DIVISION

SIC DIVISION

DWR_SIM_CARD

SIM CARD

SIM CARD

DWR_SIM_CARD_ACCS_MTHD_ASGN

SIM CARD ACCESS METHOD ASSIGNMENT

SIM CARD ACCESS METHOD ASSIGNMENT

DWR_SIM_CARD_HNDST_ASGN

SIM CARD HANDSET ASSIGNMENT

SIM CARD HANDSET ASSIGNMENT

DWR_SIM_CARD_SBRP_ASGN

SIM CARD SUBSCRIPTION ASSIGNMENT

SIM CARD SUBSCRIPTION ASSIGNMENT

DWR_SL_CHNL

SALES CHANNEL

SALES CHANNEL

DWR_SL_CHNL_RPRSTV

SALES CHANNEL REPRESENTATIVE

SALES CHANNEL REPRESENTATIVE

DWR_SL_CMISN_PLN

SALES COMMISSION PLAN

SALES COMMISSION PLAN

DWR_SL_CMISN_PLN_DTL

SALES COMMISSION PLAN DETAIL

SALES COMMISSION PLAN DETAIL

DWR_SLNG_LOC

SELLING LOCATION

SELLING LOCATION

DWR_SMS

SMS

SMS

DWR_SMS_RTNG_PLN

SMS RATING PLAN

SMS RATING PLAN

DWR_SOC_JB

SOC JOB

SOC JOB

DWR_SOC_JB_CTGRY

SOC JOB CATEGORY

SOC JOB CATEGORY

DWR_SOC_JB_GRP

SOC JOB GROUP

SOC JOB GROUP

DWR_SOC_JB_MJR_GRP

SOC JOB MAJOR GROUP

SOC JOB MAJOR GROUP

DWR_SPLMNTR_SRVC

SUPPLEMENTARY SERVICE

SUPPLEMENTARY SERVICE

DWR_SRC_SYS

SOURCE SYSTEM

SOURCE SYSTEM

DWR_SRC_SYS_KEY_MAPPING

SOURCE SYSTEM KEY MAPPING

SOURCE SYSTEM KEY MAPPING

DWR_SRVC

SERVICE

SERVICE

DWR_SRVC_COVRG_AREA

SERVICE COVERAGE AREA

SERVICE COVERAGE AREA

DWR_SRVC_COVRG_GEO_DTL

SERVICE COVERAGE GEO DETAIL

SERVICE COVERAGE GEO DETAIL

DWR_SRVC_EQPMNT_ASGN

SERVICE EQUIPMENT ASSIGNMENT

SERVICE EQUIPMENT ASSIGNMENT

DWR_SWTCH

SWITCH

SWITCH

DWR_SWTCH_CAPBLTY

SWITCH CAPABILITY

SWITCH CAPABILITY

DWR_SWTCH_CMMND

SWITCH COMMAND

SWITCH COMMAND

DWR_SWTCH_RUTNG_DVC_ASGN

SWITCH ROUTING DEVICE ASSIGNMENT

SWITCH ROUTING DEVICE ASSIGNMENT

DWR_TIME_SLT

TIME SLOT

TIME SLOT

DWR_TIME_STNDRD_BY_DAY

TIME STANDARD BY DAY

TIME STANDARD BY DAY

DWR_TIME_STNDRD_BY_WK

TIME STANDARD BY WEEK

TIME STANDARD BY WEEK

DWR_TRGT_ACCS_MTHD

TARGET ACCESS METHOD

TARGET ACCESS METHOD

DWR_TRGT_ACCT

TARGET ACCOUNT

TARGET ACCOUNT

DWR_TRGT_CNRT

TARGET CONTRACT

TARGET CONTRACT

DWR_TRGT_GEO_AREA

TARGET GEOGRAPHY AREA

TARGET GEOGRAPHY AREA

DWR_TV_CHNL

TV CHANNEL

TV CHANNEL

DWR_USER

USER

USER

DWR_VAL_ADD_SRVC

VALUE ADDED SERVICE

VALUE ADDED SERVICE

DWR_VAS_SBRP

VAS SUBSCRIPTION

VAS SUBSCRIPTION

DWR_VNDR

VENDOR

VENDOR

DWR_VNDR_CNRT

VENDOR CONTRACT

VENDOR CONTRACT

DWR_VNDR_FCTR_CMPNY_ASGN

VENDOR FACTOR COMPANY ASSIGNMENT

VENDOR FACTOR COMPANY ASSIGNMENT

DWR_VNDR_RTNG

VENDOR RATING

VENDOR RATING

DWR_VNDR_SITE

VENDOR SITE

VENDOR SITE

DWR_VNDR_SITE_CARRIER_ASGN

VENDOR SITE COURIER ASSIGNMENT

VENDOR SITE COURIER ASSIGNMENT

DWR_VOI_MSG_SRVC

VOICE MESSAGE SERVICE

VOICE MESSAGE SERVICE

DWR_VRTL_TEAM

VIRTUAL TEAM

 

DWR_WEATHR_CNDTN

WEATHER CONDITION

WEATHER CONDITION

DWR_WK_TODATE_TRANS

WEEK TODATE TRANSFORMATION

WEEK TODATE TRANSFORMATION

DWR_WK_TRANS

WEEK TRANSFORMATION

WEEK TRANSFORMATION

DWR_WKDAY

WEEKDAY

WEEKDAY

DWR_WRLS_NTWK_ELMNT

WIRELESS NETWORK ELEMENT

WIRELESS NETWORK ELEMENT

DWR_WRLS_RTNG_PLN

WIRELESS RATING PLAN

WIRELESS RATING PLAN

DWR_YR_TRANS

YEAR TRANSFORMATION

YEAR TRANSFORMATION


Lookup Tables

Table 4-3 briefly describes the Lookup tables in Oracle Communications Data Model.

Table 4-3 Lookup Tables

Table Name Description More Information

DWL_ACCS_MTHD_ASGN_TYP

ACCESS METHOD ASSIGNMENT TYPE

ACCESS METHOD ASSIGNMENT TYPE

DWL_ACCS_MTHD_ELMNT_TYP

ACCESS METHOD ELEMENT TYPE

ACCESS METHOD ELEMENT TYPE

DWL_ACCS_MTHD_PRTY_ASGN_TYP

ACCESS METHOD PARTY ASSIGNMENT TYPE

ACCESS METHOD PARTY ASSIGNMENT TYPE

DWL_ACCS_MTHD_STAT_RSN

ACCESS METHOD STATUS REASON

ACCESS METHOD STATUS REASON

DWL_ACCS_MTHD_STAT_TYP

ACCESS METHOD STATUS TYPE

ACCESS METHOD STATUS TYPE

DWL_ACCS_MTHD_TYP

ACCESS METHOD TYPE

ACCESS METHOD TYPE

DWL_ACCT_ADJ_RSN

ACCOUNT ADJUSTMENT REASON

ACCOUNT ADJUSTMENT REASON

DWL_ACCT_ASGN_RSN

ACCOUNT ASSIGNMENT REASON

ACCOUNT ASSIGNMENT REASON

DWL_ACCT_BAL_ADJ_TYP

ACCOUNT BALANCE ADJUSTMENT TYPE

ACCOUNT BALANCE ADJUSTMENT TYPE

DWL_ACCT_BAL_TYP

ACCOUNT BALANCE TYPE

ACCOUNT BALANCE TYPE

DWL_ACCT_CYCL

ACCOUNTING CYCLE

ACCOUNTING CYCLE

DWL_ACCT_EVT_TYP

ACCOUNT EVENT TYPE

ACCOUNT EVENT TYPE

DWL_ACCT_ITEM_CTGRY

ACCOUNTING ITEM CATEGORY

ACCOUNTING ITEM CATEGORY

DWL_ACCT_PYMT_MTHD_STAT_RSN

ACCOUNT PAYMENT METHOD STATUS REASON

ACCOUNT PAYMENT METHOD STATUS REASON

DWL_ACCT_PYMT_MTHD_STAT_TYP

ACCOUNT PAYMENT METHOD STATUS TYPE

ACCOUNT PAYMENT METHOD STATUS TYPE

DWL_ACCT_RFND_RSN

ACCOUNT REFUND REASON

ACCOUNT REFUND REASON

DWL_ACCT_SBRP_ASGN_RSN

ACCOUNT SUBSCRIPTION ASSIGNMENT REASON

ACCOUNT SUBSCRIPTION ASSIGNMENT REASON

DWL_ACCT_STAT_RSN

ACCOUNT STATUS REASON

ACCOUNT STATUS REASON

DWL_ACCT_STAT_TYP

ACCOUNT STATUS TYPE

ACCOUNT STATUS TYPE

DWL_ACCT_TYP

ACCOUNT TYPE

ACCOUNT TYPE

DWL_ADDR_RLTD_RSN

ADDRESS RELATED REASON

ADDRESS RELATED REASON

DWL_ADDR_STAT_RSN

ADDRESS STATUS REASON

ADDRESS STATUS REASON

DWL_ADDR_TYP

ADDRESS TYPE

ADDRESS TYPE

DWL_AGE_BND

AGE BAND

AGE BAND

DWL_AGE_ON_NET_BND

AGE ON NET BAND

AGE ON NET BAND

DWL_APNMNT_TYP

APPOINTMENT TYPE

APPOINTMENT TYPE

DWL_ARPU_BND

ARPU BAND

ARPU BAND

DWL_AWRD_LVL

AWARD LEVEL

AWARD LEVEL

DWL_BARNG_RSN

BARING REASON

BARING REASON

DWL_BER_FER_TYP

BER FER TYPE

BER FER TYPE

DWL_BLLG_CYCL

BILLING CYCLE

BILLING CYCLE

DWL_BLLG_FRQNCY

BILLING FREQUENCY

BILLING FREQUENCY

DWL_BLLG_PRD

BILLING PERIOD

BILLING PERIOD

DWL_BLLG_STAT_CTGRY

BILLING STATUS CATEGORY

BILLING STATUS CATEGORY

DWL_BLLG_STAT_TYP

BILLING STATUS TYPE

BILLING STATUS TYPE

DWL_BSNS_LEGAL_STAT

BUSINESS LEGAL STATUS

BUSINESS LEGAL STATUS

DWL_CALL_CNTR_AGNT_TYP

CALL CENTER AGENT TYPE

CALL CENTER AGENT TYPE

DWL_CALL_CNTR_CASE_SUB_TYP

CALL CENTER CASE SUB TYPE

CALL CENTER CASE SUB TYPE

DWL_CALL_CNTR_CASE_TTL

CALL CENTER CASE TITLE

CALL CENTER CASE TITLE

DWL_CALL_CNTR_CASE_TYP

CALL CENTER CASE TYPE

CALL CENTER CASE TYPE

DWL_CALL_CTGRY

CALL CATEGORY

CALL CATEGORY

DWL_CALL_DRCTN

CALL DIRECTION

CALL DIRECTION

DWL_CALL_OTHR_TYP

CALL OTHER TYPE

CALL OTHER TYPE

DWL_CALL_RCYLD_RSN

CALL RECYCLED REASON

CALL RECYCLED REASON

DWL_CALL_RUTNG_TYP

CALL ROUTING TYPE

CALL ROUTING TYPE

DWL_CALL_SRCHRG

CALL SURCHARGE

CALL SURCHARGE

DWL_CALL_SRVC_TYP

CALL SERVICE TYPE

CALL SERVICE TYPE

DWL_CALL_SUCC_FAIL_TYP

CALL SUCCESS FAILURE TYPE

CALL SUCCESS FAILURE TYPE

DWL_CALL_TMNT_RSN

CALL TERMINATION REASON

CALL TERMINATION REASON

DWL_CALL_TYP

CALL TYPE

CALL TYPE

DWL_CELL_OUTAGE_RSN

CELL OUTAGE REASON

CELL OUTAGE REASON

DWL_CELL_SITE_TYP

CELL SITE TYPE

CELL SITE TYPE

DWL_CELL_TYP

CELL TYPE

CELL TYPE

DWL_CHNG_PPSD_BY_TYP

CHANGE PROPOSED BY TYPE

CHANGE PROPOSED BY TYPE

DWL_CHNL_TYP

CHANNEL TYPE

CHANNEL TYPE

DWL_CHRN_RSN

CHURN REASON

CHURN REASON

DWL_CMISN_TYP

COMMISSION TYPE

COMMISSION TYPE

DWL_CMPGN_CHNL_TYP

CAMPAIGN CHANNEL TYPE

CAMPAIGN CHANNEL TYPE

DWL_CMPGN_PRPS_TYP

CAMPAIGN PURPOSE TYPE

CAMPAIGN PURPOSE TYPE

DWL_CMPGN_STAT

CAMPAIGN STATUS

CAMPAIGN STATUS

DWL_CMPGN_TYP

CAMPAIGN TYPE

CAMPAIGN TYPE

DWL_CNCT_LST_CHNG_RSN

CONTACT LIST CHANGE REASON

CONTACT LIST CHANGE REASON

DWL_CNCT_LST_RECRNC_TYP

CONTACT LIST RECURRENCE TYPE

CONTACT LIST RECURRENCE TYPE

DWL_CNCT_RLS

CONTACT ROLES

CONTACT ROLES

DWL_CNRT_ASGN_RSN

CONTRACT ASSIGNMENT REASON

CONTRACT ASSIGNMENT REASON

DWL_CNRT_ASGN_TYP

CONTRACT ASSIGNMENT TYPE

CONTRACT ASSIGNMENT TYPE

DWL_CNRT_CHNG_INTTR_TYP

CONTRACT CHANGE INITIATOR TYPE

CONTRACT CHANGE INITIATOR TYPE

DWL_CNRT_CHNG_TYP

CONTRACT CHANGE TYPE

CONTRACT CHANGE TYPE

DWL_CNRT_STAT_RSN

CONTRACT STATUS REASON

CONTRACT STATUS REASON

DWL_CNRT_STAT_TYP

CONTRACT STATUS TYPE

CONTRACT STATUS TYPE

DWL_CNRT_TERM_TYP

CONTRACT TERM TYPE

CONTRACT TERM TYPE

DWL_CNRT_TYP

CONTRACT TYPE

CONTRACT TYPE

DWL_CNTNT_PRCNG_TYP

CONTENT PRICING TYPE

CONTENT PRICING TYPE

DWL_CNTNT_TYP

CONTENT TYPE

CONTENT TYPE

DWL_COST_RSN

COST REASON

COST REASON

DWL_COST_SUBTYP

COST SUBTYPE

COST SUBTYPE

DWL_COST_TYP

COST TYPE

COST TYPE

DWL_CRCUT_CTGRY

CIRCUIT CATEGORY

CIRCUIT CATEGORY

DWL_CRCUT_RNTL_EVT_TYP

CIRCUIT RENTAL EVENT TYPE

CIRCUIT RENTAL EVENT TYPE

DWL_CRCUT_TYP

CIRCUIT TYPE

CIRCUIT TYPE

DWL_CRNCY

CURRENCY

CURRENCY

DWL_CUST_CLASS

CUSTOMER CLASS

CUSTOMER CLASS

DWL_CUST_OCCSN_TYP

CUSTOMER OCCASION TYPE

CUSTOMER OCCASION TYPE

DWL_CUST_RVN_BND

CUSTOMER REVENUE BAND

CUSTOMER REVENUE BAND

DWL_CUST_RVN_TYP

CUSTOMER REVENUE TYPE

CUSTOMER REVENUE TYPE

DWL_CUST_SNTMNT

CUSTOMER SENTIMENT

CUSTOMER SENTIMENT

DWL_CUST_TYP

CUSTOMER TYPE

CUSTOMER TYPE

DWL_DEBT_AGNG_BND

DEBT AGING BAND

DEBT AGING BAND

DWL_DOC_CNDTN_TYP

DOCUMENT CONDITION TYPE

DOCUMENT CONDITION TYPE

DWL_DOC_TYP

DOCUMENT TYPE

DOCUMENT TYPE

DWL_DRCT_DEBT_STAT_RSN

DIRECT DEBIT STATUS REASON

DIRECT DEBIT STATUS REASON

DWL_DSTN_TYP

DESTINATION TYPE

DESTINATION TYPE

DWL_DSTNC_BND

DISTANCE BAND

DISTANCE BAND

DWL_DVRT_RTRV_RSN

DIVERT RETRIEVE REASON

DIVERT RETRIEVE REASON

DWL_DVRT_RTRV_TYP

DIVERT RETRIEVE TYPE

DIVERT RETRIEVE TYPE

DWL_EDU

EDUCATION

EDUCATION

DWL_EMP_DESIG

EMPLOYEE DESIGNATION

EMPLOYEE DESIGNATION

DWL_EMP_JB_RL_TYP

EMPLOYEE JOB ROLE TYPE

EMPLOYEE JOB ROLE TYPE

DWL_EMP_TYP

EMPLOYEE TYPE

EMPLOYEE TYPE

DWL_EQPMNT_INSTNC_STAT_TYP

EQUIPMENT INSTANCE STATUS TYPE

EQUIPMENT INSTANCE STATUS TYPE

DWL_EVT_ASGN_RSN

EVENT ASSIGNMENT REASON

EVENT ASSIGNMENT REASON

DWL_EVT_ASGN_TYP

EVENT ASSIGNMENT TYPE

EVENT ASSIGNMENT TYPE

DWL_EVT_CLASS

EVENT CLASS

EVENT CLASS

DWL_EVT_CTGRY

EVENT CATEGORY

EVENT CATEGORY

DWL_EVT_RESPN_RSN

EVENT RESPONSE REASON

EVENT RESPONSE REASON

DWL_EVT_RSLT

EVENT RESULT

EVENT RESULT

DWL_EVT_RSN

EVENT REASON

EVENT REASON

DWL_EVT_RSN_CTGRY

EVENT REASON CATEGORY

EVENT REASON CATEGORY

DWL_EVT_STAT_RSN

EVENT STATUS REASON

EVENT STATUS REASON

DWL_EVT_STAT_TYP

EVENT STATUS TYPE

EVENT STATUS TYPE

DWL_EVT_TYP

EVENT TYPE

EVENT TYPE

DWL_EXTRNL_ORG_TYP

EXTERNAL ORGANIZATION TYPE

EXTERNAL ORGANIZATION TYPE

DWL_FLD_ACTVTY_RSLT_TYP

FIELD ACTIVITY RESULT TYPE

FIELD ACTIVITY RESULT TYPE

DWL_FLD_ACTVTY_TYP

FIELD ACTIVITY TYPE

FIELD ACTIVITY TYPE

DWL_FLT_RSLTN_TYP

FAULT RESOLUTION TYPE

FAULT RESOLUTION TYPE

DWL_FLT_TYP

FAULT TYPE

FAULT TYPE

DWL_FRAUD_PRFL_CLASS

FRAUD PROFILE CLASS

FRAUD PROFILE CLASS

DWL_GIVE_AWAY_TYP

GIVE AWAY TYPE

GIVE AWAY TYPE

DWL_GNDR

GENDER

GENDER

DWL_INTRACN_DRCTN

INTERACTION DIRECTION

INTERACTION DIRECTION

DWL_INTRACN_RSLT_TYP

INTERACTION RESULT TYPE

INTERACTION RESULT TYPE

DWL_INTRACN_RSN

INTERACTION REASON

INTERACTION REASON

DWL_INTRACN_STAT

INTERACTION STATUS

INTERACTION STATUS

DWL_INTRACN_TYP

INTERACTION TYPE

INTERACTION TYPE

DWL_INTTV_RSLT_TYP

INITIATIVE RESULT TYPE

INITIATIVE RESULT TYPE

DWL_INTTV_TYP

INITIATIVE TYPE

INITIATIVE TYPE

DWL_INVC_ADJ_RSN

INVOICE ADJUSTMENT REASON

INVOICE ADJUSTMENT REASON

DWL_INVC_ADJ_TYP

INVOICE ADJUSTMENT TYPE

INVOICE ADJUSTMENT TYPE

DWL_INVC_DISC_RSN

INVOICE DISCOUNT REASON

INVOICE DISCOUNT REASON

DWL_INVC_DISC_TYP

INVOICE DISCOUNT TYPE

INVOICE DISCOUNT TYPE

DWL_INVC_DLVRY_TYP

INVOICE DELIVERY TYPE

INVOICE DELIVERY TYPE

DWL_INVC_ITEM_DTL_TYP

INVOICE ITEM DETAIL TYPE

INVOICE ITEM DETAIL TYPE

DWL_INVC_ITEM_TYP

INVOICE ITEM TYPE

INVOICE ITEM TYPE

DWL_INVC_PYMT_TERM_TYP

INVOICE PAYMENT TERM TYPE

INVOICE PAYMENT TERM TYPE

DWL_INVC_TYP

INVOICE TYPE

INVOICE TYPE

DWL_ISP_BSNS_TYP

ISP BUSINESS TYPE

ISP BUSINESS TYPE

DWL_ISP_TYP

ISP TYPE

ISP TYPE

DWL_ITEM_TYP

ITEM TYPE

ITEM TYPE

DWL_LANG

LANGUAGE

LANGUAGE

DWL_LEGAL_PRCS_STAT_TYP

LEGAL PROCESS STATUS TYPE

LEGAL PROCESS STATUS TYPE

DWL_LTTR_TYP

LETTER TYPE

LETTER TYPE

DWL_LYLTY_PROG_EVT_CTGRY

LOYALTY PROGRAM EVENT CATEGORY

LOYALTY PROGRAM EVENT CATEGORY

DWL_LYLTY_PROG_EVT_TYP

LOYALTY PROGRAM EVENT TYPE

LOYALTY PROGRAM EVENT TYPE

DWL_LYLTY_PROG_PRTY_RL

LOYALTY PROGRAM PARTY ROLE

LOYALTY PROGRAM PARTY ROLE

DWL_MDL_TYP

MODEL TYPE

MODEL TYPE

DWL_MEDIA_OBJ_TYP

MEDIA OBJECT TYPE

MEDIA OBJECT TYPE

DWL_MNG_ACTN_TYP

MANAGE ACTION TYPE

MANAGE ACTION TYPE

DWL_MRTL_STAT

MARITAL STATUS

MARITAL STATUS

DWL_NBR_NTWK_TYP

NUMBER NETWORK TYPE

NUMBER NETWORK TYPE

DWL_NP_RQST_LN_ITEM_STATE_TYP

NP REQUEST LINE ITEM STATE TYPE

NP REQUEST LINE ITEM STATE TYPE

DWL_NP_RQST_STATE_TYP

NP REQUEST STATE TYPE

NP REQUEST STATE TYPE

DWL_NP_RQST_TYP

NP REQUEST TYPE

NP REQUEST TYPE

DWL_NP_STEP

NP STEP

NP STEP

DWL_NTFCTN_TYP

NOTIFICATION TYPE

NOTIFICATION TYPE

DWL_NTNLTY

NATIONALITY

NATIONALITY

DWL_NTWK_EVT_STAT

NETWORK EVENT STATUS

NETWORK EVENT STATUS

DWL_NTWK_EVT_TYP

NETWORK EVENT TYPE

NETWORK EVENT TYPE

DWL_NTWK_TCHPNT_CLASS

NETWORK TOUCHPOINT CLASS

NETWORK TOUCHPOINT CLASS

DWL_NTWK_TCHPNT_STAT

NETWORK TOUCHPOINT STATUS

NETWORK TOUCHPOINT STATUS

DWL_NTWK_TCHPNT_TYP

NETWORK TOUCHPOINT TYPE

NETWORK TOUCHPOINT TYPE

DWL_NTWK_TYP

NETWORK TYPE

NETWORK TYPE

DWL_ONOFF_NET

ON OFF NET TYPE

ON OFF NET TYPE

DWL_OPRTR_GRP

OPERATOR GROUP

OPERATOR GROUP

DWL_OPRTR_TYP

OPERATOR TYPE

OPERATOR TYPE

DWL_ORDR_STAT

ORDER STATUS

ORDER STATUS

DWL_ORDR_TYP

ORDER TYPE

ORDER TYPE

DWL_ORG_BSNS_UNIT_TYP

ORGANIZATION BUSINESS UNIT TYPE

ORGANIZATION BUSINESS UNIT TYPE

DWL_PAY_CTGRY

PAY CATEGORY

PAY CATEGORY

DWL_PAY_TYP

PAY TYPE

PAY TYPE

DWL_PBLCTN_TYP

PUBLICATION TYPE

PUBLICATION TYPE

DWL_PCU_OUTAGE_RSN

PCU OUTAGE REASON

PCU OUTAGE REASON

DWL_PK_OFPK_TIME

PEAK OFFPEAK TIME

PEAK OFFPEAK TIME

DWL_POSTL_SRVC_TYP

POSTAL SERVICE TYPE

POSTAL SERVICE TYPE

DWL_PPA_CTGRY

PPA CATEGORY

PPA CATEGORY

DWL_PPA_DEDCTN_TYP

PPA DEDUCTION TYPE

PPA DEDUCTION TYPE

DWL_PRMTN_RSLT_TYP

PROMOTION RESULT TYPE

PROMOTION RESULT TYPE

DWL_PRMTN_TERM_TYP

PROMOTION TERM TYPE

PROMOTION TERM TYPE

DWL_PRMTN_TYP

PROMOTION TYPE

PROMOTION TYPE

DWL_PROD_ASGN_RSN

PRODUCT ASSIGNMENT REASON

PRODUCT ASSIGNMENT REASON

DWL_PROD_CAPBLTY_TYP

PRODUCT CAPABILITY TYPE

PRODUCT CAPABILITY TYPE

DWL_PROD_CHRG_TYP

PRODUCT CHARGE TYPE

PRODUCT CHARGE TYPE

DWL_PROD_CHRG_TYP_RLTN_RSN

PRODUCT CHARGE TYPE RLTN REASON

PRODUCT CHARGE TYPE RLTN REASON

DWL_PROD_CHRGNG_RSN

PRODUCT CHARGING REASON

PRODUCT CHARGING REASON

DWL_PROD_GRP

PRODUCT GROUP

PRODUCT GROUP

DWL_PROD_GRP_TYP

PRODUCT GROUP TYPE

PRODUCT GROUP TYPE

DWL_PROD_MGMT_RL

PRODUCT MANAGEMENT ROLE

PRODUCT MANAGEMENT ROLE

DWL_PROD_MGMT_RSN

PRODUCT MANAGEMENT REASON

PRODUCT MANAGEMENT REASON

DWL_PROD_MKT_PLN_ASGN_TYP

PRODUCT MARKET PLAN ASSIGNMENT TYPE

PRODUCT MARKET PLAN ASSIGNMENT TYPE

DWL_PROD_MKT_PLN_GRP_TYP

PRODUCT MARKET PLAN GROUP TYPE

PRODUCT MARKET PLAN GROUP TYPE

DWL_PROD_MKT_PLN_TYP

PRODUCT MARKET PLAN TYPE

PRODUCT MARKET PLAN TYPE

DWL_PROD_PKG_CHRG_TYP

PRODUCT PACKAGE CHARGE TYPE

PRODUCT PACKAGE CHARGE TYPE

DWL_PROD_RTNG_PLN_TYP

PRODUCT RATING PLAN TYPE

PRODUCT RATING PLAN TYPE

DWL_PROD_STAT_TYP

PRODUCT STATUS TYPE

PRODUCT STATUS TYPE

DWL_PROD_TYP

PRODUCT TYPE

PRODUCT TYPE

DWL_PRPD_MBL_EVT_TYP

PREPAID MOBILE EVENT TYPE

PREPAID MOBILE EVENT TYPE

DWL_PRTNR_STLMNT_RSN

PARTNER SETTLEMENT REASON

PARTNER SETTLEMENT REASON

DWL_PRTY_ACCT_ASGN_TYP

PARTY ACCOUNT ASSIGNMENT TYPE

PARTY ACCOUNT ASSIGNMENT TYPE

DWL_PRTY_ASGN_RSN

PARTY ASSIGNMENT REASON

PARTY ASSIGNMENT REASON

DWL_PRTY_ASGN_TYP

PARTY ASSIGNMENT TYPE

PARTY ASSIGNMENT TYPE

DWL_PRTY_CNCT_INFO_TYP

PARTY CONTACT INFORMATION TYPE

PARTY CONTACT INFORMATION TYPE

DWL_PRTY_CNCT_LST_PRTCPTN

PARTY CONTACT LIST PARTICIPATION

PARTY CONTACT LIST PARTICIPATION

DWL_PRTY_CNCT_LST_RL

PARTY CONTACT LIST ROLE

PARTY CONTACT LIST ROLE

DWL_PRTY_CNRT_ASGN_RL

PARTY CONTRACT ASSIGNMENT ROLE

PARTY CONTRACT ASSIGNMENT ROLE

DWL_PRTY_CNRT_ASGN_TYP

PARTY CONTRACT ASSIGNMENT TYPE

PARTY CONTRACT ASSIGNMENT TYPE

DWL_PRTY_EVT_TYP

PARTY EVENT TYPE

PARTY EVENT TYPE

DWL_PRTY_IDNT_TYP

PARTY IDENTIFICATION TYPE

PARTY IDENTIFICATION TYPE

DWL_PRTY_LOC_RSN

PARTY LOCATION REASON

PARTY LOCATION REASON

DWL_PRTY_MGMT_RL

PARTY MANAGEMENT ROLE

PARTY MANAGEMENT ROLE

DWL_PRTY_ORDR_ASGN_TYP

PARTY ORDER ASSIGNMENT TYPE

PARTY ORDER ASSIGNMENT TYPE

DWL_PRTY_RL

PARTY ROLE

PARTY ROLE

DWL_PRTY_SBRP_RL

PARTY SUBSCRIPTION ROLE

PARTY SUBSCRIPTION ROLE

DWL_PRTY_SGMNT_MTHD

PARTY SEGMENTATION METHOD

PARTY SEGMENTATION METHOD

DWL_PRTY_SIM_CARD_RL

PARTY SIM CARD ROLE

PARTY SIM CARD ROLE

DWL_PRTY_STAT_CHNG_RSN

PARTY STATUS CHANGE REASON

PARTY STATUS CHANGE REASON

DWL_PRTY_STAT_CTGRY

PARTY STATUS CATEGORY

PARTY STATUS CATEGORY

DWL_PRTY_STAT_TYP

PARTY STATUS TYPE

PARTY STATUS TYPE

DWL_PRTY_TYP

PARTY TYPE

PARTY TYPE

DWL_PYMT_MTHD_TYP

PAYMENT METHOD TYPE

PAYMENT METHOD TYPE

DWL_PYMT_TRX_TYP

PAYMENT TRANSACTION TYPE

PAYMENT TRANSACTION TYPE

DWL_RDMPTN_TYP

REDEMPTION TYPE

REDEMPTION TYPE

DWL_RECHRG_RVN_SLB

RECHARGE REVENUE SLAB

RECHARGE REVENUE SLAB

DWL_RMNG_TYP

ROAMING TYPE

ROAMING TYPE

DWL_RTNG_MTHD_TYP

RATING METHOD TYPE

RATING METHOD TYPE

DWL_SBRP_ASGN_TYP

SUBSCRIPTION ASSIGNMENT TYPE

SUBSCRIPTION ASSIGNMENT TYPE

DWL_SBRP_EVT_TYP

SUBSCRIPTION EVENT TYPE

SUBSCRIPTION EVENT TYPE

DWL_SBRP_STAT_CTGRY

SUBSCRIPTION STATUS CATEGORY

SUBSCRIPTION STATUS CATEGORY

DWL_SBRP_STAT_RSN

SUBSCRIPTION STATUS REASON

SUBSCRIPTION STATUS REASON

DWL_SBRP_STAT_TYP

SUBSCRIPTION STATUS

SUBSCRIPTION STATUS

DWL_SBRP_TERM_TYP

SUBSCRIPTION TERM TYPE

SUBSCRIPTION TERM TYPE

DWL_SBRP_TYP

SUBSCRIPTION TYPE

SUBSCRIPTION TYPE

DWL_SBSCRP_ACTVTN_RSN

SUBSCRIBER ACTIVATION REASON

SUBSCRIBER ACTIVATION REASON

DWL_SCRPT_QUES_TYP

SCRIPT QUESTION TYPE

SCRIPT QUESTION TYPE

DWL_SCRTY_REQD_TYP

SECURITY REQUIRED TYPE

SECURITY REQUIRED TYPE

DWL_SEASON

SEASON

SEASON

DWL_SGMNT_TYP

SEGMENT TYPE

SEGMENT TYPE

DWL_SIC_ASGN_RSN

SIC ASSIGNMENT REASON

SIC ASSIGNMENT REASON

DWL_SIC_CLSFCTN

SIC CLASSIFICATION

SIC CLASSIFICATION

DWL_SIC_INDSTRY_GRP

SIC INDUSTRY GROUP

SIC INDUSTRY GROUP

DWL_SIM_CARD_ACCS_MTHD_RSN

SIM CARD ACCESS METHOD REASON

SIM CARD ACCESS METHOD REASON

DWL_SIM_CARD_ACTVTN_RSN

SIM CARD ACTIVATION REASON

SIM CARD ACTIVATION REASON

DWL_SIM_CARD_ACTVTN_TYP

SIM CARD ACTIVATION TYPE

SIM CARD ACTIVATION TYPE

DWL_SIM_CARD_SBRP_RSN

SIM CARD SUBSCRIPTION REASON

SIM CARD SUBSCRIPTION REASON

DWL_SIM_CARD_TYP

SIM CARD TYPE

SIM CARD TYPE

DWL_SLNG_LOC_TYP

SELLING LOCATION TYPE

SELLING LOCATION TYPE

DWL_SRC_SYS_TYP

SOURCE SYSTEM TYPE

SOURCE SYSTEM TYPE

DWL_SRVC_CLASS

SERVICE CLASS

SERVICE CLASS

DWL_SRVC_CLASS_TYP

SERVICE CLASS TYPE

SERVICE CLASS TYPE

DWL_SRVC_COVRG_AREA_TYP

SERVICE COVERAGE AREA TYPE

SERVICE COVERAGE AREA TYPE

DWL_SUBSDY_TYP

SUBSIDY TYPE

SUBSIDY TYPE

DWL_SWTCH_CAPBLTY_TYP

SWITCH CAPABILITY TYPE

SWITCH CAPABILITY TYPE

DWL_SWTCH_TYP

SWITCH TYPE

SWITCH TYPE

DWL_TAX_EXMPT

TAX EXEMPT

TAX EXEMPT

DWL_TCH_TYP

TCH TYPE

TCH TYPE

DWL_TECH

TECHNOLOGY

TECHNOLOGY

DWL_TECH_TYP

TECHNOLOGY TYPE

TECHNOLOGY TYPE

DWL_TIME_BND

TIME BAND

TIME BAND

DWL_TIME_ZN

TIME ZONE

TIME ZONE

DWL_TRGT_TYP

TARGET TYPE

TARGET TYPE

DWL_UMS_ACCS_TYP

UMS ACCESS TYPE

UMS ACCESS TYPE

DWL_UMS_EVT_TYP

UMS EVENT TYPE

UMS EVENT TYPE

DWL_UOM

UNIT OF MEASURE

UNIT OF MEASURE

DWL_VAL_MSR

VALUE MEASURE

VALUE MEASURE

DWL_VAL_TYP

VALUE TYPE

VALUE TYPE

DWL_VNDR_CLASS

VENDOR CLASS

VENDOR CLASS

DWL_VNDR_RTNG_TYP

VENDOR RATING TYPE

VENDOR RATING TYPE

DWL_VNDR_SITE_TYP

VENDOR SITE TYPE

VENDOR SITE TYPE

DWL_VOL_BND

VOLUME BAND

VOLUME BAND

     

Base Tables

Table 4-4 briefly describes the Base tables in Oracle Communications Data Model.

Table 4-4 Base Tables

Table Name Description More Information

DWB_ACCS_MTHD_PORT_HIST

ACCESS METHOD PORTING HISTORY

ACCESS METHOD PORTING HISTORY

DWB_ACCS_MTHD_STAT_HIST

ACCESS METHOD STATUS HISTORY

ACCESS METHOD STATUS HISTORY

DWB_ACCT_ACCTNG_CYCL_HIST

ACCOUNT ACCOUNTING CYCLE HISTORY

ACCOUNT ACCOUNTING CYCLE HISTORY

DWB_ACCT_BAL_ADJ

ACCOUNT BALANCE ADJUSTMENT

ACCOUNT BALANCE ADJUSTMENT

DWB_ACCT_BAL_HIST

ACCOUNT BALANCE HISTORY

ACCOUNT BALANCE HISTORY

DWB_ACCT_COST

ACCOUNT COST

ACCOUNT COST

DWB_ACCT_CRDT_LMT

ACCOUNT CREDIT LIMIT

ACCOUNT CREDIT LIMIT

DWB_ACCT_DEBT_WRT_OFF

ACCOUNT DEBT WRITE OFF

ACCOUNT DEBT WRITE OFF

DWB_ACCT_MNGMNT_HIST

ACCOUNT MANAGEMENT HISTORY

ACCOUNT MANAGEMENT HISTORY

DWB_ACCT_PMP_PRTCPTN_HIST

ACCOUNT PMP PARTICIPATION HISTORY

ACCOUNT PMP PARTICIPATION HISTORY

DWB_ACCT_PYMT

ACCOUNT PAYMENT

ACCOUNT PAYMENT

DWB_ACCT_PYMT_MTHD_STAT

ACCOUNT PAYMENT METHOD STATUS

ACCOUNT PAYMENT METHOD STATUS

DWB_ACCT_RFND

ACCOUNT REFUND

ACCOUNT REFUND

DWB_ACCT_STAT_HIST

ACCOUNT STATUS HISTORY

ACCOUNT STATUS HISTORY

DWB_ADDR_STAT

ADDRESS STATUS

ADDRESS STATUS

DWB_APNMNT_CLNDR

APPOINTMENT CALENDAR

APPOINTMENT CALENDAR

DWB_BLK_LST_HIST

BLACK LIST HISTORY

BLACK LIST HISTORY

DWB_BRDBND_USG_EVT

BROADBAND USAGE EVENT

BROADBAND USAGE EVENT

DWB_BSNS_UNIT_COST

ORGANIZATION BUSINESS UNIT COST

ORGANIZATION BUSINESS UNIT COST

DWB_CARRIER_COST

COURIER COST

COURIER COST

DWB_CELL_SITE_COST

CELL SITE COST

CELL SITE COST

DWB_CHNL_COST

CHANNEL COST

CHANNEL COST

DWB_CMPGN_COST

CAMPAIGN COST

CAMPAIGN COST

DWB_CMPGN_MSG_CRTVE

CAMPAIGN MESSAGE CREATIVE

CAMPAIGN MESSAGE CREATIVE

DWB_CNCT_LST_COST

CONTACT LIST COST

CONTACT LIST COST

DWB_CNRT_APRVL

CONTRACT APPROVAL

CONTRACT APPROVAL

DWB_CNRT_STAT

CONTRACT STATUS

CONTRACT STATUS

DWB_CNRT_TERM_VAL

CONTRACT TERM VALUE

CONTRACT TERM VALUE

DWB_CNTNT_DLVRY_EVT

CONTENT DELIVERY EVENT

CONTENT DELIVERY EVENT

DWB_COST

COST

COST

DWB_COST_CNTR_BDGT

COST CENTER BUDGET

COST CENTER BUDGET

DWB_CRCUT_RNTL

CIRCUIT RENTAL

CIRCUIT RENTAL

DWB_CRCUT_TRFC

CIRCUIT TRAFFIC

CIRCUIT TRAFFIC

DWB_CRNCY_EXCHNG_RATE

CURRENCY EXCHANGE RATE

CURRENCY EXCHANGE RATE

DWB_CUST_COST

CUSTOMER COST

CUSTOMER COST

DWB_CUST_FLD_INSTLTN

CUSTOMER FIELD INSTALLATION

CUSTOMER FIELD INSTALLATION

DWB_CUST_FLD_SPPRT

CUSTOMER FIELD SUPPORT

CUSTOMER FIELD SUPPORT

DWB_CUST_FLD_SRVC_ACTVTY

CUSTOMER FIELD SERVICE ACTIVITY

CUSTOMER FIELD SERVICE ACTIVITY

DWB_CUST_FLD_SRVC_DTL

CUSTOMER FIELD SERVICE DETAIL

CUSTOMER FIELD SERVICE DETAIL

DWB_CUST_ORDR

CUSTOMER ORDER

CUSTOMER ORDER

DWB_CUST_ORDR_LN_ITEM

CUSTOMER ORDER LINE ITEM

CUSTOMER ORDER LINE ITEM

DWB_CUST_ORDR_LN_ITEM_ST_ASGN

CUSTOMER ORDER LINE ITEM STATE ASSIGN

CUSTOMER ORDER LINE ITEM STATE ASSIGN

DWB_CUST_ORDR_PYMT

CUSTOMER ORDER PAYMENT

CUSTOMER ORDER PAYMENT

DWB_CUST_ORDR_STATE_ASGN

CUSTOMER ORDER STATE ASSIGNMENT

CUSTOMER ORDER STATE ASSIGNMENT

DWB_DATA_SRVC_EVT

DATA SERVICE EVENT

DATA SERVICE EVENT

DWB_DEBT_COLLCTN

DEBT COLLECTION

DEBT COLLECTION

DWB_DEBT_COLLCTN_ASGN

DEBT COLLECTION ASSIGNMENT

DEBT COLLECTION ASSIGNMENT

DWB_DEBT_COLLCTN_ASGN_BTCH

DEBT COLLECTION ASSIGNMENT BATCH

DEBT COLLECTION ASSIGNMENT BATCH

DWB_EMP_ACT_LBR_HRLY

EMPLOYEE ACTUAL LABOR HOURLY

EMPLOYEE ACTUAL LABOR HOURLY

DWB_EMP_ACT_LBR_SALARIED

EMPLOYEE ACTUAL LABOR SALARIED

EMPLOYEE ACTUAL LABOR SALARIED

DWB_EMP_COST

EMPLOYEE COST

EMPLOYEE COST

DWB_EMP_TRNG_REC

EMPLOYEE TRAINING RECORD

EMPLOYEE TRAINING RECORD

DWB_EQPMNT_CNTR_COST

EQUIPMENT CENTER COST

EQUIPMENT CENTER COST

DWB_EQPMNT_INSTNC_STAT_HIST

EQUIPMENT INSTANCE STATUS HISTORY

EQUIPMENT INSTANCE STATUS HISTORY

DWB_EVT

EVENT

EVENT

DWB_EVT_ACCS_MTHD_ACTVTY

EVENT ACCESS METHOD ACTIVITY

EVENT ACCESS METHOD ACTIVITY

DWB_EVT_ACCT

EVENT ACCOUNT

EVENT ACCOUNT

DWB_EVT_ASGN

EVENT ASSIGNMENT

EVENT ASSIGNMENT

DWB_EVT_COST

EVENT COST

EVENT COST

DWB_EVT_CRCUT_RNTL

EVENT CIRCUIT RENTAL

EVENT CIRCUIT RENTAL

DWB_EVT_EMP_PYRL

EVENT EMPLOYEE PAYROLL

EVENT EMPLOYEE PAYROLL

DWB_EVT_EQPMNT_INSTNC

EVENT EQUIPMENT INSTANCE

EVENT EQUIPMENT INSTANCE

DWB_EVT_FINCL

EVENT FINANCIAL

EVENT FINANCIAL

DWB_EVT_GEO

EVENT GEOGRAPHY

EVENT GEOGRAPHY

DWB_EVT_GFT_RDMPTN

EVENT GIFT REDEMPTION

EVENT GIFT REDEMPTION

DWB_EVT_INVC_DLVRY

EVENT INVOICE DELIVERY

EVENT INVOICE DELIVERY

DWB_EVT_LYLTY_PROG

EVENT LOYALTY PROGRAM

EVENT LOYALTY PROGRAM

DWB_EVT_LYLTY_PROG_ACMLTN

EVENT LOYALTY PROGRAM ACCUMULATION

EVENT LOYALTY PROGRAM ACCUMULATION

DWB_EVT_LYLTY_PROG_RDMPTN

EVENT LOYALTY PROGRAM REDEMPTION

EVENT LOYALTY PROGRAM REDEMPTION

DWB_EVT_PROD_PKG

EVENT PRODUCT PACKAGE

EVENT PRODUCT PACKAGE

DWB_EVT_PRPD_MBL

EVENT PREPAID MOBILE

EVENT PREPAID MOBILE

DWB_EVT_PRTY_ASGN

EVENT PARTY ASSIGNMENT

EVENT PARTY ASSIGNMENT

DWB_EVT_PRTY_INTRACN

EVENT PARTY INTERACTION

EVENT PARTY INTERACTION

DWB_EVT_PRTY_INTRACN_CALL

EVENT PARTY INTERACTION CALL

EVENT PARTY INTERACTION CALL

DWB_EVT_PRTY_INTRACN_EML

EVENT PARTY INTERACTION EMAIL

EVENT PARTY INTERACTION EMAIL

DWB_EVT_PRTY_INTRACN_LTTR

EVENT PARTY INTERACTION LETTER

EVENT PARTY INTERACTION LETTER

DWB_EVT_PRTY_INTRACN_VST

EVENT PARTY INTERACTION VISIT

EVENT PARTY INTERACTION VISIT

DWB_EVT_PRTY_PRFL

EVENT PARTY PROFILE

EVENT PARTY PROFILE

DWB_EVT_SBRP

EVENT SUBSCRIPTION

EVENT SUBSCRIPTION

DWB_EVT_SBRP_CHNG

EVENT SUBSCRIPTION CHANGE

EVENT SUBSCRIPTION CHANGE

DWB_EVT_SIM_CARD

EVENT SIM CARD

EVENT SIM CARD

DWB_EVT_STAT

EVENT STATUS

EVENT STATUS

DWB_EVT_WEB_RGSTRN

EVENT WEB REGISTRATION

EVENT WEB REGISTRATION

DWB_FIXED_LN_CALL_EVT

FIXED LINE CALL EVENT

FIXED LINE CALL EVENT

DWB_IDD_CALL_EVT

IDD CALL EVENT

IDD CALL EVENT

DWB_INTRACN_ANSWR_CHOICE

INTERACTION ANSWER CHOICE

INTERACTION ANSWER CHOICE

DWB_INTRACN_QUES_RESPN

INTERACTION QUESTION RESPONSE

INTERACTION QUESTION RESPONSE

DWB_INTRNT_ACCS_EVT

INTERNET ACCESS EVENT

INTERNET ACCESS EVENT

DWB_INVC

INVOICE

INVOICE

DWB_INVC_ADJ

INVOICE ADJUSTMENT

INVOICE ADJUSTMENT

DWB_INVC_DISC

INVOICE DISCOUNT

INVOICE DISCOUNT

DWB_INVC_ITEM

INVOICE ITEM

INVOICE ITEM

DWB_INVC_ITEM_DTL

INVOICE ITEM DETAIL

INVOICE ITEM DETAIL

DWB_INVC_PYMT_ASGN

INVOICE PAYMENT ASSIGNMENT

INVOICE PAYMENT ASSIGNMENT

DWB_ISP_USG_EVT

ISP USAGE EVENT

ISP USAGE EVENT

DWB_LYLTY_PROG_PTS_BAL

LOYALTY PROGRAM POINTS BALANCE

LOYALTY PROGRAM POINTS BALANCE

DWB_MDTD_CALL_EVT

MEDIATED CALL EVENT

MEDIATED CALL EVENT

DWB_MEDIA_OBJ_COST

MEDIA OBJECT COST

MEDIA OBJECT COST

DWB_MKT_PLN_MGMT

MARKET PLAN MANAGEMENT

MARKET PLAN MANAGEMENT

DWB_MMS_EVT

MMS EVENT

MMS EVENT

DWB_MNT_ALLWNC

MINUTE ALLOWANCE

MINUTE ALLOWANCE

DWB_NP_RQST_HDR

NP REQUEST HEADER

NP REQUEST HEADER

DWB_NP_RQST_LN_ITEM

NP REQUEST LINE ITEM

NP REQUEST LINE ITEM

DWB_NP_RQST_LN_ITEM_STATE_HIST

NP REQUEST LINE ITEM STATE HISTORY

NP REQUEST LINE ITEM STATE HISTORY

DWB_NP_RQST_STATE_HIST

NP REQUEST STATE HISTORY

NP REQUEST STATE HISTORY

DWB_NTWK_ELMNT_COST

NETWORK ELEMENT COST

NETWORK ELEMENT COST

DWB_NTWK_EVT

NETWORK EVENT

NETWORK EVENT

DWB_NTWK_FLT

NETWORK FAULT

NETWORK FAULT

DWB_PRMTN_CLSTR_USG

PROMOTION CLUSTER USAGE

PROMOTION CLUSTER USAGE

DWB_PRMTN_CNCT_LST_UTLZTN

PROMOTION CONTACT LIST UTILIZATION

PROMOTION CONTACT LIST UTILIZATION

DWB_PRMTN_COST

PROMOTION COST

PROMOTION COST

DWB_PRMTN_MGMT_HIST

PROMOTION MANAGEMENT HISTORY

PROMOTION MANAGEMENT HISTORY

DWB_PRMTN_TERM_VAL

PROMOTION TERM VALUE

PROMOTION TERM VALUE

DWB_PROD_COST

PRODUCT COST

PRODUCT COST

DWB_PROD_MGMT_HIST

PRODUCT MANAGEMENT HISTORY

PRODUCT MANAGEMENT HISTORY

DWB_PROD_MKT_PLN_COST

PRODUCT MARKET PLAN COST

PRODUCT MARKET PLAN COST

DWB_PROD_STAT_HIST

PRODUCT STATUS HISTORY

PRODUCT STATUS HISTORY

DWB_PRPD_RCHRG

PREPAID RECHARGE

PREPAID RECHARGE

DWB_PRTY_AM_PMP_ASGN_HIST

PARTY AM PMP ASSIGNMENT HISTORY

PARTY AM PMP ASSIGNMENT HISTORY

DWB_PRTY_AM_PMP_ASGN_STAT

PARTY AM PMP ASSIGNMENT STATUS

PARTY AM PMP ASSIGNMENT STATUS

DWB_PRTY_COST_ASGN

PARTY COST ASSIGNMENT

PARTY COST ASSIGNMENT

DWB_PRTY_INTRACN_THRD

PARTY INTERACTION THREAD

PARTY INTERACTION THREAD

DWB_PRTY_ORDR_ASGN

PARTY ORDER ASSIGNMENT

PARTY ORDER ASSIGNMENT

DWB_PRTY_PRMTN_RESPN

PARTY PROMOTION RESPONSE

PARTY PROMOTION RESPONSE

DWB_PRTY_STAT_HIST

PARTY STATUS HISTORY

PARTY STATUS HISTORY

DWB_PTV_FULL_CHNL_ACTVTN

PTV FULL CHANNEL ACTIVATION

PTV FULL CHANNEL ACTIVATION

DWB_PTV_QPI_SRVC_EVT

PTV QPI SERVICE EVENT

PTV QPI SERVICE EVENT

DWB_PTV_USG_EVT

PTV USAGE EVENT

PTV USAGE EVENT

DWB_SBRP_STAT_HIST

SUBSCRIPTION STATUS HISTORY

SUBSCRIPTION STATUS HISTORY

DWB_SBRP_TERM_VAL

SUBSCRIPTION TERM VALUE

SUBSCRIPTION TERM VALUE

DWB_SL_CMISN_DTL

SALES COMMISSION DETAIL

SALES COMMISSION DETAIL

DWB_SL_CMISN_PYRL

SALES COMMISSION PAYROLL

SALES COMMISSION PAYROLL

DWB_SMS_EVT

SMS EVENT

SMS EVENT

DWB_SRVC_RQST

SERVICE REQUEST

SERVICE REQUEST

DWB_UMS_EVT

UMS EVENT

UMS EVENT

DWB_VNDR_APNMNT

VENDOR APPOINTMENT

VENDOR APPOINTMENT

DWB_VOIP_CALL_EVT

VOIP CALL EVENT

VOIP CALL EVENT

DWB_WRLS_CALL_EVT

WIRELESS CALL EVENT

WIRELESS CALL EVENT

DWB_WRLS_CNTNT_DNLDG_EVT

WIRELESS CONTENT DOWNLOADING EVENT

WIRELESS CONTENT DOWNLOADING EVENT

     

Derived Tables

Table 4-5 briefly describes the Derived tables in Oracle Communications Data Model.

Table 4-5 Derived Tables

Table Name Description More Information

DWD_ACCT_DEBT_DAY

ACCOUNT DEBT DAY DRVD

ACCOUNT DEBT DAY DRVD

DWD_ACCT_PYMT_DAY

ACCOUNT PAYMENT DAY DRVD

ACCOUNT PAYMENT DAY DRVD

DWD_ACCT_PYMT_MTHD_STAT_HIST

ACCOUNT PAYMENT METHOD STATUS HIST DRVD

ACCOUNT PAYMENT METHOD STATUS HIST DRVD

DWD_ACCT_RFND_DAY

ACCOUNT REFUND DAY DRVD

ACCOUNT REFUND DAY DRVD

DWD_ACCT_STAT

ACCOUNT STATUS DRVD

ACCOUNT STATUS DRVD

DWD_ACCT_STTSTC

ACCOUNT STATISTIC DRVD

ACCOUNT STATISTIC DRVD

DWD_ARPU_BASE

ARPU BASE DRVD

ARPU BASE DRVD

DWD_BER_FER_ERR_RATIO_DAY

BER FER ERROR RATIO DAY DRVD

BER FER ERROR RATIO DAY DRVD

DWD_CALL_CNTR_CALL_DAY

CALL CENTER CALL DAY DRVD

CALL CENTER CALL DAY DRVD

DWD_CALL_CNTR_CASE_DAY

CALL CENTER CASE DAY DRVD

CALL CENTER CASE DAY DRVD

DWD_CANBLZTN_DTL_DAY

CANNIBALIZATION DETAIL DAY DRVD

CANNIBALIZATION DETAIL DAY DRVD

DWD_CELL_STTSTC_DAY

CELL STATISTIC DAY DRVD

CELL STATISTIC DAY DRVD

DWD_CHRN_PRDCT_SRC

CHURN PREDICT SOURCE DERIVED

CHURN PREDICT SOURCE DERIVED

DWD_CMISN_DAY

COMMISSION DAY DRVD

COMMISSION DAY DRVD

DWD_CNCT_DSCNCT_DAY

CONNECT DISCONNECT DAY DRVD

CONNECT DISCONNECT DAY DRVD

DWD_CNRT

CONTRACT DRVD

CONTRACT DRVD

DWD_CNRT_CHNG

CONTRACT CHANGED DRVD

CONTRACT CHANGED DRVD

DWD_COST_CUST

COST CUSTOMER DRVD

COST CUSTOMER DRVD

DWD_COST_ORG

COST ORGANIZATIONAL DRVD

COST ORGANIZATIONAL DRVD

DWD_CRDT_CTGRY

CREDIT CATEGORY DRVD

CREDIT CATEGORY DRVD

DWD_CUST_ACQSTN_SUMM_DAY

CUSTOMER ACQUISITION SUMMARY DAY DRVD

CUSTOMER ACQUISITION SUMMARY DAY DRVD

DWD_CUST_DEBT_COLLCTN

CUSTOMER DEBT COLLECTION DRVD

CUSTOMER DEBT COLLECTION DRVD

DWD_CUST_EQPMNT_INSTLTN_DAY

CUSTOMER EQUIPMENT INSTALLATION DAY DRVD

CUSTOMER EQUIPMENT INSTALLATION DAY DRVD

DWD_DATA_USG_DAY

DATA USAGE DAY DRVD

DATA USAGE DAY DRVD

DWD_EXTRNL_DEBT_COLLCTN_DAY

EXTERNAL DEBT COLLECTION DAY DRVD

EXTERNAL DEBT COLLECTION DAY DRVD

DWD_GIVE_AWAY_ITEM_DAY

GIVE AWAY ITEM DAY DRVD

GIVE AWAY ITEM DAY DRVD

DWD_GPRS_PCU_DAY

GPRS PCU DAY DRVD

GPRS PCU DAY DRVD

DWD_GPRS_SRVCS_DAY

GPRS SERVICES DAY DRVD

GPRS SERVICES DAY DRVD

DWD_HNDST_STCK_DAY

HANDSET STOCK DAY DRVD

HANDSET STOCK DAY DRVD

DWD_HNDST_SUBSDY_DAY

HANDSET SUBSIDY DAY DRVD

HANDSET SUBSIDY DAY DRVD

DWD_IN_PLTFRM_DAY

IN PLATFORM DAY DRVD

IN PLATFORM DAY DRVD

DWD_INTRNL_DEBT_COLLCTN_DAY

INTERNAL DEBT COLLECTION DAY DRVD

INTERNAL DEBT COLLECTION DAY DRVD

DWD_INVC

INVOICE DRVD

INVOICE DRVD

DWD_INVC_ADJ

INVOICE ADJUSTMENT DRVD

INVOICE ADJUSTMENT DRVD

DWD_LN_ACTVTN_TMNT_DAY

LINE ACTIVATION TERMINATION DAY DRVD

LINE ACTIVATION TERMINATION DAY DRVD

DWD_LYLTY_PROG_DAY

LOYALTY PROGRAM DAY DRVD

LOYALTY PROGRAM DAY DRVD

DWD_MKT_SHARE

MARKET SHARE DRVD

MARKET SHARE MONTH DRVD

DWD_MSC_TRFC_DAY

MSC TRAFFIC DAY DRVD

MSC TRAFFIC DAY DRVD

DWD_NBR_PRT_DAY

NUMBER PORT DAY DRVD

NUMBER PORT DAY DRVD

DWD_NTWK_AVLBLTY_DAY

NETWORK AVAILABILITY DAY DRVD

NETWORK AVAILABILITY DAY DRVD

DWD_NTWK_TCHPNT

NETWORK TOUCHPOINT DRVD

NETWORK TOUCHPOINT DRVD

DWD_MKT_OPRTR_PRTNG

MARKET OPERATOR PORTING DERIVED

MARKET OPERATOR PORTING DERIVED

DWD_PRPD_ACCT_STTSTC

PREPAID ACCOUNT STATISTIC DRVD

PREPAID ACCOUNT STATISTIC DRVD

DWD_PRPD_ALWNCE_DAY

PREPAID ALLOWANCE DAY DRVD

PREPAID ALLOWANCE DAY DRVD

DWD_PRPD_CALL_SUMM_DAY

PREPAID CALL SUMMARY DAY DRVD

PREPAID CALL SUMMARY DAY DRVD

DWD_PRTNR_STLMNT

PARTNER SETTLEMENT DRVD

PARTNER SETTLEMENT DRVD

DWD_PYMT_AGNG_DAY

PAYMENT AGING DAY DRVD

PAYMENT AGING DAY DRVD

DWD_RDMPTN_DAY

REDEMPTION DAY DRVD

REDEMPTION DAY DRVD

DWD_RF_NTWK_CPCTY_DAY

RF NETWORK CAPACITY DAY DRVD

RF NETWORK CAPACITY DAY DRVD

DWD_SBCRBR_CHRN_STTSTC

SUBSCRIBER CHURN STATISTIC DRVD

SUBSCRIBER CHURN STATISTIC MONTH DRVD

DWD_SHRD_PKG_USG_STSC_DAY

SHARED PACKAGE USAGE STATISTICS DAY DRVD

SHARED PACKAGE USAGE STATISTICS DAY DRVD

DWD_SHOP_EFFNCY_DAY

SHOP EFFICIENCY DAY DRVD

SHOP EFFICIENCY DAY DRVD

DWD_SL_CMPGN_SUMM_DAY

SALES CAMPAIGN SUMMARY DAY DRVD

SALES CAMPAIGN SUMMARY DAY DRVD

DWD_SL_DAY

SALES DAY DRVD

SALES DAY DRVD

DWD_SL_RPRSTV_STTSTC

SALES REPRESENTATIVE STATISTICS DRVD

SALES REPRESENTATIVE STATISTICS DRVD

DWD_SPLMNTR_SRVC_USG

SUPPLEMENTARY SERVICE USAGE DRVD

SUPPLEMENTARY SERVICE USAGE MONTH DRVD

DWD_SUBSDY_AMT

SUBSIDY AMOUNT DRVD

SUBSIDY AMOUNT DRVD

DWD_VAS_SBRP_QCK_SUMM

VAS SUBSCRIPTION QUICK SUMMARY DRVD

VAS SUBSCRIPTION QUICK SUMMARY DRVD

DWD_VAS_USG_DAY

VAS USAGE DAY DRVD

VAS USAGE DAY DRVD

DWD_VOI_CALL_DAY

VOICE CALL DAY DRVD

VOICE CALL DAY DRVD


Aggregate Tables

Table 4-6 briefly describes the Aggregate tables in Oracle Communications Data Model.

Table 4-6 Aggregate Tables

Table Name Description More Information

DWA_ACCT_DEBT_MO

ACCOUNT DEBT MONTH AGGR

ACCOUNT DEBT MONTH AGGR

DWA_ACCT_PYMT_MO

ACCOUNT PAYMENT MONTH AGGR

ACCOUNT PAYMENT MONTH AGGR

DWA_ACCT_PYMT_MTHD_STAT_HIST

ACCOUNT PAYMENT METHOD STATUS HIST AGGR

ACCOUNT PAYMENT METHOD STATUS HIST AGGR

DWA_ACCT_RFND_MO

ACCOUNT REFUND MONTH AGGR

ACCOUNT REFUND MONTH AGGR

DWA_ACCT_STAT_TYP

ACCOUNT STATUS TYPE AGGR

ACCOUNT STATUS TYPE AGGR

DWA_ACCT_STTSTC_TYP

ACCOUNT STATISTIC TYPE AGGR

ACCOUNT STATISTIC TYPE AGGR

DWA_ARPU_BASE_CUST_TYP

ARPU BASE CUSTOMER TYPE AGGR

ARPU BASE CUSTOMER TYPE AGGR

DWA_BER_FER_ERR_RATIO_MO

BER FER ERROR RATIO MONTH AGGR

BER FER ERROR RATIO MONTH AGGR

DWA_CALL_CNTR_CALL_MO

CALL CENTER CALL MONTH AGGR

CALL CENTER CALL MONTH AGGR

DWA_CALL_CNTR_CASE_MO

CALL CENTER CASE MONTH AGGR

CALL CENTER CASE MONTH AGGR

DWA_CANBLZTN_DTL_MO

CANNIBALIZATION DETAIL MONTH AGGR

CANNIBALIZATION DETAIL MONTH AGGR

DWA_CELL_STTSTC_MO

CELL STATISTIC MONTH AGGR

CELL STATISTIC MONTH AGGR

DWA_CMISN_MO

COMMISSION MONTH AGGR

COMMISSION MONTH AGGR

DWA_CNCT_DSCNCT_MO

CONNECT DISCONNECT MONTH AGGR

CONNECT DISCONNECT MONTH AGGR

DWA_CNRT_MO

CONTRACT MONTH AGGR

CONTRACT MONTH AGGR

DWA_COST_CUST_MO

COST CUSTOMER MONTH AGGR

COST CUSTOMER MONTH AGGR

DWA_COST_ORG_MO

COST ORGANIZATIONAL MONTH AGGR

COST ORGANIZATIONAL DRVD

DWA_CRDT_CTGRY_MO

CREDIT CATEGORY MONTH AGGR

CREDIT CATEGORY MONTH AGGR

DWA_CUST_ACQSTN_SUMM_MO

CUSTOMER ACQUISITION SUMMARY MONTH AGGR

CUSTOMER ACQUISITION SUMMARY MONTH AGGR

DWA_CUST_DEBT_COLLCTN_MO

CUSTOMER DEBT COLLECTION MONTH AGGR

CUSTOMER DEBT COLLECTION MONTH AGGR

DWA_CUST_EQPMNT_INSTLTN_MO

CUSTOMER EQUIPMENT INSTALLATION MO AGGR

CUSTOMER EQUIPMENT INSTALLATION MO AGGR

DWA_DATA_USG_MO

DATA USAGE MONTH AGGR

DATA USAGE MONTH AGGR

DWA_EXTRNL_DEBT_COLLCTN_MO

EXTERNAL DEBT COLLECTION MONTH AGGR

EXTERNAL DEBT COLLECTION MONTH AGGR

DWA_GIVE_AWAY_ITEM_MO

GIVE AWAY ITEM MONTH AGGR

GIVE AWAY ITEM MONTH AGGR

DWA_GPRS_PCU_MO

GPRS PCU MONTH AGGR

GPRS PCU MONTH AGGR

DWA_GPRS_SRVCS_MO

GPRS SERVICES MONTH AGGR

GPRS SERVICES MONTH AGGR

DWA_HNDST_STCK_MO

HANDSET STOCK MO AGGR

HANDSET STOCK MO AGGR

DWA_HNDST_SUBSDY_MO

HANDSET SUBSIDY MONTH AGGR

HANDSET SUBSIDY MONTH AGGR

DWA_IN_PLTFRM_MO

IN PLATFORM MONTH AGGR

IN PLATFORM MONTH AGGR

DWA_INTRNL_DEBT_COLLCTN_MO

INTERNAL DEBT COLLECTION MONTH AGGR

INTERNAL DEBT COLLECTION MONTH AGGR

DWA_INVC_ADJ_MO

INVOICE ADJUSTMENT MONTH AGGR

INVOICE ADJUSTMENT MONTH AGGR

DWA_INVC_CUST_TYP

INVOICE CUSTOMER TYPE AGGR

INVOICE CUSTOMER TYPE AGGR

DWA_LN_ACTVTN_TMNT_MO

LINE ACTIVATION TERMINATION MONTH AGGR

LINE ACTIVATION TERMINATION MONTH AGGR

DWA_LYLTY_PROG_MO

LOYALTY PROGRAM MO AGGR

LOYALTY PROGRAM MO AGGR

DWA_MKT_SHARE

MARKET SHARE AGGR

MARKET SHARE MONTH AGGR

DWA_MSC_TRFC_MO

MSC TRAFFIC MONTH AGGR

MSC TRAFFIC MONTH AGGR

DWA_NBR_PRT_MO

NUMBER PORT MONTH AGGR

NUMBER PORT MONTH AGGR

DWA_NTWK_AVLBLTY_MO

NETWORK AVAILABILITY MONTH AGGR

NETWORK AVAILABILITY MONTH AGGR

DWA_NTWK_TCHPNT_MO

NETWORK TOUCHPOINT MONTH AGGR

NETWORK TOUCHPOINT MONTH AGGR

DWA_PRPD_ACCT_STTSTC_SGMNT

PREPAID ACCOUNT STATISTIC SEGMENT AGGR

PREPAID ACCOUNT STATISTIC SEGMENT AGGR

DWA_PRPD_ALWNCE_MO

PREPAID ALLOWANCE MONTH AGGR

PREPAID ALLOWANCE MONTH AGGR

DWA_PRPD_CALL_SUMM_MO

PREPAID CALL SUMMARY MONTH AGGR

PREPAID CALL SUMMARY MONTH AGGR

DWA_PRTNR_STLMNT_MO

PARTNER SETTLEMENT MONTH AGGR

PARTNER SETTLEMENT MONTH AGGR

DWA_PYMT_AGNG_MO

PAYMENT AGING MONTH AGGR

PAYMENT AGING MONTH AGGR

DWA_RDMPTN_MO

REDEMPTION MO AGGR

REDEMPTION MO AGGR

DWA_RF_NTWK_CPCTY_MO

RF NETWORK CAPACITY MONTH AGGR

RF NETWORK CAPACITY MONTH AGGR

DWA_SBCRBR_CHRN_STTSTC_MO

SUBSCRIBER CHURN STATISTIC MONTH AGGR

SUBSCRIBER CHURN STATISTIC MONTH AGGR

DWA_SHARED_PKG_USG_STTSTC_MO

SHARED PACKAGE USAGE STATISTICS MO AGGR

SHARED PACKAGE USAGE STATISTICS MO AGGR

DWA_SHOP_EFFNCY_MO

SHOP EFFICIENCY MONTH AGGR

SHOP EFFICIENCY MONTH AGGR

DWA_SL_CMPGN_SUMM_MO

SALES CAMPAIGN SUMMARY MONTH AGGR

SALES CAMPAIGN SUMMARY MONTH AGGR

DWA_SL_MO

SALES MONTH AGGR

SALES MONTH AGGR

DWA_SPLMNTR_SRVC_USG_MO

SUPPLEMENTARY SERVICE USAGE MONTH AGGR

SUPPLEMENTARY SERVICE USAGE MONTH AGGR

DWA_SUBSDY_AMT_MO

SUBSIDY AMOUNT MONTH AGGR

SUBSIDY AMOUNT MONTH AGGR

DWA_VAS_SBRP_QCK_SUMM_MO

VAS SUBSCRIPTION QUICK SUMMARY MO AGGR

VAS SUBSCRIPTION QUICK SUMMARY MO AGGR

DWA_VAS_USG_MO

VAS USAGE MONTH AGGR

VAS USAGE MONTH AGGR

DWA_VOI_CALL_MO

VOICE CALL MONTH AGGR

VOICE CALL MONTH AGGR


Database Sequences

Table 4-7 lists the Sequence Names in Oracle Communications Data Model.

Table 4-7 Database Sequences

Sequence Name Generates the Physical Key for This Table

AM_SEQ

DWR_ACCS_MTHD

AME1_SEQ

DWR_ACCS_MTHD_ELMNT

AMP_SEQ

DWR_ACCS_MTHD_POOL

AMS_SEQ

DWR_ACCS_MTHD_SGMNT

ACCE_SEQ

DWR_ACCSRS

ACCT_SEQ

DWR_ACCT

ABCH_SEQ

DWR_ACCT_BLLG_CYCL_HIST

ABFH_SEQ

DWR_ACCT_BLLG_FRQNCY_HIST

ABPH_SEQ

DWR_ACCT_BLLG_PRD_HIST

APP_SEQ

DWR_ACCT_PREF_PYMT_MTHD

APH1_SEQ

DWR_ACCT_PRFL

ACCT_SEG_SEQ

DWR_ACCT_SGMNT

CSM_2_SEQ

DWR_ACCT_SGMNT_MDL

AL1_SEQ

DWR_ADDR_LOC

AR_1_SEQ

DWR_ADDR_RLTD

AT2_SEQ

DWR_ADTNL_TXT

AP_SEQ

DWR_ADVR_PRD

AQ_SEQ

DWR_ADVR_QTR

AW_SEQ

DWR_ADVR_WK

AY_SEQ

DWR_ADVR_YR

ANZSIC_SEQ

DWR_ANZSIC_CLSFCTN

BTS_SEQ

DWR_BASE_TRNSCVR_STN

BAN1_SEQ

DWR_BNK

BDDC_SEQ

DWR_BNK_DRCT_DEBT_CHNL

BRA_SEQ

DWR_BRND

BHM_SEQ

DWR_BSNS_HLF_MO

BHY_SEQ

DWR_BSNS_HLF_YR

BM_SEQ

DWR_BSNS_MO

BQ_SEQ

DWR_BSNS_QTR

BUS_SEQ

DWR_BSNS_UNIT_SHFT

BW_SEQ

DWR_BSNS_WK

BY1_SEQ

DWR_BSNS_YR

CC3_SEQ

DWR_CALL_CNTR

CCA_SEQ

DWR_CALL_CNTR_AGNT

CCSC_SEQ

DWR_CALL_CNTR_SRVC_CAPBLTY

CD3_SEQ

DWR_CALL_SRC_DSTN

CEL_SEQ

DWR_CELL

CS1_SEQ

DWR_CELL_SCTR

CS2_SEQ

DWR_CELL_SITE

CHNL_SEQ

DWR_CHNL

CHM_SEQ

DWR_CLNDR_HLF_MO

CHY_SEQ

DWR_CLNDR_HLF_YR

CM_SEQ

DWR_CLNDR_MO

CQ_SEQ

DWR_CLNDR_QTR

CW_SEQ

DWR_CLNDR_WK

CY_SEQ

DWR_CLNDR_YR

CAM_SEQ

DWR_CMPGN

RCC_SEQ

DWR_CMPGN_CHNL

RCM_SEQ

DWR_CMPGN_MSG

CMD_SEQ

DWR_CMPGN_MSG_DPCT

CL_SEQ

DWR_CNCT_LST

CON_SEQ

DWR_CNRT

CD_SEQ

DWR_CNRT_DOC

CNTNT_SEQ

DWR_CNTNT

CP1_SEQ

DWR_CNTNT_PRICE

CP_SEQ

DWR_CNTNT_PRVDR

CAP_SEQ

DWR_COLLCTN_AGNCY

CC1_SEQ

DWR_COST_CNTR

CC_SEQ

DWR_CRCUT_CMPNT

DLCC_SEQ

DWR_CRDT_CTGRY

CGER_SEQ

DWR_CRNCY_GEO_ENT_ASGN

CI_SEQ

DWR_CUST

CCAI_SEQ

DWR_CUST_CLASS_ASGN

CO2_SEQ

DWR_CUST_OCCSN

CRI_1_SEQ

DWR_CUST_RSTRCT_INFO

DLCS_SEQ

DWR_CUST_SCR

SEG_SEQ

DWR_CUST_SGMNT

CSM_SEQ

DWR_CUST_SGMNT_MDL

CSIC_SEQ

DWR_CUST_SIC_ASGN

CS5_SEQ

DWR_CUST_SRC

DAY_SEQ

DWR_DAY

DAC_SEQ

DWR_DAY_ACT_CONDITION

DTT_SEQ

DWR_DAY_TODATE_TRANS

DTRAN_SEQ

DWR_DAY_TRANS

DEA2_SEQ

DWR_DEAL

DA_SEQ

DWR_DEMOG_ATRIB

DG_SEQ

DWR_DEMOG_GRP

XEDG_SEQ

DWR_DISC_GRP

DEA1_SEQ

DWR_DLR

DDGA_SEQ

DWR_DLR_DISC_GRP_ASGN

DV_SEQ

DWR_DRVD_VAL

EMP_SEQ

DWR_EMP

ELC_SEQ

DWR_EMP_LANG_CAPBLTY

CRI_SEQ

DWR_EMP_RSTRCT_INFO

EQU_SEQ

DWR_EQPMNT

EC2_SEQ

DWR_EQPMNT_CNTR

EF_SEQ

DWR_EQPMNT_FNCTNLTY

EI_SEQ

DWR_EQPMNT_INSTNC

EISH_SEQ

DWR_EQPMNT_INSTNC_RENTING_CNRT

EPR_SEQ

DWR_EVT_PRTY_RL

ER2_SEQ

DWR_EVT_RSLTN

EIS_SEQ

DWR_EXTRNL_INFO_SRC

PEO_SEQ

DWR_EXTRNL_OPRTR

FC_SEQ

DWR_FCTR_CMPNY

FHM_SEQ

DWR_FSCL_HLF_MO

FHY_SEQ

DWR_FSCL_HLF_YR

FM_SEQ

DWR_FSCL_MO

FQ_SEQ

DWR_FSCL_QTR

FW_SEQ

DWR_FSCL_WK

FY_SEQ

DWR_FSCL_YR

GC1_SEQ

DWR_GEO_CITY

GC_SEQ

DWR_GEO_CNTRY

GEOC_SEQ

DWR_GEO_CNTY

GDA_SEQ

DWR_GEO_DEMOG_ATRIB

GDG_SEQ

DWR_GEO_DEMOG_GRP

GDV_SEQ

DWR_GEO_DEMOG_VAL

GE_1_SEQ

DWR_GEO_ENT

GH_SEQ

DWR_GEO_HRCHY

GHL_SEQ

DWR_GEO_HRCHY_LVL

GL_SEQ

DWR_GEO_LVL

GLATTR_SEQ

DWR_GEO_LVL_ATRIB

GLA_SEQ

DWR_GEO_LVL_ATRIB_VAL

GR_1_SEQ

DWR_GEO_RGN

GSR_SEQ

DWR_GEO_SBRGN

GS_1_SEQ

DWR_GEO_STATE

GW_SEQ

DWR_GEO_WORLD

GR_SEQ

DWR_GL_REF

GS_SEQ

DWR_GPRS_SRVC

HOU1_SEQ

DWR_HH

HH_SEQ

DWR_HLF_HR

HMTT_SEQ

DWR_HLF_MO_TODATE_TRANS

HMT_SEQ

DWR_HLF_MO_TRANS

HYT_SEQ

DWR_HLF_YR_TRANS

HAN_SEQ

DWR_HNDST_INSTNC

HM_SEQ

DWR_HNDST_MDL

HOU_SEQ

DWR_HR

DRIP_SEQ

DWR_IN_PLTFRM

IDV_1_SEQ

DWR_INDVL_DEMOG_VAL

IC_SEQ

DWR_INTRACN_CHNL

IPT_SEQ

DWR_INVC_PYMT_TRM

ISP_SEQ

DWR_ISP

IBT_SEQ

DWR_ISP_BSNS

IU_SEQ

DWR_ISP_USER

ITE_SEQ

DWR_ITEM

DLJ_SEQ

DWR_JB

JR_SEQ

DWR_JB_RL

LP_SEQ

DWR_LYLTY_PROG

LPC_SEQ

DWR_LYLTY_PROG_CHNL

MAI_SEQ

DWR_MAILBOX

MSC_SEQ

DWR_MBL_SWTCHNG_CNTR

MO_SEQ

DWR_MEDIA_OBJ

OMA_SEQ

DWR_MKT_AREA

OMAL_SEQ

DWR_MKT_AREA_LVL

MPTV_SEQ

DWR_MKT_PLN_TERM_VAL

MIN_SEQ

DWR_MNT

MTT_SEQ

DWR_MO_TODATE_TRANS

MT1_SEQ

DWR_MO_TRANS

NAIC_SEQ

DWR_NAICS_CLSFCTN

NI_SEQ

DWR_NAICS_INDSTRY

NIG_SEQ

DWR_NAICS_INDSTRY_GRP

IS3_SEQ

DWR_NAICS_INDSTRY_SCTR

NIS_SEQ

DWR_NAICS_INDSTRY_SUBSCTR

DAX_SEQ

DWR_NBR_AREA

DCC1_SEQ

DWR_NBR_CNTRY

NMM_SEQ

DWR_NP_MBL_MSISDN

NET1_SEQ

DWR_NTWK

DWNE_SEQ

DWR_NTWK_ELMNT

NTP_SEQ

DWR_NTWK_TCHPNT

OLIS_SEQ

DWR_ORDR_LN_ITEM_STATE

ARE_SEQ

DWR_ORG_AREA

BAN_SEQ

DWR_ORG_BNR

OBE_SEQ

DWR_ORG_BSNS_ENT

DOBU_SEQ

DWR_ORG_BSNS_UNIT

CHA_1_SEQ

DWR_ORG_CHAIN

COM_SEQ

DWR_ORG_CMPNY

COR_SEQ

DWR_ORG_CRPRT

DIV_SEQ

DWR_ORG_DIV

DOD_SEQ

DWR_ORG_DSTRCT

OH_SEQ

DWR_ORG_HRCHY

OHL_SEQ

DWR_ORG_HRCHY_LVL

OHLA_SEQ

DWR_ORG_HRCHY_LVL_ASGN

OHV_SEQ

DWR_ORG_HRCHY_VRSN

OL_SEQ

DWR_ORG_LVL

OBEA_SEQ

DWR_ORG_LVL_ATRIB_VAL

OLA_SEQ

DWR_ORG_LVL_ATTR

REG_SEQ

DWR_ORG_RGN

OW_SEQ

DWR_ORG_WRHS

OI_SEQ

DWR_OTHR_INDVL

PTV_SEQ

DWR_PAY_TV

PUB_SEQ

DWR_PBLCTN

PP4_SEQ

DWR_PLNG_PRD

PQ1_SEQ

DWR_PLNG_QTR

PS1_SEQ

DWR_PLNG_SEASON

PW_1_SEQ

DWR_PLNG_WK

ADV_SEQ

DWR_PLNG_YR

POS_SEQ

DWR_POSTCD

PDR_SEQ

DWR_PRICE_DRVTN_RULE

P_SEQ

DWR_PRMTN

PRO_SEQ

DWR_PROD

PAT_SEQ

DWR_PROD_ADTNL_TXT

PC_SEQ

DWR_PROD_CAPBLTY

EF1_SEQ

DWR_PROD_FTR

PGR_SEQ

DWR_PROD_GRP_ASGN

PI3_SEQ

DWR_PROD_INSTNC

PMP_SEQ

DWR_PROD_MKT_PLN

PMPG_SEQ

DWR_PROD_MKT_PLN_GRP

PPACK_SEQ

DWR_PROD_PKG

CPP_SEQ

DWR_PROD_RTNG_PLN

CRPD_SEQ

DWR_PROD_RTNG_PLN_DTL

PV_SEQ

DWR_PROD_VRSN

PMV_SEQ

DWR_PRPD_MBL_VCHR

PRO1_SEQ

DWR_PRSPCT

PPP_SEQ

DWR_PRTNR_PRMTN_PROG

PAR_SEQ

DWR_PRTY

PCI_SEQ

DWR_PRTY_CNCT_INFO

PI_SEQ

DWR_PRTY_ID

PLPP_SEQ

DWR_PRTY_LYLTY_PROG_PRTCPTN

PRR_SEQ

DWR_PRTY_RL_ASGN

PRSH_SEQ

DWR_PRTY_RL_STAT

PSCH_SEQ

DWR_PRTY_SIM_CARD_ASGN

PC2_SEQ

DWR_PYMT_CHNL

QUA_SEQ

DWR_QTR_HR

QTDT_SEQ

DWR_QTR_TODATE_TRANS

QT_SEQ

DWR_QTR_TRANS

CAR_SEQ

DWR_RF_CARRIER

RS_SEQ

DWR_RTL_STORE

SUB_SEQ

DWR_SBRP

SCOS_SEQ

DWR_SBRP_CLASS_OF_SRVC

SEC_SEQ

DWR_SCND

SCR_SEQ

DWR_SCRPT

IQ_SEQ

DWR_SCRPT_QUES

SC_1_SEQ

DWR_SGMNT_CRTRA

SICD_SEQ

DWR_SIC_DIV

SCAMH_SEQ

DWR_SIM_CARD_ACCS_MTHD_ASGN

SCHH_SEQ

DWR_SIM_CARD_HNDST_ASGN

SCSH_SEQ

DWR_SIM_CARD_SBRP_ASGN

CHR_SEQ

DWR_SL_CHNL

RSCR_SEQ

DWR_SL_CHNL_RPRSTV

SCP_SEQ

DWR_SL_CMISN_PLN

SCPD_SEQ

DWR_SL_CMISN_PLN_DTL

SL_SEQ

DWR_SLNG_LOC

SJ_SEQ

DWR_SOC_JB

SJC_SEQ

DWR_SOC_JB_CTGRY

SJG_SEQ

DWR_SOC_JB_GRP

SJMG_SEQ

DWR_SOC_JB_MJR_GRP

SS_SEQ

DWR_SRC_SYS

OTA_SEQ

DWR_SRVC_COVRG_AREA

SCGD_SEQ

DWR_SRVC_COVRG_GEO_DTL

SWH_SEQ

DWR_SWTCH

SC3_SEQ

DWR_SWTCH_CAPBLTY

SCMD_SEQ

DWR_SWTCH_CMMND

SRDR_SEQ

DWR_SWTCH_RUTNG_DVC_ASGN

DRTS_SEQ

DWR_TIME_SLT

TSBW_SEQ

DWR_TIME_STNDRD_BY_WK

USE_SEQ

DWR_USER

VAS1_SEQ

DWR_VAL_ADD_SRVC

VEN_SEQ

DWR_VNDR

VC_SEQ

DWR_VNDR_CNRT

VFCA_SEQ

DWR_VNDR_FCTR_CMPNY_ASGN

VR_SEQ

DWR_VNDR_RTNG

VS2_SEQ

DWR_VNDR_SITE

WTT_SEQ

DWR_WK_TODATE_TRANS

WT_SEQ

DWR_WK_TRANS

TWD1_SEQ

DWR_WKDAY

YT_SEQ

DWR_YR_TRANS


Compressed Tables

Table 4-8 lists the Compressed Tables in Oracle Communications Data Model. Oracle Communications Data Model uses Database Compression on these tables to save space and load times.

Table 4-8 Compressed Tables

Table Name

DWB_ACCS_MTHD_PORT_HIST

DWB_ACCS_MTHD_STAT_HIST

DWB_ACCT_BAL_HIST

DWB_ACCT_COST

DWB_ACCT_CRDT_LMT

DWB_ACCT_MNGMNT_HIST

DWB_ACCT_PMP_PRTCPTN_HIST

DWB_ACCT_PYMT

DWB_ACCT_PYMT_MTHD_STAT

DWB_ACCT_RFND

DWB_ACCT_STAT_HIST

DWB_APNMNT_CLNDR

DWB_BLK_LST_HIST

DWB_BRDBND_USG_EVT

DWB_BSNS_UNIT_COST

DWB_CARRIER_COST

DWB_CELL_SITE_COST

DWB_CHNL_COST

DWB_CMPGN_COST

DWB_CMPGN_MSG_CRTVE

DWB_CNCT_LST_COST

DWB_CNRT_APRVL

DWB_CNRT_STAT

DWB_CNRT_TERM_VAL

DWB_CNTNT_DLVRY_EVT

DWB_COST

DWB_COST_CNTR_BDGT

DWB_CRCUT_RNTL

DWB_CRCUT_TRFC

DWB_CUST_COST

DWB_CUST_FLD_INSTLTN

DWB_CUST_FLD_SPPRT

DWB_CUST_FLD_SRVC_ACTVTY

DWB_CUST_FLD_SRVC_DTL

DWB_CUST_ORDR

DWB_CUST_ORDR_LN_ITEM

DWB_CUST_ORDR_LN_ITEM_ST_ASGN

DWB_CUST_ORDR_PYMT

DWB_CUST_ORDR_STATE_ASGN

DWB_DATA_SRVC_EVT

DWB_DEBT_COLLCTN

DWB_DEBT_COLLCTN_ASGN

DWB_DEBT_COLLCTN_ASGN_BTCH

DWB_EMP_ACT_LBR_HRLY

DWB_EMP_ACT_LBR_SALARIED

DWB_EMP_COST

DWB_EMP_TRNG_REC

DWB_EQPMNT_CNTR_COST

DWB_EQPMNT_INSTNC_STAT_HIST

DWB_EVT

DWB_EVT_ACCS_MTHD_ACTVTY

DWB_EVT_ACCT

DWB_EVT_ASGN

DWB_EVT_COST

DWB_EVT_CRCUT_RNTL

DWB_EVT_EMP_PYRL

DWB_EVT_EQPMNT_INSTNC

DWB_EVT_FINCL

DWB_EVT_GEO

DWB_EVT_GFT_RDMPTN

DWB_EVT_INVC_DLVRY

DWB_EVT_LYLTY_PROG

DWB_EVT_LYLTY_PROG_ACMLTN

DWB_EVT_LYLTY_PROG_RDMPTN

DWB_EVT_PROD_PKG

DWB_EVT_PRPD_MBL

DWB_EVT_PRTY_ASGN

DWB_EVT_PRTY_INTRACN

DWB_EVT_PRTY_INTRACN_CALL

DWB_EVT_PRTY_INTRACN_EML

DWB_EVT_PRTY_INTRACN_LTTR

DWB_EVT_PRTY_INTRACN_VST

DWB_EVT_PRTY_PRFL

DWB_EVT_SBRP

DWB_EVT_SBRP_CHNG

DWB_EVT_SIM_CARD

DWB_EVT_STAT

DWB_EVT_WEB_RGSTRN

DWB_FIXED_LN_CALL_EVT

DWB_IDD_CALL_EVT

DWB_INTRNT_ACCS_EVT

DWB_INVC

DWB_INVC_ADJ

DWB_INVC_DISC

DWB_INVC_ITEM

DWB_INVC_ITEM_DTL

DWB_INVC_PYMT_ASGN

DWB_ISP_USG_EVT

DWB_LYLTY_PROG_PTS_BAL

DWB_MDTD_CALL_EVT

DWB_MEDIA_OBJ_COST

DWB_MKT_PLN_MGMT

DWB_MMS_EVT

DWB_MNT_ALLWNC

DWB_NP_RQST_HDR

DWB_NP_RQST_LN_ITEM

DWB_NP_RQST_LN_ITEM_STATE_HIST

DWB_NP_RQST_STATE_HIST

DWB_NTWK_ELMNT_COST

DWB_NTWK_EVT

DWB_NTWK_FLT

DWB_PRMTN_COST

DWB_PRMTN_MGMT_HIST

DWB_PRMTN_TERM_VAL

DWB_PROD_COST

DWB_PROD_MKT_PLN_COST

DWB_PRPD_RCHRG

DWB_PRTY_AM_PMP_ASGN_HIST

DWB_PRTY_AM_PMP_ASGN_STAT

DWB_PRTY_INTRACN_THRD

DWB_PRTY_ORDR_ASGN

DWB_PRTY_PRMTN_RESPN

DWB_PRTY_STAT_HIST

DWB_PTV_FULL_CHNL_ACTVTN

DWB_PTV_QPI_SRVC_EVT

DWB_PTV_USG_EVT

DWB_SBRP_STAT_HIST

DWB_SBRP_TERM_VAL

DWB_SL_CMISN_DTL

DWB_SL_CMISN_PYRL

DWB_SMS_EVT

DWB_SRVC_RQST

DWB_UMS_EVT

DWB_VNDR_APNMNT

DWB_VOIP_CALL_EVT

DWB_WRLS_CALL_EVT

DWB_WRLS_CNTNT_DNLDG_EVT

DWD_ACCT_DEBT_DAY

DWD_ACCT_PYMT_DAY

DWD_ACCT_PYMT_MTHD_STAT_HIST

DWD_ACCT_RFND_DAY

DWD_ACCT_STAT

DWD_ACCT_STTSTC

DWD_ARPU_BASE

DWD_BER_FER_ERR_RATIO_DAY

DWD_CALL_CNTR_CALL_DAY

DWD_CALL_CNTR_CASE_DAY

DWD_CANBLZTN_DTL_DAY

DWD_CELL_STTSTC_DAY

DWD_CHRN_PRDCT_SRC

DWD_CMISN_DAY

DWD_CNCT_DSCNCT_DAY

DWD_CNRT

DWD_CNRT_CHNG

DWD_COST_CUST

DWD_COST_ORG

DWD_CRDT_CTGRY

DWD_CUST_ACQSTN_SUMM_DAY

DWD_CUST_DEBT_COLLCTN

DWD_CUST_EQPMNT_INSTLTN_DAY

DWD_DATA_USG_DAY

DWD_EXTRNL_DEBT_COLLCTN_DAY

DWD_GIVE_AWAY_ITEM_DAY

DWD_GPRS_PCU_DAY

DWD_GPRS_SRVCS_DAY

DWD_HNDST_STCK_DAY

DWD_HNDST_SUBSDY_DAY

DWD_INTRNL_DEBT_COLLCTN_DAY

DWD_INVC

DWD_INVC_ADJ

DWD_IN_PLTFRM_DAY

DWD_LN_ACTVTN_TMNT_DAY

DWD_LYLTY_PROG_DAY

DWD_MKT_OPRTR_PRTNG

DWD_MKT_SHARE

DWD_MSC_TRFC_DAY

DWD_NBR_PRT_DAY

DWD_NTWK_AVLBLTY_DAY

DWD_NTWK_TCHPNT

DWD_PRPD_ACCT_STTSTC

DWD_PRPD_ALWNCE_DAY

DWD_PRPD_CALL_SUMM_DAY

DWD_PRTNR_STLMNT

DWD_PYMT_AGNG_DAY

DWD_RDMPTN_DAY

DWD_RF_NTWK_CPCTY_DAY

DWD_SBCRBR_CHRN_STTSTC

DWD_SHRD_PKG_USG_STSC_DAY

DWD_SHOP_EFFNCY_DAY

DWD_SL_CMPGN_SUMM_DAY

DWD_SL_DAY

DWD_SL_RPRSTV_STTSTC

DWD_SPLMNTR_SRVC_USG

DWD_SUBSDY_AMT

DWD_VAS_SBRP_QCK_SUMM

DWD_VAS_USG_DAY

DWD_VOI_CALL_DAY


Partition Definitions

Table 4-9 lists the Partition Tables, Partition Column, Partition Level and Partition Table space for Partition definitions in Oracle Communications Data Model.

Table 4-9 Partition Definitions

Table Name Partition Column Partition Level Partition Table space

DWA_ACCT_DEBT_MO

DT

QTY

TBS_MV

DWA_ACCT_PYMT_MO

DT

QTY

TBS_MV

DWA_ACCT_PYMT_MTHD_STAT_HIST

DT

QTY

TBS_MV

DWA_ACCT_RFND_MO

DT

QTY

TBS_MV

DWA_ACCT_STAT_TYP

DT

QTY

TBS_MV

DWA_ACCT_STTSTC_TYP

DT

QTY

TBS_MV

DWA_ARPU_BASE_CUST_TYP

DT

QTY

TBS_MV

DWA_BER_FER_ERR_RATIO_MO

DT

QTY

TBS_MV

DWA_CALL_CNTR_CALL_MO

DT

QTY

TBS_MV

DWA_CALL_CNTR_CASE_MO

DT

QTY

TBS_MV

DWA_CANBLZTN_DTL_MO

DT

QTY

TBS_MV

DWA_CELL_STTSTC_MO

DT

QTY

TBS_MV

DWA_CMISN_MO

DT

QTY

TBS_MV

DWA_CNCT_DSCNCT_MO

DT

QTY

TBS_MV

DWA_CNRT_MO

DT

QTY

TBS_MV

DWA_COST_CUST_MO

DT

QTY

TBS_MV

DWA_COST_ORG_MO

DT

QTY

TBS_MV

DWA_CRDT_CTGRY_MO

DT

QTY

TBS_MV

DWA_CUST_ACQSTN_SUMM_MO

DT

QTY

TBS_MV

DWA_CUST_DEBT_COLLCTN_MO

DT

QTY

TBS_MV

DWA_CUST_EQPMNT_INSTLTN_MO

DT

QTY

TBS_MV

DWA_DATA_USG_MO

DT

QTY

TBS_MV

DWA_EXTRNL_DEBT_COLLCTN_MO

DT

QTY

TBS_MV

DWA_GIVE_AWAY_ITEM_MO

DT

QTY

TBS_MV

DWA_GPRS_PCU_MO

DT

QTY

TBS_MV

DWA_GPRS_SRVCS_MO

DT

QTY

TBS_MV

DWA_HNDST_STCK_MO

DT

QTY

TBS_MV

DWA_HNDST_SUBSDY_MO

DT

QTY

TBS_MV

DWA_INTRNL_DEBT_COLLCTN_MO

DT

QTY

TBS_MV

DWA_INVC_ADJ_MO

DT

QTY

TBS_MV

DWA_INVC_CUST_TYP

DT

QTY

TBS_MV

DWA_IN_PLTFRM_MO

DT

QTY

TBS_MV

DWA_LN_ACTVTN_TMNT_MO

DT

QTY

TBS_MV

DWA_LYLTY_PROG_MO

DT

QTY

TBS_MV

DWA_MKT_SHARE

DT

QTY

TBS_MV

DWA_MSC_TRFC_MO

DT

QTY

TBS_MV

DWA_NBR_PRT_MO

DT

QTY

TBS_MV

DWA_NTWK_AVLBLTY_MO

DT

QTY

TBS_MV

DWA_NTWK_TCHPNT_MO

DT

QTY

TBS_MV

DWA_PRPD_ACCT_STTSTC_SGMNT

DT

QTY

TBS_MV

DWA_PRPD_ALWNCE_MO

DT

QTY

TBS_MV

DWA_PRPD_CALL_SUMM_MO

DT

QTY

TBS_MV

DWA_PRTNR_STLMNT_MO

DT

QTY

TBS_MV

DWA_PYMT_AGNG_MO

DT

QTY

TBS_MV

DWA_RDMPTN_MO

DT

QTY

TBS_MV

DWA_RF_NTWK_CPCTY_MO

DT

QTY

TBS_MV

DWA_SBCRBR_CHRN_STTSTC_MO

DT

QTY

TBS_MV

DWA_SHARED_PKG_USG_STTSTC_MO

DT

QTY

TBS_MV

DWA_SHOP_EFFNCY_MO

DT

QTY

TBS_MV

DWA_SL_CMPGN_SUMM_MO

DT

QTY

TBS_MV

DWA_SL_MO

DT

QTY

TBS_MV

DWA_SPLMNTR_SRVC_USG_MO

DT

QTY

TBS_MV

DWA_SUBSDY_AMT_MO

DT

QTY

TBS_MV

DWA_VAS_SBRP_QCK_SUMM_MO

DT

QTY

TBS_MV

DWA_VAS_USG_MO

DT

QTY

TBS_MV

DWA_VOI_CALL_MO

DT

QTY

TBS_MV

DWB_ACCS_MTHD_PORT_HIST

ACT_CTVR_DT

QTR

TBS_BASE

DWB_ACCS_MTHD_STAT_HIST

EFF_FROM_DT

QTR

TBS_BASE

DWB_ACCT_BAL_HIST

BAL_DT

MONTH

TBS_BASE

DWB_ACCT_COST

INCURR_DT

MONTH

TBS_BASE

DWB_ACCT_CRDT_LMT

CRDT_RTNG_DT

MONTH

TBS_BASE

DWB_ACCT_MNGMNT_HIST

ASGN_STRT_DT

MONTH

TBS_BASE

DWB_ACCT_PMP_PRTCPTN_HIST

RLTN_STRT_DT

MONTH

TBS_BASE

DWB_ACCT_PYMT

PYMT_DT

MONTH

TBS_BASE

DWB_ACCT_PYMT_MTHD_STAT

EFF_FROM_DT

MONTH

TBS_BASE

DWB_ACCT_RFND

PYMT_DT

MONTH

TBS_BASE

DWB_ACCT_STAT_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_APNMNT_CLNDR

DAY_KEY

DAY

TBS_BASE

DWB_BLK_LST_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_BRDBND_USG_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_BSNS_UNIT_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CARRIER_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CELL_SITE_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CHNL_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CMPGN_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CMPGN_MSG_CRTVE

CRTN_DT

MONTH

TBS_BASE

DWB_CNCT_LST_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CNRT_APRVL

CNRT_APRVL_DT

MONTH

TBS_BASE

DWB_CNRT_STAT

EFF_FROM_DT

MONTH

TBS_BASE

DWB_CNRT_TERM_VAL

TERM_PRD_STRT_DT

MONTH

TBS_BASE

DWB_CNTNT_DLVRY_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_COST

INCURR_DT

MONTH

TBS_BASE

DWB_COST_CNTR_BDGT

EFF_FROM_DT

MONTH

TBS_BASE

DWB_CRCUT_RNTL

EFF_FROM_DT

MONTH

TBS_BASE

DWB_CRCUT_TRFC

EFF_STRT_DT

MONTH

TBS_BASE

DWB_CUST_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CUST_FLD_INSTLTN

FLD_ACTVTY_STRT_DT

MONTH

TBS_BASE

DWB_CUST_FLD_SPPRT

FLD_ACTVTY_STRT_DT

MONTH

TBS_BASE

DWB_CUST_FLD_SRVC_ACTVTY

FLD_ACTVTY_STRT_DT

MONTH

TBS_BASE

DWB_CUST_FLD_SRVC_DTL

ACTN_DT

MONTH

TBS_BASE

DWB_CUST_ORDR

ORGNL_ORDR_DT

MONTH

TBS_BASE

DWB_CUST_ORDR_LN_ITEM

ORGNL_ORDR_DT

MONTH

TBS_BASE

DWB_CUST_ORDR_LN_ITEM_ST_ASGN

ORDR_LN_ITEM_STATE_BEGIN_DT

MONTH

TBS_BASE

DWB_CUST_ORDR_PYMT

PYMT_DT

MONTH

TBS_BASE

DWB_CUST_ORDR_STATE_ASGN

ORDR_STATE_BEGIN_DT

MONTH

TBS_BASE

DWB_DATA_SRVC_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_DEBT_COLLCTN

INTRACN_THRD_STRT_DT

MONTH

TBS_BASE

DWB_DEBT_COLLCTN_ASGN

ASGN_DT

MONTH

TBS_BASE

DWB_DEBT_COLLCTN_ASGN_BTCH

ASGN_DT

MONTH

TBS_BASE

DWB_EMP_ACT_LBR_HRLY

DAY_KEY

DAY

TBS_BASE

DWB_EMP_ACT_LBR_SALARIED

DAY_KEY

DAY

TBS_BASE

DWB_EMP_COST

INCURR_DT

MONTH

TBS_BASE

DWB_EMP_TRNG_REC

TRNG_STRT_DT

MONTH

TBS_BASE

DWB_EQPMNT_CNTR_COST

INCURR_DT

MONTH

TBS_BASE

DWB_EQPMNT_INSTNC_STAT_HIST

EFF_BEGIN_DT

MONTH

TBS_BASE

DWB_EVT

STRT_DT

DAY

TBS_BASE

DWB_EVT_ACCS_MTHD_ACTVTY

STRT_DT

DAY

TBS_BASE

DWB_EVT_ACCT

STRT_DT

MONTH

TBS_BASE

DWB_EVT_ASGN

EFF_FROM_DT

DAY

TBS_BASE

DWB_EVT_COST

INCURR_DT

MONTH

TBS_BASE

DWB_EVT_CRCUT_RNTL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_EMP_PYRL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_EQPMNT_INSTNC

STRT_DT

MONTH

TBS_BASE

DWB_EVT_FINCL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_GEO

STRT_DT

MONTH

TBS_BASE

DWB_EVT_GFT_RDMPTN

STRT_DT

MONTH

TBS_BASE

DWB_EVT_INVC_DLVRY

STRT_DT

MONTH

TBS_BASE

DWB_EVT_LYLTY_PROG

STRT_DT

MONTH

TBS_BASE

DWB_EVT_LYLTY_PROG_ACMLTN

STRT_DT

MONTH

TBS_BASE

DWB_EVT_LYLTY_PROG_RDMPTN

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PROD_PKG

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRPD_MBL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_ASGN

EFF_DT

DAY

TBS_BASE

DWB_EVT_PRTY_INTRACN

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_INTRACN_CALL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_INTRACN_EML

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_INTRACN_LTTR

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_INTRACN_VST

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_PRFL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_SBRP

STRT_DT

MONTH

TBS_BASE

DWB_EVT_SBRP_CHNG

STRT_DT

MONTH

TBS_BASE

DWB_EVT_SIM_CARD

STRT_DT

MONTH

TBS_BASE

DWB_EVT_STAT

EFF_FROM_DT

DAY

TBS_BASE

DWB_EVT_WEB_RGSTRN

STRT_DT

MONTH

TBS_BASE

DWB_FIXED_LN_CALL_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_IDD_CALL_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_INTRNT_ACCS_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_INVC

BLLG_DT

MONTH

TBS_BASE

DWB_INVC_ADJ

STRT_DT

MONTH

TBS_BASE

DWB_INVC_DISC

BLLG_DT

MONTH

TBS_BASE

DWB_INVC_ITEM

BLLG_DT

MONTH

TBS_BASE

DWB_INVC_ITEM_DTL

BLLG_DT

MONTH

TBS_BASE

DWB_INVC_PYMT_ASGN

EFF_FROM_DT

MONTH

TBS_BASE

DWB_ISP_USG_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_LYLTY_PROG_PTS_BAL

EFF_FROM_DT

MONTH

TBS_BASE

DWB_MDTD_CALL_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_MEDIA_OBJ_COST

INCURR_DT

MONTH

TBS_BASE

DWB_MKT_PLN_MGMT

MNG_ACTN_DT

MONTH

TBS_BASE

DWB_MMS_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_MNT_ALLWNC

BAL_DT

MONTH

TBS_BASE

DWB_NP_RQST_HDR

APLCTN_DT

MONTH

TBS_BASE

DWB_NP_RQST_LN_ITEM

NP_STEP_STRT_DT

MONTH

TBS_BASE

DWB_NP_RQST_LN_ITEM_STATE_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_NP_RQST_STATE_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_NTWK_ELMNT_COST

INCURR_DT

MONTH

TBS_BASE

DWB_NTWK_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_NTWK_FLT

OPEN_DT

MONTH

TBS_BASE

DWB_PRMTN_COST

INCURR_DT

MONTH

TBS_BASE

DWB_PRMTN_MGMT_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_PRMTN_TERM_VAL

TERM_PRD_STRT

MONTH

TBS_BASE

DWB_PROD_COST

INCURR_DT

MONTH

TBS_BASE

DWB_PROD_MKT_PLN_COST

INCURR_DT

MONTH

TBS_BASE

DWB_PRPD_RCHRG

PYMT_DT

MONTH

TBS_BASE

DWB_PRTY_AM_PMP_ASGN_HIST

ASGN_BEGIN_DT

MONTH

TBS_BASE

DWB_PRTY_AM_PMP_ASGN_STAT

ASGN_BEGIN_DT

MONTH

TBS_BASE

DWB_PRTY_INTRACN_THRD

INTRACN_THRD_STRT_DT

MONTH

TBS_BASE

DWB_PRTY_ORDR_ASGN

EFF_FROM_DT

MONTH

TBS_BASE

DWB_PRTY_PRMTN_RESPN

RESPN_DT

MONTH

TBS_BASE

DWB_PRTY_STAT_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_PTV_FULL_CHNL_ACTVTN

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_PTV_QPI_SRVC_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_PTV_USG_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_SBRP_STAT_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_SBRP_TERM_VAL

TERM_PRD_STRT_DT

MONTH

TBS_BASE

DWB_SL_CMISN_DTL

PYMT_DT

MONTH

TBS_BASE

DWB_SL_CMISN_PYRL

PAY_DT

MONTH

TBS_BASE

DWB_SMS_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_SRVC_RQST

INTRACN_THRD_STRT_DT

MONTH

TBS_BASE

DWB_UMS_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_VNDR_APNMNT

VNDR_APNMNT_DT

MONTH

TBS_BASE

DWB_VOIP_CALL_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_WRLS_CALL_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_WRLS_CNTNT_DNLDG_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWD_ACCT_DEBT_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_PYMT_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_PYMT_MTHD_STAT_HIST

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_RFND_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_STAT

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_STTSTC

MO_KEY

MONTH

TBS_DERIVED

DWD_ARPU_BASE

MO_KEY

MONTH

TBS_DERIVED

DWD_BER_FER_ERR_RATIO_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CALL_CNTR_CALL_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CALL_CNTR_CASE_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CANBLZTN_DTL_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CELL_STTSTC_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CHRN_PRDCT_SRC

MO_KEY

MONTH

TBS_DERIVED

DWD_CMISN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CNCT_DSCNCT_DAY

DAY_KEY

DAY

TBS_DERIVED

DWD_CNRT

MO_KEY

MONTH

TBS_DERIVED

DWD_CNRT_CHNG

MO_KEY

MONTH

TBS_DERIVED

DWD_COST_CUST

MO_KEY

MONTH

TBS_DERIVED

DWD_COST_ORG

MO_KEY

MONTH

TBS_DERIVED

DWD_CRDT_CTGRY

MO_KEY

MONTH

TBS_DERIVED

DWD_CUST_ACQSTN_SUMM_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CUST_DEBT_COLLCTN

MO_KEY

MONTH

TBS_DERIVED

DWD_CUST_EQPMNT_INSTLTN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_DATA_USG_DAY

DAY_KEY

DAY

TBS_DERIVED

DWD_EXTRNL_DEBT_COLLCTN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_GIVE_AWAY_ITEM_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_GPRS_PCU_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_GPRS_SRVCS_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_HNDST_STCK_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_HNDST_SUBSDY_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_INTRNL_DEBT_COLLCTN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_INVC

MO_KEY

MONTH

TBS_DERIVED

DWD_INVC_ADJ

MO_KEY

MONTH

TBS_DERIVED

DWD_IN_PLTFRM_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_LN_ACTVTN_TMNT_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_LYLTY_PROG_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_MKT_SHARE

MO_KEY

MONTH

TBS_DERIVED

DWD_MSC_TRFC_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_NBR_PRT_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_NTWK_AVLBLTY_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_NTWK_TCHPNT

MO_KEY

MONTH

TBS_DERIVED

DWD_MKT_OPRTR_PRTNG

MO_KEY

MONTH

TBS_DERIVED

DWD_PRPD_ACCT_STTSTC

MO_KEY

MONTH

TBS_DERIVED

DWD_PRPD_ALWNCE_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_PRPD_CALL_SUMM_DAY

DAY_KEY

DAY

TBS_DERIVED

DWD_PRTNR_STLMNT

MO_KEY

MONTH

TBS_DERIVED

DWD_PYMT_AGNG_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_RDMPTN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_RF_NTWK_CPCTY_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SBCRBR_CHRN_STTSTC

MO_KEY

MONTH

TBS_DERIVED

DWD_SHRD_PKG_USG_STSC_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SHOP_EFFNCY_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SL_CMPGN_SUMM_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SL_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SL_RPRSTV_STTSTC

MO_KEY

MONTH

TBS_DERIVED

DWD_SPLMNTR_SRVC_USG

MO_KEY

MONTH

TBS_DERIVED

DWD_SUBSDY_AMT

MO_KEY

MONTH

TBS_DERIVED

DWD_VAS_SBRP_QCK_SUMM

MO_KEY

MONTH

TBS_DERIVED

DWD_VAS_USG_DAY

DAY_KEY

DAY

TBS_DERIVED

DWD_VOI_CALL_DAY

DAY_KEY

DAY

TBS_DERIVED


Oracle Communications Data Model OLAP Cube MV, Cube View

Table 4-10 shows the cube materialized views in ocdm_sys schema.

Table 4-10 OLAP Cube Materialized Views in ocdm_sys Schema

Cube Materialized View Name OLAP Object Name OLAP Object Type More Information

CB$ACM

ACM

Cube

Customer Acquisition Cube

CB$ADM

ADM

Cube

Account Debt Cube

CB$APM

APM

Cube

Account Payment Cube

CB$ARM

ARM

Cube

Account Refund Cube

CB$ARRSN_HARRSN

ARRSN_HARRSN

Dimension_Hierarchy

Account Refund Reason: ARRSN

CB$CAGNCY_HCAGNCY

CAGNCY_HCAGNCY

Dimension_Hierarchy

Collection Agency: CAGNCY

CB$CCM

CCM

Cube

Cost Customer Cube

CB$CHRN

CHRN

Cube

Subscriber Churn Statistic Cube

CB$CM

CM

Cube

Contract Cube

CB$CMSN

CMSN

Cube

Commission Cube

CB$CMTYP_HCMTYP

CMTYP_HCMTYP

Dimension_Hierarchy

Commission Type: CMTYP

CB$COM

COM

Cube

Cost Organizational Cube

CB$CRNRSN_HCRNRSN

CRNRSN_HCRNRSN

Dimension_Hierarchy

Churn Reason: CRNRSN

CB$CSGMNT_HCSGMNT

CSGMNT_HCSGMNT

Dimension_Hierarchy

Customer Segment: CSGMNT

CB$CSM

CSM

Cube

Cell Statistic Cube

CB$CUSTYP_HCUSTYP

CUSTYP_HCUSTYP

Dimension_Hierarchy

Customer Type: CUSTYP

CB$CUST_HCUST

CUST_HCUST

Dimension_Hierarchy

Customer: CUST

CB$CUST_MNNG_STTSTC

CUST_MNNG_STTSTC

Cube

Customer Mining Statistics Cube

CB$DAB_HDAB

DAB_HDAB

Dimension_Hierarchy

Debt Aging Band: DAB

CB$EDCM

EDCM

Cube

External Debt Collection Cube

CB$GEO_HGEO

GEO_HGEO

Dimension_Hierarchy

Geography: GEO

CB$HSKM

HSKM

Cube

Handset Stock Cube

CB$HSMDL_HHSMDL

HSMDL_HHSMDL

Dimension_Hierarchy

Handset Model: HSMDL

CB$IAM

IAM

Cube

Invoice Adjustment Cube

CB$IARSN_HIARSN

IARSN_HIARSN

Dimension_Hierarchy

Invoice Adjustment Reason: IARSN

CB$IATYP_HIATYP

IATYP_HIATYP

Dimension_Hierarchy

Invoice Adjustment Type: IATYP

CB$ICT

ICT

Cube

Invoice Customer Type Cube

CB$MNCT_HMNCT

MNCT_HMNCT

Dimension_Hierarchy

Mining Churn Type: MNCT

CB$MNLSB_HMNLSB

MNLSB_HMNLSB

Dimension_Hierarchy

Mining Life Time Survival Band: MNLSB

CB$MNLVB_HMNLVB

MNLVB_HMNLVB

Dimension_Hierarchy

Mining Life Time Value Band: MNLVB

CB$MNSC_HMNSC

MNSC_HMNSC

Dimension_Hierarchy

Mining Sentiment Category: MNSC

CB$NELMNT_HNELMNT

NELMNT_HNELMNT

Dimension_Hierarchy

Network Element: NELMNT

CB$ORG_HBANNER

ORG_HBANNER

Dimension_Hierarchy

Organization: ORG

CB$ORG_HCHAIN

ORG_HCHAIN

Dimension_Hierarchy

Organization: ORG

CB$ORG_HCORPORATE

ORG_HCORPORATE

Dimension_Hierarchy

Organization: ORG

CB$PCHNL_HPCHNL

PCHNL_HPCHNL

Dimension_Hierarchy

Payment Channel: PCHNL

CB$PMP_HPMP

PMP_HPMP

Dimension_Hierarchy

Product Market Plan: PMP

CB$PMTYP_HPMTYP

PMTYP_HPMTYP

Dimension_Hierarchy

Payment Method Type: PMTYP

CB$POPT_HPOPT

POPT_HPOPT

Dimension_Hierarchy

Peak Offpeak Time: POPT

CB$PRMTN_HCMPGN

PRMTN_HCMPGN

Dimension_Hierarchy

Promotion: PRMTN

CB$PRMTN_HPRMTN

PRMTN_HPRMTN

Dimension_Hierarchy

Promotion: PRMTN

CB$PROD_HPROD

PROD_HPROD

Dimension_Hierarchy

Product: PROD

CB$PTTYP_HPTTYP

PTTYP_HPTTYP

Dimension_Hierarchy

Payment Transaction Type: PTTYP

CB$RVN

RVN

Cube

Revenue Cube

CB$SLCHNL_HSLCHNL

SLCHNL_HSLCHNL

Dimension_Hierarchy

Sales Channel: SLCHNL

CB$TIME_HTBSNS

TIME_HTBSNS

Dimension_Hierarchy

Time: TIME

CB$TSLT_HTSLT

TSLT_HTSLT

Dimension_Hierarchy

Time Slot: TSLT


Table 4-11 shows the OLAP cube views in ocdm_sys schema.

Table 4-11 OLAP Cube Views in ocdm_sys schema

Cube View Name OLAP Object Name OLAP Object Type More Information

ACM_FCST_STTSTC_VIEW

ACM_FCST_STTSTC

Cube

Customer Acquisition Forecast Statistic Cube

ACM_FCST_VIEW

ACM_FCST

Cube

Customer Acquisition Forecast Cube

ACM_VIEW

ACM

Cube

Customer Acquisition Forecast Cube

ADM_VIEW

ADM

Cube

Customer Acquisition Cube

APM_VIEW

APM

Cube

Account Payment Cube

ARM_VIEW

ARM

Cube

Account Refund Cube

ARRSN_HARRSN_VIEW

ARRSN_HARRSN

Hierarchy

Account Refund Reason: ARRSN

ARRSN_VIEW

ARRSN

Dimension

Account Refund Reason: ARRSN

CAGNCY_HCAGNCY_VIEW

CAGNCY_HCAGNCY

Hierarchy

Collection Agency: CAGNCY

CAGNCY_VIEW

CAGNCY

Dimension

Collection Agency: CAGNCY

CCM_VIEW

CCM

Cube

Cost Customer Cube

CHRN_VIEW

CHRN

Cube

Subscriber Churn Statistic Cube

CMSN_VIEW

CMSN

Cube

Commission Cube

CMTYP_HCMTYP_VIEW

CMTYP_HCMTYP

Hierarchy

Commission Type: CMTYP

CMTYP_VIEW

CMTYP

Dimension

Commission Type: CMTYP

CM_VIEW

CM

Cube

Contract Cube

COM_VIEW

COM

Cube

Cost Organizational Cube

CRNRSN_HCRNRSN_VIEW

CRNRSN_HCRNRSN

Hierarchy

Churn Reason: CRNRSN

CRNRSN_VIEW

CRNRSN

Dimension

Churn Reason: CRNRSN

CSGMNT_HCSGMNT_VIEW

CSGMNT_HCSGMNT

Hierarchy

Customer Segment: CSGMNT

CSGMNT_VIEW

CSGMNT

Dimension

Customer Segment: CSGMNT

CSM_FCST_VIEW

CSM_FCST

Cube

Cell Statistic Forecast Cube

CSM_VIEW

CSM

Cube

Cell Statistic Cube

CUSTYP_HCUSTYP_VIEW

CUSTYP_HCUSTYP

Hierarchy

Customer Type: CUSTYP

CUSTYP_VIEW

CUSTYP

Dimension

Customer Type: CUSTYP

CUST_HCUST_VIEW

CUST_HCUST

Hierarchy

Customer: CUST

CUST_MNNG_STTSTC_VIEW

CUST_MNNG_STTSTC

Cube

Customer Mining Statistics Cube

CUST_VIEW

CUST

Dimension

Customer: CUST

DAB_HDAB_VIEW

DAB_HDAB

Hierarchy

Debt Aging Band: DAB

DAB_VIEW

DAB

Dimension

Debt Aging Band: DAB

EDCM_VIEW

EDCM

Cube

External Debt Collection Cube

GEO_HGEO_VIEW

GEO_HGEO

Hierarchy

Geography: GEO

GEO_VIEW

GEO

Dimension

Geography: GEO

HSKM_FCST_VIEW

HSKM_FCST

Cube

Handset Stock Forecast Cube

HSKM_VIEW

HSKM

Cube

Handset Stock Cube

HSMDL_HHSMDL_VIEW

HSMDL_HHSMDL

Hierarchy

Handset Model: HSMDL

HSMDL_VIEW

HSMDL

Dimension

Handset Model: HSMDL

IAM_VIEW

IAM

Cube

Invoice Adjustment Cube

IARSN_HIARSN_VIEW

IARSN_HIARSN

Hierarchy

Invoice Adjustment Reason: IARSN

IARSN_VIEW

IARSN

Dimension

Invoice Adjustment Reason: IARSN

IATYP_HIATYP_VIEW

IATYP_HIATYP

Hierarchy

Invoice Adjustment Type: IATYP

IATYP_VIEW

IATYP

Dimension

Invoice Adjustment Type: IATYP

ICT_VIEW

ICT

Cube

Invoice Customer Type Cube

MNCT_HMNCT_VIEW

MNCT_HMNCT

Hierarchy

Mining Churn Type: MNCT

MNCT_VIEW

MNCT

Dimension

Mining Churn Type: MNCT

MNLSB_HMNLSB_VIEW

MNLSB_HMNLSB

Hierarchy

Mining Life Time Survival Band: MNLSB

MNLSB_VIEW

MNLSB

Dimension

Mining Life Time Survival Band: MNLSB

MNLVB_HMNLVB_VIEW

MNLVB_HMNLVB

Hierarchy

Mining Life Time Value Band: MNLVB

MNLVB_VIEW

MNLVB

Dimension

Mining Life Time Value Band: MNLVB

MNSC_HMNSC_VIEW

MNSC_HMNSC

Hierarchy

Mining Sentiment Category: MNSC

MNSC_VIEW

MNSC

Dimension

Mining Sentiment Category: MNSC

NELMNT_HNELMNT_VIEW

NELMNT_HNELMNT

Hierarchy

Network Element: NELMNT

NELMNT_VIEW

NELMNT

Dimension

Network Element: NELMNT

ORG_HBANNER_VIEW

ORG_HBANNER

Hierarchy

Organization: ORG

ORG_HCHAIN_VIEW

ORG_HCHAIN

Hierarchy

Organization: ORG

ORG_HCORPORATE_VIEW

ORG_HCORPORATE

Hierarchy

Organization: ORG

ORG_VIEW

ORG

Dimension

Organization: ORG

PCHNL_HPCHNL_VIEW

PCHNL_HPCHNL

Hierarchy

Payment Channel: PCHNL

PCHNL_VIEW

PCHNL

Dimension

Payment Channel: PCHNL

PMP_HPMP_VIEW

PMP_HPMP

Hierarchy

Product Market Plan: PMP

PMP_VIEW

PMP

Dimension

Product Market Plan: PMP

PMTYP_HPMTYP_VIEW

PMTYP_HPMTYP

Hierarchy

Payment Method Type: PMTYP

PMTYP_VIEW

PMTYP

Dimension

Payment Method Type: PMTYP

POPT_HPOPT_VIEW

POPT_HPOPT

Hierarchy

Peak Offpeak Time: POPT

POPT_VIEW

POPT

Dimension

Peak Offpeak Time: POPT

PRMTN_HCMPGN_VIEW

PRMTN_HCMPGN

Hierarchy

Promotion: PRMTN

PRMTN_HPRMTN_VIEW

PRMTN_HPRMTN

Hierarchy

Promotion: PRMTN

PRMTN_VIEW

PRMTN

Dimension

Promotion: PRMTN

PROD_HPROD_VIEW

PROD_HPROD

Hierarchy

Product: PROD

PROD_VIEW

PROD

Dimension

Product: PROD

PTTYP_HPTTYP_VIEW

PTTYP_HPTTYP

Hierarchy

Payment Transaction Type: PTTYP

PTTYP_VIEW

PTTYP

Dimension

Payment Transaction Type: PTTYP

RVN_FCST_VIEW

RVN_FCST

Cube

Revenue Forecast Cube

RVN_VIEW

RVN

Cube

Revenue Cube

SLCHNL_HSLCHNL_VIEW

SLCHNL_HSLCHNL

Hierarchy

Sales Channel: SLCHNL

SLCHNL_VIEW

SLCHNL

Dimension

Sales Channel: SLCHNL

TIME_HTBSNS_VIEW

TIME_HTBSNS

Hierarchy

Time: TIME

TIME_VIEW

TIME

Dimension

Time: TIME

TSLT_HTSLT_VIEW

TSLT_HTSLT

Hierarchy

Time Slot: TSLT

TSLT_VIEW

TSLT

Dimension

Time Slot: TSLT