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
Reference Tables
Lookup Tables
Base Tables
Derived Tables
Aggregate Tables
Database Sequences
Compressed Tables
Partition Definitions
Oracle Communications Data Model OLAP Cube MV, Cube View

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:

Reference Tables
Lookup Tables
Base Tables
Derived Tables
Aggregate Tables
Database Sequences

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